Forum Discussion
M_henriksen
10 years agoLevel 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()) <= 14
order by startTime DESC
Related Content
- 9 years ago
- 11 years ago