Overview

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. 

<supportagent>

Prerequisites

• Access to the Jump server.
• Access to the CIS database.

</supportagent>

Solution

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. 

<supportagent>

1. Login to the Jump server 10.185.40.141.
2. Open Microsoft SSMS and connect to aes.cons.com.
3. Select New Query in the top bar.
4. 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.

</supportagent>

Testing

The required information will be provided by CIS Support.