10. amps-sqlite3-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
file
The file to search.
timestamp
The timestamp to extract, in the format _YYYYMMDD**T**HHmmSS_

Table 10.1: Parameters for amps_sqlite3_report

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 ...