Apple Remote Desktop - PostgreSQL Schema Sample

background image

PostgreSQL Schema Sample

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) |

background image

200

Appendix D

PostgreSQL Schema Sample

lastupdated | timestamp with time zone |

Sample list of property names
Command:

/System/Library/CoreServices/RemoteManagement/rmdb.bundle/bin/psql -U ard -c

"select * from propertynamemap" ard

Output:

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

......

Sample list of table from one computer
Command:

/System/Library/CoreServices/RemoteManagement/rmdb.bundle/bin/psql -U ard -c

"select * from systeminformation" ard

Output:

computerid | objectname | propertyname | itemseq |

value | lastupdated

-------------------+----------------------+-----------------+---------+-----

----------------+------------------------

00:03:93:af:15:cc | Mac_HardDriveElement | CreationDate | 0 |

2005-02-25T03:30:07Z| 2005-02-26 22:21:38-08

00:03:93:af:15:cc | Mac_HardDriveElement | FileSystemType | 0 |

18475 | 2005-02-26 22:21:38-08

00:03:93:af:15:cc | Mac_HardDriveElement | FreeSpace | 0 |

4101610 | 2005-02-26 22:21:38-08

00:03:93:af:15:cc | Mac_HardDriveElement | GroupName | 0 |

admin | 2005-02-26 22:21:38-08

background image

201

Inde

x