Video Screencast Help

opscenter 7.5 Report using query

Created: 01 May 2013 | 2 comments

I'm attempting to create a query in Ops Center 7.5 to accomplish the following report: Client name, mastername ,policy name, backup window, retention period

The problem is that I know jack about SQL queries and I don't see any way of creating this report outside of a custom query. Any advice or pointers here are appreciated. Thank you.

Operating Systems:

Comments 2 CommentsJump to latest comment

huanglao2002's picture

if you want to use "SQL queries" function, it need OpsCenter Analytics license.

MilesVScott's picture

Just to let you the info you want from the4 database will give you multiple multiple rows for each policy. You will need to put in into excel and do some sort of pivot on it or something of the sort...

SELECT dpc.clientName AS 'Client'
       ,dm.networkName AS 'Master Server'
       ,dp.name AS 'Policy Name'
       ,ds.windows AS 'Backup Window'
       ,ds.retension AS 'Retention Level'
       ,st.name AS 'Backup Type'
FROM domain_Policy dp
INNER JOIN domain_PolicyClient dpc
ON dp.name = dpc.policyName
INNER JOIN domain_Schedule ds
ON dpc.policyName = ds.policyName
INNER JOIN domain_MasterServer dm
ON dp.masterServerId = dm.id
INNER JOIN lookup_ScheduleType st
ON st.id = ds.type

Also I have not found a way to convert the window into something readable so that will be a deffinate fallback. If you can figure out how to convert the window data into something that dosen't make my eyes bleed, let me know.

If my answer was helpful, please mark as a solution so others can benefit as well.

NBU 7.1.0.3,Win 2k3 Enterprise x64 SP2

Miles Scott | Holland & Knight
IT Infrastructure Specialist