Forum Discussion

lisareinhart's avatar
lisareinhart
Level 4
12 years ago
Solved

Media server count per master customer report?

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

Backup and Recovery
OpsCenter
Reporting
Windows Server (2003-2008)
  • Ramazan_Cakir's avatar
    Ramazan_Cakir
    11 years ago

    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

  • Ramazan_Cakir's avatar
    Ramazan_Cakir
    Level 3
    11 years ago

    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