09-30-2015 10:49 PM
Good day!
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 7.6.1.1 & 7.6.0.2
Master server name |
policy name |
policy type |
policy status |
client name |
Client status |
schedule name |
path selection |
client verison |
client hardware |
Solved! Go to Solution.
10-05-2015 01:00 AM
Pleasure. Please mark it as the solution.
10-01-2015 05:09 AM
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
10-01-2015 05:48 AM
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..
10-01-2015 10:18 PM
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)
10-05-2015 12:22 AM
Riaan,
Thank You so much ! Your Opscenter SQL query worked well.
10-05-2015 01:00 AM
Pleasure. Please mark it as the solution.