Data transformation for the Patch Orchestration with Microsoft SCCM Integration

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.

注:

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.

表 : 1. SCCM Collection Import transform map script timing
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.

注:

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.

表 : 2. SCCM Patch Update Import transform map fields
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.

表 : 3. SCCM Patch Update Import transform map script timing
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.

注:

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.

表 : 4. SCCM Device Patch Update Transform map script timing
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.

注:

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.

表 : 5. Device Collection Import transform map script timing
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.

表 : 6. SCCM Device Collection Import transform map fields
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.

注:

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.

表 : 7. SCCM Deployment Transform map fields
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.

表 : 8. SCCM Deployment Import transform map script timing
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.