In BO 6.5, I know that I could query the repository and look to see which users are enabled or disabled with a query like:
From obj_m_actor
Where m_actor_n_type <> 1
AND M_ACTOR_N_STATUS <> 0
Can this type of query be done in BOXIR2?
Thanks,
Terance
tb185024 
(BOB member since 2007-09-12)
A bit tricker as the repository doesn’t allow normal relational queries against it in XI.
You can use the SDK which would involve writing code and understanding the SDK object model.
A possible solution is to use Query Builder.
Go to http://:8080/businessobjects/enterprise115/adminlaunch
and then on the left, there’s a link to Query Builder.
Here you can query the repository.
If you type:
select top 10 * from ci_systemobjects where SI_PROGID=‘CrystalEnterprise.User’
This will return the first 10 users in the system and show you all the properties for it. Unfortunately, the si_disabled property is not a primary property and so you cannot query for it directly.
You could query:
select si_name,si_aliases from ci_systemobjects where SI_PROGID=‘CrystalEnterprise.User’
which will return all users, the username and the disabled flag of true or false. you could then cut-n-paste into Excel and frig around with it and get the answer you need.
chesl73 (BOB member since 2008-05-15)
Alternatively, Julian has provided an Excel spreadsheet in his post on the download forum here.
This is neater than the Query Builder since you get a physical output.
dessa 
(BOB member since 2004-01-29)