Skip to main content
Question

Commvault Database to fetch information related to Media Agent properites


Forum|alt.badge.img+6

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.

3 replies

Forum|alt.badge.img+7
  • Vaulter
  • 70 replies
  • December 13, 2023

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


Forum|alt.badge.img+6
  • Author
  • Byte
  • 30 replies
  • December 15, 2023

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.


Forum|alt.badge.img+8

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings