Apple M9547Z/A Administration Guide - Page 199
PostgreSQL Schema Sample
UPC - 718908688908
View all Apple M9547Z/A manuals
Add to My Manuals
Save this manual to your list of manuals |
Page 199 highlights
Appendix PostgreSQL Schema Sample D D This chapter contains SQL commands to assist SQL programmers in obtaining the database schema used in Apple Remote Desktop's 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: /System/Library/CoreServices/RemoteManagement/rmdb.bundle/bin/psql -U ard -c "\\d propertynamemap" ard Output: Table "public.propertynamemap" Column | Type | Modifiers objectname | character varying(128) | not null propertyname | character varying(128) | not null propertymapid | integer | Sample list of system information table Command: /System/Library/CoreServices/RemoteManagement/rmdb.bundle/bin/psql -U ard -c "\\d systeminformation" ard Output: Table "public.systeminformation" Column | Type | Modifiers computerid | character(17) | not null objectname | character varying(128) | not null propertyname | character varying(128) | not null itemseq | integer | value | character varying(512) | 199