Is there a table in commserve where we can find the days since the last password change? also alert/event to find the login events for a particular user
Solved
Is there a table in commserve where we can find the days since the last password change? also alert/event to find the login events for a particular user
- Novice
Best answer by Jos Meijer
Hi
Here is a query which will show you the last change date [datePasswordSet]:
SELECT [id]
,[name]
,[datePasswordSet]
,[lastLogInTime]
FROM [CommServ].[dbo].[UMUsers]
WHERE [id] >= 0Please 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).
+16- Community All Star
- Answer
Hi
Here is a query which will show you the last change date [datePasswordSet]:
SELECT [id]
,[name]
,[datePasswordSet]
,[lastLogInTime]
FROM [CommServ].[dbo].[UMUsers]
WHERE [id] >= 0Please 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).
- Novice
Thanks
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 :(
+16- Community All Star
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)
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.