Commvault Database to fetch information related to Media Agent properites

@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