Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Need script to disable selected users in BOEXI 3.1

Hi,

I am looking for a script to disable selected users. I have a query builder query which I want to use in that script to disable users.

SELECT SI_NAME, SI_LASTLOGONTIME, SI_CREATION_TIME FROM CI_SYSTEMOBJECTS WHERE SI_NAME NOT IN ('ADMINISTRATOR','GUEST') AND SI_KIND='USER' AND SI_CREATION_TIME <= '2012.12.31' AND SI_LASTLOGONTIME IS NULL ORDER BY SI_NAME

Please help.

Regards,

Lokesh

Former Member
replied

Also use '*' in the query and check the results.

Thanks,

Prithvi

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question