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