Skip to Content
0

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

Mar 23, 2017 at 02:50 PM

45

avatar image

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

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

2 Answers

Jawahar Konduru Mar 24, 2017 at 06:57 PM
1

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.

Share
10 |10000 characters needed characters left characters exceeded
Jyothirmayee A Mar 23, 2017 at 03:23 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded