Database Tools – Running On All Employees
Navigating To The Database Tools Page
There are times when you are looking for information within the system that a report does not provide. In some of these cases, you can utilize the Database Tools feature to run a pre-written query to obtain the information. In the example below, the steps to query login history will be examined.
- In the Main Navigation menu, open the Diagnostics folder.
- Click on the Database Tools page.
After the selection is made, the query will populate the query window.
2. In the Output Results To field you have the option to return the results to the screen via a pop-up window, or sent to an Excel file or plain text document.
3. Click 
The resulting output.
A. The employees login USER_NAME
B. The Login and Logout times for the user.
Database Tools – Running On An Individual Employee
Navigating To The Database Tools Page
In the example below, the steps to query the login history of an individual wmployww will be examined.
- In the Main Navigation menu, open the Diagnostics folder.
- Click on the Database Tools page.
After the selection is made, the query will populate the query window.
2. Remove the – – at the start of the –WHERE user_name = ‘ADMIN’ /*Replace with desired login and uncomment*/ line and replace ADMIN with the employee ‘s username you wish to run the query on.
Below, the user_name has been set to dwhite.
3. In the Output Results To field you have the option to return the results to the screen via a pop-up window, or sent to an Excel file or plain text document.
4. Click
The resulting output.
A. The individual employee’s login USER_NAME
B. The Login and Logout times for the user.
Database Tools – Running On An Individual Employee Within Date Range
Navigating To The Database Tools Page
In the example below, the steps to query the login history of an individual user within a specified date range will be examined.
- In the Main Navigation menu, open the Diagnostics folder.
- Click on the Database Tools page.
After the selection is made, the query will populate the query window.
2. Remove the – – at the start of the –WHERE user_name = ‘ADMIN’ /*Replace with desired login and uncomment*/ line and replace ADMIN with the employee ‘s username you wish to run the query on.
3. Remove the – – at the start of the – – AND login BETWEEN ‘2010-01-01’ AND ‘2010-12-31’ line and replace the dates with the range you wish to run for the employee.
Below the user_name is set to Admin and the date range from 1/1/2023 through 1/14/2023.
4. In the Output Results To field you have the option to return the results to the screen via a pop-up window, or sent to an Excel file or plain text document.
5. Click
The resulting output.
A. The individual employee’s login USER_NAME
B. The Login and Logout times for the user appear withing the specified date range.
