--- title: Detailed Logs slug: kronpam-how-to-guides-180/detailed-logs description: Learn about the different filters available for data in a system, including user name, access protocol, and host name. Discover the various types of logs, such as SQL Proxy Queries, SSH/TELNET Commands, and HTTPS/S Messages, and how to use their specific docTags: createdAt: 2022-08-18T16:43:26.000Z --- # Filter Data can be filtered by: - User name (sqlproxy, admin, as, etc.) - Access Protocol (MSSQL, MYSQL, SSHv2, etc.) - Host Name (10.20.40.41 etc.) # SQL Proxy Queries It shows the queries created in SQLProx in the **log***** ***column of the chart.  # Tables Used | **sc\_userlog** | | | --------------- | ----------------------------------------- | | **log in** | Queries shown in the chart | | **type** | SQLPROXY | | **log\_time** | Looks here while applying a filter.
| | **sc\_sessions: ** | This is related to the sc\_userlog table. It is combined to identify who created the query. | | ----------------------- | -------------------------------------------------------------------------------------------- | | **user\_name** | Client log in username | | **host** | Host ip | | **host\_name** | Server host name | **SSH / TELNET Commands:***** ***Shows SSH / TELNET command logs. The columns are the same as the PROXY SQL Queries, with the only difference being that the type column of the **COMMAND***** ***is sanitized.      **HTTPS/S Messages: **Pulls the **request\_content **column from the **sc\_http\_proxy\_log **table. Can only be filtered by time. **TACACS+ Messages: **It is a chart that shows the **command **column from the **tac\_accounting **table. Only the filter can be discarded over time. **Environment:** **t\_instance **table, using** instance\_name**, **UserName**, **ip\_adress **to run group by queries. **RADIUS Messages: Returns **commands from the **radius **schema **raddact **table (cmd column). It can only be filtered by time.