05-03-2016 08:51 AM
Hi,
Could someone pleadse help me with the SQL script/steps to generate a list of all client list for a master server
Opscenter version - 7.7.1
05-03-2016 11:58 PM
Try this one
SELECT DISTINCT
B.friendlyName as 'Master Server',
A.clientName as 'Client Name'
FROM "domain_Job" A , "domain_masterserver" B
WHERE A.masterServerId = B.id
order by 1,2
05-05-2016 02:49 PM
@M_henriksen - wouldnt that show you all client names that were ever backed up? Well, I guess not ever, but for as long as OpsCenter keeps data for in the domain_job table (30 days?). Some of those could have already been deleted from policies by the time the query runs.