You may need to know the last time a user accessed Aurea's CSR portal successfully. This article provides the process to acquire this information.
- Access to the Jump server.
- Access to the CIS database.
You can acquire the last time a specific user logged into the CSR portal successfully. This information is not found in the portal but can be provided by CIS Support. Create a support ticket, making sure to include the user's full name and/or email.
- Login to the Jump server 10.185.40.141.
- Open Microsoft SSMS and connect to
New Queryin the top bar.
- Get the last successful login for a user with the following query:
Select distinct Su.UserID,
Upper(Concat(Firstname ,' ' ,LastName))[User Name], Email,LastLoginSuccess From SecUser Su Join SecGroupSecUser Sgsu on Su.userid=sgsu.userid Where 1=1
and FirstName like '%givenname%'
and LastName like '%givenname%' and LastLoginSuccess > '2019/01/01' and activeflag=1
Note: The query above will only display active users. If the customer is requesting information about a user that could be inactive, the activeflag filter in the query must be removed.
The required information will be provided by CIS Support.