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

[former_member208716]

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

[former_member185603]

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.

[jyothirmayee_s]

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