Skip to Content

Users details those who logged in to the server and refreshed some reports within last 60 days

Hello Experts,

Can you please provide the query to use in query builder for below. Env: SAP BO4.1

Need to get the users details those who logged in to the server and refreshed around 10 reports in last 60 days.

I have searched the same but didn't see how to get the details for some particular reports(with its name).

Thanks

LKumar

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Mar 24, 2017 at 06:57 PM

    Query builder will not give Audit information. Only information you can get is when was the user logged in, not on running the reports. You need to use Audit universe to get those details.

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 23, 2017 at 03:23 PM

    HI,

    Try this:

    SELECT SI_NAME, SI_LASTLOGONTIME , CI_INFOOBJECTS FROM CI_SYSTEMOBJECTS

    SI_KIND='USER' AND SI_LASTLOGONTIME < '2017.01.23'

    ORDER BY SI_NAME

    Thanks,

    Jothi

    Add comment
    10|10000 characters needed characters exceeded