Big Fix Database location

Usage and Config Platform
1

(imported topic written by Jamesk91)

Hi

I need to know the location of the Big Fix Database beacuse i would like to export information directly from the d/b

I have looked on the install server where the main console resides and cannot seem to locate it any help appreciated

Any help appreciatd

2

(imported comment written by BenKus)

Hey James,

The database name is “BFEnterprise” and it lives on the BES Server (unless you used a different database server, which is not common). You can find more information about querying the database from: http://support.bigfix.com/cgi-bin/kbdirect.pl?id=161

Ben

3

(imported comment written by Jamesk91)

Thanks Ben

I have another question in regards to the table names

I need to know what tables i can get the information from for

Installed applications

CPU

RAM

OS

Can you provide table names???

Regards

4

(imported comment written by BenKus)

Hey James,

You can see from the schema document that the BES_COLUMN_HEADINGS view is the easiest way to query the properties of computers. For instance, to see a list of all the OSes, use:

select Value from BES_COLUMN_HEADINGS where Name = ‘OS’

For RAM, try:

select Value from BES_COLUMN_HEADINGS where Name = ‘RAM’

To retrieve multiple properties in one query, you will need to join the BES_COLUMN_HEADINGS view against itself.

If you are looking to develop reports based on these properties, consider using custom web reports because it tends to be easier and puts less load on the database.

Ben

5

(imported comment written by Jamesk91)

Thanks muchly