Forum Discussion

Michael_G_Ander's avatar
Michael_G_Ander
Level 6
12 years ago

Number of policies over time report ?

Hello

We are trying to generate a report over the number of policies over time

We would like the number of policies per month per year, the average number of policies would the be fine as it is for seeing trend in the number policies

Regards

Michael

 

Backup and Recovery
OpsCenter
Reporting
Windows Server (2003-2008)
  • MilesVScott's avatar
    MilesVScott
    Level 6
    12 years ago
    SELECT COUNT(*) AS 'Active Policy Count'
    FROM domain_policy dp
    INNER JOIN lookup_PolicyStatus ps
    ON dp.status = ps.id
    WHERE ps.name = 'Active'
     
    That will give you the current active policies. You can also change the where clause to look for Retired, Pending, Deleted, Unknown, or Failed.
  • MilesVScott's avatar
    MilesVScott
    Level 6
    12 years ago

    I guess I am a little confused. The statment I provided will give a count of any policy that is currently visable under policies in your NBU Console. This includes policies that have been disabled, but not ones that have been deleted.

     

    If the SQL statment did not give you what you needed, can you clarify what you are looking for?