Accessing Report Data with Other Tools
In addition to generating a report and then exporting it for use in other applications, it is possible to interact directly with the report data collected by a task server. Because the data is stored in a PostgreSQL database, many SQL tools can be used to retrieve information from it. Doing so requires a decent understanding of SQL and a solid understanding of the tools that you are attempting to connect to the database (or development experience, if you are attempting to create your own tools). It is also possible to use the psql command-line tool to query the database from the Terminal or using an SSH connection. Again, some experience with SQL is needed. The Apple Develop Connection includes a great deal of information for users familiar with SQL and/or Mac development to use as a guide for working with the Remote Desktop data through other applications.