DDS Dashboard Template

DDS is a MongoDB-compatible database service that is secure, highly available, reliable, scalable, and easy to use. You can use DB instance creation, scaling, redundancy, backup, restoration, monitoring, and alarm reporting functions with just a few clicks on the DDS console. LTS allows you to analyze, search, visualize, and download logs, and view real-time logs.

LTS provides a one-stop wizard to collect DDS logs. The DDS audit log center dashboard displays charts such as the number of audit logs, access users, and access clients.

Prerequisites

Logs have been collected from DDS. For details, see Ingesting DDS Logs to LTS.
Logs have been structured. For details, see Setting Cloud Structuring Parsing.

DDS Audit Log Center

Log in to the LTS console. In the navigation pane, choose Dashboards.
Choose DDS dashboard templates under Dashboard Templates and click DDS audit log center to view the chart details.
- Filter by operation type. The associated query and analysis statement is:
```
select distinct(optype)
```
- Filter by client IP address. The associated query and analysis statement is:
```
select distinct(user_ip)
```
- Filter by database name. The associated query and analysis statement is:
```
select distinct(db)
```
- Filter by username. The associated query and analysis statement is:
```
select distinct(user)
```
- Filter by collection name. The associated query and analysis statement is:
```
select distinct(coll)
```
- Audit Logs. The associated query and analysis statement is:
```
select count(1) as log_num
```
- Users. The associated query and analysis statement is:
```
select count(distinct(user)) as user_num
```
- Clients. The associated query and analysis statement is:
```
select count(distinct(user_ip)) as client_num
```
- Top 5 Commands. The associated query and analysis statement is:
```
select optype, count(1) as 'command_count' group by optype order by count(1) desc LIMIT 5
```
- Top 5 Users. The associated query and analysis statement is:
```
select user, count(1) as 'user_count' group by user order by count(1) desc LIMIT 5
```
- Top 5 Clients. The associated query and analysis statement is:
```
select user_ip, count(1) as 'remote_count' group by user_ip order by count(1) desc LIMIT 5
```
- Audit Log Details. The associated query and analysis statement is:
```
select "time" as "Executed","user" as "Username","param" as "Query Statement","instanceid" as "Instance ID","db" as "DB","coll" as "Collection Name ","user_ip" as "Client IP Address"
```