Centrify directory password report

Showing results for 
Search instead for 
Do you mean 
Reply
Highlighted
Participant I
Posts: 1
Registered: ‎12-12-2018
#1 of 2 398

Centrify directory password report

I am trying to create a report that shows all user accounts from the Centrify Directory and when their password was set. Is there a data dictionary that give you the date of password change?

Centrify Guru I
Posts: 2,432
Registered: ‎07-26-2012
#2 of 2 391

Re: Centrify directory password report

@KCantCet,

 

Welcome to the Centrify Forums.

Looks like you've posted in Centrify Express.  Are you a commercial customer?  Instructions like these are part of the enablement during professional services delivery.

 

If you're referring to Privilege Access Service, you can use Report Builder  (Core Services > Reports > New Report) and this capability is self-documenting (e.g. you have access to the data dictionary inline).

 

Here's an example using te VaultAccount table (the table that contains the accounts in the vault):

last-cha.PNG

As you check te boxes, it will provide you with the SQL.

You can also preview your results.

rep-prev.PNG

 

Another example (and that's what I think you meant) is a Centrify Directory user.  In that case I'd look at the Event Table within the Cloud.SaaS.PasswordChange context and relate to te CDUser table.

 

Unfortunately I  don't have data for that example (Idaptive leads feel free to chime-in).

 

If you are referring to an Active Directory user, you can use PowerShell or other tools

e.g. get-aduser -filter * -properties passwordlastset, passwordneverexpires |ft Name, passwordlastset, Passwordneverexpires

 

R.P

Want to learn more about practical Centrify examples? Check out my blog at http://centrifying.blogspot.com
Follow Centrify: