Report of User Details from CMC

security CMC
1

Hi all
Is there anyway of producing a report from the system database, which details account id, name, description, groups, enabled/disabled status?
Many thanks, Sandi

SandiR :uk: (BOB member since 2004-12-20)

2

Have you configured Audit database? If yes, you can trace from there.

sunchega :india: (BOB member since 2008-04-23)

3

Or check this utility from BOB downloads

.

haider :es: (BOB member since 2005-07-18)

4

Hi - yes audit is enabled - I will check in the activity universe.
But I had thought that the activity universe only tracked actual activity rather than the base tables such as users and groups.

I know there is a download in the dl section on here, but I am working on customer site and do not have access to the client side tools.

Many thanks

SandiR :uk: (BOB member since 2004-12-20)

5

Auditing does only list activity - so any users who haven’t logged in wouldn’t be listed.

David.Mitchell :uk: (BOB member since 2008-04-28)

6

[quote:778c9bd9a2=“David.Mitchell”]Auditing does only list activity - so any users who haven’t logged in wouldn’t be listed.
[/quote]

This is what I thought.
We are after a complete list of the users currently recorded on the system including all details except password.
I have used the macro’d spreadsheet in the past but only where I had access to the client side tools. It does not work from PCs which have WebI access only it seems.

I was having a look at the Query Builder from the launchpad, however I do not have access to the DDL for the system database to enable me to find out the tables and column names that I need.

Cheers, Sandi

SandiR :uk: (BOB member since 2004-12-20)

7

OK I have managed to get the information out using Query Builder and the following query however I was hoping it would be in a format that I could extract to a spreadsheet.
Cheers, Sandi

SELECT
SI_ID,
SI_NAME,
SI_USERFULLNAME,
SI_DESCRIPTION,
SI_USERGROUPS,
SI_EMAIL_ADDRESS,
SI_FORCE_PASSWORD_CHANGE,
SI_ALIASES,
SI_LASTLOGONTIME,
SI_PASSWORDEXPIRE
FROM
CI_SYSTEMOBJECTS
Where
SI_KIND=‘User’

SandiR :uk: (BOB member since 2004-12-20)

8

Yes, this is correct query for all CMC information and gets the data from Audit table. :+1:

sunchega :india: (BOB member since 2008-04-23)

9

Surely this comes from the system tables and not audit?
You can still get this information even if the Auditing is not switched on.
If it was from the Audit database, you would have been able to write a query against the Activity universe.

Curvy :uk: (BOB member since 2008-09-02)