verify user has been deleted

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

I have deactivated a user from UMP  and I still see it in the wasp logs, How can be sure that such user has been inactivated?

Cause

login attempts for that user will be seen in the logs but the user will not authenticate

Resolution

If you have deleted a user in UMP via account admin then you can verify this has been removed with the following SQL query 

SELECT * FROM [CA_UIM].[dbo].[User_] 

assuming the dbname is CA_UIM