Help on OpsCenter reports on restores from Exchange, NDMP, etc.

[Pierre_J]

Is it possible to create reports in OpsCenter Analytics on restores of a specific type, ie. an Exchange restore, an NDMP restore, a VM restore?

[M_henriksen]

Hi Peter de Jong.
I do not think it is possible because policy type information is not available for restore.
I have built this query, but maybe you or others can build on it.

SELECT
domain_MasterServer.friendlyName AS 'Master Server',
domain_jobArchive.id AS 'Job ID',
domain_jobArchive.clientName AS 'Client name',
UTCBigIntToNomTime(domain_jobArchive.startTime) AS 'Start Time',
UTCBigIntToNomTime(domain_jobArchive.endTime) AS 'End Time',
domain_jobArchive.statusCode AS 'Status Code'
from domain_JobArchive, domain_MasterServer, lookup_PolicyType
WHERE domain_jobArchive.masterServerId = domain_MasterServer.id
AND type = '2'
AND DATEDIFF(day,UtcBigIntToNomTime(domain_jobArchive.endTime), GETDATE()) <= 14
order by domain_jobArchive.startTime DESC

Br Morten