Service Graph Connector For Microsoft Intune - Advanced (Configure advanced Data sources)Overview With the new release of SG-Intune version 2.5, we introduced advanced data sources. They are "SG-Intune Device Reports" and "SG-Intune Software Reports". SG-Intune Device Reports data source serves as an alternative to the SG-Intune Computer and SG-Intune Devices data sources, importing the same information while optimizing the data retrieval process by minimizing API calls and reducing import time. Similarly, SG-Intune Software Reports data source serves as an alternative to SG-Intune Software data source. Note: This component is in beta phase and is currently intended only for users experiencing server errors or performance issues with the existing data sources (SG-Intune Computer, SG-Intune Devices and SG-Intune Software), which may arise due to the large number of devices in the MS Intune Portal. How to Configure Go to Navigator, All -> Service Graph Connectors -> Intune -> SetUp.Proceed to the final section of the guided setup, labeled "Advanced". In the first step, user needs to configure the scheduled jobs for the OOB advanced data sources.In the second step, user needs to configure the scheduled import for the parent scheduled import i.e., SG-Intune Device Reports.The remaining steps are for multi connection scenarios. In the third step, user need to provide access to the application to create/update/delete scheduled jobs, enabling the creation of new scheduled jobs for new connections/instances.The fourth step involves clearing the cache to refresh it with updated access permissions.The fifth step is to create these advanced data source and it's related files for multi connections. NOTE: To use this feature, activate the ServiceNow IntegrationHub Professional Pack Installer (com.glide.hub.integrations.professional) plugin on your instance. Also after configuring the scheduled jobs for this new data sources, please ensure that SG-Intune Computer, SG-Intune Devices, SG-Intune Software scheduled imports are deactivated. Perform similar adjustments for other multiple connections, if applicable. Make sure "glide.attachment.extensions" system property value is either empty to allow all the attachment types or include zip and json in the value if they are not included earlier. Data Comparision between the data sources -> The SG-Intune Device Reports data source retrieves all the devices same as the old data sources (SG-Intune Computer and SG-Intune Devices) with below exceptions in data. Instead of WiredIPv4Address of devices, this new data source will populate the WiFiIPv4Address.Additionally, this new data source brings below 5 fields into related tables of devices and computers. (sn_intune_integrat_computer_related, sn_intune_integrat_device_related) security_patch_level (for mobile devices only)device_categorywifi_subnet_iddevice_statesystem_management_bios_version But azure_ad_registered, device_enrollment_type and management_agent fields won't be populated into related tables with this new data source. -> The SG-Intune Software Reports data source retrieves all the softwares same as the old data source SG-Intune Software. Additionally it also populates publisher field in Software Install table (cmdb_sam_sw_install) if Microsoft provides that information for those software records. Technical Details For this advanced data sources approach, there will be 3 main components. Data Source Scheduled Job Scheduled Import FLOW A scheduled job initiates the subflow.The subflow contains 3 flow actions (1 for each API). First action will trigger the device/software reports.Second action is to check the status of the reports. Upon completion, a URL is provided in the API response. (takes few seconds to 3 hrs acc. to Microsoft). So we will wait sometime and try it again in loop with constant delay of 1 min till 3 hrs. As it is async, it will end the scheduled job.The third action utilizes the above provided URL to obtain the zipped JSON file and it will unzip the file and attach the unzipped file to the records of sn_intune_integrat_report_chunks table. When the scheduled import runs as configured by the user, it triggers data source and the data source will pull the report files from the sn_intune_integrat_report_chunks table and ensures data loading into the import set table. The remaining flow of transformations (RTE) and identifications (IRE) will be similar to any other datasources and finally the data will be inserted into CMDB tables. Note: For SG-Intune Software Reports, this subflow will run for 16 times (async) to divide the large software dump file into 16 almost equal chunks. Potential problem scenarios: 1. Error Message: "Error encountered while creating Attachment. Attachments of type are not allowed". - Make sure "glide.attachment.extensions" system property value is empty or include zip and json if they are not included earlier. 2. Data is not getting loaded. Make sure ServiceNow IntegrationHub Professional Pack Installer (com.glide.hub.integrations.professional) plugin is activated on your instance. And also check if the Advanced section of guided setup is followed properly. Note: In 2.5 version of SG-Intune, we are asking to install ServiceNow IntegrationHub Professional Pack Enterprise plugin. But if your platform version is after tokyo, no need to install enterprise plugin, installing ServiceNow IntegrationHub Professional Pack Installer (com.glide.hub.integrations.professional) plugin is enough.