How to find Users not in use past one year

[Former Member]

Hi Exports ,

Ian using sap Bo 3.1 sp5 . We are having Round 1000 users ..But  few of the users are not using there account from past 1 year .How can we find them

Thanks,

Raghunath

[Former Member · Accepted solution]

Sample Query :

SELECT count (SI_NAME)  FROM CI_SYSTEMOBJECTS

WHERE SI_LASTLOGONTIME> '2014.10.06.00.00.01' AND SI_KIND = 'Connection'

[Former Member]

Dear

You can take help from ABAPER and develop pgm and ztcode from where you can access the report when ever you want

you can use following tables

usr02

usr21

usr06

Regards