SDK Query Tool?

[system]

Hello -

There are several free solutions available that provide information that I believe might help with your needs/

They are:

Infolytik’s free XI3 CMS Query and Reporting Universe driver

http://www.infolytik.com/cmsconnect-community-edition

BOXI Repository Documentor:

120×120 10.4 KB

I have created the attached spreadsheet for XI R3 which will retrieve information about the reports, Universes, connections and categories in the BOXI environment. It will also provide information as to which reports use a specific universe and which reports may be affected by a universe change too - as returned when querying via the query builder. It should be ran under the administrator account for the best results, but also works for delegated administrators/users. The first tab has a secti…

Document a Universe in Excel:

120×120 10.4 KB

Author: André Lützkendorf Platform: Windows Version: GetSetUniverse 3.5.25 Code: VBA code within the uploaded xls file Author notes: 1. What can you do with the tool? Presentation of all universe objects and properties This includes general universe information (defined in parameters) all object properties object dependencies (lineage/ impact analysis) (which table will be used by which object, which objects will be used by which objects with @functions) contexts hierarchies joins inc…

Instances Viewer:

120×120 10.4 KB

Author: Rachidb Author notes: This macro generates information about instances finished/running/pending. It accepts a date range. If start date is omitted it shows instances statuses for a given day starting 12AM until time of run. End date is also option and will default to current date/time. Rows returned is limited to 64000 rows. But please be careful not to run for a big date range as it may overload your CMS. Platform: Excel 2003 Version: Initial release 1.0 Feel free to give feedback …

Connection Info + Universes

120×120 10.4 KB

Author: Joe Peters (with thanks to Dwayne) Platform: Windows Version: 1.0 Notes: Joe connections.xls (59.0 KB) joepeters (BOB member since 2002-08-29)

BOXI UserList and Group Extraction

BOXI UserList & Group Extraction

Here is a little excel file with a bit of VBA code to extract from a CMS the complete list of user and the list of groups each user is member of. Quite useful when you need to check group membership. It’s now possible to edit the CMS data, simply by modify entries in the Excel File. You need then to export your modification back to the CMS. Modifiables column are : Login, FullName, Email, Disabled and Description. Platform: BO XI R2 / BOXI3.1 (it’s necessary to change the libs to fits XI3.1, s…

Each has its own pro’s and con’s (well, all but the first one ;> )

Hope this helps

---

Atul Chowdhury (BOB member since 2003-07-07)