Beispiele für das postgresql schema – Apple Remote Desktop 2.2 Benutzerhandbuch
Seite 126

126
Anhang A
Referenz
Beispiele für das PostgreSQL Schema
Beispielliste für das Hauptdatenbankschema
/System/Library/CoreServices/RemoteManagement/rmdb.bundle/bin/psql -U
ard -c "\\d propertynamemap" ard
Table "public.propertynamemap"
Column | Type | Modifiers
---------------+------------------------+-----------
objectname | character varying(128) | not null
propertyname | character varying(128) | not null
propertymapid | integer |
Beispielliste der Systeminformationstabelle
/System/Library/CoreServices/RemoteManagement/rmdb.bundle/bin/psql -U
ard -c "\\d systeminformation" ard
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) |
lastupdated | timestamp with time zone |
Beispielliste von Property-Namen
/System/Library/CoreServices/RemoteManagement/rmdb.bundle/bin/psql -U
ard -c "select * from propertynamemap" ard
objectname | propertyname | propertymapid
-----------------------+------------------------------+---------------
Mac_SystemInfoElement | WirelessCardIsActive | 0
Mac_SystemInfoElement | WirelessCardFirmwareVersion | 1
Mac_SystemInfoElement | WirelessCardHardwareAddress | 2
Mac_SystemInfoElement | WirelessCardLocale | 3
Mac_SystemInfoElement | WirelessCardType | 4
Mac_SystemInfoElement | WirelessCardInstalled | 5
Mac_SystemInfoElement | WirelessChannelNumber | 6
Mac_SystemInfoElement | WirelessNetworkAvailable | 7
Mac_SystemInfoElement | WirelessIsComputerToComputer | 8
......
Beispielliste der Tabelle eines einzelnen Computers
/System/Library/CoreServices/RemoteManagement/rmdb.bundle/bin/psql -U
ard -c "select * from systeminformation" ard
computerid | objectname | propertyname | itemseq | value | lastupdated
-------------------+----------------------+-----------------+---------+---------------------+------------------------
00:03:93:af:15:cc | Mac_HardDriveElement | CreationDate | 0 | 2004-02-25T03:30:07Z| 2004-02-26 22:21:38-08
00:03:93:af:15:cc | Mac_HardDriveElement | FileSystemType | 0 | 18475 | 2004-02-26 22:21:38-08
00:03:93:af:15:cc | Mac_HardDriveElement | FreeSpace | 0 | 4101610 | 2004-02-26 22:21:38-08
00:03:93:af:15:cc | Mac_HardDriveElement | GroupName | 0 | admin | 2004-02-26 22:21:38-08