Service Graph connector for Microsoft SCCM software usages data import

[amitsharma]

Why Service Graph connector for Microsoft SCCM is not able to import software usages data in Software Usage [“samp_sw_usage”] table ? even after running ‘SG-SCCM SAMP Usage’ or ‘SG-SCCM Software Last Used ‘ scheduled data import

User can verify following things to understand reasons why software usages data is not getting imported:

• Verify software metering in enabled on Microsoft SCCM. Look at Microsoft SCCM documentation for more detail to enable software metering https://docs.microsoft.com/en-us/mem/configmgr/apps/deploy-use/monitor-app-usage-with-software-metering.

• Reclamation rules are defined for software user want to import software usages data. Use following documentation for creating reclamation rules https://docs.servicenow.com/bundle/rome-it-asset-management/page/product/software-asset-management2/task/t_AddAReclamationRule.html

• Make sure that the Software Products you are creating reclamation rules for have product processes (file executable names) in samp_sw_product_process. If a product process does not exist for a software product, you can create a custom one on the form. Product processes are stored in the Custom Product Process [samp_custom_product_process] table. For more detail refer following documentation https://docs.servicenow.com/bundle/rome-it-asset-management/page/product/software-asset-management2/task/create-reclamation-rule-sccm.html

• ‘SG-SCCM SAMP Usage’ or ‘SG-SCCM Software Last Used ‘ scheduled data import runs only on every 2nd day of month. So, scheduled import will only run-on 2nd day of month to import previous month data.NOTE: If user want manually to run scheduled import for testing purpose any day other then 2nd of month, then modify condition, check in Scheduled data import, and run scheduled data imports. Also not to disable Conditional checkbox in SG-SCCM SAMP Usages and SG-SCCM Software Last Used scheduled data import.

• Make sure user and Computer CI on which software is installed is already imported in SN instance.

• Not to use running Data source ‘Load All Records’ and transforming import will not work, instead use always use scheduled data import, because SQL statement is dynamically generated when scheduled data import executed and sets the data source SQL statement.

• Before running ‘SG-SCCM SAMP Usage’ or ‘SG-SCCM Software Last Used ‘, Run SG-Computer Identity scheduled data import so Computer CIs are already imported to SN instance.