Solved

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

Posted on 2009-07-02
2
480 Views
Last Modified: 2013-11-15
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
Comment
Question by:conardb
2 Comments
 
LVL 1

Accepted Solution

by:
by6738 earned 500 total points
ID: 24765527
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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question