Asset data export to other applications

(imported topic written by jlamb23)

We have a system that we would like to use to share data with Bigfix. We need to build a query that will pull the information related to every machine in Bigfix out, along with all properties such as disk space, processor, operating system, service pack level, etc. (We want it all). The data base is not that intuitive. Can someone post a simple script that we can run in SQL that will pull out the complete inventory? I assume there are many different levels of joins.

(imported comment written by SystemAdmin)

Hi jlamb,

The best place to start for pulling this data out is the database api reference:

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

The data you mentioned would be queried through the BES_COLUMN_HEADINGS view.

Here is an example on how to query this view for multiple properties.

SELECT ComputerID, Name as 
'Property Name', Value   FROM BES_COLUMN_HEADINGS WITH (NOLOCK)   WHERE NAME IN ( 
'Computer Name', 
'OS', 
'CPU' )

Finally, please use good judgment querying the database. Running external queries places additional load on the database and it is possible to cause performance problems by doing so.