Data transformation for the Patch Orchestration with Microsoft SCCM Integration
Data is retrieved from the Patch Orchestration with Microsoft SCCM Integration, processed through a set of data sources, and transformed in your ServiceNow AI Platform® instance.
SCCM Collection import
The data from the imported collections are loaded into the SCCM Collection Import [sn_vul_sccm_collection_import] table. The SCCM Collections (transform map) is used to transform the imported information.
Note: Changes to this transform map alter how data from the SCCM Collection import is processed.
To access this transform map, navigate to All > System Import Sets > Transform Maps and locate SCCM Collection Transform. The following table lists the transform map fields by integration.
| Source field | Target field | Description |
|---|---|---|
| u_collectionid | source_id | Unique Id of the collection. |
| u_name | name | Name of the collection. |
| u_membercount | device_count | Number of devices in this collection. |
| [script] | integration_instance | Name of the instance the Patch is imported from. |
| Script | Description |
|---|---|
| OnStart \(when an import set has created transformation\). | Script used to initialize the values in the scope variable \[sn\_vul\_sccm\] for the integration process. This script is for internal use and should not be modified or deleted. |
| onBefore \(before an import set has completed transformation\). | The script that is used to update the values in the scope variable \[sn\_vul\_sccm\]. This script is for internal use and should not be modified or deleted. |
| onComplete \(when an import set has completed transformation\). | Script that is used to set the number of items created, updated, and ignored. This script is for internal use and should not be modified or deleted. |
SCCM Patch Update Import
The data from the imported Patches are loaded into SCCM Patch update Import [sn_vul_sccm_patch_update_import] table.
SCCM Patch update transform is used to transform the imported information.
Note: Changes to this transform map alter how data from the SCCM Patch update import is processed.
To access this transform map, navigate to All > System Import Sets > Transform Maps and locate the SCCM Patch update transform.
The following table lists the transform map fields by integration.
| Source field | Target field | Description |
|---|---|---|
| [Script] | urls | URLs for the Patch. |
| u_nummissing | num_missing | Number of devices missing this patch. |
| [Script] | date_release | Patch release date. |
| u_bulletinid | bulletin_id | Bulletin ID for the Patch. |
| u_numtotal | num_total | Total number of devices. |
| u_localizeddescription | description | Description for the Patch. |
| [Script] | is_highest_supersedence | Is the Patch with the highest supersedence. |
| u_numnotapplicable | num_not_applicable | Number of devices not applicable for this Patch. |
| u_iscontentprovisioned | is_downloaded | If Patch is downloaded to the SCCM Server. |
| u_numunknown | num_unknown | Total number of unknown devices. |
| u_articleid | article_id | Article ID of the Patch. |
| u_localizeddisplayname | title | Title of the Patch. |
| u_ci_id | source_id | Unique ID for the Patch in SCCM. |
| u_numpresent | num_present | Number of devices where the Patch is installed. |
| [Script] | integration_instance | Name of the instance the Patch is imported from. |
| [Script] | sn_vul_solution | Solution based on the source ID. |
| [Script] | last_modified | Patch last modified date. |
| u_severity | source_severity | Severity of the Patch. |
| Script | Description |
|---|---|
| OnStart \(when an import set has created transformation\). | Script that is used to initialize the values in the scope variable \[sn\_vul\_sccm\] for the integration process. This script is for internal use and should not be modified or deleted. |
| onBefore \(before an import set has completed transformation\). | The script that is used to update the values in the scope variable \[sn\_vul\_sccm\]. This script is for internal use and should not be modified or deleted. |
| onComplete \(when an import set has completed transformation\). | Script that is used to set the number of items created, updated, and ignored. This script is for internal use and should not be modified or deleted. |
SCCM Device Patch Update Import
The data from the imported relevent Patches on devices are loaded into the SCCM Device Patch Update Import [sn_vul_sccm_device_patch_import] table.
SCCM Device Patch Update Transform is used to transform the imported information.
Note: Changes to this transform map alter how data from the SCCM Device Patch Update Import is processed.
To access this transform map, navigate to All > System Import Sets > Transform Maps and locate the SCCM Device Patch Update Transform.
The following table lists the transform map fields by integration.
| Script | Description |
|---|---|
| OnStart \(when an import set has created transformation\). | Script that is used to initialize the values in the scope variable \[sn\_vul\_sccm\] for the integration process. This script is for internal use and should not be modified or deleted. |
| onBefore \(before an import set has completed transformation\). | Script that is used to Create and Update CIs based on CI Lookup Rules and patches, as well as the relationship between them. Based on the results, this script modifies the values in the scope variable \[sn\_vul\_sccm\]. This script is for internal use and should not be modified or deleted. |
| onComplete \(when an import set has completed transformation\). | Script that is used to set the number of items created, updated, and ignored. This script is for internal use and should not be modified or deleted. |
SCCM Device Collection Import
The data from the imported device collections are loaded into the SCCM Device Collection Import [sn_vul_sccm_device_collection_import] table.
The SCCM Device Collection Import Transform is used to transform the imported information.
Note: Changes to this transform map alter how data from the SCCM Device Collection Import is processed.
To access this transform map, navigate to All > System Import Sets > Transform Maps and locate the SCCM Device Collection Transform.
The following table lists the transform map fields by integration.
| Script | Description |
|---|---|
| OnStart \(when an import set has created transformation\). | Script that is used to initialize the values in the scope variable \[sn\_vul\_sccm\] for the integration process. This script is for internal use and should not be modified or deleted. |
| onBefore \(before an import set has completed transformation\). | The script that is used to create and update CIs based on the CI Lookup Rules and collections, as well as the relationship between them. Based on the results, this script modifies values in the scope variable \[sn\_vul\_sccm\]. This script is for internal use and should not be modified or deleted. |
| onComplete \(when an import set has completed transformation\). | Script that is used to set the number of items created, updated, and ignored. This script is for internal use and should not be modified or deleted. |
| Source field | Target field | Description |
|---|---|---|
| u_id | source_id | Unique Id of an action. |
| U_name | name | Name of the action |
| [Script] | Sn_vul_sccm_discovered_item | Reference of the discovered item on which the patch is deployed |
| U_status | status | Status of the action |
| [Script] | Sn_vul_patch_orch_update | Reference of the patch |
| U_apply_count | Count_success | Success count of action. |
| U_retry_count | retry | Retry count of the action. |
| [Script] | Deployment_time | Start time of the action. |
| [Script] | deadline | End time of the action. |
| [Script] | Source_created | Creation time of the action. |
| [Script] | Integration_instance | Name of the instance from which the action is imported. |
SCCM Deployment Import
The data from imported deployments are loaded into the SCCM Deployment Import [sn_vul_sccm_deployment_import] table.
The SCCM Deployment Import Transform is used to transform the imported information.
Note: Changes to this transform map alter how data from the SCCM Deployment Import is processed.
To access this transform map, navigate to All > System Import Sets > Transform Maps and locate the SCCM Deployment Transform.
| Source field | Target field | Description |
|---|---|---|
| u_id | source_id | Unique Id of a Deployment. |
| u_name | name | Name of the Deployment. |
| [Script] | deadline | Deadline time for the Deployment. |
| u_numberinprogress | count_progress | Count of devices in progress for the Deployment. |
| [Script] | deployment_time | Deployment start time. |
| [Script] | integration_instance | Name of the instance the Deployment is imported from. |
| [Script] | source_created | Creation time of the Deployment. |
| [Script] | sn_vul_patch_orch_update | Reference of the Patch |
| [Script] | sn_vul_patch_orch_collection | Reference of the discovered item the patch is deployed on. |
| u_softwarename | name | Name of the Deployment. |
| u_numberother | count_other | Other count of devices for the Deployment. |
| u_numberunknown | count_unknown | Unknown state count of devices for the Deployment. |
| u_deploymentid | source_id | Unique identifier of the Deployment. |
| u_numbersuccess | count_success | Success count of devices for the Deployment. |
| u_numbererrors | count_error | Error count of devices for the Deployment. |
| u_numbertargeted | count_total | Total count of the devices for the Deployment. |
| Script | Description |
|---|---|
| OnStart \(when an import set has created transformation\). | Script that is used to initialize the values in the scope variable \[sn\_vul\_sccm\] for the integration process. This script is for internal use and should not be modified or deleted. |
| onBefore \(before an import set has completed transformation\). | The script that is used to update the values in the scope variable \[sn\_vul\_sccm\]. This script is for internal use and should not be modified or deleted. |
| onComplete \(when an import set has completed transformation\). | Script that is used to set the number of items created, updated, and ignored. This script is for internal use and should not be modified or deleted. |