Apple Remote Desktop - Appendix D SQLite Schema Sample

19 8
This chapter contains SQL commands to assist SQL
programmers in obtaining the database schema used in
the Apple Remote Desktop report database. You can use
this knowledge about the schema to create your own
applications that access Apple Remote Desktop report
information.
Sample list of main database schema
Command:
sudo /usr/bin/sqlite3 -column -header /var/db/RemoteManagement/RMDB/rmdb.
sqlite3 'PRAGMA table_info(propertynamemap);'
Output:
cid name type notnull dflt_value pk
---------- ---------- ------------ ---------- ---------- ----------
0 ObjectName VARCHAR(128) 99 0
1 PropertyNa VARCHAR(128) 99 0
2 PropertyMa INTEGER 0 0
Command without truncated output:
sudo /usr/bin/sqlite3 -header /var/db/RemoteManagement/RMDB/rmdb.sqlite3
'PRAGMA table_info(propertynamemap);'
Appendix D
SQLite Schema Sample