24001: Login succeeded
Event 24001 occurs when a user successfully logs into an SQL server.
Action groups consist of all the relevant events together, making it easy for an administrator to identify an event's type just by looking at its action group. This particular event is generated by the SUCCESSFUL_LOGIN_GROUP action group. This event includes important information, like the:
- Date and time at which the login occurred.
- Session identifier of the event.
- Name of the user who logged in.
- ID, name, and type of the target object (in this case, the SQL server login).