06-23-2015 04:06 AM
Hi Folks,
I need some sample Opscenter basic queries to pull out report for a client.. Pls help me.
Thanks,
Sathish
06-23-2015 04:33 AM
Try this, just change 'your.server.name' with the correct one
clientName AS "Client",
policyName AS "Policy Name",
lookup_ScheduleType.name AS "Schedule Type",
utcbiginttonomtime(startTime) AS "Start Time",
utcbiginttonomtime(endTime) AS "End Time",
DATEDIFF(mi, utcbiginttonomtime(StartTime), utcbiginttonomtime(EndTime)) AS "Duration (Min)",
filesBackedUp AS "File Count",
(bytesWritten/1024/1024/1024) AS "Size (GB)",
statuscode AS "Status Code"
FROM domain_jobArchive
JOIN lookup_ScheduleType
ON lookup_ScheduleType.id = domain_jobArchive.scheduleType
WHERE clientName = 'your.server.name'
DATEDIFF(day,UTCBigIntToNomTime(endTime), GETDATE()) <= 14
order by startTime DESC
06-23-2015 06:59 AM
Check this link for most client related query report : https://www-secure.symantec.com/connect/downloads/opscenter-common-custom-reports
If what you are looking for isn't there, give us a clue of what report you are looking for. Thanks
06-24-2015 09:27 PM
Report on what? Please be specific.