BigFix Database

Customizations
1

(imported topic written by SystemAdmin)

Hi.

My goal is to get informations from DB queries (I know that is not recommended) or by SOAP.

I get computer informations from BES_COLUMN_HEADINGS view, but there’s no complete hardware infos; I get only:

Computer Name, OS, CPU, Last Report Time, Locked, Lock Expiration, BES Relay Selection Method, Relay, Distance to BES Relay, BES Relay Service Installed, Relay Name of Client, DNS Name, Active Directory Path,

Client Administrators, Client Settings, IP Address, IPv6 Address, Subscribed Sites, BES Root Server, License Type,

User Name, RAM, Free Space on System Drive, Total Size of System Drive, BIOS, Subnet Address

Where are other infos ? Is there a more complete Database Schema (not this one http://support.bigfix.com/cgi-bin/kbdirect.pl?id=161) ?

Thanks for this beautiful software.

:wink:

2

(imported comment written by Peter_Loer)

Hi,

Generally we do recommend using the SOAP interface to issue a “session relevance” query for this sort of information.

The SOAP interface isolates you from changes to the underlying database schema, and our database schema is not very friendly to the sort of query you are describing in any case (take a look at the definition of the BES_COLUMN_HEADINGS view if you’re curious what it would look like).

I am not an expert on session relevance, but here is an example I just threw together on my local deployment that pulls back a couple of random properties for all computers:

(name of it, concatenation “;” of values of result from (bes property “Computer Manufacturer - Windows”) of it | “”, concatenation “;” of values of result from (bes property “CD-ROM - Windows”) of it | “”) of bes computers

The error handling bits in there are to deal with the case where a particular computer hasn’t reported on a property (maybe the analysis isn’t activated on that machine), and just turn it into an empty string.

Hope that helps point you in the right direction.

cheers,

peter

3

(imported comment written by BenKus)

You should check out the brand new BFExtractToCSV tool at: https://www.ibm.com/developerworks/mydeveloperworks/wikis/home?lang=en#/wiki/Tivoli%20Endpoint%20Manager/page/BigFix%20SOAP%20API

More info on extracting data from BigFix at: https://www.ibm.com/developerworks/mydeveloperworks/wikis/home?lang=en#/wiki/Tivoli%20Endpoint%20Manager/page/Querying%20BigFix%20Data

This command-line tool will allow you to easily and efficiently pull this information into a CSV file, which can be imported into another database.

Hope that helps,

Ben

4

(imported comment written by SystemAdmin)

Thanks ! :slight_smile:

Now I have to work hard …