Retrieve the Properties of specific analysis with audit result

(imported topic written by Springer_Xie91)

I want to do some operations will need to be done at the database level, but the tables of database is very puzzle,

such as I need to select the properties of specific analysis with the audit result and computers,Any ideas on how the table design and the relationships between the tables?

(imported comment written by ygong191)

Let me add on more info.

We are using Bigfix 6.0 and DB version is 1.58

We want to pull data from the Bigfix DB all the analysis result with the computer name/Analysis name/Name/Property name and result text, but we get problem data not accurate like missing computer or dulicated computer name, any one can help to provide the SQL query. Thanks,

(imported comment written by BenKus)

Have you looked at the database API? You should use the Views (the table structure changes in BES 7.0/7.1, but the views remain the same):

http://support.bigfix.com/cgi-bin/kbdirect.pl?id=161

Ben