How to retrieve users which are active from CMC and not disabled ?

[Former Member]

Hi,

Can anyone let me know how to query for  users from CMC which are not disabled ?

My query is :

Select SI_ID, SI_NAME, SI_DESCRIPTION, SI_DISABLED

From CI_SYSTEMOBJECTS

where SI_KIND = 'User'

But this does not return any info about the SI_DISABLE object since it a nested property of SI_ALIASES ?

And if I put a where clause SI_DISABLED=false then it does not return any users ?

Select SI_ID, SI_NAME, SI_DESCRIPTION

From CI_SYSTEMOBJECTS

where SI_KIND = 'User' AND SI_DISABLED=false

Also the SI_DISABLED being the nested property of SI_ALIASES

Also otherwise if any one can let me know what property to look for when retrieving the field  'Account is disabled' from CMC

Here is the screen capture for better understanding of my question ?

My aim here is, I don't want to get the users who have this value set to true, as these are the one's that have been Disabled from the AD.

I appreciate any help on this topic

Thanks

[manikandan_elumalai]

Instead of SI_DISABLED, can we try with SI_ALIASES.SI_DISABLED?

This is possible if the property is nested within the immediate level of the top most property

[adityabhosrekar]

Hi,

Did you get the solution ?