05-12-2014 12:39 PM
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
Solved! Go to Solution.
06-25-2014 07:59 AM
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
06-11-2014 10:51 AM
I would also like the steps needed for such a report.
06-20-2014 09:51 AM
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.
06-20-2014 10:11 AM
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.
06-25-2014 07:59 AM
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