Extracting information using REST API from BigFix

[Navaneeth1]

We have a BigFix account that can generate Configuration Item's (CIs) information just like how SAM pro's discovery does. We've found a way to get the data into a CSV  Excel sheet and upload it into ServiceNow checking to not create new CIs if records already exist.

This is now a manual process where one person uploads the CSV manually. We're looking to see if this process can be automated using ServiceNow's REST API and BIGFix through custom REST API creations in ServiceNow and BIGFix. We know there are paid options for this but we were wondering to create something from scratch on both sides to establish that connection and have a ServiceNow workflow trigger once a week and extract the information and populate our CMDB table.

Can someone please tell me how this can be done? A series of step would be most helpful. I'm also open to the suggestion of an idea where the CSV can automatically be uploaded into ServiceNow as well. Bottom line we'd like to not spend more money on further licensing functionalities for this. 

Thank you in advance!  

[Swapnil24]

Hi @Navaneeth1 , using the OOB Bigfix connector is the ideal way to do it as it utilizes the IRE to decide which data sources takes priority on which fields. Also, based on the products and subscriptions for IHUB - you might already be eligible to use the BigFix spoke.

But if you want to recreate the integration using REST API's then in general you would follow steps for TableAPI /ImportSet API integration.

Note - For any CMDB integration, its best to utilize IRE.

Thank you,

Swapnil Deo

[Navaneeth1]

Hello @Swapnil24 ,

Thank you so much for your response! Could you please let me know if BigFix Inventory spoke is the OOB BigFix connector you are talking about? 

I'm new with managing CMDB, could you please let me know if IRE require separate licensing or do you think it would be part of the regular ITSM licensing plan?
Also, suppose we have the data from BigFix on a CSV file. Is IRE needed to populate the CMDB again with these values?

Thank you, 

Regards,
Navaneeth Sunil

[KabirSingh]

Hi @Navaneeth1,

Using the out-of-the-box (OOB) BigFix connector is ideal because it utilizes the Identification and Reconciliation Engine (IRE) to determine data source priority for various fields. Additionally, based on your products and subscriptions for IntegrationHub (IHUB), you might already be eligible to use the BigFix spoke.

However, if you prefer to recreate the integration using REST APIs, you would generally follow the steps for TableAPI or ImportSet API integration.

Note: For any CMDB integration, it's best to utilize the IRE.

[Amit Verma]

Hi @Navaneeth1 

Below link could be useful :

https://www.servicenow.com/community/developer-articles/create-atachment-in-servicenow-using-attachm...

Thanks and Regards

Amit Verma