+5HI Team,
I am putting media agent in maintenance mode through exescript post which i want to run a sql query to fetch media agent name along with showing whether media agent is marked in maintenance mode or not.
Can someone help me with sql table wherein i can fetch this information.
Best answer by Abhishek Narulkar
Hi
select host.ClientId, APPC.name
from MMHost host with (readuncommitted)
inner join APP_Client APPC with (readuncommitted) ON host.ClientId = APPC.id
where host.Attribute & 16 /*MMS2_MA_MARKED_FOR_MAINTENANCE*/ > 0
please try the view check if it helps
select * from CommCellMediaAgentInfo
+5Hi Sujay,
Above query doesnt give expected output. It doesnt have any column to show if a MA is marked in maintenance mode or not.
Hi
select host.ClientId, APPC.name
from MMHost host with (readuncommitted)
inner join APP_Client APPC with (readuncommitted) ON host.ClientId = APPC.id
where host.Attribute & 16 /*MMS2_MA_MARKED_FOR_MAINTENANCE*/ > 0
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
