Statistics Database Report
amps_sqlite3_report is a utility used to extract a specific time range from stats.db for reporting or diagnostic purposes.
Options and Parameters
| Option | Description |
|---|---|
| The file to search. |
| The timestamp to extract, in the format YYYYMMDDTHHmmSS |
Usage
The following examples shows how to extract statistics starting at May 1, 2018 at midnight UTC from amps-sqlite3_report. The output of the command is the information from the tables starting from the specified time .
$ amps_sqlite3_report stats.db 20180501T000000
amps-sqlite3-report on stats.db since 20180501T0000
TABLE HCPUS
timestamp,static_id,idle_percent,iowait_percent,system_percent,user_percent,static_id:1,oid
212391936000000,2,0,0,0,0,2,all
212391936000000,3,0,0,0,0,3,cpu0
212391936000000,4,0,0,0,0,4,cpu1
212391936000000,5,0,0,0,0,5,cpu2
212391936000000,6,0,0,0,0,6,cpu3
... etc ...