Installation manual

200 Appendix D SQLite Schema Sample
Sample list of table from one computer
Command:
sudo /usr/bin/sqlite3 -column -header /var/db/RemoteManagement/RMDB/rmdb.
sqlite3 'select * from systeminformation;'
Output:
ComputerID ObjectName PropertyName ItemSeq Value
LastUpdated
----------------- -------------------- ------------ ---------- ------
-------------- --------------------
00:1b:63:9f:5a:00 Mac_HardDriveElement DataDate 0
2009-03-05T22:06:04Z 2009-03-05T22:06:04Z
00:1b:63:9f:5a:00 Mac_HardDriveElement LastConsiste 0
2009-03-05T22:06:04Z 2009-03-05T22:06:04Z
00:1b:63:9f:5a:00 Mac_HardDriveElement UnixMountPoi 0 /dev/
disk0s2 2009-03-05T22:06:04Z
00:1b:63:9f:5a:00 Mac_HardDriveElement Model 0 WDC
WD3200AAJS-40RYA 2009-03-05T22:06:04Z
......
Command without truncated output:
sudo /usr/bin/sqlite3 -header /var/db/RemoteManagement/RMDB/rmdb.sqlite3
'select * from systeminformation;'