1. Linux

1.1. Installation

  • Enter the following commands at a Command Line.

    sudo apt-get install sqlite3

2. Windows

2.1. Installation

  • Extract the sqlite3.exe file from the sqlite-tools-win-x64-3450100.zip archive to the C:\Windows folder.

3. Usage

  • Note: The free and used fields in the total table are in MB’s.

  • Note: The used field in the usage table is in MB’s.

  • Enter the following commands at a Command Line.

    sqlite3 /media/Teams/IT/Auto-Backups/Disk-Usage.db3             # Linux.
sqlite3.exe T:\IT\Auto-Backups\Disk-Usage.db3                   # Windows.

sqlite> .schema
sqlite> .tables
sqlite> SELECT * FROM total;
sqlite> SELECT * FROM usage;
sqlite> SELECT date, used FROM usage WHERE share = 'Teams' AND folder = 'IT';
sqlite> SELECT date, used FROM usage WHERE share = 'Home' AND folder = 'Ko Phyo';
sqlite> SELECT date, free FROM total WHERE share = 'Teams';
sqlite> .quit