Page History
The User Login History Report ... allows users to configure their preferred email and SNMP settings, as well as to groom undesired alerts on your SQL Servers. lists all login activity for specified users. Use this report to audit your SQL Server security settings and identify misconduct.
A filter can include a list of wildcards, separated by commas, where a wildcard is a string, which may contain asterisks. The following parameters are specific to the selected report and enable you to filter the data to include in the report.
Available actions
Server Instance
Allows you to select a registered instance on which you want to report. Select ALL to report on all instances.
...
Allows you to select or type the name of one or more databases on which you want to report.
Login
Allows you type or to select the login from the drop down list of available logins. Select ALL to report on all logins.
Start Date
Allows you to select the start date for the range from which you want to report.
...
Select between AM or PM from the drop down list to configure the End Time for Each Day range from which you want to report.
Schema
Allows you to type the name of the schema on which you want to report.
...
Click this button to Run the report.
Default columns
HostLogin
The Host Login column displays the login name of the hostuser who performed the event.
LoginHost
The Login Host column displays the login name of the user who performed the eventhost.
Application
The Application column displays the name of the application used to capture the event.
EventTime
The Event Time column displays a description of the date and time when the event was captured.
TimeEvent
The Time Event column displays the date and time when a description of the event was captured.
...