Skip to Content
0
Jan 04, 2017 at 05:56 AM

Report on Users who have not logged in BOfor consecutive 30 & 90 days

135 Views

Hi,

I need to find users who have not logged in BO for consecutive 30 & 90 days. Useing Query Builder I ran the query .

SELECT TOP 5000 SI_NAME, SI_LASTLOGONTIME FROM CI_SYSTEMOBJECTS WHERE SI_NAME NOT IN ('ADMINISTRATOR','GUEST') AND SI_KIND='USER' AND SI_LASTLOGONTIME > '2015.09.04' ORDER BY SI_NAME

Is there any way to verify the output.

And how to import the result into excel.

How to access Infostore Query