Logs
Insight generates and stores the following security events in the Administration database:
-
User's successful login
-
User's attempt to log in with incorrect credentials
-
User's logout
-
Adding/updating/deleting roles in Admin Console
-
Adding/updating/deleting users in Admin Console
-
Changing the expired password for the user
-
Opening a View
-
Printing a View
-
Printing a report
-
Exporting to Excel
To view these logs, on the SQL server, navigate to the dbo.INSIGHTLOG table in the Administration database.
Logs for an Insight user
Possible log events for an Insight user include the following.
Datetime |
User |
ProjectID |
Event |
Value |
Application Type |
isSuccess |
SourceIP |
|
---|---|---|---|---|---|---|---|---|
Login |
Date/time stamp |
The name of the user that performs the action. |
Not applicable |
Login |
The number of concurrent users. For example, if you log in as the same user in three different browsers, each browser will have a separate "login" event where "Value" shows the number from one to three (by the sequence number of the opened browser). |
Insight application |
1 (success) |
IP address of the application |
Wrong login |
Date/time stamp |
The name of the user that performs the action. |
Not applicable |
Login |
The number of concurrent users. For example, if you log in as the same user in three different browsers, each browser will have a separate "login" event where "Value" shows the number from one to three (by the sequence number of the opened browser). |
Insight application |
0 (failure) |
IP address of the application |
Logout |
Date/time stamp |
The name of the user that performs the action. |
Not applicable |
Logout |
Not applicable |
Insight application |
1 for success and 0 for failure |
IP address of the application |
Change password |
Date/time stamp |
The name of the user that performs the action. |
Not applicable |
ChangePassword |
User ID stored in the INSIGHTUSERS table in the Admin DB. |
Insight application |
1 for success and 0 for failure |
IP address of the application |
Create a user |
Date/time stamp |
The name of the user that performs the action. |
Not applicable |
Update |
User ID stored in the INSIGHTUSERS table in the Admin DB. |
Insight application |
1 for success and 0 for failure |
IP address of the application |
Update a user |
Date/time stamp |
The name of the user that performs the action. |
Not applicable |
Update |
User ID stored in the INSIGHTUSERS table in the Admin DB. |
Insight application |
1 for success and 0 for failure |
IP address of the application |
Delete a user |
Date/time stamp |
The name of the user that performs the action. |
Not applicable |
Delete |
User ID stored in the INSIGHTUSERS table in the Admin DB. |
Insight application |
1 for success and 0 for failure |
IP address of the application |
Create a user role |
Date/time stamp |
The name of the user that performs the action. |
Not applicable |
Update |
Role ID stored in the ROLES table in the Admin DB. |
Insight application |
1 for success and 0 for failure |
IP address of the application |
Update a user role |
Date/time stamp |
The name of the user that performs the action. |
Not applicable |
Update |
Role ID stored in the ROLES table in the Admin DB. |
Insight application |
1 for success and 0 for failure |
IP address of the application |
Delete a user role |
Date/time stamp |
The name of the user that performs the action. |
Not applicable |
Delete |
Role ID stored in the ROLES table in the Admin DB. |
Insight application |
1 for success and 0 for failure |
IP address of the application |
Create/Update/Delete an Administrator role |
Date/time stamp |
The name of the user that performs the action. |
Not applicable |
Update/Delete |
Role ID stored in the ROLES table in the Admin DB. |
Insight application |
1 for success and 0 for failure |
IP address of the application |
Open a View |
Date/time stamp |
The name of the user that performs the action. |
Project ID of the View |
OpenView |
The name of the View |
Insight application |
1 for success and 0 for failure |
IP address of the application |
Print a View |
Date/time stamp |
The name of the user that performs the action. |
Project ID of the View |
PrintView |
The name of the View |
Insight application |
1 for success and 0 for failure |
IP address of the application |
Print a report |
Date/time stamp |
The name of the user that performs the action. |
Project ID of the View |
PrintReport |
Names of the Views included into the report |
Insight application |
1 for success and 0 for failure |
IP address of the application |
Export to Excel |
Date/time stamp |
The name of the user that performs the action. |
Project ID of the View |
ExportToExcel |
The title of the exported grid or chart |
Insight application |
1 for success and 0 for failure |
IP address of the application |
Logs for a user with Windows authentication
Logs for a user with Windows authentication include the following events.
-
Login
-
Wrong login
-
Logout
Logs for a user with HTTP authentication
Logs for a user with HTTP authentication include the following events.
-
Login
-
Wrong login
-
Logout