Skip to Content
0

Query to get list of modified reports in last one month

Nov 10, 2017 at 12:43 AM

61

avatar image
Former Member

Hi,

Any idea how to get list of objects and reports that are modified in BOE environment in last 30 days.

I got below query to get list of reports that are last updated on certain date.

SELECT SI_ID, SI_NAME, SI_UPDATE_TS FROM CI_INFOOBJECTS WHERE SI_KIND = ‘WebI’ AND SI_UPDATE_TS = ‘2017.11.09’

Thanks,

Vikram

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Erdem Pekcan Nov 10, 2017 at 09:16 AM
0

Hi,

You can create a universe on top of audit databases (or use shared ones on SCN). Then simply create filters by using time functions.

Share
10 |10000 characters needed characters left characters exceeded
Jawahar Konduru Nov 10, 2017 at 01:39 PM
0

Which version of BO are you in?

BI3 already has Audit db.

BI4 depending on which version you are on. Earlier version of BI4, there is Audit Universe available in SCN blog.

https://blogs.sap.com/2015/07/15/unlock-the-auditing-database-with-a-new-universe-and-web-intelligence-documents-for-bi41/

Later versions of BI 4.X, Audit Universe is part of BI install.

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Nov 10, 2017 at 05:26 PM
0

Hi Jawahar--We are in BI 4.1SP4.

Share
10 |10000 characters needed characters left characters exceeded