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
file (required)	The file to search.
timestamp (required)	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 ...