03-21-2014 08:11 AM
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
Solved! Go to Solution.
04-07-2014 12:28 PM
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
04-07-2014 12:28 PM
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
04-08-2014 06:50 AM
Thanks so much!! perfect.