---
title: End Point Management Reports
slug: kronpam-how-to-guides/end-point-management-reports
description: Learn about various charts and filters for comprehensive data analysis in this document. Explore charts like "Recently Modified End Points," "Recently Enabled End Points," "Recently Created End Points," "Recently Deleted End Points," and "Extended Attribu
docTags: 
createdAt: 2022-08-18T16:43:17.000Z
---

# Filter

Data can be filtered by:

- Date
- Device Name
- Element Type

# Charts

- **Recently Modified End Points:** The chart displays when the passwords of the devices were last changed or when they have not been changed. **last\_change\_time **represents the time the device's password was last changed. Three tables are combined using **\{}t\_device** to connect them. If  **last\_change\_time** is** **empty, it means that the device's credentials are not defined. Shows the last 10 devices whose passwords have been changed.     

| **t \_device**               | Contains basic device information. (Unchanged information such as Access protocol, ip)                           |
| ---------------------------- | ---------------------------------------------------------------------------------------------------------------- |
| **t \_device\_credential**   | Stores information such as the username of the device, when the password was last changed (variable information) |
| **t \_device\_availability** | Keeps track of when the device was last connected to                                                             |

 

- **Recently Enabled End Points: The chart** that lists the last logged devices. The table structure is exactly the same as the previous chart. The only difference is the use of **last\_access\_time** from the **\{}t\_device\_availability** table, instead of **last\_change\_time** from the **t\_device\_credential** table. Shows the last 10 connected devices.


- **Recently Created End Points: **The chart that lists the devices by element type and name. It shows what happens in the same element type in the same list. The following three tables are created with the same ids as the **Recently Modified End Points **chart. The main purpose is to find which devices are defined for each element type and answer the question of how many copies of these devices are there, by name. Shows 10 devices that are most recently defined.     

| **t \_device**               | Contains basic device information. (Unchanged information such as Access protocol, ip)                           |
| ---------------------------- | ---------------------------------------------------------------------------------------------------------------- |
| **t \_device\_credential**   | Stores information such as the username of the device, when the password was last changed (variable information) |
| **t \_device\_availability** | Keeps track of when the device was last connected to                                                             |

- **Recently Deleted End Points: **Lists the deleted devices. **t\_device **deleted devices from **t\_event **table are logged. The query lists the ones registered as "/device / deleted" in the **type **column in the **t\_event **table. The chart shows **params**, **t\_device **in the table **DEVICE\_NAME, **and **management\_ip **is reduced to Eq.


- **Extended Attribute Changes: **Lists all changes made to the devices. All changes in the **t\_event **table are logged. Since the changes made in the device necessarily contain **device** in the type section, it lists all the data containing **device** in the **type** section of the **t\_event.**