Skip to main content

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

@Rahul Nair Good day!
please try the view check if it helps
select * from CommCellMediaAgentInfo

Hi 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 @Rahul Nair , you can use this query to get the media Agents which are in maintenance.

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 
 

Reply


Terms & ConditionsCookie settings