Forum Discussion
3 Replies
- RiaanBadenhorstLevel 6
Report on what? Please be specific.
- DollypeeModerator
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
- M_henriksenLevel 4
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()) <= 14order by startTime DESC
Related Content
- 9 years ago
- 11 years ago