BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Want to sponsor BOB? 
Want to sponsor BOB? (Opens a new window)  

General Notice: BOB is going to retire...please see details here.
General Notice: No events within the next 45 days.

Auditing report containing scheduled report information.


 
Search this topic... | Search Auditor... | Search Box
Register or Login to Post    Forum Index -> Other Products -> Auditor  Previous TopicPrint TopicNext Topic
Author Message
Sourabh.Ghadge
Forum Member
Forum Member



Joined: 11 Mar 2015

Posts: 7



PostPosted: Thu Feb 02, 2017 2:30 pm 
Post subject: Auditing report containing scheduled report information.

Hi All,

I need to create a report which will provide us information regarding especially "Scheduled" reports that ran on particular day/time (e.g. Monday XYZ), along with other information like, Schedule instance owner, report object name, path, status, Duration for which the report ran, start time, end time, etc.
I need this report very badly, since there are lot of reports scheduled specially on monday by our users, which is creating very much load on servers, resulting into slow running reports or failing them.
Please help.

Thanks,
Sourabh
Back to top
hilfy
Forum Enthusiast
Forum Enthusiast



Joined: 16 Apr 2007
ASUG Icon
speaker.gif*3
Posts: 1901
Location: Atlanta, GA


flag
PostPosted: Mon Feb 06, 2017 3:27 pm 
Post subject: Re: Auditing report containing scheduled report information.

If you're on version 4.x of the BI Platform, you'll need to go to the Auditing page in the CMC and make sure that "Folder Path Details" is checked.

From there, you should be able to get everything except the path from the ADS_EVENT table. You specifically want to pull data based on the "Run" event type. If you're doing this in Crystal instead of Webi, let me know and I'll write a query for you. If you're doing this in Webi, you should go here to get the latest version of the Audit universe: https://blogs.sap.com/2015/07/15/unlock-the-auditing-database-with-a-new-universe-and-web-intelligence-documents-for-bi41/.

-Dell[/url]

_________________
Protiviti
Data & Analytics Practice
https://www.protiviti.com/US-en/data-management-advanced-analytics
Back to top
mr1925
Forum Member
Forum Member



Joined: 30 Jul 2020

Posts: 1



PostPosted: Thu Jul 30, 2020 5:05 am 
Post subject: Re: Auditing report containing scheduled report information.

Hi Dell-

Could you please let us know how to get the webi schedule information in Audit report which includes "Scheduled" reports that ran on particular day/time (e.g. Monday XYZ), along with other information like,Instance title, Schedule instance owner, report object name, path, status, Duration for which the report ran, start time, end time, etc.

Thanks
MR
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Other Products -> Auditor  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0268 seconds using 17 queries. (SQL 0.0020 Parse 0.0008 Other 0.0240)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo