Skip to main content
Solved

User details CommServe DB query

  • August 21, 2023
  • 3 replies
  • 91 views

Forum|alt.badge.img+6

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.

3 replies

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
  • Vaulter
  • Answer
  • August 21, 2023

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


Forum|alt.badge.img+6
  • Author
  • Novice
  • August 21, 2023

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!