Skip to main content
commvault.com commvault.com
Solved

SQL Query for Disabled for Write

  • September 29, 2022
  • 2 replies
  • 95 views
N
Novice
Forum|alt.badge.img+4

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.

Best answer by Mike Struening

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

2 replies

Mike Struening
Vaulter
Forum|alt.badge.img+22
  • Mike StrueningVaulter
  • Vaulter
  • Answer
  • September 30, 2022

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

https://www.linkedin.com/in/michael-struening
J
Vaulter
Forum|alt.badge.img+10
  • JordanVaulter
  • Vaulter
  • September 30, 2022

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

Mike Struening
N
Terms & ConditionsCookie settingsAccessibility statement