Query BFI Database Using Web Service

Reporting
1

Hi,

I need to return data from the BF Inventory database using just a web service call. Is this possible (REST API??) and if so, could someone please post an example.

The specific use case is we need to automatically remove software that has not been used for 90 days or longer. I know this attribute is available in BigFix Inventory Reporting, but it will need to be part of an automated routine (script) that will add and remove Windows domain computers from AD groups.

I’m planning on using a powershell script, unless someone has a better way?

Thanks,
Simon.

2

I don’t know if you can use the REST API to do what you ask, but here’s the link to the BFI REST API documentation.

https://www.ibm.com/support/knowledgecenter/SSKLLW_9.2.1/com.ibm.bigfix.inventory.doc/Inventory/com.ibm.bigfix.inventory.doc/integration/c_rest_api.html

–Mark

3

So for reference, I was able to gain the required info using the following two calls.

https://servername:port/api/sam/raw_app_usage_property_values?criteria={“and”:[[“process”,"=",“visio.exe”]]}&limit=1000&columns[]=process&columns[]=computer_id&columns[]=last_used

https://servername:port/api/sam/computer_systems?criteria={“and”:[[“computer_id”,"=",“57”]]}

Unfortunately you can’t get all the info in 1 call, so I’ve powershell’d it into a couple of loops and arrays.