Sample list of main database schema | Apple 3 manual

DPostgreSQL Schema Sample

D

Appendix

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)

180

Image 180

Apple 3 manual Sample list of main database schema, Sample list of system information table

Contents

Administrator’s Guide Apple Computer, Inc Apple Computer, Inc. All rights reserved Contents Administrator Computer Understanding and Controlling Access PrivilegesApple Remote Desktop Administrator Access Using Local Accounts Setting Up the Network and Maintaining Security Setting Up the NetworkRemote Desktop Authentication and Data Transport Encryption Switching Between Control and Observe Modes Administering Client Computers Using the Task Feedback DisplayKeeping Track of Task Progress and History Enabling a Task Notification Script Appendix a 161 Icon and Port Reference Client Status Icons Appendix B Appendix CAppendix D Index What Is Apple Remote Desktop? About This Book Using This Guide Remote Desktop HelpNotation Conventions Where to Find More Information About Apple Remote Desktop Terminal Command Conventions Preface About This Book Using Apple Remote Desktop Administering Computers Using Apple Remote Desktop Distributing Installer Packages Deploying Software Using Network Install Images Using NetBoot Images Using Unix Shell Scripts Verifying InstallationsDistributing Preference Files Distributing Drag-and-Drop Applications Taking Inventory ARD SQL Administration Settings Report File Search ReportSpotlight File Search Software Version Report Application Usage Report Network Test ReportGenerating Your Own Reports Managing Power State Housekeeping Supporting Users Providing Help Desk Support Requesting HelpChatting with the User Screen Monitoring Using Reports Screen ControllingScreen Sharing Deploying New Software or Files Using Text Messages Interacting with StudentsMonitoring Student Computers Sharing Screens Finding More Information To learn more about See information for Starting on Getting to Know Remote Desktop Remote Desktop Human Interface Guide Remote Desktop Main Window Getting to Know Remote Desktop Getting to Know Remote Desktop Task Dialogs ABG Control and Observe Window C D E F G HI Multiple-Client Observe Window HA B CI Report Window DEF Changing Report Layout To change what information is displayed Configuring Remote Desktop Customizing the Remote Desktop ToolbarTo customize the application toolbar To open the Preferences window Interface Tips and Shortcuts Computers can be selected from any window Drag and drop works on configuration dialogs Making lists from reports or other listsSaved Tasks and Task Templates save you time Administrator and client computers NetBoot and Network Install optionalSystem Requirements for Apple Remote Desktop Installing the Remote Desktop Administrator Software Network Requirements Upgrading the Remote Desktop Administrator Software Method #1-Remote Upgrade Installation Upgrading the Client Software Method #2-Manual Installation Upgrading Apple Remote Desktop Clients Using SSHTo manually upgrade the client software Creating a Custom Client Installer To upgrade existing client software using SSHTo create the client installer Installing Apple Remote Desktop Uninstalling the Administrator Software To remove the administrator softwareConsiderations for Managed Clients Removing or Disabling Apple Remote Desktop To disable the client software on a client computer Disabling the Client Software Uninstalling the Client Software from Client Computers To uninstall client software Computer Lists Finding Clients by Searching the Local Network Finding Clients by Searching a Network RangeTo search for clients on the local network Finding Clients by Network Address To search a range of network addressesTo search for a specific address Finding Clients by File Import Making a New ScannerTo import a list of computers from a file To make a custom search list Making and Managing Lists About Apple Remote Desktop Computer Lists Creating an Apple Remote Desktop Computer List Deleting Apple Remote Desktop ListsCreating a Smart Computer List To create an Apple Remote Desktop computer list Editing a Smart Computer List To create a smart computer listTo edit a smart computer list To create an list of computer lists Importing and Exporting Computer Lists To transfer the computer lists To transfer the computer lists To transfer the computer lists Access Privileges Apple Remote Desktop Administrator Access Select To allow administrators to To set administrator privileges on a computer Creating Administrator Access Groups To create an administrator access groupMethod #1 Understanding and Controlling Access Privileges Understanding and Controlling Access Privileges Apple Remote Desktop Guest Access Enabling Directory Services Group AuthorizationTo enable Apple Remote Desktop authorization by group Method #2 Apple Remote Desktop Nonadministrator Access To allow guest accessLimiting Features in the Administrator Application Virtual Network Computing Access To enable User Mode Command-Line SSH Access Managing Client Administration Settings and PrivilegesTo allow VNC access Getting an Administration Settings Report Changing Client Administrator PrivilegesTo get an administration settings report To change administrator privileges on each computer Understanding and Controlling Access Privileges Setting Up the Network Maintaining Security Setting Up the Network Setting Up the Network and Maintaining Security Getting the Best Performance Maintaining Security Administrator Application Security Password Access SecurityUser Privileges and Permissions Security Remote Desktop Authentication and Data Transport Encryption Physical Access SecurityEncrypting Observe and Control Network Data To enable Observe and Control transport encryption To set a default encryption preference for file copies Interacting with Users Controlling Controlling Apple Remote Desktop Clients Control Window Options To control an Apple Remote Desktop client Switching Between Control and Observe Modes To switch between control and observe modesTo switch between complete control and shared mouse modes Sharing Control with a User To switch between standard control and curtain modes To switch between full screen and in-a-window modesHiding a User’s Screen While Controlling Capturing the Control Window to a File To share clipboard content with the client Sharing Clipboards for Copy and PasteControlling VNC Servers To control a VNC client computer Setting up a Non-Mac OS X VNC Server Basic steps areApple Remote Desktop Control and the PC’s Ctrl-Alt-Del To set a custom VNC port when adding a computer by address VNC Control OptionsTo set a custom port on an existing computer list member To designate a display to control To configure a client to accept VNC connections Observing Dealing With Many Client Screens Getting More Information on Observed Clients Changing Observe Settings While Observing To change your observe settings Changing Screen Titles While Observing Viewing a User’s Account Picture While ObservingTo change your observe window titles To view a user’s account picture Icon Indicates Shortcuts in the Multiple Screen Observe Window Observing a Single ComputerTo show system status in the observe window To observe a single computer To observe using Dashboard Observing Multiple ComputersObserving a Computer in Dashboard To observe multiple computers Sending Messages Sending One-Way MessagesInteractive Chat To send a one-way text message Sharing Screens Viewing Attention RequestsSharing a Screen with Client Computers To view attention requests Interacting with Your Apple Remote Desktop Administrator Requesting Administrator AttentionTo request administrator attention Monitoring a Screen Sharing Tasks Canceling an Attention Request To cancel an attention requestTo change your login icon Changing Your Observed Client Icon Administering Client Computers Keeping Track of Task Progress and History To enable a task notification script Enabling a Task Notification Script Using the Task Feedback Display Getting Active Task StatusStopping a Currently Running Task Getting Completed Task History Saving a Task for Later UseTo stop a currently running task To get status on a completed task Creating and Using Task Templates To create a task templateTo apply a task template Installing Software Using Apple Remote Desktop Installing by Package and MetapackageEditing a Saved Task To edit a saved task To copy and install software using a .pkg file Installing Software on Offline Computers To install software on offline clients Installing by Using the Copy Items Command Using Installers from Other CompaniesTo install software by copying To install software with third-party installers To upgrade software on client computers Upgrading Software Copying Files Copy Options Copying from Administrator to Clients More Options When the Item Already ExistsPost-Copy Action To copy items to clients Copying Using Drag and Drop To copy items from a client to the administrator’s computerCopying from the Finder to a Client To copy items from the Finder to a client To restore files using the Copy Items command Restoring Items from a Master Copy Creating Reports Collecting Report Data Using a Task Server for Report Data Collection To set up a Task Server, you need to Report Database Recommendations and Bandwidth Usage Auditing Client Usage Information System Report SizeGenerating a User History Report To generate a User History report Generating an Application Usage ReportTo generate an Application Usage report Using Spotlight to Find Items To search for software items using SpotlightFinding Files, Folders, and Applications Generating a File Search Report To search for software items Comparing Software Generating a Software Version ReportTo generate a Software Version report Generating a Software Difference Report Auditing Hardware To generate a Software Difference reportTo get a basic System Overview report Getting Serial Numbers To generate a serial number reportGetting Storage Information To generate a Storage report Getting FireWire Device Information To generate a FireWire Devices reportGetting USB Device Information To generate a USB Devices report Getting Network Interface InformationTo generate a Network Interfaces report Getting Memory Information To generate a Memory reportGetting PCI Card Information Testing Network Responsiveness To generate a PCI Cards reportTo generate a Network Test report Evaluating the Network Test Report Exporting Report Information To export a report Using Report Windows to Work with Computers Maintaining Systems Deleting ItemsTo delete an item from a client Setting the Startup Disk Emptying the TrashTo empty the Trash To set the startup disk Renaming Computers Synchronizing Computer TimeTo rename a computer Setting Computer Audio Volume To set a computer’s audio volumeTo synchronize client computer clocks Repairing File Permissions Adding Items to the DockTo repair a computer’s file permissions To add an application or other item to the Dock Changing Energy Saver Preferences To change the Energy Saver preferences Changing Sharing Preferences for Remote Login Setting Printer PreferencesTo change the Remote Login sharing preference To set up printer preferences using Copy Items To set up printer preferences using Send Unix Command Managing Computers Opening Files and Folders Opening Applications To open an itemTo open an application Quitting Applications Without Logging Out the User Putting a Computer to SleepTo quit an open application To put a computer to sleep Waking Up a Computer Locking a Computer ScreenTo wake a computer Displaying a Custom Picture on a Locked Screen Unlocking a Computer ScreenTo lock a computer screen To create a custom locked screen picture Logging In a User at the Login Window To disable a computer screen while you workDisabling a Computer Screen To log in a user Logging Out the Current User Restarting a ComputerTo log out a user To restart a computer Shutting Down a Computer To shut down a computer Unix Shell Commands Send Unix Command Templates Template sub-menu Template name Executing a Single Unix Command Executing Scripts Using Send Unix CommandTo execute a single Unix command Executing Shell Scripts with Remote Desktop To execute an AppleScript using the Send Unix Command To copy and execute a scriptExecuting AppleScripts with Remote Desktop To send and execute an AppleScript Built-in Command-Line Tools Using networksetup Few of the capabilities of networksetup are listed below Using systemsetup Few of the capabilities of systemsetup are listed below 150 Using kickstart Shut down the Apple Remote Desktop Agent process Setting the Client’s Data Reporting Policy Automating Functions Creating a Template Data Reporting Policy To set a client’s data reporting policy To set the default data reporting policy template Setting Scheduled Tasks Scheduled TasksTo set the Task Server location To schedule a task Using AppleScript with Remote Desktop Editing Scheduled TasksTo edit a task schedule Deleting Scheduled Tasks Using the Remote Desktop AppleScript Dictionary Remote Desktop’s AppleScript BasicsComputer list n inh. item a list which holds computers Add v Add a computer to a task To access the full AppleScript dictionary for Remote Desktop Sample AppleScript Using Automator with Remote Desktop 160 Apple Remote Desktop Status Icons Appendix List Menu Icons Task Status Icons System Status Icons Basic System Status Icons Detailed TCP and UDP Port Reference Port Protocol Function Report Field Definitions Reference B System Overview Report 166 167 Storage Report HFS, HFS+, UFS FireWire Devices Report USB Devices ReportMemory Report PCI Cards Report Network Interfaces Report 171 Administration Settings Report Network Test Report Application Usage Report User History Report Control v Start a control session with the computer Execute v Executes a taskObserve v Start an observation session Remove v Remove a computer from a task Elements Computer n inh. item a physical computer Contained by application Message Unicode text Message to display on the screens Restart task n inh. task item Restart the target computers Shutdown task n inh. task item Shutdown the target computers Wake up task n inh. task item Wake up the target computers Sample list of main database schema Sample list of system information table Sample list of property names Sample list of table from one computer Index 183 184