Generating a User List

[OV]

Does anyone know how to generate a list of the users in the system, with their names and logins.
Thanks OV

 

[chael]

There should be a command line manager script for this -- do you have the MicroStrategy Administrator?

 

[OV]

Chael
I don't see a command for that in command manger. Everything in command managerrequires to specify a user.

OV

 

[OV]

If anyone who is interested, I went to the metadata DB and ran the following query:

select OBJECT_NAME,ABBREVIATION
from DSSMDOBJINFO A inner join DSSMDUSRACCT B on A.OBJECT_ID=B.OBJECT_ID
where OBJECT_TYPE =34
and SUBTYPE=8704

 

[wolf5370]

CMD MGR command:

LIST ALL PROPERTIES FOR USERS IN GROUP "everyone" ;

All users are in 'everyone', so you get all the users with their properties.

Richard