Posted: 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.
Posted: 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. _________________ My latest idea....