cms_query
Run SQL-like queries against SAP BusinessObjects CMS repository tables to retrieve InfoObjects, applications, system objects, users, and security data.
Instructions
Executes an arbitrary SQL-like query against the CMS repository tables (CI_INFOOBJECTS, CI_APPOBJECTS, CI_SYSTEMOBJECTS). Examples:
'SELECT SI_ID, SI_NAME FROM CI_INFOOBJECTS WHERE SI_KIND = "Webi"'
'SELECT SI_ID, SI_NAME, SI_LASTLOGONTIME FROM CI_SYSTEMOBJECTS WHERE SI_KIND = "User"'
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| page | No | ||
| query | Yes | ||
| pagesize | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||