cancel
Showing results for 
Search instead for 
Did you mean: 

OPS Center Report On Clients In Policy

ianhoskins
Level 4

I am looking for either a customized canned report or help with a SQL query to list clients and their associated policy(ies)
I think I am running into a problem because some of my policies are disabled and have no backup history. (For tracking of exempt from backup)
So it should look something like this:

server1     policy1
server1     policy2
server2     policy1
server2     policy2
server3     exempt
server4     policy3

I looked at using domain_policyClient, but it is missing data from the disabled policies.
Also looked at a Backup/Recovery Job/Image/Media/Disk with NoTimeBasis selecting Client and Policy Name, but again no data about disabled policies

I'm not very SQL savy so trying to figure out where to join all the info from tables domain_Client, domain_Policy, domain_MasterServer, domain_Entity makes my eyes crossed.
OPSAnalytics7.6

Any help would be appreciated

 

ian

1 ACCEPTED SOLUTION

Accepted Solutions

DG-2005
Level 5

Think this might do it. sorry on formatting, best i could get it:

select *
from(select name AS "Name",
id
from domain_client WHERE masterServerID=61) t1

INNER JOIN (select
policyname AS "Policy Name",
clientName AS "Client",
clientID AS "Client_ID"
from domain_PolicyClient where masterServerid=61) t3
ON t3.Client_ID=t1.id

ORDER BY name

View solution in original post

4 REPLIES 4

PDragon
Level 4

I would also like the steps needed for such a report.

DG-2005
Level 5

would bpcoverage -c client_name be what you are looking for? This shows client installed systems and where they reside within policies.

 

looking into the vm-based ones, will post if I find anything.
 

PDragon
Level 4

Nope, as the goal is to build reporting inside of Ops Center with out requiring the need for a shell/commnad prompt.

Using /usr/openv/netbackup/bin/admincmd/bpcoverage -c is one option, however we are looking for a solution using the analytics reporting tool inside of Ops Center.

DG-2005
Level 5

Think this might do it. sorry on formatting, best i could get it:

select *
from(select name AS "Name",
id
from domain_client WHERE masterServerID=61) t1

INNER JOIN (select
policyname AS "Policy Name",
clientName AS "Client",
clientID AS "Client_ID"
from domain_PolicyClient where masterServerid=61) t3
ON t3.Client_ID=t1.id

ORDER BY name