Service Graph Connector for Azure data Import

[Naushad1]

Dear All,

We are in a process to import Hardware Cis from Microsoft Azure through Service Graph connector. Connection was successful however not getting any data while running the imports. We followed the guided setup.

Is there any additional step we are missing?

Appreciate any help!

State: Complete

Completion code: Success

Message: No insert or update

Attached message for reference.

Note: Azure client application has User.Read permission on Microsoft Graph API.

[Prabu Velayutha]

@Naushad1 Can you check the import set or staging tables that if it has imported any records from the graph API? Check the associated data sources it will start like SG_Azure example SG-Azure Virtual Machines. Please do add the attachment which I don't find.

If you have the data in the import set then it not an issue with the API, It could be the CIs that you are trying to import already exist and IRE engine did not find any new records to insert, also you need to check the Target CI class reconciliation rules is set with proper precedence for Azure data source to update the existing CIs or you need to define the reconciliation for Azure data source. Please let me know if you have more questions.

If my response helps to solve your issue. Kindly mark it as helpful & correct.

[Naushad1]

Hi Prabhu,

Thank you for your response.

We have validated all import sets and no record found. Also the run time for each Import set is around 2-3 seconds only. 

It seems the API is unable to pull any data from Azure.

Attached is the screenshot.

[Prabu Velayutha]

@Naushad1 Seems like there is no records received in the API response for data loader script to import, is this the same status for all SG Azure data sources?

If your using the lower Azure dev environment  API there could be chances that they don't have any resources in that environment.  Could you please check with your Azure SME regarding this? I would recommend to use only Azure production environment API even if your integrating with Servicenow non prod so that you have full data.

If my response helps to solve your issue. Kindly mark it as helpful & correct.

[Naushad1]

Hi Prabu,

We are getting the same status for all data sources.

Also Azure SME confirmed the we are using Production Environment. It's strange that we are not getting any error or suggestion in the log for it.

If possible could you also confirm if we need separate connection details(clientID and Secret) for software import(different application registration) than hardware import?