SDK Query Tool?

[system]

Good afternoon all!

Is there a query tool one can use to ping the BO CMS, similiar to phpmyadmin? It’s difficult to remember all of the columns available.

Thanks!

---

sohmc (BOB member since 2008-06-25)

[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:

BOXI Repository Documentor

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:

Document a BO Universe in Excel

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:

XIR2 scheduling instances viewer

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

Connection info + universes

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)

[system]

@Atul Chowdhury

Infolytik’s free XI3 CMS Query and Reporting Universe driver

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

You dirty dog you!

I’m going to try this out. This is exactly what I need!

---

sohmc (BOB member since 2008-06-25)

[system]

Thanks Mike - I hope you find it useful. Please let me know of any issues or questions you may have as I’d be happy to help!

Happy New Year -

Atul

---

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