Categories

Queries can be based on the following APS InfoStore categories:

• CI_INFOOBJECTS

  This category allows you to retrieve folders, reports, and report instances from the APS InfoStore.

• CI_SYSTEMOBJECTS

  This category allows you to retrieve system objects, such as servers, users, groups, destinations, and events from the APS InfoStore.

You can query from a single category, or from two categories at the same time. For example:

SELECT SI_NAME, SI_ID FROM CI_INFOOBJECTS, CI_SYSTEMOBJECTS WHERE SI_ID =123 AND SI_CREATION_TIME='2000/03/31'