Skip to Content
avatar image
Former Member

Query to get list of modified reports in last one month

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Nov 10, 2017 at 09:16 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 10, 2017 at 01:39 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 10, 2017 at 05:26 PM

    Hi Jawahar--We are in BI 4.1SP4.

    Add comment
    10|10000 characters needed characters exceeded