Showing results for 
Search instead for 
Did you mean: 

OpsCenter Custom Report

Not applicable


         I've been playing with OpsCenter for a couple days trying to create a Custom Report to no avail. My report need to list all the policies on the Master Server, whether or not the policy is active and the servers associated with that policy. Can anyone provide some guidance on this matter?





Level 6

Can't find a template where you can use for all policies, you can try with this SQL query:

SELECT distinct AS 'policy name', b.friendlyname AS 'master server'
FROM nb_policy a,  domain_masterserver b
WHERE  ( a.masterserverID =

Please note this list all policies (regardless of active/inactive) and include SLP policies as well.

Level 6
Employee Accredited Certified


I have been working on something for another coworker / customer... 

Please try the following and let me know how this looks...

It may report some duplicate information, which I am trying to resolve... 

I have tested it, in my lab, but I must provide the following disclaimer:

This script is provided for educational purposes only...and should not be utilized for production reporting. Additional Testing of this script in your environment should be performed and validated against the data that is currently present in your environment.

If anyone can offer any additional support / advice - please let us know.


   dms.networkname AS 'Master', AS 'ClientName', AS 'PolicyName', AS 'PolicyStatus'

FROM domain_client dc
  JOIN domain_policyclient dpc
    ON dpc.clientname =
  JOIN domain_policy dp
    ON = dpc.policyname
  JOIN domain_masterserver dms
    ON = dpc.masterserverid
  JOIN lookup_policystatus lps
    ON dp.status =
  JOIN nb_policy nbp
    ON =

WHERE dp.versionno = nbp.versionNo
  AND dp.versionno = dpc.policyversionno

GROUP BY dms.networkname,,, 
ORDER BY, dms.networkname,