I have requirement to get ntebackup configurations from symantec opscenter. I tried with opscenter custom report but there i dont have any option to join the tables path selection and client version.
Can you please help me in getting the configuratioin information in the following format using opscenter? This is no time basis. If you need any information please let me know.
opscenter version we using are 184.108.40.206 & 220.127.116.11
|Master server name|
Solved! Go to Solution.
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
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..
Here you go.
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"
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
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_Schedule.type = lookup_scheduletype.id AND
domain_Policy.active in (1) AND
domain_policy.versionNo in (1) AND
domain_schedule.scheduleid not in (-2147483633)