Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 485
  • Last Modified:

how2 create rpt in boe xi r2 sp5 to id all rpts scheduled to run between 7a and 8a est?

How can I create a report or identify all reports that are run between 7am and 8am est, for example? I have boe xi r2 sp5... looking at our cms db/table, CMS_InfoObjects5, there is a next run time but doesn't have any tables with report name. the query builder doesn't allow convert functions to convert the next run time from gmt to ext?
0
conardb
Asked:
conardb
1 Solution
 
by6738Commented:
In order to report on ad-hoc usage, you will need to query the Auditor tables (if you have Auditor installed).  The canned Auditor reports should be a good starting point.  

Usage information is not captured in the Infostore (CMS database), and cannot be retrieved through Query Builder / SDK scripting.  The closest you will be able to get is start and end times of scheduled report instances (all ad-hoc activity and on-demand report requests are excluded).
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now