Prepare reports from the database tables

(imported topic written by SystemAdmin)

Dear Everyone,

I was researching with BigFix database (BEEnterprise) to prepare some general purpose reports that i can present to the management. I was looking at the QUESTIONRESULTS table that contains most of the information i needed but unfortunately i was not able to find out the Analysis Name based on the Analysis ID anywhere.

In other words, which table i must use to join the AnalysisID column to get the Analysis Name.

Also, if possible, is there any way by which one could understand the database structure in terms of relationships and which tables hold what kind of information that can be utilized.

Please help !!!

Regards

Manu Kapoor

(imported comment written by SystemAdmin)

Hi Manu,

Please see this documentation first and see if it answers your questions.

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