cancel
Showing results for 
Search instead for 
Did you mean: 

Media server count per master customer report?

lisareinhart
Level 4

Can anyone please assist with an SQL report for OpsCenter to count the media servers per master server and list in alphabetical order?

So the format would be:

master_server_1           50

Master_server2             75

Master_server3             14

 

TIA,

Lisa

1 ACCEPTED SOLUTION

Accepted Solutions

Ramazan_Cakir
Level 3

As this a clear request, here the query :

select BB.networkName as MasterServer, count(AA.name) as MediaServerCount
from domain_mediaserver AA, domain_masterserver BB
where AA.isValid = 1
and AA.masterServerId=BB.id
group by BB.networkName

But think that Master Server is also a Mediaserver and will count also.

Have fun :)

Ramazan

View solution in original post

2 REPLIES 2

Ramazan_Cakir
Level 3

As this a clear request, here the query :

select BB.networkName as MasterServer, count(AA.name) as MediaServerCount
from domain_mediaserver AA, domain_masterserver BB
where AA.isValid = 1
and AA.masterServerId=BB.id
group by BB.networkName

But think that Master Server is also a Mediaserver and will count also.

Have fun :)

Ramazan

lisareinhart
Level 4

Thanks so much!! perfect.