Tips for finding Knowledge Articles

  • - Enter just a few key words related to your question or problem
  • - Add Key words to refine your search as necessary
  • - Do not use punctuation
  • - Search is not case sensitive
  • - Avoid non-descriptive filler words like "how", "the", "what", etc.
  • - If you do not find what you are looking for the first time,reduce the number of key words you enter and try searching again.
  • - Minimum supported Internet Explorer version is IE9
Home  >

KB-7625: How to create a report showing policy modification in the last 30 days

App Access Service ,  

14 October,16 at 12:52 AM

Applies to:   All versions of Centrify Identity Service 

Question:  How to create a report showing policy modification in the last 30 days?

Answer:  Create a report with the SQL queries stated below.
  1. Go to Cloud Manager and click "Reports" on top menu.
  2. Click 'New Report"
  3. Fill in the name of the report under Settings and click "save"
  4. Click "Script Editor" and run the following SQL query for a custom report:
SELECT NormalizedUser,WhenOccurred,EventType,SetPath from event where ( EventType = 'Cloud.Core.Policy.PlinkChange' or EventType = 'Cloud.Core.Policy.AddSet' or EventType = 'Cloud.Core.Policy.ModifySet' or EventType = 'Cloud.Core.Policy.DeleteSet' or EventType = 'Cloud.Core.Policy.PlinkOrder')and WhenOccurred > DateFunc('now', '-30')
        User-added image

       5.Click "Role Access" and select the role whom you would like to grant access to.
The above query aims to show if there is any policy modification in the last 30 days.You can change the number from 30 in DateFunc('now', '-30') to any numbers such as 60 in DateFunc('now', '-60')  to read the policy modification in the last 60 days.The SQL query is very useful for administrators to keep track with the changes in policies and technical support engineers to troubleshoot issues caused by changes in policies.


Still have questions? Click here to log a technical support case, or collaborate with your peers in Centrify's Online Community.