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: No events within the next 45 days.

User requesting to view SQL of reports using Auditing Univer


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



Joined: 10 Dec 2004

Posts: 111



PostPosted: Wed Feb 28, 2018 8:45 am 
Post subject: User requesting to view SQL of reports using Auditing Univer

We have reports using the AUDIT universe to see user activity and we maintain a regular reports on these and now we want to know what reports are run regularly so we can convert them to Hana.

The issue here is users have saved the reports to their folders and we don't know which original report was it and we want to see the SQL to identify which report was that or Is there a way we can do this using audit universe or any other way which defines/lists the current run report name and what was the original report name.

Thanks for help in advance.
Also I was not sure if I was adding this to correct group if this is incorrect please guide me.
Back to top
Nick Daniels
Forum Aficionado
Forum Aficionado



Joined: 15 Aug 2002

Posts: 14141
Location: England


flag
PostPosted: Wed Feb 28, 2018 3:07 pm 
Post subject: Re: User requesting to view SQL of reports using Auditing Un

[Moderator note - moved to the Auditor forum]
Auditing out of the box doesn't capture this with the default settings. In CMC/Auditor there is a check box on the right...something like 'Query'. That collects the SQL but I have a feeling it has a character limit.

_________________
Available for contract work now.
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.0378 seconds using 17 queries. (SQL 0.0094 Parse 0.0009 Other 0.0275)
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