06-24-2014 05:15 AM
Hi All
I am looking for SQL query which provides all offline clients list and deactived policy list.
Could any one help with the script.
Thanks-----
06-24-2014 05:17 AM
I am looking for SQl scripts which gives all offline client list in netbackup domains.
and required SQL scripts for providing deactivated policy list on netbackups domains.
06-25-2014 08:12 AM
select name AS "Client Name",
deleted as "deleted",
retired as "retired"
from domain_client WHERE masterServerID=61 AND deleted=1 OR retired=1
order by name
select name AS "Policy Name",
UTCBigintToUTCTime(effectivedate) AS "Date Effective",
UTCBigintToUTCTime(retirement) AS "Retired on",
UTCBigintToUTCTime(discoveryLifetime) AS "Discovery Lifetime"
from domain_Policy WHERE masterServerID=61 AND active=0
order by name