cancel
Showing results for 
Search instead for 
Did you mean: 

Opscenter report to pull active clients for one master server

Vamika
Level 3

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

2 REPLIES 2

M_henriksen
Level 4
Partner

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

areznik
Level 5

@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.