Is there a database schema available to help me query the database?
Available database api documentation list.
Resolving the problem
The last available database api documentation can be downloaded here:
The database API documentation provides information on querying the database through a set of sql views built around common database queries. The documentation also provides helpful example queries and important information on how to work with the database. The documentation does not cover the underlying database tables and structure and you should not attempt to query these directly.
In addition, here is an example of a perl script that extracts computer properties and puts them in a CSV file. This script shows how to extract properties from the BigFix database and requires customization to work properly: