Hi @alligator 

Here is a query which will show you the last change date datePasswordSet]:

SELECT  id]
      ,,name]
      ,,datePasswordSet]
      ,,lastLogInTime]
  FROM  CommServ]..dbo]..UMUsers]
  WHERE  id] >= 0

Please note this is not a regular date notation, not sure how to convert yet.
Additionally I suspect this table is only useful for local commvault users as the password policy otherwise is managed by an external user database (AD etc).

Thanks @Jos Meijer this is really helpful

Why don’t we have any events for user login, however I do see them in audit trial logs.

but couldn’t find any straightforward way to configure this as event/alert :(

Regarding the login alert you can perform the following:

Create events based on login and logoff activity using the following additional setting:

https://documentation.commvault.com/additionalsetting/details?name=%22bCreateEventForLoginAndLogout%22&id=12689

Create an event based alert based on:

Category: Operation
Type: Event Viewer Events
Entities: Commserve
Event Code equals to 35:1911
Select your notification type (email etc)