Apple Remote Desktop - Page 199

Appendix D SQLite Schema Sample 199
Sample list of system information table
Command:
sudo /usr/bin/sqlite3 -column -header /var/db/RemoteManagement/RMDB/rmdb.
sqlite3 'PRAGMA table_info(systeminformation);'
Output:
cid name type notnull dflt_value pk
---------- ---------- ---------- ---------- ---------- ----------
0 ComputerID CHAR(17) 99 0
1 ObjectName VARCHAR(12 99 0
2 PropertyNa VARCHAR(12 99 0
3 ItemSeq INTEGER 0 0
4 Value VARCHAR(51 0 0
5 LastUpdate VARCHAR(20 0 0
Command without truncated output:
sudo /usr/bin/sqlite3 -header /var/db/RemoteManagement/RMDB/rmdb.sqlite3
'PRAGMA table_info(systeminformation);'
Sample list of property names
Command:
sudo /usr/bin/sqlite3 -column -header /var/db/RemoteManagement/RMDB/rmdb.
sqlite3 'select * from propertynamemap;'
Output:
ObjectName PropertyName PropertyMapID
--------------------- -------------------- -------------
Mac_SystemInfoElement WirelessCardIsActive 0
Mac_SystemInfoElement WirelessCardFirmware 1
Mac_SystemInfoElement WirelessCardHardware 2
Mac_SystemInfoElement WirelessCardLocale 3
Mac_SystemInfoElement WirelessCardType 4
Mac_SystemInfoElement WirelessCardInstalle 5
Mac_SystemInfoElement WirelessChannelNumbe 6
Mac_SystemInfoElement WirelessNetworkAvail 7
Mac_SystemInfoElement WirelessIsComputerTo 8
......
Command without truncated output:
sudo /usr/bin/sqlite3 -header /var/db/RemoteManagement/RMDB/rmdb.sqlite3
'select * from propertynamemap;'