User Information from CMS DB

[Former Member]

Hi Gurus,

We are planning to develop user password expiry information report before going to expire the same from we would like to get all users who have been going to expire their passwords in five days

For this we want build metadata data universe for password expiry info report.

But whenever i looked it am getting encrypted information with CMS_INFOOBJECTS5 table..

Any idea how do we achieve it using CMS tables?

Note: we are using CMS DB as Oracle 10G...

We are having BOXI 11.5.0 version

and we are not configured for Audit DB.

[roland_hoeller2 · Accepted solution]

Hi

Reporting directly of the CMS tables is strongly discouraged that is one of the reasons why they are encrypted. You can use Query Builder and query the Infostore.

Like this:

SELECT * FROM CI_SYSTEMOBJECTS WHERE SI_KIND = 'USER' to see all the user related information.

You will notice that there is a SI_LAST_PASSWORD_CHANGE_TIME property which lets you work out the password expiry date.

Unfortunately you will not use this information in a report for that you would need to use Auditing

Kind Regards

Roland

[Former Member]

If you need it combined with the Audit Data there is a product called Audit Launch that enhances the Audit Universe with these types of attributes for user, group, folder,etc

Kevin McManus

www.mcmanussoft.com/AuditLaunch.htm