Opscenter report to pull netbackup configuration

Same type of query in this post.

https://www-secure.symantec.com/connect/forums/how-export-all-policy-attributesconfigand-others-such-throughput-using-sql-query

Hi Riaan,

Thank you for your response!

please note that i have multiple backup servers in the opscenter based on regions. The sql query showing in above link working fine in my opsceneter but it does not showing corresponding master servers.

can you customize the same sql qurey to include following three columns?

Master server name

Client version.

policy status

NB: policy i need both active and inactive list. In that way i can generate junk policy list which we can remove.

Please let know if you need any further info..

Hi,

 

Here you go.

 

SELECT
domain_PolicyClient.policyName as "Policy Name",
lookup_PolicyType.name as "Policy Type",
lookup_policystatus.name as "Status",
domain_Policy.active as "Active",
domain_PolicyClient.clientName as "Client Name",
nb_policy.usefastbackup as "Accelerator",
nb_policy.storageUnitName as "Storage Unit",
nb_policy.volumePoolName as "Volume Pool",
domain_client.hardwaredescription as "Hardware",
domain_client.osdescription as "Operating System",
domain_client.versionLabel as "Client Version",
nb_Policy.fileList as "Backup Selection",
domain_schedule.Name as "Schedule",
lookup_scheduletype.name as "Schedule Type",
lookup_policystatus.name as "Policy Status",
domain_masterserver.networkname as "Master"

FROM
domain_PolicyClient, domain_Client,lookup_PolicyType, domain_Policy, nb_Policy, lookup_policystatus, lookup_scheduletype, domain_schedule, lookup_policystatus, domain_masterserver

WHERE domain_Policy.masterServerId = domain_Schedule.masterServerId
AND domain_Policy.name =  domain_Schedule.policyName
AND domain_Policy.policyDomainName = domain_Schedule.policyDomainName
AND domain_Policy.versionNo =  domain_Schedule.policyVersionNo
AND domain_Policy.name = nb_Policy.name
AND domain_Policy.masterServerId = nb_Policy.masterServerId  
AND domain_Policy.versionNo = nb_Policy.versionNo  
AND domain_Policy.policyDomainName = nb_Policy.policyDomainName  
AND lookup_PolicyType.id = domain_Policy.type
AND
lookup_PolicyType.id = domain_Policy.type AND

domain_PolicyClient.clientName = domain_Client.name  AND
domain_PolicyClient.masterServerId = domain_Client.masterServerId  AND

domain_PolicyClient.policyName = domain_Policy.name AND
domain_PolicyClient.masterServerId = domain_Policy.masterServerId  AND
domain_PolicyClient.policyDomainName = domain_Policy.policyDomainName  AND
domain_PolicyClient.policyVersionNo= domain_Policy.versionNo  AND

domain_Policy.name = nb_Policy.name AND
domain_Policy.masterServerId = nb_Policy.masterServerId  AND
domain_Policy.versionNo = nb_Policy.versionNo  AND
domain_Policy.policyDomainName = nb_Policy.policyDomainName AND
domain_masterserver.id=domain_client.masterserverid AND
domain_Schedule.type = lookup_scheduletype.id AND
domain_Policy.active in (1) AND
domain_policy.versionNo  in (1) AND
domain_schedule.scheduleid not in (-2147483633)

Riaan,

Thank You so much ! Your Opscenter SQL query worked well.