---
title: Authentication Statistics
slug: kronpam-how-to-guides/authentication-statistics
description: Learn how to filter data by date, user name, and system name in this comprehensive document. Discover three insightful charts to visualize successful authentications by user and device, as well as authentication failures. Get step-by-step instructions on 
docTags: 
createdAt: 2022-08-18T16:43:21.000Z
---

# Filter 

Data can be filtered by:

- Date
- User name
- System name

# Charts

- of Successful Authentication, :\* The chart shows how many users have successfully logged in. Using the ***t\_user\_auth\_log ***table, the dataset is grouped according to ***user\_eid*** when ***"event"*** ***= 0*** for successful authentications.
** **
- of Successful Authentication by Device: The chart is obtained by grouping the same chart according to** \******"nas\_hostname"***.
** **
- of Authentication Failures: The chart shows how many users logged in when they signed up. In the query, when the difference between 2 and** \******"event"*** is equal to 1, not 0, meaning that 0's are successful and 1's are unsuccessful.