Solved

SQL Query for Disabled for Write

  • 29 September 2022
  • 2 replies
  • 81 views

Badge +5

Hi Team,

I was developing a SQL query for Library space details in which I need to get Lib Name, Capacity, FreeSpace. I got the LibName, Capacity, FreeSpace columns from the CSDB tables.

But I need the column through which I can exclude the “Disabled for Write” option on mount paths.

Can someone please let me know in which table that status of “disabled for write” will be available.

 

Thanks,

Harshavardhan.

icon

Best answer by Mike Struening RETIRED 30 September 2022, 22:26

View original

2 replies

Userlevel 7
Badge +23

@naraharsha , have you looked into using REST API calls to get this info?

We have it right here:

https://documentation.commvault.com/v11/essential/49044_rest_api_get_storage_pool_details.html

Let me know if that helps.

Userlevel 5
Badge +11

REST API doesn’t have the MP level info, @naraharsha, will ping you direct on the field you need.

Reply