Skip to main content
commvault.com commvault.com

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

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

 




 

​@DUO-CSR

The above API is supported from SP34 onwards.

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 :)

 

​@DUO-CSR 

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

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 ;)

 

Hi ​@DUO-CSR 

Thanks for the sharing the details.

Reply


Terms & ConditionsCookie settings