Hello Experts,
We have installed the Plugin (out of the box) Service Graph Connector for Microsoft Intune to integrate ServiceNow and Intune. Currently, "Scheduled Data Import Job" "SG-Intune Devices" is import the data into a staging table that extend from "import set row" table and by a transform map we are bring data into a custom table called "Intune Mobile devices".
The "Scheduled Data Import Job" "SG-Intune Devices" is running weekly on a Weekend basis. but it is taking lot of time to execute and an incident created by platform team. We have deactivated another "Scheduled Data Import Job" "SG-Intune software" and "SG-Intune computer".
- We would like to know what's causing this delay in the script/running job and how we can optimize the script to avoid delays in the running jobs in the Production instance.
- I have created a before - insert business rule to abort record creation if u_manageddeviceownertype=personal OR u_serialnumber=0 on staging table. But it is not working.
- There is a data source and it is loaded by script. in this script a script include called and here is two enpoints defined, I have not an idea how can we change this endpoint/URL to fetch only u_manageddeviceownertype=company and u_serialnumber!=0 devices.
