Skip to main content
Solved

User details CommServe DB query


Forum|alt.badge.img+7

Good Day Community,

 

An auditing company is requesting the system generated user listings for Commvault from Jan 1st, 2023 – July 31st 2023, showing the following parameters:  

o    user ID

o    user status (active/disabled)

o    user creation date

o    user disabled date

o    access roles/groups

o    last login date.  

 

Is there a report I can run that would give that information?

If not, I’d like to create a custom report from the WebConsole, but what would be the table/view with the required information?

Many thanks in advance.

Best answer by Navneet Singh

Also you can check from SSMS (CSDB): select * from UMusers this will give you all users details.

View original
Did this answer your question?

Forum|alt.badge.img+10

@Carl Brault 

Hi Carl, Please try using the below API call and check if this helps.

https://api.commvault.com/#2183553d-7b3e-4d4d-9818-0f8e1677f774


Forum|alt.badge.img+10

Also you can check from SSMS (CSDB): select * from UMusers this will give you all users details.


Forum|alt.badge.img+7

Thanks to both of you!

That was awesome. I used the SQL table and was able to generate a custom report with the required information.

Have an excellent day!


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