Reg: CMC Commands

[lakshmanakumarvepuri]

Hi All,

Please help me in getting the below information in CMC in BO XI R3. using Query Builder

1. Report Name
2. Folder Path
3. Start tIme
4. Completion Time
5. Duration ( in Sec)
6. Server

Please also send me the Queries related to Query Builder for Users, User access, Folder Access etc.

Thanks in Advance

Regards

L K Vepuri

[Former Member]

Hi,

SELECT SI_NAME, SI_FILES, SI_SCHEDULEINFO.SI_STARTTIME, SI_SCHEDULEINFO.SI_ENDTIME from CI_INFOOBJECTS WHERE SI_KIND= 'webi'

The above query will return the name, path, start time, and end time for all WebI documents.

If you want to have a look at all the available properties that you can query, try SELECT * from CI_INFOOBJECTS WHERE SI_KIND= 'WEBI_REPORT_CUID'

Also, there are three tables that you can use for other objects besides WebI documents:
- CI_INFOOBJECTS
- CI_APPOBJECTS
- CI_SYSTEMOBJECTS

Also, the following Wiki contains detailed information regarding QueryBuilder, where you can find examples for getting users and other objects properties:

I hope this helps,
Moslem