Resource Table in Clarity Database

[Chris Flynn]

What table in the Clarity Database holds a complete list of user accounts? I am using the table CMN_SEC_USERS in the Clarity Universe to try and pull the full name from, but not all of my users are showing up in this table. Where would I find a complete list of users?

[Deactivated User]

CMN_SEC_USERS is the table that holds the Clarity users - all of them. Is your universe up to date?
Which users are missing?

Martti K.

[Chris Flynn]

I am missing so of my main licensed users that login into Clarity. How would I ensure my Universe is up to date? Do I have to run something in Clarity to update my Universe?



From: CA Clarity Global User Community [mailto:[e-mail]]
Sent: April 23, 2013 12:39 PM
To: [e-mail]
Subject: [Clarity Business Objects] RE: Resource Table in Clarity Database



CMN_SEC_USERS is the table that holds the Clarity users - all of them. Is your universe up to date?
Which users are missing?

Martti K.
Posted by:another_martink
--
CA Communities Message Boards
100875635
[e-mail]
https://communities.ca.com



“This email and any attached files are intended for the sole use of the primary and copied addressee(s) and may contain privileged and/or confidential information. Any distribution, use or copying by any means of this information is strictly prohibited. If you received this email in error, please delete it immediately and notify the sender.”

[Chris Flynn]

I figured it out. I had a restriction in the my universe editor to only display a 100 records. I increased it to 1000 and now I see all my users.

[navzjoshi00]

Thanks for sharing the info, Chris !!! :-)

NJ