Query to get list of modified reports in last one month

[former_member418791]

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

[former_member418791]

Hi Jawahar--We are in BI 4.1SP4.

[former_member185603]

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-intelligen...

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

[erdempekcan]

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.