Skip to main content
commvault.com commvault.com
Solved

How to find SQL Server authentication using REST API?

  • December 23, 2024
  • 6 replies
  • 63 views
D
Byte
Forum|alt.badge.img+5

Friends,

We want to do a cleanup within our Credentials Vault and therefore I need to find out what MSSQL instances are using what credentials.


Via Protect - Databases, you can see in the Overview tab the option “SQL server authentication”.

Here you can override the Impersonate User on instance level. I want to do a check on these settings.

 

How can I find the used credentials using REST API?

 

Here you can set it for a new MSSQL instance, but I want to look this up and if possible update.
https://api.commvault.com/docs/SP36/api/cv/MSSQL_API/add-mssql-instance/

Thanks in advance,
Maurice

Best answer by DUO-CSR

I found the API call by hacking into the old Powershell modules…

GET /sql/instances?instanceName=<instancename>&propertyLevel=11

propertyLevel 11 is needed to show the authentication for the instance.

 

I can’t find detailed info about this call in the API documentation, only for collecting all instances; List all SQL instances | Commvault®

From the Powershell module I see that more available parameters: sql/instances?propertyLevel={propertyLevel}&paging={paging}&start={startPage}&max={pageSize}&sla={onlySLA}&sortBy={sortBy}&sortDir={sortDir}&search_term={searchTerm}&instanceName={instanceName}&clientName={clientName}

So I assume that the Commvault API documentation needs a few updates ;)

 

View original
Did this answer your question?

6 replies

P
Vaulter
Forum|alt.badge.img+11
  • PradeepVaulter
  • Vaulter
  • 235 replies
  • December 24, 2024

Hi ​@DUO-CSR 

our internal Dev team is already working on report to provide more granular details of credentials used at instance level. However,  At this moment we can either use below report or execute below API to fetch the details.

API details: GET /CommCell/Credential/{credentialId}?propertyLevel=50 

CMR : 381246


Credentials association  report :  https://cloud.commvault.com/webconsole/softwarestore/store.do#!/135/663/29930

 




 

P
Vaulter
Forum|alt.badge.img+11
  • PradeepVaulter
  • Vaulter
  • 235 replies
  • December 24, 2024

​@DUO-CSR

The above API is supported from SP34 onwards.

D
Byte
Forum|alt.badge.img+5
  • DUO-CSR
  • Author
  • Byte
  • 22 replies
  • December 24, 2024

Thank you ​@Pradeep !!

 

Currently we use 11.32, but we will upgrade in about 2 / 3 months to 11.36, so I will be patient for now :)

 

P
1 person likes this
  • P
    Pradeep
P
Vaulter
Forum|alt.badge.img+11
  • PradeepVaulter
  • Vaulter
  • 235 replies
  • December 24, 2024

​@DUO-CSR 

You  can upgrade the system as per your convenient and use API or report.

D
Byte
Forum|alt.badge.img+5
  • DUO-CSR
  • Author
  • Byte
  • 22 replies
  • Answer
  • January 6, 2025

I found the API call by hacking into the old Powershell modules…

GET /sql/instances?instanceName=<instancename>&propertyLevel=11

propertyLevel 11 is needed to show the authentication for the instance.

 

I can’t find detailed info about this call in the API documentation, only for collecting all instances; List all SQL instances | Commvault®

From the Powershell module I see that more available parameters: sql/instances?propertyLevel={propertyLevel}&paging={paging}&start={startPage}&max={pageSize}&sla={onlySLA}&sortBy={sortBy}&sortDir={sortDir}&search_term={searchTerm}&instanceName={instanceName}&clientName={clientName}

So I assume that the Commvault API documentation needs a few updates ;)

 

P
Vaulter
Forum|alt.badge.img+11
  • PradeepVaulter
  • Vaulter
  • 235 replies
  • January 8, 2025

Hi ​@DUO-CSR 

Thanks for the sharing the details.

Reply


Most helpful members this week

Terms & ConditionsCookie settings

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