ConfigMgr Inbox File Types Extensions and Associated Components

Let’s discuss the ConfigMgr Inbox File Types Extensions and Associated Components. I’ve seen loads of questions about the SCCM ConfigMgr Inbox file extensions. Some examples are: What type of files are *.TRG files in the SCCM 2012 Inbox?

I have a backlog of *.UDC files in my SCCM CB, 2012 or 2007 Inbox folder. Can I delete these files? I’m not going to provide answers to these questions.  However, the following table can give us more details about SCCM ConfigMgr 2012 file extensions and the process/thread associated with each type of SCCM file.

Update:– Some of these are still valid for SCCM CB as well..Download the file extension list for offline use from the GitHub gallery here. Pivot the table of Files here. The best way to know more about these SCCM 2012 file extensions and details about the SQL actions that get triggered with each type of file extension is to go into the registry of the SCCM ConfigMgr 2012 primary or CAS server.  

The picture below shows that each trigger, like ActiveDirectoryForests_HMAN, can provide information. For example, ActiveDirectoryForests_HMAN contains this load of information ::: This is exciting information for me. I don’t know what you feel. Is this valuable information in some troubleshooting?

• Files Types Folder Inbox Locations Used For Replication Processes SCCM ConfigMgr
• ConfigMgr CMPivot Logs | Background Process Guide | SCCM | Configuration Manager
• SCCM File Replication Account to help with Site Replication Issue Troubleshooting

Index
ConfigMgr Inbox File Types Extensions and Associated Components

ConfigMgr Inbox File Types Extensions and Associated Components

Let’s discuss the ConfigMgr Inbox File Types Extensions and Associated Components. The table below provides more details.

ConfigMgr Inbox File Types Extensions and Associated Components.

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\CAS\ActiveDirectoryForests_HMAN]
“Active”=dword:00000001
“Table”=”ActiveDirectoryForests”
“Action”=”Insert, Update”
“Target Service”=”Hierarchy Manager”
“File Extension”=”TRG”
“Key Name”=”ForestID“
“Filter”=””

SCCM 2012 File Extensions	Trigger Name	SCCM 2012 Thread Service
.TRG	ActiveDirectoryForests_HMAN	Hierarchy Manager
.TRG	ActiveDirectoryForests_SITECOMP	Site Component Manager
.ALE	AlertForTrigger_ALE	Alert Notification Inbox
.ALT	Alert_ALT	Alert Notification Inbox
.RCM	ArticleData_RCM	Replication Configuration And Monitoring Inbox
.AUC	AutoClientUpgradeConfigs_UPD_HMAN	Hierarchy Manager
.BND	BoundaryEx_Event	Discovery Data Manager (Notification)
.TRG	BoundaryEx_HMAN	Hierarchy Manager
.BND	BoundaryGroupMembers_Event	Discovery Data Manager (Notification)
.TRG	BoundaryGroupMembers_HMAN	Hierarchy Manager
.BND	BoundaryGroup_Event	Discovery Data Manager (Notification)
.TRG	BoundaryGroup_HMAN	Hierarchy Manager
.CTN	CategoryNotify_iud	Object Replication Manager
.CFE	CFDGo_INS_UPD_HMAN	Hierarchy Manager (CFD)
.CIA	CIAssignmentNotify_iu	Object Replication Manager
.CIN	CINotify_iud	Object Replication Manager
.CIN	CI_ApplicationModelInfo_CINotify	Object Replication Manager
.CIA	CI_AssignmentTargetedCIs_CIAMGR	Object Replication Manager
.CIN	CI_ConfigurationItemRelations_Flat_From_iud	Object Replication Manager
	CI_ConfigurationItemRelations_FromVE_ToDT_iud
.GCS	ClientAgentProperty_Value_iud	Object Replication Manager
.OPA	ClientOperation_iu	Object Replication Manager
.GCA	ClientSettingsAssignments_iu	Object Replication Manager
.GCS	ClientSettings_iud	Object Replication Manager
.CSD	CloudSubscription_CSD	Replication Configuration And Monitoring Inbox
.REC	CRP_CertRevoke	Certificate Manager
.LQU	CurrentSiteSQL_AddUpd_HMAN	Hierarchy Manager
.ICP	DataLdr_InventoryAction	Client Data Files Source Directory
.ICP	DataLdr_InventoryClass	Client Data Files Source Directory
.ICP	DataLdr_InventoryClassProperty	Client Data Files Source Directory
.RIS	DataLdr_RemoteInvSchema	Client Data Files Source Directory
.MDA	DeviceAction_iu_CertMgr	Certificate Manager
.DSN	DeviceSettingItemNotify_iud	Object Replication Manager
.CRV	DiscPropertyDefs_Ins_DDM	Discovery Data Manager (Notification)
	DiscProps_Add_SMSProv	SMS Provider
.PKN	DistributionJobOrder_Updated	SMS_PACKAGE_TRANSFER_MANAGER
.CAN	DistributionJob_Cancelled	SMS_PACKAGE_TRANSFER_MANAGER
.PKN	DistributionJob_Creation	SMS_PACKAGE_TRANSFER_MANAGER
.INS	DistributionPoints_Ins	Distribution Manager
.INS	DistributionPoints_Upd	Distribution Manager
.DPN	DPNotify_ADD	Distribution Manager
.DPU	DPNotify_Upgrade	Distribution Manager
.INS	DPNotify_Upgrade_Ins	Distribution Manager
.NOT	DP_Properties_Upd	Distribution Manager
.EUN	EULANotify_iud	Object Replication Manager
	GroupMap_Add_SMSProv	SMS Provider
.RCM	InitPackageRequest_RCM	Replication Configuration And Monitoring Inbox
.ITO	InteropBlockList_AddDel_HMAN	Hierarchy Manager
.CFE	MDMCFDFeature_UPD_HMAN	Hierarchy Manager (CFD)
.RSB	MDMDeviceManagementStates_Local_INS_UPD_HMAN	Hierarchy Manager
.MIG	MIG_Job_MIG	Migration Manager Inbox
.SYN	MIG_SiteMapping_SYN	Migration Manager Inbox
.MRU	MonitoringRole_UPD_HMAN	Hierarchy Manager
.CRP	NDESCertificates_iud_CRP	Certificate Manager
.RQU	OtherSiteSQL_AddUpd_HMAN	Hierarchy Manager
.RQD	OtherSiteSQL_Del_HMAN	Hierarchy Manager
.PKN	PkgNotify_Add	Distribution Manager
.PRN	PkgPrograms_G_Avail_iu	Object Replication Manager
.ENR	PreEnrollmentRecords_Upd_AMT	SMS_AMT_PROXY_COMPONENT
.OAN	ProgramOffers_G_Avail_iu	Object Replication Manager
.PUL	PullDPResponse_UpdIns	Distribution Manager (Incoming)
.ROA	RAXSubNotify_iud	Object Replication Manager
	RBAC_Admins_ins_del_SMSProv	SMS Provider
.RBC	Rbac_Sync_ChangeNotification	Hierarchy Manager
.RCM	RCM_DrsInitializationTracking_RCM	Replication Configuration And Monitoring Inbox
.RIU	RecoveryInfo_UPD_HMAN	Hierarchy Manager
.RCM	ReplicationData_RCM	Replication Configuration And Monitoring Inbox
.RUL	Rules_iud	Rule Engine
.RAU	SCCMAutoUpdates_RAU	Replication Configuration And Monitoring Inbox
.RCM	ServerData_RCM	Replication Configuration And Monitoring Inbox
.SCA	SiteControl_Address_Scheduler	Scheduler
.SCU	SiteControl_AddUpd_HMAN	Hierarchy Manager
.CT0	SiteControl_AddUpd_SiteCtrl	Site Control Manager (Master Site Control File)
.SCA	SiteCtrlNot_Add_DDM	Discovery Data Manager (Notification)
.SCD	SiteCtrlNot_Del_DDM	Discovery Data Manager (Notification)
.SDD	SiteDefinition_DEL_HMAN	Hierarchy Manager (Forwarding messages)
.SAT	SiteDefinition_INS_HMAN	Hierarchy Manager (Forwarding messages)
.EXP	SiteExpansion_INS_HMAN	Hierarchy Manager
.SPK	SiteKey_ADDUPD_HMAN	Hierarchy Manager
.SHA	SiteNotif_AIKbMgr	Asset Intelligence KB Manager
.SHA	SiteNotif_iu_WCM	WSUS Configuration Manager
.SHA	SiteNotif_Upd_DDM	Discovery Data Manager
.SHA	SiteNotif_WSyncMgr	WSUS Sync Manager
.SR1	SiteReassign_Upd_HMAN_SR1	Hierarchy Manager (Site Reassign)
.SR2	SiteReassign_Upd_HMAN_SR2	Hierarchy Manager (Site Reassign)
.SR5	SiteReassign_Upd_HMAN_SR5	Hierarchy Manager (Site Reassign)
.SSC	SiteServerUpdate_AddUpd_HMAN	Hierarchy Manager
.CEU	SiteSQLCert_ADDUPD_HMAN	Hierarchy Manager
.SQR	SiteSQLService_Restart_HMAN	Hierarchy Manager
.IPK	SiteStatus_UPD_HMAN	Hierarchy Manager
.CMN	SiteSystemNotification_iu_CertMgr	Certificate Manager
.SSU	Sites_AddUpd_HMAN	Hierarchy Manager
.CMS	Sites_Add_CertMgr	Certificate Manager
.SSD	Sites_Del_HMAN	Hierarchy Manager
.ITC	Sites_Interop_Update_HMAN	Hierarchy Manager
	SMSDBMON_RunNow
.PAN	SMSPackages_G_Avail_iu	Object Replication Manager
	SMS_Advertisement_del_SMSProv	SMS Provider
	SMS_Advertisement_ins_upd_SMSProv	SMS Provider
	SMS_Alert_ins_upd_SMSProv	SMS Provider
	SMS_Alert_upd_SMSProv_AlertForTrigger	SMS Provider
	SMS_Collection_del_SMSProv	SMS Provider
	SMS_Collection_ins_upd_SMSProv	SMS Provider
	SMS_Package_del_SMSProv	SMS Provider
	SMS_Package_ins_upd_SMSProv	SMS Provider
.DVC	SqlControlProperty_DView	Replication Configuration And Monitoring Inbox
.RSC	SqlControlProperty_RCM	Replication Configuration And Monitoring Inbox
.SBP	SQLServerSSBPORT_UPD_HMAN	Hierarchy Manager
.SSR	SR_SingleSummaryRequest_ins_upd	State System
.RUN	SR_SummaryTasks_upd	State System
.CSB	SubNotify_d_WCM	WSUS Configuration Manager
.CSB	SubNotify_iu_WCM	WSUS Configuration Manager
.SYN	SyncNotif_WSyncMgr	WSUS Sync Manager
.TST	TestConnection_TST	Alert Notification Inbox
.SCN	UpdSrcNotify_iud	Object Replication Manager
.RCM	ViewData_RCM	Replication Configuration And Monitoring Inbox
.TASK	Azure_CloudServicesTask_CloudMgr_ins	Cloud Services Manager Inbox
.SVCCERT	Azure_Service_CloudMgr_ServiceCert_Upd	Cloud Services Manager Inbox
.CSC	CcarSiteControl_AddUpd_PolicyPV	Policy Provider
.CEP	CEP_ADD_Upd	Collection Evaluator
.CIT	CINotify_TSApp_PolicyPv_iud	Policy Provider
.CPB	ClientPushMachine_G_Insert	Client Configuration Record (Incoming)
.CPB	ClientPushMachine_G_Update_Site	Client Configuration Record (Incoming)
.GCA	ClientSettingsAssignments_iu	Object Replication Manager
.CSV	CloudServiceVersion_Event	License Manager Inbox
.CSD	CloudSubscription_CSD	Replication Configuration And Monitoring Inbox
.CMN	Collection_Del	Offer Manager
.ADC	CollG_Add	Collection Evaluator
.DC	CollG_Del	Collection Evaluator
.UDC	CollG_Upd	Collection Evaluator
.CMN	Coll_Add_OFFERMGR	Offer Manager
.IAC	ConfigMOF_iu	Policy Provider
.CPC	CP_SC_Component_Properties_Update	Client Configuration Record (Incoming)
.CRP	CrpCertChg_Notify	Policy Targeting Evaluator
.CRP	CrpChange_Notify_ins	Policy Targeting Evaluator
.CRP	CrpResourceChg_Notify	Policy Targeting Evaluator
.CRP	CrpUserChg_Notify	Policy Targeting Evaluator
.ICP	DataLdr_Sites	Client Data Files Source Directory
.NSA	DeviceSiteReassignment_Chg	Policy Provider
.UXD	DISCChangeNotifications_insdel	Policy Targeting Evaluator
.CRV	DiscPropertyDefs_Ins_DDM	Discovery Data Manager (Notification)
.IAC	InventoryAction_Chg	Policy Provider
.LPK	LanguagePackStatus_ALL_HMAN	Hierarchy Manager
.SLK	LicenseKeys_Event	License Manager Inbox
.LIC	LicenseRelation_Chg	Policy Provider
.CRT	MDMCertificates_Event	License Manager Inbox
.MEP	MEP_ADD_Upd	Policy Provider
.SRC	MPAdd_upd_PolicyPv	Policy Provider
.SRC	MPDel_upd_PolicyPv	Policy Provider
.SRC	MPInfoChg_upd_PolicyPv	Policy Provider
.MRN	MtrRule_Chg	Policy Provider
.SCE	NDES_upd_PolicyPv	Policy Provider
.OFN	OfferNotify_Add	Offer Manager
.DEL	Offer_Del	Offer Manager
.DPN	PeerDPResMap_d	Policy Provider
.DPN	PeerDPResMap_iu	Policy Provider
.CMN	PolicyTargetEvalNotify_ColMember_iu	Policy Targeting Evaluator
.CCN	PolicyTargetEvalNotify_iud	Policy Targeting Evaluator
.SRC	PortalInfoChg_upd_PolicyPv	Policy Provider
.SRC	PortalInfo_del_PolicyPv	Policy Provider
.CAT	PortalInfo_upd_PolicyPv	Policy Provider
.AD	PreEnrollmentRecords_Event	Enrollment Active Directory Service Inbox
.MPCERT	SC_SysResUse_Property_CloudMgr_MPCert_InsUpd	Cloud Services Manager Inbox
.PROXY	SC_SysResUse_Site_Server_Site_System_Property_Upd	Cloud Services Manager Inbox
.CTO	ServerData_Upd_SiteCtrl	Site Control Manager (Master Site Control File)
.CAS	SiteControl_CAS_Upd_SiteComp	Site Component Manager
.SHA	SiteNotif_Upd_OfferMgr	Offer Manager
.MPDEL	SysResList_CloudMgr_del	Cloud Services Manager Inbox
.RUC	SysResUse_Property_AddUpd_HMAN_SRS	Hierarchy Manager
.CPC	System_SMS_Assign_ARR_Insert	Client Configuration Record (Incoming)
.UEP	UEP_ADD_Upd	Policy Provider
.UKS	UnknownToKnownSystem_Upd	Policy Provider
.STN	UpdSyncStatus_iu	Policy Provider
.UDA	UserMachineRelation_Chg	Policy Provider
.UDA	UserMachineSourceRelation_Chg	Policy Provider
.UDA	UserMachineTypeRelation_Chg	Policy Provider
.WRC	WebServiceInfoChg_upd_PolicyPv	Policy Provider
.WLN	WOLMgr_WOLScheduleMap_iu	SMS_WAKEONLAN_MANAGER
.AHC	AIHinvClass_Upd_Dataldr	Client Data Files Source Directory (SCCM 2007)
.OTP	AMT_Add_OTP	SMS_AMT_PROXY_PROV (SCCM 2007)
.CTN	CategoryNotify_iud	Object Replication Manager (SCCM 2007)
.CEP	CEP_ADD_Upd	Collection Evaluator (SCCM 2007)

Registry Keys of SCCM 2012 primary server

Let’s discuss the Registry Keys of the SCCM 2012 primary server. The section below helps you show the Registry Keys of the SCCM 2012 primary server.

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI]
“Polling Directory”=””
“SMS Primary Site”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\ActiveDirectoryForests_HMAN]
“Active”=dword:00000001
“Table”=”ActiveDirectoryForests”
“Action”=”Insert, Update“
“Target Service”=”Hierarchy Manager”
“File Extension”=”TRG“
“Key Name”=”ForestID”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\ActiveDirectoryForests_SITECOMP]
“Active”=dword:00000001
“Table”=”ActiveDirectoryForests”
“Action”=”Insert, Update”
“Target Service”=”Site Component Manager”
“File Extension”=”TRG”
“Key Name”=”ForestID”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\AlertForTrigger_ALE]
“Active”=dword:00000001
“Table”=”AlertForTrigger”
“Action”=”Insert, Update”
“Target Service”=”Alert Notification Inbox”
“File Extension”=”ALE”
“Key Name”=”AlertID”
“Filter”=” exists (select 1 from inserted left join deleted on inserted.AlertID = deleted.AlertID where (ISNULL(inserted.AlertState, ‘-‘) <> ISNULL(deleted.AlertState, ‘-‘)) AND ISNULL(inserted.AlertState, ‘-‘) = ‘A’)”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\Alert_ALT]
“Active”=dword:00000001
“Table”=”Alert”
“Action”=”Insert, Update”
“Target Service”=”Alert Notification Inbox”
“File Extension”=”ALT”
“Key Name”=”AlertID”
“Filter”=” exists (select 1 from inserted left join deleted on inserted.AlertID = deleted.AlertID where (inserted.Enabled <> deleted.Enabled AND inserted.Enabled = 1) OR (inserted.SkipUntil <> deleted.SkipUntil))”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\ArticleData_RCM]
“Active”=dword:00000001
“Table”=”ArticleData”
“Action”=”Insert, Update, Delete”
“Target Service”=”Replication Configuration And Monitoring Inbox”
“File Extension”=”RCM”
“Key Name”=”ArticleName”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\AutoClientUpgradeConfigs_UPD_HMAN]
“Active”=dword:00000001
“Table”=”AutoClientUpgradeConfigs”
“Action”=”Update”
“Target Service”=”Hierarchy Manager”
“File Extension”=”AUC”
“Key Name”=”ClientVersion”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\Azure_CloudServicesTask_CloudMgr_ins]
“Active”=dword:00000001
“Table”=”Azure_CloudServicesTask”
“Action”=”Insert”
“Target Service”=”Cloud Services Manager Inbox”
“File Extension”=”TASK”
“Key Name”=”TaskId”
“Filter”=”exists(SELECT 1 FROM inserted WHERE SiteCode = dbo.fnGetSiteCode())”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\Azure_Service_CloudMgr_ServiceCert_Upd]
“Active”=dword:00000001
“Table”=”Azure_Service”
“Action”=”Update”
“Target Service”=”Cloud Services Manager Inbox”
“File Extension”=”SVCCERT”
“Key Name”=”AzureServiceId”
“Filter”=”exists(select 1 from inserted join deleted on inserted.AzureServiceId = deleted.azureserviceid where inserted.ServiceThumbprint <> deleted.ServiceThumbprint AND inserted.SiteCode = dbo.fnGetSiteCode() and inserted.State not in (1, 3, 99))”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\BoundaryEx_Event]
“Active”=dword:00000001
“Table”=”BoundaryEx”
“Action”=”Update”
“Target Service”=”Discovery Data Manager (Notification)”
“File Extension”=”BND”
“Key Name”=”BoundaryID”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\BoundaryEx_HMAN]
“Active”=dword:00000001
“Table”=”BoundaryEx”
“Action”=”Update”
“Target Service”=”Hierarchy Manager”
“File Extension”=”TRG”
“Key Name”=”BoundaryID”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\BoundaryGroupMembers_Event]
“Active”=dword:00000001
“Table”=”BoundaryGroupMembers”
“Action”=”Insert, Update, Delete”
“Target Service”=”Discovery Data Manager (Notification)”
“File Extension”=”BND”
“Key Name”=”BoundaryID,GroupID”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\BoundaryGroupMembers_HMAN]
“Active”=dword:00000001
“Table”=”BoundaryGroupMembers”
“Action”=”Insert,Update,Delete”
“Target Service”=”Hierarchy Manager”
“File Extension”=”TRG”
“Key Name”=”BoundaryID”
“Filter”=”GroupID in (select GroupID from BoundaryGroup where DefaultSiteCode in (select SiteCode from Sites where SiteCode=dbo.fnGetSiteCode() or ReportToSite=dbo.fnGetSiteCode()))”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\BoundaryGroup_Event]
“Active”=dword:00000001
“Table”=”BoundaryGroup”
“Action”=”Update”
“Target Service”=”Discovery Data Manager (Notification)”
“File Extension”=”BND”
“Key Name”=”GroupID”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\BoundaryGroup_HMAN]
“Active”=dword:00000001
“Table”=”BoundaryGroup”
“Action”=”Update”
“Target Service”=”Hierarchy Manager”
“File Extension”=”TRG”
“Key Name”=”GroupID”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\CategoryNotify_iud]
“Active”=dword:00000001
“Table”=”CI_CategoryInstances”
“Action”=”Insert, Update”
“Target Service”=”Object Replication Manager”
“File Extension”=”CTN”
“Key Name”=”CategoryInstanceID”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\CcarSiteControl_AddUpd_PolicyPV]
“Active”=dword:00000001
“Table”=”SiteControl”
“Action”=”Update”
“Target Service”=”Policy Provider”
“File Extension”=”CSC”
“Key Name”=”SiteCode”
“Filter”=”SiteCode = N’CAS’ and not exists (select 1 from TableChangeNotifications where Component=N’CcarSiteControl_AddUpd_PolicyPV’ and Key1=N’CAS’)”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\CEP_ADD_Upd]
“Active”=dword:00000001
“Table”=”CEP_CollectionExtendedProperties”
“Action”=”Insert, Update”
“Target Service”=”Collection Evaluator”
“File Extension”=”CEP”
“Key Name”=”CollectionID”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\CIAssignmentNotify_iu]
“Active”=dword:00000001
“Table”=”CI_CIAssignments”
“Action”=”Insert, Update”
“Target Service”=”Object Replication Manager”
“File Extension”=”CIA”
“Key Name”=”AssignmentID”
“Filter”=”ISNULL(MinRequiredVersion, 0) <= dbo.fnCurrentSiteVersion_INT()”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\CINotify_iud]
“Active”=dword:00000001
“Table”=”CI_ConfigurationItems”
“Action”=”Insert, Update”
“Target Service”=”Object Replication Manager”
“File Extension”=”CIN”
“Key Name”=”CI_ID”
“Filter”=”ISNULL(MinRequiredVersion, 0) <= dbo.fnCurrentSiteVersion_INT()”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\CINotify_TSApp_PolicyPv_iud]
“Active”=dword:00000001
“Table”=”CI_ConfigurationItems”
“Action”=”Insert, Update”
“Target Service”=”Policy Provider”
“File Extension”=”CIT”
“Key Name”=”CI_ID”
“Filter”=”(CIType_ID not in (1, 2, 6, 8, 9)) and (IsLatest = 1 or IsTombstoned = 1) AND ISNULL(MinRequiredVersion, 0) <= dbo.fnCurrentSiteVersion_INT()”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\CI_ApplicationModelInfo_CINotify]
“Active”=dword:00000001
“Table”=”CI_ApplicationModelInfo”
“Action”=”Update”
“Target Service”=”Object Replication Manager”
“File Extension”=”CIN”
“Key Name”=”CI_ID”
“Filter”=”EXISTS(SELECT 1 FROM CI_ConfigurationItems ci WHERE ci.CI_ID=inserted.CI_ID AND ISNULL(MinRequiredVersion, 0) <= dbo.fnCurrentSiteVersion_INT()) AND EXISTS(SELECT 1 FROM deleted d WHERE d.CI_ID=inserted.CI_ID AND d.Featured!=inserted.Featured)”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\CI_AssignmentTargetedCIs_CIAMGR]
“Active”=dword:00000001
“Table”=”CI_AssignmentTargetedCIs”
“Action”=”Insert, Update, Delete”
“Target Service”=”Object Replication Manager”
“File Extension”=”CIA”
“Key Name”=”AssignmentID”
“Filter”=”ActualCI_ID is not null”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\CI_ConfigurationItemRelations_Flat_From_iud]
“Active”=dword:00000001
“Table”=”CI_ConfigurationItemRelations_Flat”
“Action”=”Insert, Update, Delete”
“Target Service”=”Object Replication Manager”
“File Extension”=”CIN”
“Key Name”=”FromCI_ID”
“Filter”=”RelationType != 7”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\CI_ConfigurationItemRelations_FromVE_ToDT_iud]
“Active”=dword:00000000
“Table”=””
“Action”=””
“Target Service”=””
“File Extension”=””
“Key Name”=””
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\ClientAgentProperty_Value_iud]
“Active”=dword:00000001
“Table”=”ClientAgentProperty_Value”
“Action”=”Insert, Update, Delete”
“Target Service”=”Object Replication Manager”
“File Extension”=”GCS”
“Key Name”=”ClientSettingsID”
“Filter”=”dbo.fnIsCas()=0”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\ClientOperation_iu]
“Active”=dword:00000001
“Table”=”ClientOperation”
“Action”=”Insert, Update”
“Target Service”=”Object Replication Manager”
“File Extension”=”OPA”
“Key Name”=”ID”
“Filter”=”dbo.fnIsCas() = 0 AND State in (0, 1)”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\ClientPushMachine_G_Insert]
“Active”=dword:00000001
“Table”=”ClientPushMachine_G”
“Action”=”Insert”
“Target Service”=”Client Configuration Record (Incoming)”
“File Extension”=”CPB”
“Key Name”=”PushSiteCode”
“Filter”=”PushSiteCode=N’PRI’ and not exists (select 1 from TableChangeNotifications where Component=N’ClientPushMachine_G_Insert’ and Key1=inserted.PushSiteCode)”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\ClientPushMachine_G_Update_Site]
“Active”=dword:00000001
“Table”=”ClientPushMachine_G”
“Action”=”Update”
“Target Service”=”Client Configuration Record (Incoming)”
“File Extension”=”CPB”
“Key Name”=”Status”
“Filter”=”Status=0 and PushSiteCode=N’PRI’ and not exists (select 1 from TableChangeNotifications where Component=N’ClientPushMachine_G_Update_Site’ and Key1=inserted.Status)”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\ClientSettingsAssignments_iu]
“Active”=dword:00000001
“Table”=”ClientSettingsAssignments”
“Action”=”Insert, Update”
“Target Service”=”Object Replication Manager”
“File Extension”=”GCA”
“Key Name”=”ID”
“Filter”=”dbo.fnIsCas()=0”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\ClientSettings_iud]
“Active”=dword:00000001
“Table”=”ClientSettings”
“Action”=”Insert, Update, Delete”
“Target Service”=”Object Replication Manager”
“File Extension”=”GCS”
“Key Name”=”ID”
“Filter”=”dbo.fnIsCas()=0”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\CloudServiceVersion_Event]
“Active”=dword:00000001
“Table”=”CloudServiceVersion”
“Action”=”Insert, Update”
“Target Service”=”License Manager Inbox”
“File Extension”=”CSV”
“Key Name”=”ID”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\CloudSubscription_CSD]
“Active”=dword:00000001
“Table”=”CloudSubscription”
“Action”=”Delete”
“Target Service”=”Replication Configuration And Monitoring Inbox”
“File Extension”=”CSD”
“Key Name”=”UniqueID”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\Collection_Del]
“Active”=dword:00000001
“Table”=”Collections_G”
“Action”=”Delete”
“Target Service”=”Offer Manager”
“File Extension”=”CMN”
“Key Name”=”SiteID”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\CollG_Add]
“Active”=dword:00000001
“Table”=”Collections_G”
“Action”=”Insert”
“Target Service”=”Collection Evaluator”
“File Extension”=”ADC”
“Key Name”=”SiteID”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\CollG_Del]
“Active”=dword:00000001
“Table”=”Collections_G”
“Action”=”Delete”
“Target Service”=”Collection Evaluator”
“File Extension”=”DC”
“Key Name”=”SiteID”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\CollG_Upd]
“Active”=dword:00000001
“Table”=”Collections_G”
“Action”=”Update”
“Target Service”=”Collection Evaluator”
“File Extension”=”UDC”
“Key Name”=”SiteID”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\Coll_Add]
“Active”=dword:00000001
“Table”=”Collection_Maint”
“Action”=”Insert”
“Target Service”=”Collection Evaluator”
“File Extension”=”ADC”
“Key Name”=”CollectionID”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\Coll_Add_OFFERMGR]
“Active”=dword:00000001
“Table”=”Collection_MemberChg_Notif”
“Action”=”Insert”
“Target Service”=”Offer Manager”
“File Extension”=”CMN”
“Key Name”=”CollectionID”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\Coll_Del]
“Active”=dword:00000001
“Table”=”Collection_Maint”
“Action”=”Delete”
“Target Service”=”Collection Evaluator”
“File Extension”=”DC”
“Key Name”=”CollectionID”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\Coll_Upd]
“Active”=dword:00000001
“Table”=”Collection_Maint”
“Action”=”Update”
“Target Service”=”Collection Evaluator”
“File Extension”=”UDC”
“Key Name”=”CollectionID”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\ConfigMOF_iu]
“Active”=dword:00000001
“Table”=”HinvMOFs”
“Action”=”Update, NonZeroByteFile”
“Target Service”=”Policy Provider”
“File Extension”=”IAC”
“Key Name”=”MOFName”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\CP_SC_Component_Properties_Update]
“Active”=dword:00000001
“Table”=”SC_Component_Property”
“Action”=”Update”
“Target Service”=”Client Configuration Record (Incoming)”
“File Extension”=”CPC”
“Key Name”=”Value3”
“Filter”=”dbo.FnIsAnyClientPushActive(N’PRI’)=1 AND inserted.Name=N’AutoInstallSiteSystem’ AND NOT EXISTS (SELECT 1 FROM TableChangeNotifications WHERE Component=N’CP_SC_Component_Properties_Update’)”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\CrpCertChg_Notify]
“Active”=dword:00000001
“Table”=”CrpCertChg_Notify”
“Action”=”Insert”
“Target Service”=”Policy Targeting Evaluator”
“File Extension”=”CRP”
“Key Name”=”CI_ID”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\CrpChange_Notify_ins]
“Active”=dword:00000001
“Table”=”CrpChange_Notify”
“Action”=”Insert”
“Target Service”=”Policy Targeting Evaluator”
“File Extension”=”CRP”
“Key Name”=”CollectionID”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\CrpResourceChg_Notify]
“Active”=dword:00000001
“Table”=”CrpResourceChg_Notify”
“Action”=”Insert”
“Target Service”=”Policy Targeting Evaluator”
“File Extension”=”CRP”
“Key Name”=”DeviceItemkey”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\CrpUserChg_Notify]
“Active”=dword:00000001
“Table”=”CrpUserChg_Notify”
“Action”=”Insert”
“Target Service”=”Policy Targeting Evaluator”
“File Extension”=”CRP”
“Key Name”=”UserItemkey”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\CRP_CertRevoke]
“Active”=dword:00000001
“Table”=”CertRevocationNotify”
“Action”=”Insert”
“Target Service”=”Certificate Manager”
“File Extension”=”REC”
“Key Name”=”ID”
“Filter”=”Flag=0”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\CurrentSiteSQL_AddUpd_HMAN]
“Active”=dword:00000001
“Table”=”SC_SysResUse”
“Action”=”Insert, Update”
“Target Service”=”Hierarchy Manager”
“File Extension”=”LQU”
“Key Name”=”SiteNumber,dbo.fnGetSiteSystemName(NALPath)”
“Filter”=”SiteNumber=dbo.fnGetSiteNumber() AND RoleTypeID IN (SELECT RoleTypeID FROM SC_RoleType WHERE RoleName = ‘SMS SQL Server’) AND UPDATE(NALPath)”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\DataLdr_InventoryAction]
“Active”=dword:00000001
“Table”=”InventoryAction”
“Action”=”Insert, Update, Delete”
“Target Service”=”Client Data Files Source Directory”
“File Extension”=”ICP”
“Key Name”=”ActionID”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\DataLdr_InventoryClass]
“Active”=dword:00000001
“Table”=”InventoryClass”
“Action”=”Insert, Update, Delete, distinct”
“Target Service”=”Client Data Files Source Directory”
“File Extension”=”ICP”
“Key Name”=”ClassID”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\DataLdr_InventoryClassProperty]
“Active”=dword:00000001
“Table”=”InventoryClassProperty”
“Action”=”Insert, Update, Delete, distinct”
“Target Service”=”Client Data Files Source Directory”
“File Extension”=”ICP”
“Key Name”=”ClassID”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\DataLdr_Sites]
“Active”=dword:00000001
“Table”=”Sites”
“Action”=”Update”
“Target Service”=”Client Data Files Source Directory”
“File Extension”=”ICP”
“Key Name”=”SiteCode”
“Filter”=”SiteCode=dbo.fnGetSiteCode() and DetailedStatus IN (125, 110)”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\DeviceAction_iu_CertMgr]
“Active”=dword:00000001
“Table”=”MDMDeviceActions_L”
“Action”=”Insert, Update”
“Target Service”=”Certificate Manager”
“File Extension”=”MDA”
“Key Name”=”ResourceID”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\DeviceSettingItemNotify_iud]
“Active”=dword:00000001
“Table”=”DeviceSettingItems”
“Action”=”Insert, Update”
“Target Service”=”Object Replication Manager”
“File Extension”=”DSN”
“Key Name”=”DeviceSettingItemID”
“Filter”=”SourceSite = ‘PRI'”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\DeviceSiteReassignment_Chg]
“Active”=dword:00000001
“Table”=”DeviceSiteReassignment”
“Action”=”Insert, Update, NonZeroByteFile”
“Target Service”=”Policy Provider”
“File Extension”=”NSA”
“Key Name”=”Flag”
“Filter”=”Flag = 0 AND (((dbo.fnGetSiteRangeStart() < MachineID) AND (MachineID < dbo.fnGetSiteRangeEnd())) OR (dbo.fnGetSiteCode() = SiteCode))”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\DISCChangeNotifications_insdel]
“Active”=dword:00000001
“Table”=”DISCChangeNotifications”
“Action”=”Insert”
“Target Service”=”Policy Targeting Evaluator”
“File Extension”=”UXD”
“Key Name”=”ChangeType”
“Filter”=” ChangeType IN (100,101) “

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\DiscPropertyDefs_Ins_DDM]
“Active”=dword:00000001
“Table”=”DiscPropertyDefs”
“Action”=”Insert”
“Target Service”=”Discovery Data Manager (Notification)”
“File Extension”=”CRV”
“Key Name”=”DiscArchKey”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\DiscProps_Add_SMSProv]
“Active”=dword:00000001
“Table”=”DiscPropertyDefs”
“Action”=”insert”
“Target Service”=”SMS Provider”
“File Extension”=””
“Key Name”=”DiscArchKey,PropertyName”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\DistributionJobOrder_Updated]
“Active”=dword:00000001
“Table”=”DistributionJobs”
“Action”=”Update”
“Target Service”=”SMS_PACKAGE_TRANSFER_MANAGER”
“File Extension”=”PKN”
“Key Name”=”PkgID”
“Filter”=”Update(DynamicOrder)”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\DistributionJob_Cancelled]
“Active”=dword:00000001
“Table”=”DistributionJobs”
“Action”=”Update”
“Target Service”=”SMS_PACKAGE_TRANSFER_MANAGER”
“File Extension”=”CAN”
“Key Name”=”JobID”
“Filter”=”(Action = 5) OR (UPDATE(State) and inserted.State = 8)”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\DistributionJob_Creation]
“Active”=dword:00000001
“Table”=”DistributionJobs”
“Action”=”Update”
“Target Service”=”SMS_PACKAGE_TRANSFER_MANAGER”
“File Extension”=”PKN”
“Key Name”=”PkgID”
“Filter”=”((State = 1) AND (restarttime is null))”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\DistributionPoints_Ins]
“Active”=dword:00000001
“Table”=”DistributionPoints”
“Action”=”Insert”
“Target Service”=”Distribution Manager”
“File Extension”=”INS”
“Key Name”=”DPID”
“Filter”=”SMSSiteCode =’PRI’ AND DPFlags <> 1”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\DistributionPoints_Upd]
“Active”=dword:00000001
“Table”=”DistributionPoints”
“Action”=”Update”
“Target Service”=”Distribution Manager”
“File Extension”=”INS”
“Key Name”=”DPID”
“Filter”=”SMSSiteCode =’PRI’ AND DPFlags <> 1 AND exists (select 1 from inserted join deleted on inserted.NALPath=deleted.NALPath where inserted.Action = 0 AND (deleted.Action = 3 OR inserted.SMSSiteCode<>deleted.SMSSiteCode))”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\DPNotify_ADD]
“Active”=dword:00000001
“Table”=”DPNotification”
“Action”=”Insert”
“Target Service”=”Distribution Manager”
“File Extension”=”DPN”
“Key Name”=”DPID”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\DPNotify_Upgrade]
“Active”=dword:00000001
“Table”=”DistributionPoints”
“Action”=”Insert, Update”
“Target Service”=”Distribution Manager”
“File Extension”=”DPU”
“Key Name”=”DPID”
“Filter”=”SMSSiteCode =’PRI’ AND ((exists (select 1 from inserted join deleted on inserted.NALPath=deleted.NALPath where (inserted.DPFlags=0x00004 AND deleted.DPFlags = 0) OR (inserted.DPFlags=0 AND deleted.DPFlags = 0x00004))) OR (exists(select 1 from inserted join DistributionPoints on DistributionPoints.ServerName=inserted.ServerName where DistributionPoints.DPFlags=1 and inserted.DPFlags<>1)) OR (exists(select 1 from inserted where DPFlags = 0x00004)))”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\DPNotify_Upgrade_Ins]
“Active”=dword:00000001
“Table”=”DistributionPoints”
“Action”=”Insert, Update”
“Target Service”=”Distribution Manager”
“File Extension”=”INS”
“Key Name”=”DPID”
“Filter”=”SMSSiteCode =’PRI’ AND (State<>1 OR State is NULL) AND (exists (select 1 from inserted join deleted on inserted.NALPath=deleted.NALPath where (inserted.DPFlags<>1 AND deleted.DPFlags = 1) OR (inserted.DPFlags=0x00004 AND deleted.DPFlags = 0) OR (inserted.DPFlags=0 AND deleted.DPFlags = 0x00004)))”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\DP_Properties_Upd]
“Active”=dword:00000001
“Table”=”DistributionPoints”
“Action”=”Update”
“Target Service”=”Distribution Manager”
“File Extension”=”NOT”
“Key Name”=”DPID”
“Filter”=”SMSSiteCode =’PRI’ AND (exists (select 1 from inserted join deleted on inserted.DPID=deleted.DPID where inserted.DPType<>deleted.DPType OR inserted.AnonymousEnabled<>deleted.AnonymousEnabled OR inserted.SslState<>deleted.SslState OR inserted.IsPXE<>deleted.IsPXE OR inserted.IsPullDP<>deleted.IsPullDP))”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\EULANotify_iud]
“Active”=dword:00000001
“Table”=”EULA_Content”
“Action”=”Insert, Update”
“Target Service”=”Object Replication Manager”
“File Extension”=”EUN”
“Key Name”=”EULAContentID”
“Filter”=”SourceSite = ‘PRI'”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\GroupMap_Add_SMSProv]
“Active”=dword:00000001
“Table”=”GroupMap_Notif”
“Action”=”insert,update,delete,distinct”
“Target Service”=”SMS Provider”
“File Extension”=””
“Key Name”=”GroupClass”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\InitPackageRequest_RCM]
“Active”=dword:00000001
“Table”=”RCM_InitPackageRequest”
“Action”=”Insert”
“Target Service”=”Replication Configuration And Monitoring Inbox”
“File Extension”=”RCM”
“Key Name”=”RequestTrackingGUID”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\InteropBlockList_AddDel_HMAN]
“Active”=dword:00000001
“Table”=”InteropBlockList”
“Action”=”Insert, Delete”
“Target Service”=”Hierarchy Manager”
“File Extension”=”ITO”
“Key Name”=”ID”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\InventoryAction_Chg]
“Active”=dword:00000001
“Table”=”InventoryAction”
“Action”=”Insert, Update, NonZeroByteFile”
“Target Service”=”Policy Provider”
“File Extension”=”IAC”
“Key Name”=”ActionID”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\LanguagePackStatus_ALL_HMAN]
“Active”=dword:00000001
“Table”=”LanguagePackStatus”
“Action”=”insert,delete,update”
“Target Service”=”Hierarchy Manager”
“File Extension”=”LPK”
“Key Name”=”Locale”
“Filter”=”not exists (select 1 from TableChangeNotifications where Component=N’LanguagePackStatus_ALL_HMAN’ )”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\LicenseKeys_Event]
“Active”=dword:00000001
“Table”=”LicenseKeys”
“Action”=”Insert, Update”
“Target Service”=”License Manager Inbox”
“File Extension”=”SLK”
“Key Name”=”KeyId”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\LicenseRelation_Chg]
“Active”=dword:00000001
“Table”=”LicenseRelation”
“Action”=”Insert, Update, Delete, NonZeroByteFile”
“Target Service”=”Policy Provider”
“File Extension”=”LIC”
“Key Name”=”RelationshipID”
“Filter”=”dbo.fnGetSiteRangeStart() < MachineID AND MachineID < dbo.fnGetSiteRangeEnd()”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\MDMCertificates_Event]
“Active”=dword:00000001
“Table”=”MDMCertificates”
“Action”=”Insert, Update”
“Target Service”=”License Manager Inbox”
“File Extension”=”CRT”
“Key Name”=”ID”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\MDMDeviceManagementStates_Local_INS_UPD_HMAN]
“Active”=dword:00000001
“Table”=”MDMDeviceManagementStates_Local”
“Action”=”Insert,Update”
“Target Service”=”Hierarchy Manager”
“File Extension”=”RSB”
“Key Name”=”DeviceID”
“Filter”=”WIPE IS NOT NULL OR RETIRE IS NOT NULL”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\MEP_ADD_Upd]
“Active”=dword:00000001
“Table”=”MEP_MachineExtendedProperties”
“Action”=”Insert, Update, NonZeroByteFile”
“Target Service”=”Policy Provider”
“File Extension”=”MEP”
“Key Name”=”MachineID”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\MIG_Job_MIG]
“Active”=dword:00000001
“Table”=”MIG_Job”
“Action”=”Insert, Update”
“Target Service”=”Migration Manager Inbox”
“File Extension”=”MIG”
“Key Name”=”JobID”
“Filter”=” exists (select 1 from inserted left join deleted on inserted.JobID = deleted.JobID where (ISNULL(inserted.ScheduleToken, ”) <> ISNULL(deleted.ScheduleToken, ”)) or((ISNULL(inserted.Status, 0) <> ISNULL(deleted.Status, 0)) AND ISNULL(inserted.Status, 0) = 1) or(ISNULL(inserted.RequestedOperation, ”) <> ”))”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\MIG_SiteMapping_SYN]
“Active”=dword:00000001
“Table”=”MIG_SiteMapping”
“Action”=”Insert, Update”
“Target Service”=”Migration Manager Inbox”
“File Extension”=”SYN”
“Key Name”=”SiteMappingID”
“Filter”=” exists (select 1 from inserted left join deleted on inserted.SiteMappingID = deleted.SiteMappingID where (ISNULL(inserted.ScheduleToken, ”) <> ISNULL(deleted.ScheduleToken, ”)) or((ISNULL(inserted.Status, 0) <> ISNULL(deleted.Status, 0)) AND ISNULL(inserted.Status, 0) = 1) or(ISNULL(inserted.RequestedOperation, ”) <> ”))”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\MonitoringRole_UPD_HMAN]
“Active”=dword:00000001
“Table”=”CM_MonitoringRoles”
“Action”=”Update”
“Target Service”=”Hierarchy Manager”
“File Extension”=”MRU”
“Key Name”=”RoleID”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\MPAdd_upd_PolicyPv]
“Active”=dword:00000001
“Table”=”SC_SysResUse_Property”
“Action”=”Insert, Update”
“Target Service”=”Policy Provider”
“File Extension”=”SRC”
“Key Name”=”SysResUseID”
“Filter”=” (Name = ‘SignedSerializedCertificateEx’ AND Value2 IS NOT NULL AND Value2 <> ” AND SysResUseID IN ( SELECT SysResUseID FROM SC_SysResUse SRU INNER JOIN SC_RoleType RT ON SRU.RoleTypeID = RT.RoleTypeID WHERE RT.RoleName = ‘SMS Management Point’))”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\MPDel_upd_PolicyPv]
“Active”=dword:00000001
“Table”=”SysResList”
“Action”=”Delete”
“Target Service”=”Policy Provider”
“File Extension”=”SRC”
“Key Name”=”SysResList_PK”
“Filter”=”EXISTS (SELECT 1 FROM DELETED WHERE RoleName = ‘SMS Management Point’)”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\MPInfoChg_upd_PolicyPv]
“Active”=dword:00000001
“Table”=”SysResList”
“Action”=”Update”
“Target Service”=”Policy Provider”
“File Extension”=”SRC”
“Key Name”=”SysResList_PK”
“Filter”=” ((RoleName = ‘SMS Management Point’ AND Certificate IS NOT NULL) AND EXISTS (SELECT 1 FROM INSERTED I FULL JOIN DELETED D ON I.SysResList_PK = D.SysResList_PK WHERE ( (I.IsAvailable <> D.IsAvailable) OR (I.SslState <> D.SslState) OR (I.InternetEnabled <> D.InternetEnabled) OR (I.Shared <> D.Shared) OR (I.ServerRemoteName <> D.ServerRemoteName) OR (I.PublicDNSName <> D.PublicDNSName) OR (I.DomainFQDN <> D.DomainFQDN) OR (I.ForestFQDN <> D.ForestFQDN) )) )”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\MtrRule_Chg]
“Active”=dword:00000001
“Table”=”MeterRules”
“Action”=”Insert, Update, Delete, NonZeroByteFile”
“Target Service”=”Policy Provider”
“File Extension”=”MRN”
“Key Name”=”SecurityKey”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\NDESCertificates_iud_CRP]
“Active”=dword:00000001
“Table”=”SC_SysResUse_Property”
“Action”=”Insert, Update, delete”
“Target Service”=”Certificate Manager”
“File Extension”=”CRP”
“Key Name”=”SysResUseID”
“Filter”=” Name = ‘NDESCertificates’ AND SysResUseID IN (SELECT SysResUseID FROM SC_SysResUse WHERE RoleTypeID = 25)”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\NDES_upd_PolicyPv]
“Active”=dword:00000001
“Table”=”MDMNdesList”
“Action”=”Insert, Update, Delete”
“Target Service”=”Policy Provider”
“File Extension”=”SCE”
“Key Name”=”URLID”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\OfferNotify_Add]
“Active”=dword:00000001
“Table”=”OfferNotification”
“Action”=”Insert”
“Target Service”=”Offer Manager”
“File Extension”=”OFN”
“Key Name”=”OfferID”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\Offer_Del]
“Active”=dword:00000001
“Table”=”ProgramOffers_L”
“Action”=”Delete”
“Target Service”=”Offer Manager”
“File Extension”=”DEL”
“Key Name”=”OfferID”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\OtherSiteSQL_AddUpd_HMAN]
“Active”=dword:00000001
“Table”=”SC_SysResUse”
“Action”=”Insert, Update”
“Target Service”=”Hierarchy Manager”
“File Extension”=”RQU”
“Key Name”=”SiteNumber,ID,dbo.fnGetSiteSystemName(NALPath)”
“Filter”=”dbo.fnIsParentOrChildSite(SiteNumber) != 0 AND RoleTypeID IN (SELECT RoleTypeID FROM SC_RoleType WHERE RoleName = ‘SMS SQL Server’) AND UPDATE(NALPath)”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\OtherSiteSQL_Del_HMAN]
“Active”=dword:00000001
“Table”=”SC_SysResUse_Property”
“Action”=”Delete”
“Target Service”=”Hierarchy Manager”
“File Extension”=”RQD”
“Key Name”=”Name,dbo.fnReplaceBackSlashWithEqualSign(Value2),dbo.fnGetSiteSystemNameFromID(SysResUseID)”
“Filter”=”dbo.fnIsParentOrChildSite(SiteNumber) != 0 AND Name IN (‘SQL Server Service Logon Account’, ‘SQL Server Agent Service Logon Account’)”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\PeerDPResMap_d]
“Active”=dword:00000001
“Table”=”PeerDPResMap”
“Action”=”Delete, NonZeroByteFile”
“Target Service”=”Policy Provider”
“File Extension”=”DPN”
“Key Name”=”DPID”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\PeerDPResMap_iu]
“Active”=dword:00000001
“Table”=”PeerDPResMap”
“Action”=”Insert, Update, NonZeroByteFile”
“Target Service”=”Policy Provider”
“File Extension”=”DPN”
“Key Name”=”DPID”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\PkgNotify_Add]
“Active”=dword:00000001
“Table”=”PkgNotification”
“Action”=”Insert”
“Target Service”=”Distribution Manager”
“File Extension”=”PKN”
“Key Name”=”PkgID”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\PkgPrograms_G_Avail_iu]
“Active”=dword:00000001
“Table”=”PkgPrograms_G”
“Action”=”Insert, Update”
“Target Service”=”Object Replication Manager”
“File Extension”=”PRN”
“Key Name”=”ProgramID”
“Filter”=”dbo.fnIsPrimary()=1 AND ProgramFlags & 0x00001100 = 0 and Command is not null and Command != N””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\PolicyAssignmentChg_Notify_iu]
“Active”=dword:00000001
“Table”=”PolicyAssignmentChg_Notify”
“Action”=”Insert, Update”
“Target Service”=”Policy Targeting Evaluator”
“File Extension”=”PAC”
“Key Name”=”PADBID”
“Filter”=” MachineID is NULL “

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\PolicyTargetEvalNotify_ColMember_iu]
“Active”=dword:00000001
“Table”=”Collection_MemberChg_Notif”
“Action”=”Insert, Update”
“Target Service”=”Policy Targeting Evaluator”
“File Extension”=”CMN”
“Key Name”=”CollectionID”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\PolicyTargetEvalNotify_iud]
“Active”=dword:00000001
“Table”=”Collections_L”
“Action”=”Insert, Update”
“Target Service”=”Policy Targeting Evaluator”
“File Extension”=”CCN”
“Key Name”=”CollectionID”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\PortalInfoChg_upd_PolicyPv]
“Active”=dword:00000001
“Table”=”PortalInfo”
“Action”=”Insert, Update”
“Target Service”=”Policy Provider”
“File Extension”=”SRC”
“Key Name”=”ServerName, SiteCode”
“Filter”=”Update(AuthenticodeCertificate) AND AuthenticodeCertificate IS NOT NULL”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\PortalInfo_del_PolicyPv]
“Active”=dword:00000001
“Table”=”PortalInfo”
“Action”=”Delete”
“Target Service”=”Policy Provider”
“File Extension”=”SRC”
“Key Name”=”ServerName, SiteCode”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\PortalInfo_upd_PolicyPv]
“Active”=dword:00000001
“Table”=”PortalInfo”
“Action”=”Update”
“Target Service”=”Policy Provider”
“File Extension”=”CAT”
“Key Name”=”ServerName, SiteCode”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\PreEnrollmentRecords_Event]
“Active”=dword:00000001
“Table”=”EN_EnrollmentRecords”
“Action”=”Insert, Update”
“Target Service”=”Enrollment Active Directory Service Inbox”
“File Extension”=”AD”
“Key Name”=”DeviceName”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\PreEnrollmentRecords_Upd_AMT]
“Active”=dword:00000001
“Table”=”EN_EnrollmentRecords”
“Action”=”Update”
“Target Service”=”SMS_AMT_PROXY_COMPONENT”
“File Extension”=”ENR”
“Key Name”=”DeviceName”
“Filter”=”ClientType = 1 and StateId = 1”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\ProgramOffers_G_Avail_iu]
“Active”=dword:00000001
“Table”=”ProgramOffers_G”
“Action”=”Insert, Update”
“Target Service”=”Object Replication Manager”
“File Extension”=”OAN”
“Key Name”=”OfferID”
“Filter”=”dbo.fnIsPrimary()=1 AND OfferTypeID = 2 AND ISNULL(MinRequiredVersion, 0) <= dbo.fnCurrentSiteVersion_INT()”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\PullDPResponse_UpdIns]
“Active”=dword:00000001
“Table”=”PullDPResponse”
“Action”=”Insert,Update”
“Target Service”=”Distribution Manager (Incoming)”
“File Extension”=”PUL”
“Key Name”=”PkgStatusID”
“Filter”=” exists (select 1 from inserted join PkgStatus_G on inserted.PkgStatusID = PkgStatus_G.PKID and PkgStatus_G.SiteCode=’PRI’)”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\RAXSubNotify_iud]
“Active”=dword:00000001
“Table”=”RAXSubscriptions”
“Action”=”Insert, Update, Delete”
“Target Service”=”Object Replication Manager”
“File Extension”=”ROA”
“Key Name”=”ID”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\RBAC_Admins_ins_del_SMSProv]
“Active”=dword:00000001
“Table”=”RBAC_Admins”
“Action”=”insert,delete”
“Target Service”=”SMS Provider”
“File Extension”=””
“Key Name”=”AdminID”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\Rbac_Sync_ChangeNotification]
“Active”=dword:00000001
“Table”=”RBAC_ChangeNotification”
“Action”=”Insert”
“Target Service”=”Hierarchy Manager”
“File Extension”=”RBC”
“Key Name”=”ID”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\RCM_DrsInitializationTracking_RCM]
“Active”=dword:00000001
“Table”=”RCM_DrsInitializationTracking”
“Action”=”Insert, Delete”
“Target Service”=”Replication Configuration And Monitoring Inbox”
“File Extension”=”RCM”
“Key Name”=”ReplicationGroup”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\RecoveryInfo_UPD_HMAN]
“Active”=dword:00000001
“Table”=”ServerData”
“Action”=”Update”
“Target Service”=”Hierarchy Manager”
“File Extension”=”RIU”
“Key Name”=”SiteCode”
“Filter”=”SiteCode != dbo.fnGetSiteCode() AND UPDATE(RecoveryCount) AND EXISTS (SELECT * FROM DELETED D WHERE ISNULL(D.RecoveryCount,0)+1 = ISNULL(INSERTED.RecoveryCount,0))”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\ReplicationData_RCM]
“Active”=dword:00000001
“Table”=”ReplicationData”
“Action”=”Insert, Update, Delete”
“Target Service”=”Replication Configuration And Monitoring Inbox”
“File Extension”=”RCM”
“Key Name”=”ID”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\Rules_iud]
“Active”=dword:00000001
“Table”=”Rules”
“Action”=”Insert, Update, Delete”
“Target Service”=”Rule Engine”
“File Extension”=”RUL”
“Key Name”=”RuleID”
“Filter”=”RuleEnabled = 1”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\SCCMAutoUpdates_RAU]
“Active”=dword:00000001
“Table”=”SCCMAutoUpdates”
“Action”=”Insert, Update”
“Target Service”=”Replication Configuration And Monitoring Inbox”
“File Extension”=”RAU”
“Key Name”=”ID”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\SC_SysResUse_Property_CloudMgr_MPCert_InsUpd]
“Active”=dword:00000001
“Table”=”SC_SysResUse_Property”
“Action”=”Insert, Update”
“Target Service”=”Cloud Services Manager Inbox”
“File Extension”=”MPCERT”
“Key Name”=”SysResUseID”
“Filter”=”Name=’SerializedCertificate’ AND SysResUseID IN (SELECT SysResUseID FROM SC_SysResUse SRU JOIN SC_RoleType RT on SRU.RoleTypeID=RT.RoleTypeID WHERE RT.RoleName = ‘SMS Management Point’)”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\SC_SysResUse_Site_Server_Site_System_Property_Upd]
“Active”=dword:00000001
“Table”=”SC_SysResUse_Property”
“Action”=”Update”
“Target Service”=”Cloud Services Manager Inbox”
“File Extension”=”PROXY”
“Key Name”=”SysResUseID”
“Filter”=”Name in (‘UseProxy’,’ProxyName’,’ProxyServerPort’,’AnonymousProxyAccess’,’ProxyUserName’) AND SysResUseID IN (SELECT SysResUseID from SC_SysResUse SYS join SC_RoleType RT on RT.RoleTypeID = SYS.RoleTypeID join SC_SiteDefinition SD on SD.SiteNumber = sys.SiteNumber where SD.SiteCode = dbo.fnGetSiteCode() and RT.RoleName = ‘SMS Site System’)”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\ServerData_RCM]
“Active”=dword:00000001
“Table”=”ServerData”
“Action”=”Insert, Update, Delete”
“Target Service”=”Replication Configuration And Monitoring Inbox”
“File Extension”=”RCM”
“Key Name”=”ID”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\ServerData_Upd_SiteCtrl]
“Active”=dword:00000001
“Table”=”ServerData”
“Action”=”Update”
“Target Service”=”Site Control Manager (Master Site Control File)”
“File Extension”=”CT0”
“Key Name”=”SiteCode”
“Filter”=”SiteCode = N’PRI’ AND SiteStatus = 125 AND EXISTS (SELECT * FROM DELETED D WHERE D.ID = INSERTED.ID AND D.SiteStatus != 125) AND NOT EXISTS (SELECT * FROM TableChangeNotifications WHERE Component=N’ServerData_Upd_SiteCtrl’ AND Key1=N’PRI’)”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\SiteControl_Address_Scheduler]
“Active”=dword:00000001
“Table”=”SC_Address”
“Action”=”Insert, Update, Delete”
“Target Service”=”Scheduler”
“File Extension”=”SCA”
“Key Name”=”ID”
“Filter”=”DestType=0 AND dbo.fnIsCas() = 0 AND dbo.fnGetPrimarySiteCode( dbo.fnGetSiteCodeBySiteNumber(SiteNumber) ) = dbo.fnGetPrimarySiteCode( dbo.fnGetSiteCode() )”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\SiteControl_AddUpd_HMAN]
“Active”=dword:00000001
“Table”=”SiteControl”
“Action”=”Insert, Update”
“Target Service”=”Hierarchy Manager”
“File Extension”=”SCU”
“Key Name”=”SiteCode”
“Filter”=”not exists (select 1 from ServerData S JOIN SC_SiteDefinition SC ON SC.SiteNumber = S.ID WHERE SC.SiteCode = INSERTED.SiteCode AND S.SiteStatus = 120) and not exists (select 1 from TableChangeNotifications where Component=N’SiteControl_AddUpd_HMAN’ and Key1=inserted.SiteCode)”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\SiteControl_AddUpd_SiteCtrl]
“Active”=dword:00000001
“Table”=”SiteControl”
“Action”=”Update”
“Target Service”=”Site Control Manager (Master Site Control File)”
“File Extension”=”CT0”
“Key Name”=”SiteCode”
“Filter”=”SiteCode = N’PRI’ and exists (select 1 from ServerData S JOIN SC_SiteDefinition SC ON SC.SiteNumber = S.ID where SC.SiteCode = N’PRI’ AND S.SiteStatus in (125, 110)) and not exists (select 1 from TableChangeNotifications where Component=N’SiteControl_AddUpd_SiteCtrl’ and Key1=N’PRI’)”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\SiteControl_CAS_Upd_SiteComp]
“Active”=dword:00000001
“Table”=”SiteControl”
“Action”=”update”
“Target Service”=”Site Component Manager”
“File Extension”=”CAS”
“Key Name”=”SiteCode”
“Filter”=”dbo.fnIsCasOrStandalonePrimary()=0 and inserted.SiteCode=dbo.fnGetParentSiteCode()”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\SiteCtrlNot_Add_DDM]
“Active”=dword:00000001
“Table”=”SiteControlNotification”
“Action”=”Insert, Update”
“Target Service”=”Discovery Data Manager (Notification)”
“File Extension”=”SCA”
“Key Name”=”SiteCode”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\SiteCtrlNot_Del_DDM]
“Active”=dword:00000001
“Table”=”SiteControlNotification”
“Action”=”Delete”
“Target Service”=”Discovery Data Manager (Notification)”
“File Extension”=”SCD”
“Key Name”=”SiteCode”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\SiteDefinition_DEL_HMAN]
“Active”=dword:00000001
“Table”=”SC_SiteDefinition”
“Action”=”Delete”
“Target Service”=”Hierarchy Manager (Forwarding messages)”
“File Extension”=”SDD”
“Key Name”=”SiteCode”
“Filter”=”dbo.fnIsSecondary() = 0 AND DELETED.SiteNumber != dbo.fnGetSiteNumber() AND DELETED.SiteType != 1”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\SiteDefinition_INS_HMAN]
“Active”=dword:00000001
“Table”=”SC_SiteDefinition”
“Action”=”Insert”
“Target Service”=”Hierarchy Manager (Forwarding messages)”
“File Extension”=”SAT”
“Key Name”=”SiteCode”
“Filter”=”dbo.fnIsSecondary() = 0 AND INSERTED.SiteNumber != dbo.fnGetSiteNumber() AND INSERTED.SiteType != 1”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\SiteExpansion_INS_HMAN]
“Active”=dword:00000001
“Table”=”sc_sitedefinition_property”
“Action”=”Insert”
“Target Service”=”Hierarchy Manager”
“File Extension”=”EXP”
“Key Name”=”SiteNumber”
“Filter”=”dbo.fnIsPrimary() = 1 AND INSERTED.Name = ‘SiteExpansion’ AND INSERTED.Value3 = 1 AND INSERTED.SiteNumber = 0”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\SiteKey_ADDUPD_HMAN]
“Active”=dword:00000001
“Table”=”SC_SiteDefinition”
“Action”=”Insert, Update”
“Target Service”=”Hierarchy Manager”
“File Extension”=”SPK”
“Key Name”=”SiteCode”
“Filter”=”SiteCode != N’ ‘ AND NOT EXISTS(SELECT * FROM DELETED D WHERE D.SiteNumber = INSERTED.SiteNumber AND D.ServiceExchangeKey = INSERTED.ServiceExchangeKey) AND dbo.fnIsParentOrChildSite(SiteNumber) != 0”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\SiteNotif_AIKbMgr]
“Active”=dword:00000001
“Table”=”SiteNotification”
“Action”=”Insert, Update”
“Target Service”=”Asset Intelligence KB Manager”
“File Extension”=”SHA”
“Key Name”=”SiteCode”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\SiteNotif_iu_WCM]
“Active”=dword:00000001
“Table”=”Sites”
“Action”=”Insert, Update”
“Target Service”=”WSUS Configuration Manager”
“File Extension”=”SHA”
“Key Name”=”SiteCode”
“Filter”=”(ReportToSite = ‘PRI’) and BuildNumber > 5200 and DetailedStatus IN (125, 110) AND SiteCode != ‘ ‘”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\SiteNotif_Upd_DDM]
“Active”=dword:00000001
“Table”=”SiteNotification”
“Action”=”Update”
“Target Service”=”Discovery Data Manager”
“File Extension”=”SHA”
“Key Name”=”SiteCode”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\SiteNotif_Upd_OfferMgr]
“Active”=dword:00000001
“Table”=”SiteNotification”
“Action”=”Update”
“Target Service”=”Offer Manager”
“File Extension”=”SHA”
“Key Name”=”SiteCode”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\SiteNotif_WSyncMgr]
“Active”=dword:00000001
“Table”=”SiteNotification”
“Action”=”Insert, Update”
“Target Service”=”WSUS Sync Manager”
“File Extension”=”SHA”
“Key Name”=”SiteCode”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\SiteReassign_Upd_HMAN_SR1]
“Active”=dword:00000001
“Table”=”DeviceSiteReassignment”
“Action”=”Update”
“Target Service”=”Hierarchy Manager (Site Reassign)”
“File Extension”=”SR1”
“Key Name”=”SiteCode”
“Filter”=”NOT EXISTS(SELECT * FROM TableChangeNotifications WHERE Component = N’SiteReassign_Upd_HMAN_SR1′ AND Key1 = ISNULL(SiteCode, N”)) AND EXISTS (SELECT * FROM DELETED WHERE Flag = 0) AND INSERTED.Flag = 1 AND INSERTED.SiteCode = dbo.fnGetSiteCode()”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\SiteReassign_Upd_HMAN_SR2]
“Active”=dword:00000001
“Table”=”DeviceSiteReassignment”
“Action”=”Update”
“Target Service”=”Hierarchy Manager (Site Reassign)”
“File Extension”=”SR2”
“Key Name”=”SiteCode”
“Filter”=”NOT EXISTS(SELECT * FROM TableChangeNotifications WHERE Component = N’SiteReassign_Upd_HMAN_SR2′ AND Key1 = ISNULL(SiteCode, N”)) AND EXISTS (SELECT * FROM DELETED WHERE Flag != 2) AND INSERTED.Flag = 2 AND INSERTED.MachineID BETWEEN dbo.fnGetSiteRangeStart() AND dbo.fnGetSiteRangeEnd()”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\SiteReassign_Upd_HMAN_SR5]
“Active”=dword:00000001
“Table”=”DeviceSiteReassignment”
“Action”=”Update”
“Target Service”=”Hierarchy Manager (Site Reassign)”
“File Extension”=”SR5”
“Key Name”=”SiteCode”
“Filter”=”NOT EXISTS(SELECT * FROM TableChangeNotifications WHERE Component = N’SiteReassign_Upd_HMAN_SR5′ AND Key1 = ISNULL(SiteCode, N”)) AND EXISTS (SELECT * FROM DELETED WHERE Flag != 5) AND INSERTED.Flag = 5 AND INSERTED.MachineID BETWEEN dbo.fnGetSiteRangeStart() AND dbo.fnGetSiteRangeEnd()”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\SiteServerUpdate_AddUpd_HMAN]
“Active”=dword:00000001
“Table”=”SC_SysResUse”
“Action”=”Insert, Update”
“Target Service”=”Hierarchy Manager”
“File Extension”=”SSC”
“Key Name”=”SiteNumber”
“Filter”=”RoleTypeID IN (SELECT RoleTypeID FROM SC_RoleType WHERE RoleName = ‘SMS Site Server’) AND UPDATE(NALPath) AND SiteNumber = dbo.fnGetSiteNumber()”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\SiteSQLCert_ADDUPD_HMAN]
“Active”=dword:00000001
“Table”=”SC_SiteDefinition_Property”
“Action”=”Insert, Update”
“Target Service”=”Hierarchy Manager”
“File Extension”=”CEU”
“Key Name”=”SiteNumber”
“Filter”=”Name = ‘SQLServerCertificate’ AND UPDATE(Value2) AND (dbo.fnIsParentOrChildSite(SiteNumber) != 0 OR SiteNumber = dbo.fnGetSiteNumber())”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\SiteSQLService_Restart_HMAN]
“Active”=dword:00000001
“Table”=”SC_SiteDefinition”
“Action”=”Update”
“Target Service”=”Hierarchy Manager”
“File Extension”=”SQR”
“Key Name”=”SiteNumber”
“Filter”=”1 = 0”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\SiteStatus_UPD_HMAN]
“Active”=dword:00000001
“Table”=”ServerData”
“Action”=”Update”
“Target Service”=”Hierarchy Manager”
“File Extension”=”IPK”
“Key Name”=”SiteCode”
“Filter”=”SiteStatus = 125 AND EXISTS (SELECT * FROM DELETED D WHERE D.ID = INSERTED.ID AND D.SiteStatus != 125) AND EXISTS (SELECT * FROM SMSData WHERE ThisSiteCode = INSERTED.SiteCode) “

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\SiteSystemNotification_iu_CertMgr]
“Active”=dword:00000001
“Table”=”SiteSystemNotification”
“Action”=”Insert, Update”
“Target Service”=”Certificate Manager”
“File Extension”=”CMN”
“Key Name”=”RoleTypeID,SiteSystemName”
“Filter”=”SiteSystemName NOT IN (SELECT sc.ServerName FROM vSMS_SC_SysResUse sc WHERE sc.NALResType=’Windows Azure’)”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\Sites_AddUpd_HMAN]
“Active”=dword:00000001
“Table”=”Sites”
“Action”=”Insert, Update”
“Target Service”=”Hierarchy Manager”
“File Extension”=”SSU”
“Key Name”=”SiteCode”
“Filter”=”SiteCode != N’ ‘ AND ((EXISTS (SELECT * FROM Sites S JOIN SMSData D ON S.SiteCode = D.ThisSiteCode AND S.DetailedStatus = 125) AND DetailedStatus = 125) OR SiteType = 1)”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\Sites_Del_HMAN]
“Active”=dword:00000001
“Table”=”Sites”
“Action”=”Delete”
“Target Service”=”Hierarchy Manager”
“File Extension”=”SSD”
“Key Name”=”SiteCode”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\Sites_Interop_Update_HMAN]
“Active”=dword:00000001
“Table”=”Sites”
“Action”=”Update”
“Target Service”=”Hierarchy Manager”
“File Extension”=”ITC”
“Key Name”=”SiteCode”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\SMSDBMON_RunNow]
“Active”=dword:00000001
“Table”=”SQLTaskStatus”
“Action”=”Update”
“Target Service”=””
“File Extension”=””
“Key Name”=”TaskName,TaskType”
“Filter”=”RunNow=1”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\SMSPackages_G_Avail_iu]
“Active”=dword:00000001
“Table”=”SMSPackages_G”
“Action”=”Insert, Update”
“Target Service”=”Object Replication Manager”
“File Extension”=”PAN”
“Key Name”=”PkgID”
“Filter”=”dbo.fnIsPrimary()=1 AND PackageType = 0”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\SMS_Advertisement_del_SMSProv]
“Active”=dword:00000001
“Table”=”ProgramOffers_L”
“Action”=”delete”
“Target Service”=”SMS Provider”
“File Extension”=””
“Key Name”=”OfferID”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\SMS_Advertisement_ins_upd_SMSProv]
“Active”=dword:00000001
“Table”=”ProgramOffers_L”
“Action”=”insert,update”
“Target Service”=”SMS Provider”
“File Extension”=””
“Key Name”=”OfferID”
“Filter”=”inserted.Action!=0 and inserted.Action!=3”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\SMS_Alert_ins_upd_SMSProv]
“Active”=dword:00000001
“Table”=”Alert”
“Action”=”insert,update”
“Target Service”=”SMS Provider”
“File Extension”=””
“Key Name”=”AlertID”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\SMS_Alert_upd_SMSProv_AlertForTrigger]
“Active”=dword:00000001
“Table”=”AlertForTrigger”
“Action”=”update”
“Target Service”=”SMS Provider”
“File Extension”=””
“Key Name”=”AlertID”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\SMS_Collection_del_SMSProv]
“Active”=dword:00000001
“Table”=”Collections_G”
“Action”=”delete”
“Target Service”=”SMS Provider”
“File Extension”=””
“Key Name”=”SiteID”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\SMS_Collection_ins_upd_SMSProv]
“Active”=dword:00000001
“Table”=”Collection_Maint”
“Action”=”insert,update”
“Target Service”=”SMS Provider”
“File Extension”=””
“Key Name”=”CollectionID”
“Filter”=”inserted.CStatus!=0”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\SMS_Package_del_SMSProv]
“Active”=dword:00000001
“Table”=”SMSPackages_G”
“Action”=”delete”
“Target Service”=”SMS Provider”
“File Extension”=””
“Key Name”=”PkgID”
“Filter”=”PackageType=0”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\SMS_Package_ins_upd_SMSProv]
“Active”=dword:00000001
“Table”=”SMSPackages_G”
“Action”=”insert,update”
“Target Service”=”SMS Provider”
“File Extension”=””
“Key Name”=”PkgID”
“Filter”=”inserted.PackageType=0 and inserted.Action!=0 and inserted.Action!=3”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\SqlControlProperty_RCM]
“Active”=dword:00000001
“Table”=”RcmSqlControlProperty”
“Action”=”Insert, Update”
“Target Service”=”Replication Configuration And Monitoring Inbox”
“File Extension”=”RSC”
“Key Name”=”ID”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\SQLServerSSBPORT_UPD_HMAN]
“Active”=dword:00000001
“Table”=”SC_SiteDefinition_Property”
“Action”=”Update”
“Target Service”=”Hierarchy Manager”
“File Extension”=”SBP”
“Key Name”=”SiteNumber”
“Filter”=”Name = ‘SSBPort’ AND UPDATE(Value3) AND (dbo.fnIsParentOrChildSite(SiteNumber) != 0 OR SiteNumber = dbo.fnGetSiteNumber())”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\SR_SingleSummaryRequest_ins_upd]
“Active”=dword:00000001
“Table”=”SR_SingleSummaryRequest”
“Action”=”Insert, Update”
“Target Service”=”State System”
“File Extension”=”SSR”
“Key Name”=”RequestID”
“Filter”=”SiteCode=dbo.fnGetSiteCode()”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\SR_SummaryTasks_upd]
“Active”=dword:00000001
“Table”=”SR_SummaryTasks_L”
“Action”=”Update”
“Target Service”=”State System”
“File Extension”=”RUN”
“Key Name”=”TaskID”
“Filter”=”RunNow=1”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\SubNotify_d_WCM]
“Active”=dword:00000001
“Table”=”CI_UpdateCategorySubscription”
“Action”=”Delete”
“Target Service”=”WSUS Configuration Manager”
“File Extension”=”CSB”
“Key Name”=”CategoryInstanceID”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\SubNotify_iu_WCM]
“Active”=dword:00000001
“Table”=”CI_UpdateCategorySubscription”
“Action”=”Insert, Update”
“Target Service”=”WSUS Configuration Manager”
“File Extension”=”CSB”
“Key Name”=”CategoryInstanceID”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\SyncNotif_WSyncMgr]
“Active”=dword:00000001
“Table”=”Update_SyncStatus”
“Action”=”Insert, Update”
“Target Service”=”WSUS Sync Manager”
“File Extension”=”SYN”
“Key Name”=”SyncNow”
“Filter”=”SiteCode=dbo.fnGetSiteCode() and SyncNow in (‘SELF’, ‘FULL’)”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\SysResList_CloudMgr_del]
“Active”=dword:00000001
“Table”=”SysResList”
“Action”=”Delete”
“Target Service”=”Cloud Services Manager Inbox”
“File Extension”=”MPDEL”
“Key Name”=”ServerName”
“Filter”=”exists(SELECT 1 FROM deleted WHERE RoleName = ‘SMS Management Point’)”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\SysResUse_Property_AddUpd_HMAN_SRS]
“Active”=dword:00000001
“Table”=”SC_SysResUse_Property”
“Action”=”Insert,Update”
“Target Service”=”Hierarchy Manager”
“File Extension”=”RUC”
“Key Name”=”ID”
“Filter”=”Name = N’Username’ AND SiteNumber = 0 AND SysResUseID IN (SELECT SysResUseID FROM SC_SysResUse WHERE RoleTypeID = 17)”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\System_SMS_Assign_ARR_Insert]
“Active”=dword:00000001
“Table”=”System_SMS_Assign_ARR”
“Action”=”Insert”
“Target Service”=”Client Configuration Record (Incoming)”
“File Extension”=”CPC”
“Key Name”=”SMS_Assigned_Sites0”
“Filter”=”dbo.fnGetPrimarySiteCode(SMS_Assigned_Sites0)=N’PRI’ and dbo.FnIsClientPushActive(SMS_Assigned_Sites0)=1 and not exists (select 1 from TableChangeNotifications where Component=N’System_SMS_Assign_ARR_Insert’ and Key1=inserted.SMS_Assigned_Sites0)”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\TestConnection_TST]
“Active”=dword:00000001
“Table”=”AlertEmailTestConnection”
“Action”=”Insert”
“Target Service”=”Alert Notification Inbox”
“File Extension”=”TST”
“Key Name”=”TestID”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\UEP_ADD_Upd]
“Active”=dword:00000001
“Table”=”UEP_UserExtendedProperties”
“Action”=”Insert, Update, NonZeroByteFile”
“Target Service”=”Policy Provider”
“File Extension”=”UEP”
“Key Name”=”UserID”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\UnknownToKnownSystem_Upd]
“Active”=dword:00000001
“Table”=”System_DISC”
“Action”=”Update, NonZeroByteFile”
“Target Service”=”Policy Provider”
“File Extension”=”UKS”
“Key Name”=”ItemKey”
“Filter”=”Client0 = 1 and inserted.ItemKey in (select ItemKey from deleted where ISNULL(deleted.Client0, 0) = 0) AND (ISNULL(Decommissioned0, 0) = 0) AND (ISNULL(Obsolete0, 0) = 0) AND dbo.fnGetSiteRangeStart() < ItemKey AND ItemKey < dbo.fnGetSiteRangeEnd()”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\UpdSrcNotify_iud]
“Active”=dword:00000001
“Table”=”CI_UpdateSources”
“Action”=”Insert, Update”
“Target Service”=”Object Replication Manager”
“File Extension”=”SCN”
“Key Name”=”UpdateSource_ID”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\UpdSyncStatus_iu]
“Active”=dword:00000001
“Table”=”Update_SyncStatus”
“Action”=”Insert, Update, NonZeroByteFile”
“Target Service”=”Policy Provider”
“File Extension”=”STN”
“Key Name”=”UpdateSource_UniqueID”
“Filter”=”SiteCode = ‘PRI'”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\UserMachineRelation_Chg]
“Active”=dword:00000001
“Table”=”UserMachineRelation”
“Action”=”Insert, Update, Delete, NonZeroByteFile”
“Target Service”=”Policy Provider”
“File Extension”=”UDA”
“Key Name”=”RelationshipResourceID”
“Filter”=”dbo.fnGetSiteRangeStart() < MachineResourceID AND MachineResourceID < dbo.fnGetSiteRangeEnd()”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\UserMachineSourceRelation_Chg]
“Active”=dword:00000001
“Table”=”UserMachineSourceRelation”
“Action”=”Insert, Update, Delete, NonZeroByteFile”
“Target Service”=”Policy Provider”
“File Extension”=”UDA”
“Key Name”=”RelationshipResourceID”
“Filter”=”RelationshipResourceID in (select umr.RelationshipResourceID from UserMachineRelation umr where dbo.fnGetSiteRangeStart() < umr.MachineResourceID AND umr.MachineResourceID < dbo.fnGetSiteRangeEnd())”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\UserMachineTypeRelation_Chg]
“Active”=dword:00000001
“Table”=”UserMachineTypeRelation”
“Action”=”Insert, Update, Delete, NonZeroByteFile”
“Target Service”=”Policy Provider”
“File Extension”=”UDA”
“Key Name”=”RelationshipResourceID”
“Filter”=”RelationshipResourceID in (select umr.RelationshipResourceID from UserMachineRelation umr where dbo.fnGetSiteRangeStart() < umr.MachineResourceID AND umr.MachineResourceID < dbo.fnGetSiteRangeEnd())”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\ViewData_RCM]
“Active”=dword:00000001
“Table”=”ViewData”
“Action”=”Insert, Update, Delete”
“Target Service”=”Replication Configuration And Monitoring Inbox”
“File Extension”=”RCM”
“Key Name”=”ID”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\WebServiceInfoChg_upd_PolicyPv]
“Active”=dword:00000001
“Table”=”WebServiceInfo”
“Action”=”Insert, Update, Delete”
“Target Service”=”Policy Provider”
“File Extension”=”WRC”
“Key Name”=”ServerName, SiteCode”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\PRI\WOLMgr_WOLScheduleMap_iu]
“Active”=dword:00000001
“Table”=”WOLScheduleMap”
“Action”=”Insert, Update”
“Target Service”=”SMS_WAKEONLAN_MANAGER”
“File Extension”=”WLN”
“Key Name”=”ScheduleMapID”
“Filter”=””

 SCCM 2012 CAS server Registry Keys

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\CAS]
“Polling Directory”=””
“SMS Primary Site”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\CAS\ActiveDirectoryForests_HMAN]
“Active”=dword:00000001
“Table”=”ActiveDirectoryForests”
“Action”=”Insert, Update”
“Target Service”=”Hierarchy Manager”
“File Extension”=”TRG”
“Key Name”=”ForestID”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\CAS\ActiveDirectoryForests_SITECOMP]
“Active”=dword:00000001
“Table”=”ActiveDirectoryForests”
“Action”=”Insert, Update”
“Target Service”=”Site Component Manager”
“File Extension”=”TRG”
“Key Name”=”ForestID”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\CAS\AlertForTrigger_ALE]
“Active”=dword:00000001
“Table”=”AlertForTrigger”
“Action”=”Insert, Update”
“Target Service”=”Alert Notification Inbox”
“File Extension”=”ALE”
“Key Name”=”AlertID”
“Filter”=” exists (select 1 from inserted left join deleted on inserted.AlertID = deleted.AlertID where (ISNULL(inserted.AlertState, ‘-‘) <> ISNULL(deleted.AlertState, ‘-‘)) AND ISNULL(inserted.AlertState, ‘-‘) = ‘A’)”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\CAS\Alert_ALT]
“Active”=dword:00000001
“Table”=”Alert”
“Action”=”Insert, Update”
“Target Service”=”Alert Notification Inbox”
“File Extension”=”ALT”
“Key Name”=”AlertID”
“Filter”=” exists (select 1 from inserted left join deleted on inserted.AlertID = deleted.AlertID where (inserted.Enabled <> deleted.Enabled AND inserted.Enabled = 1) OR (inserted.SkipUntil <> deleted.SkipUntil))”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\CAS\ArticleData_RCM]
“Active”=dword:00000001
“Table”=”ArticleData”
“Action”=”Insert, Update, Delete”
“Target Service”=”Replication Configuration And Monitoring Inbox”
“File Extension”=”RCM”
“Key Name”=”ArticleName”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\CAS\AutoClientUpgradeConfigs_UPD_HMAN]
“Active”=dword:00000001
“Table”=”AutoClientUpgradeConfigs”
“Action”=”Update”
“Target Service”=”Hierarchy Manager”
“File Extension”=”AUC”
“Key Name”=”ClientVersion”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\CAS\BoundaryEx_Event]
“Active”=dword:00000001
“Table”=”BoundaryEx”
“Action”=”Update”
“Target Service”=”Discovery Data Manager (Notification)”
“File Extension”=”BND”
“Key Name”=”BoundaryID”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\CAS\BoundaryEx_HMAN]
“Active”=dword:00000001
“Table”=”BoundaryEx”
“Action”=”Update”
“Target Service”=”Hierarchy Manager”
“File Extension”=”TRG”
“Key Name”=”BoundaryID”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\CAS\BoundaryGroupMembers_Event]
“Active”=dword:00000001
“Table”=”BoundaryGroupMembers”
“Action”=”Insert, Update, Delete”
“Target Service”=”Discovery Data Manager (Notification)”
“File Extension”=”BND”
“Key Name”=”BoundaryID,GroupID”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\CAS\BoundaryGroupMembers_HMAN]
“Active”=dword:00000001
“Table”=”BoundaryGroupMembers”
“Action”=”Insert,Update,Delete”
“Target Service”=”Hierarchy Manager”
“File Extension”=”TRG”
“Key Name”=”BoundaryID”
“Filter”=”GroupID in (select GroupID from BoundaryGroup where DefaultSiteCode in (select SiteCode from Sites where SiteCode=dbo.fnGetSiteCode() or ReportToSite=dbo.fnGetSiteCode()))”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\CAS\BoundaryGroup_Event]
“Active”=dword:00000001
“Table”=”BoundaryGroup”
“Action”=”Update”
“Target Service”=”Discovery Data Manager (Notification)”
“File Extension”=”BND”
“Key Name”=”GroupID”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\CAS\BoundaryGroup_HMAN]
“Active”=dword:00000001
“Table”=”BoundaryGroup”
“Action”=”Update”
“Target Service”=”Hierarchy Manager”
“File Extension”=”TRG”
“Key Name”=”GroupID”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\CAS\CategoryNotify_iud]
“Active”=dword:00000001
“Table”=”CI_CategoryInstances”
“Action”=”Insert, Update”
“Target Service”=”Object Replication Manager”
“File Extension”=”CTN”
“Key Name”=”CategoryInstanceID”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\CAS\CFDGo_INS_UPD_HMAN]
“Active”=dword:00000001
“Table”=”CFDGo”
“Action”=”Insert,Update”
“Target Service”=”Hierarchy Manager (CFD)”
“File Extension”=”CFE”
“Key Name”=”FeatureID”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\CAS\CIAssignmentNotify_iu]
“Active”=dword:00000001
“Table”=”CI_CIAssignments”
“Action”=”Insert, Update”
“Target Service”=”Object Replication Manager”
“File Extension”=”CIA”
“Key Name”=”AssignmentID”
“Filter”=”ISNULL(MinRequiredVersion, 0) <= dbo.fnCurrentSiteVersion_INT()”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\CAS\CINotify_iud]
“Active”=dword:00000001
“Table”=”CI_ConfigurationItems”
“Action”=”Insert, Update”
“Target Service”=”Object Replication Manager”
“File Extension”=”CIN”
“Key Name”=”CI_ID”
“Filter”=”ISNULL(MinRequiredVersion, 0) <= dbo.fnCurrentSiteVersion_INT()”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\CAS\CI_ApplicationModelInfo_CINotify]
“Active”=dword:00000001
“Table”=”CI_ApplicationModelInfo”
“Action”=”Update”
“Target Service”=”Object Replication Manager”
“File Extension”=”CIN”
“Key Name”=”CI_ID”
“Filter”=”EXISTS(SELECT 1 FROM CI_ConfigurationItems ci WHERE ci.CI_ID=inserted.CI_ID AND ISNULL(MinRequiredVersion, 0) <= dbo.fnCurrentSiteVersion_INT()) AND EXISTS(SELECT 1 FROM deleted d WHERE d.CI_ID=inserted.CI_ID AND d.Featured!=inserted.Featured)”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\CAS\CI_AssignmentTargetedCIs_CIAMGR]
“Active”=dword:00000001
“Table”=”CI_AssignmentTargetedCIs”
“Action”=”Insert, Update, Delete”
“Target Service”=”Object Replication Manager”
“File Extension”=”CIA”
“Key Name”=”AssignmentID”
“Filter”=”ActualCI_ID is not null”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\CAS\CI_ConfigurationItemRelations_Flat_From_iud]
“Active”=dword:00000001
“Table”=”CI_ConfigurationItemRelations_Flat”
“Action”=”Insert, Update, Delete”
“Target Service”=”Object Replication Manager”
“File Extension”=”CIN”
“Key Name”=”FromCI_ID”
“Filter”=”RelationType != 7”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\CAS\CI_ConfigurationItemRelations_FromVE_ToDT_iud]
“Active”=dword:00000000
“Table”=””
“Action”=””
“Target Service”=””
“File Extension”=””
“Key Name”=””
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\CAS\ClientAgentProperty_Value_iud]
“Active”=dword:00000001
“Table”=”ClientAgentProperty_Value”
“Action”=”Insert, Update, Delete”
“Target Service”=”Object Replication Manager”
“File Extension”=”GCS”
“Key Name”=”ClientSettingsID”
“Filter”=”dbo.fnIsCas()=0”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\CAS\ClientOperation_iu]
“Active”=dword:00000001
“Table”=”ClientOperation”
“Action”=”Insert, Update”
“Target Service”=”Object Replication Manager”
“File Extension”=”OPA”
“Key Name”=”ID”
“Filter”=”dbo.fnIsCas() = 0 AND State in (0, 1)”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\CAS\ClientSettingsAssignments_iu]
“Active”=dword:00000001
“Table”=”ClientSettingsAssignments”
“Action”=”Insert, Update”
“Target Service”=”Object Replication Manager”
“File Extension”=”GCA”
“Key Name”=”ID”
“Filter”=”dbo.fnIsCas()=0”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\CAS\ClientSettings_iud]
“Active”=dword:00000001
“Table”=”ClientSettings”
“Action”=”Insert, Update, Delete”
“Target Service”=”Object Replication Manager”
“File Extension”=”GCS”
“Key Name”=”ID”
“Filter”=”dbo.fnIsCas()=0”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\CAS\CloudSubscription_CSD]
“Active”=dword:00000001
“Table”=”CloudSubscription”
“Action”=”Delete”
“Target Service”=”Replication Configuration And Monitoring Inbox”
“File Extension”=”CSD”
“Key Name”=”UniqueID”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\CAS\CRP_CertRevoke]
“Active”=dword:00000001
“Table”=”CertRevocationNotify”
“Action”=”Insert”
“Target Service”=”Certificate Manager”
“File Extension”=”REC”
“Key Name”=”ID”
“Filter”=”Flag=0”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\CAS\CurrentSiteSQL_AddUpd_HMAN]
“Active”=dword:00000001
“Table”=”SC_SysResUse”
“Action”=”Insert, Update”
“Target Service”=”Hierarchy Manager”
“File Extension”=”LQU”
“Key Name”=”SiteNumber,dbo.fnGetSiteSystemName(NALPath)”
“Filter”=”SiteNumber=dbo.fnGetSiteNumber() AND RoleTypeID IN (SELECT RoleTypeID FROM SC_RoleType WHERE RoleName = ‘SMS SQL Server’) AND UPDATE(NALPath)”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\CAS\DataLdr_InventoryAction]
“Active”=dword:00000001
“Table”=”InventoryAction”
“Action”=”Insert, Update, Delete”
“Target Service”=”Client Data Files Source Directory”
“File Extension”=”ICP”
“Key Name”=”ActionID”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\CAS\DataLdr_InventoryClass]
“Active”=dword:00000001
“Table”=”InventoryClass”
“Action”=”Insert, Update, Delete, distinct”
“Target Service”=”Client Data Files Source Directory”
“File Extension”=”ICP”
“Key Name”=”ClassID”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\CAS\DataLdr_InventoryClassProperty]
“Active”=dword:00000001
“Table”=”InventoryClassProperty”
“Action”=”Insert, Update, Delete, distinct”
“Target Service”=”Client Data Files Source Directory”
“File Extension”=”ICP”
“Key Name”=”ClassID”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\CAS\DataLdr_RemoteInvSchema]
“Active”=dword:00000001
“Table”=”RemoteInvSchema”
“Action”=”Insert, Update, Delete, distinct”
“Target Service”=”Client Data Files Source Directory”
“File Extension”=”RIS”
“Key Name”=”SiteNumber”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\CAS\DeviceAction_iu_CertMgr]
“Active”=dword:00000001
“Table”=”MDMDeviceActions_L”
“Action”=”Insert, Update”
“Target Service”=”Certificate Manager”
“File Extension”=”MDA”
“Key Name”=”ResourceID”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\CAS\DeviceSettingItemNotify_iud]
“Active”=dword:00000001
“Table”=”DeviceSettingItems”
“Action”=”Insert, Update”
“Target Service”=”Object Replication Manager”
“File Extension”=”DSN”
“Key Name”=”DeviceSettingItemID”
“Filter”=”SourceSite = ‘CAS'”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\CAS\DiscPropertyDefs_Ins_DDM]
“Active”=dword:00000001
“Table”=”DiscPropertyDefs”
“Action”=”Insert”
“Target Service”=”Discovery Data Manager (Notification)”
“File Extension”=”CRV”
“Key Name”=”DiscArchKey”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\CAS\DiscProps_Add_SMSProv]
“Active”=dword:00000001
“Table”=”DiscPropertyDefs”
“Action”=”insert”
“Target Service”=”SMS Provider”
“File Extension”=””
“Key Name”=”DiscArchKey,PropertyName”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\CAS\DistributionJobOrder_Updated]
“Active”=dword:00000001
“Table”=”DistributionJobs”
“Action”=”Update”
“Target Service”=”SMS_PACKAGE_TRANSFER_MANAGER”
“File Extension”=”PKN”
“Key Name”=”PkgID”
“Filter”=”Update(DynamicOrder)”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\CAS\DistributionJob_Cancelled]
“Active”=dword:00000001
“Table”=”DistributionJobs”
“Action”=”Update”
“Target Service”=”SMS_PACKAGE_TRANSFER_MANAGER”
“File Extension”=”CAN”
“Key Name”=”JobID”
“Filter”=”(Action = 5) OR (UPDATE(State) and inserted.State = 8)”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\CAS\DistributionJob_Creation]
“Active”=dword:00000001
“Table”=”DistributionJobs”
“Action”=”Update”
“Target Service”=”SMS_PACKAGE_TRANSFER_MANAGER”
“File Extension”=”PKN”
“Key Name”=”PkgID”
“Filter”=”((State = 1) AND (restarttime is null))”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\CAS\DistributionPoints_Ins]
“Active”=dword:00000001
“Table”=”DistributionPoints”
“Action”=”Insert”
“Target Service”=”Distribution Manager”
“File Extension”=”INS”
“Key Name”=”DPID”
“Filter”=”SMSSiteCode =’CAS’ AND DPFlags <> 1”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\CAS\DistributionPoints_Upd]
“Active”=dword:00000001
“Table”=”DistributionPoints”
“Action”=”Update”
“Target Service”=”Distribution Manager”
“File Extension”=”INS”
“Key Name”=”DPID”
“Filter”=”SMSSiteCode =’CAS’ AND DPFlags <> 1 AND exists (select 1 from inserted join deleted on inserted.NALPath=deleted.NALPath where inserted.Action = 0 AND (deleted.Action = 3 OR inserted.SMSSiteCode<>deleted.SMSSiteCode))”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\CAS\DPNotify_ADD]
“Active”=dword:00000001
“Table”=”DPNotification”
“Action”=”Insert”
“Target Service”=”Distribution Manager”
“File Extension”=”DPN”
“Key Name”=”DPID”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\CAS\DPNotify_Upgrade]
“Active”=dword:00000001
“Table”=”DistributionPoints”
“Action”=”Insert, Update”
“Target Service”=”Distribution Manager”
“File Extension”=”DPU”
“Key Name”=”DPID”
“Filter”=”SMSSiteCode =’CAS’ AND ((exists (select 1 from inserted join deleted on inserted.NALPath=deleted.NALPath where (inserted.DPFlags=0x00004 AND deleted.DPFlags = 0) OR (inserted.DPFlags=0 AND deleted.DPFlags = 0x00004))) OR (exists(select 1 from inserted join DistributionPoints on DistributionPoints.ServerName=inserted.ServerName where DistributionPoints.DPFlags=1 and inserted.DPFlags<>1)) OR (exists(select 1 from inserted where DPFlags = 0x00004)))”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\CAS\DPNotify_Upgrade_Ins]
“Active”=dword:00000001
“Table”=”DistributionPoints”
“Action”=”Insert, Update”
“Target Service”=”Distribution Manager”
“File Extension”=”INS”
“Key Name”=”DPID”
“Filter”=”SMSSiteCode =’CAS’ AND (State<>1 OR State is NULL) AND (exists (select 1 from inserted join deleted on inserted.NALPath=deleted.NALPath where (inserted.DPFlags<>1 AND deleted.DPFlags = 1) OR (inserted.DPFlags=0x00004 AND deleted.DPFlags = 0) OR (inserted.DPFlags=0 AND deleted.DPFlags = 0x00004)))”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\CAS\DP_Properties_Upd]
“Active”=dword:00000001
“Table”=”DistributionPoints”
“Action”=”Update”
“Target Service”=”Distribution Manager”
“File Extension”=”NOT”
“Key Name”=”DPID”
“Filter”=”SMSSiteCode =’CAS’ AND (exists (select 1 from inserted join deleted on inserted.DPID=deleted.DPID where inserted.DPType<>deleted.DPType OR inserted.AnonymousEnabled<>deleted.AnonymousEnabled OR inserted.SslState<>deleted.SslState OR inserted.IsPXE<>deleted.IsPXE OR inserted.IsPullDP<>deleted.IsPullDP))”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\CAS\EULANotify_iud]
“Active”=dword:00000001
“Table”=”EULA_Content”
“Action”=”Insert, Update”
“Target Service”=”Object Replication Manager”
“File Extension”=”EUN”
“Key Name”=”EULAContentID”
“Filter”=”SourceSite = ‘CAS'”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\CAS\GroupMap_Add_SMSProv]
“Active”=dword:00000001
“Table”=”GroupMap_Notif”
“Action”=”insert,update,delete,distinct”
“Target Service”=”SMS Provider”
“File Extension”=””
“Key Name”=”GroupClass”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\CAS\InitPackageRequest_RCM]
“Active”=dword:00000001
“Table”=”RCM_InitPackageRequest”
“Action”=”Insert”
“Target Service”=”Replication Configuration And Monitoring Inbox”
“File Extension”=”RCM”
“Key Name”=”RequestTrackingGUID”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\CAS\InteropBlockList_AddDel_HMAN]
“Active”=dword:00000001
“Table”=”InteropBlockList”
“Action”=”Insert, Delete”
“Target Service”=”Hierarchy Manager”
“File Extension”=”ITO”
“Key Name”=”ID”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\CAS\MDMCFDFeature_UPD_HMAN]
“Active”=dword:00000001
“Table”=”MDMCFDFeature”
“Action”=”Update”
“Target Service”=”Hierarchy Manager (CFD)”
“File Extension”=”CFE”
“Key Name”=”FeatureID”
“Filter”=” Flag in (0, 1) “

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\CAS\MDMDeviceManagementStates_Local_INS_UPD_HMAN]
“Active”=dword:00000001
“Table”=”MDMDeviceManagementStates_Local”
“Action”=”Insert,Update”
“Target Service”=”Hierarchy Manager”
“File Extension”=”RSB”
“Key Name”=”DeviceID”
“Filter”=”WIPE IS NOT NULL OR RETIRE IS NOT NULL”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\CAS\MIG_Job_MIG]
“Active”=dword:00000001
“Table”=”MIG_Job”
“Action”=”Insert, Update”
“Target Service”=”Migration Manager Inbox”
“File Extension”=”MIG”
“Key Name”=”JobID”
“Filter”=” exists (select 1 from inserted left join deleted on inserted.JobID = deleted.JobID where (ISNULL(inserted.ScheduleToken, ”) <> ISNULL(deleted.ScheduleToken, ”)) or((ISNULL(inserted.Status, 0) <> ISNULL(deleted.Status, 0)) AND ISNULL(inserted.Status, 0) = 1) or(ISNULL(inserted.RequestedOperation, ”) <> ”))”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\CAS\MIG_SiteMapping_SYN]
“Active”=dword:00000001
“Table”=”MIG_SiteMapping”
“Action”=”Insert, Update”
“Target Service”=”Migration Manager Inbox”
“File Extension”=”SYN”
“Key Name”=”SiteMappingID”
“Filter”=” exists (select 1 from inserted left join deleted on inserted.SiteMappingID = deleted.SiteMappingID where (ISNULL(inserted.ScheduleToken, ”) <> ISNULL(deleted.ScheduleToken, ”)) or((ISNULL(inserted.Status, 0) <> ISNULL(deleted.Status, 0)) AND ISNULL(inserted.Status, 0) = 1) or(ISNULL(inserted.RequestedOperation, ”) <> ”))”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\CAS\MonitoringRole_UPD_HMAN]
“Active”=dword:00000001
“Table”=”CM_MonitoringRoles”
“Action”=”Update”
“Target Service”=”Hierarchy Manager”
“File Extension”=”MRU”
“Key Name”=”RoleID”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\CAS\NDESCertificates_iud_CRP]
“Active”=dword:00000001
“Table”=”SC_SysResUse_Property”
“Action”=”Insert, Update, delete”
“Target Service”=”Certificate Manager”
“File Extension”=”CRP”
“Key Name”=”SysResUseID”
“Filter”=” Name = ‘NDESCertificates’ AND SysResUseID IN (SELECT SysResUseID FROM SC_SysResUse WHERE RoleTypeID = 25)”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\CAS\OtherSiteSQL_AddUpd_HMAN]
“Active”=dword:00000001
“Table”=”SC_SysResUse”
“Action”=”Insert, Update”
“Target Service”=”Hierarchy Manager”
“File Extension”=”RQU”
“Key Name”=”SiteNumber,ID,dbo.fnGetSiteSystemName(NALPath)”
“Filter”=”dbo.fnIsParentOrChildSite(SiteNumber) != 0 AND RoleTypeID IN (SELECT RoleTypeID FROM SC_RoleType WHERE RoleName = ‘SMS SQL Server’) AND UPDATE(NALPath)”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\CAS\OtherSiteSQL_Del_HMAN]
“Active”=dword:00000001
“Table”=”SC_SysResUse_Property”
“Action”=”Delete”
“Target Service”=”Hierarchy Manager”
“File Extension”=”RQD”
“Key Name”=”Name,dbo.fnReplaceBackSlashWithEqualSign(Value2),dbo.fnGetSiteSystemNameFromID(SysResUseID)”
“Filter”=”dbo.fnIsParentOrChildSite(SiteNumber) != 0 AND Name IN (‘SQL Server Service Logon Account’, ‘SQL Server Agent Service Logon Account’)”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\CAS\PkgNotify_Add]
“Active”=dword:00000001
“Table”=”PkgNotification”
“Action”=”Insert”
“Target Service”=”Distribution Manager”
“File Extension”=”PKN”
“Key Name”=”PkgID”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\CAS\PkgPrograms_G_Avail_iu]
“Active”=dword:00000001
“Table”=”PkgPrograms_G”
“Action”=”Insert, Update”
“Target Service”=”Object Replication Manager”
“File Extension”=”PRN”
“Key Name”=”ProgramID”
“Filter”=”dbo.fnIsPrimary()=1 AND ProgramFlags & 0x00001100 = 0 and Command is not null and Command != N””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\CAS\PreEnrollmentRecords_Upd_AMT]
“Active”=dword:00000001
“Table”=”EN_EnrollmentRecords”
“Action”=”Update”
“Target Service”=”SMS_AMT_PROXY_COMPONENT”
“File Extension”=”ENR”
“Key Name”=”DeviceName”
“Filter”=”ClientType = 1 and StateId = 1”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\CAS\ProgramOffers_G_Avail_iu]
“Active”=dword:00000001
“Table”=”ProgramOffers_G”
“Action”=”Insert, Update”
“Target Service”=”Object Replication Manager”
“File Extension”=”OAN”
“Key Name”=”OfferID”
“Filter”=”dbo.fnIsPrimary()=1 AND OfferTypeID = 2 AND ISNULL(MinRequiredVersion, 0) <= dbo.fnCurrentSiteVersion_INT()”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\CAS\PullDPResponse_UpdIns]
“Active”=dword:00000001
“Table”=”PullDPResponse”
“Action”=”Insert,Update”
“Target Service”=”Distribution Manager (Incoming)”
“File Extension”=”PUL”
“Key Name”=”PkgStatusID”
“Filter”=” exists (select 1 from inserted join PkgStatus_G on inserted.PkgStatusID = PkgStatus_G.PKID and PkgStatus_G.SiteCode=’CAS’)”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\CAS\RAXSubNotify_iud]
“Active”=dword:00000001
“Table”=”RAXSubscriptions”
“Action”=”Insert, Update, Delete”
“Target Service”=”Object Replication Manager”
“File Extension”=”ROA”
“Key Name”=”ID”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\CAS\RBAC_Admins_ins_del_SMSProv]
“Active”=dword:00000001
“Table”=”RBAC_Admins”
“Action”=”insert,delete”
“Target Service”=”SMS Provider”
“File Extension”=””
“Key Name”=”AdminID”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\CAS\Rbac_Sync_ChangeNotification]
“Active”=dword:00000001
“Table”=”RBAC_ChangeNotification”
“Action”=”Insert”
“Target Service”=”Hierarchy Manager”
“File Extension”=”RBC”
“Key Name”=”ID”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\CAS\RCM_DrsInitializationTracking_RCM]
“Active”=dword:00000001
“Table”=”RCM_DrsInitializationTracking”
“Action”=”Insert, Delete”
“Target Service”=”Replication Configuration And Monitoring Inbox”
“File Extension”=”RCM”
“Key Name”=”ReplicationGroup”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\CAS\RecoveryInfo_UPD_HMAN]
“Active”=dword:00000001
“Table”=”ServerData”
“Action”=”Update”
“Target Service”=”Hierarchy Manager”
“File Extension”=”RIU”
“Key Name”=”SiteCode”
“Filter”=”SiteCode != dbo.fnGetSiteCode() AND UPDATE(RecoveryCount) AND EXISTS (SELECT * FROM DELETED D WHERE ISNULL(D.RecoveryCount,0)+1 = ISNULL(INSERTED.RecoveryCount,0))”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\CAS\ReplicationData_RCM]
“Active”=dword:00000001
“Table”=”ReplicationData”
“Action”=”Insert, Update, Delete”
“Target Service”=”Replication Configuration And Monitoring Inbox”
“File Extension”=”RCM”
“Key Name”=”ID”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\CAS\Rules_iud]
“Active”=dword:00000001
“Table”=”Rules”
“Action”=”Insert, Update, Delete”
“Target Service”=”Rule Engine”
“File Extension”=”RUL”
“Key Name”=”RuleID”
“Filter”=”RuleEnabled = 1”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\CAS\SCCMAutoUpdates_RAU]
“Active”=dword:00000001
“Table”=”SCCMAutoUpdates”
“Action”=”Insert, Update”
“Target Service”=”Replication Configuration And Monitoring Inbox”
“File Extension”=”RAU”
“Key Name”=”ID”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\CAS\ServerData_RCM]
“Active”=dword:00000001
“Table”=”ServerData”
“Action”=”Insert, Update, Delete”
“Target Service”=”Replication Configuration And Monitoring Inbox”
“File Extension”=”RCM”
“Key Name”=”ID”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\CAS\SiteControl_Address_Scheduler]
“Active”=dword:00000001
“Table”=”SC_Address”
“Action”=”Insert, Update, Delete”
“Target Service”=”Scheduler”
“File Extension”=”SCA”
“Key Name”=”ID”
“Filter”=”DestType=0 AND dbo.fnIsCas() = 0 AND dbo.fnGetPrimarySiteCode( dbo.fnGetSiteCodeBySiteNumber(SiteNumber) ) = dbo.fnGetPrimarySiteCode( dbo.fnGetSiteCode() )”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\CAS\SiteControl_AddUpd_HMAN]
“Active”=dword:00000001
“Table”=”SiteControl”
“Action”=”Insert, Update”
“Target Service”=”Hierarchy Manager”
“File Extension”=”SCU”
“Key Name”=”SiteCode”
“Filter”=”not exists (select 1 from ServerData S JOIN SC_SiteDefinition SC ON SC.SiteNumber = S.ID WHERE SC.SiteCode = INSERTED.SiteCode AND S.SiteStatus = 120) and not exists (select 1 from TableChangeNotifications where Component=N’SiteControl_AddUpd_HMAN’ and Key1=inserted.SiteCode)”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\CAS\SiteControl_AddUpd_SiteCtrl]
“Active”=dword:00000001
“Table”=”SiteControl”
“Action”=”Update”
“Target Service”=”Site Control Manager (Master Site Control File)”
“File Extension”=”CT0”
“Key Name”=”SiteCode”
“Filter”=”SiteCode = N’CAS’ AND EXISTS (SELECT 1 FROM SC_SiteDefinition WHERE SiteCode = N’CAS’) AND NOT EXISTS (SELECT 1 FROM TableChangeNotifications WHERE Component = N’SiteControl_AddUpd_SiteCtrl’ AND Key1 = N’CAS’)”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\CAS\SiteCtrlNot_Add_DDM]
“Active”=dword:00000001
“Table”=”SiteControlNotification”
“Action”=”Insert, Update”
“Target Service”=”Discovery Data Manager (Notification)”
“File Extension”=”SCA”
“Key Name”=”SiteCode”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\CAS\SiteCtrlNot_Del_DDM]
“Active”=dword:00000001
“Table”=”SiteControlNotification”
“Action”=”Delete”
“Target Service”=”Discovery Data Manager (Notification)”
“File Extension”=”SCD”
“Key Name”=”SiteCode”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\CAS\SiteDefinition_DEL_HMAN]
“Active”=dword:00000001
“Table”=”SC_SiteDefinition”
“Action”=”Delete”
“Target Service”=”Hierarchy Manager (Forwarding messages)”
“File Extension”=”SDD”
“Key Name”=”SiteCode”
“Filter”=”dbo.fnIsSecondary() = 0 AND DELETED.SiteNumber != dbo.fnGetSiteNumber() AND DELETED.SiteType != 1”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\CAS\SiteDefinition_INS_HMAN]
“Active”=dword:00000001
“Table”=”SC_SiteDefinition”
“Action”=”Insert”
“Target Service”=”Hierarchy Manager (Forwarding messages)”
“File Extension”=”SAT”
“Key Name”=”SiteCode”
“Filter”=”dbo.fnIsSecondary() = 0 AND INSERTED.SiteNumber != dbo.fnGetSiteNumber() AND INSERTED.SiteType != 1”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\CAS\SiteExpansion_INS_HMAN]
“Active”=dword:00000001
“Table”=”sc_sitedefinition_property”
“Action”=”Insert”
“Target Service”=”Hierarchy Manager”
“File Extension”=”EXP”
“Key Name”=”SiteNumber”
“Filter”=”dbo.fnIsPrimary() = 1 AND INSERTED.Name = ‘SiteExpansion’ AND INSERTED.Value3 = 1 AND INSERTED.SiteNumber = 0”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\CAS\SiteKey_ADDUPD_HMAN]
“Active”=dword:00000001
“Table”=”SC_SiteDefinition”
“Action”=”Insert, Update”
“Target Service”=”Hierarchy Manager”
“File Extension”=”SPK”
“Key Name”=”SiteCode”
“Filter”=”SiteCode != N’ ‘ AND NOT EXISTS(SELECT * FROM DELETED D WHERE D.SiteNumber = INSERTED.SiteNumber AND D.ServiceExchangeKey = INSERTED.ServiceExchangeKey) AND dbo.fnIsParentOrChildSite(SiteNumber) != 0”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\CAS\SiteNotif_AIKbMgr]
“Active”=dword:00000001
“Table”=”SiteNotification”
“Action”=”Insert, Update”
“Target Service”=”Asset Intelligence KB Manager”
“File Extension”=”SHA”
“Key Name”=”SiteCode”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\CAS\SiteNotif_iu_WCM]
“Active”=dword:00000001
“Table”=”Sites”
“Action”=”Insert, Update”
“Target Service”=”WSUS Configuration Manager”
“File Extension”=”SHA”
“Key Name”=”SiteCode”
“Filter”=”(ReportToSite = ‘CAS’) and BuildNumber > 5200 and DetailedStatus IN (125, 110) AND SiteCode != ‘ ‘”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\CAS\SiteNotif_Upd_DDM]
“Active”=dword:00000001
“Table”=”SiteNotification”
“Action”=”Update”
“Target Service”=”Discovery Data Manager”
“File Extension”=”SHA”
“Key Name”=”SiteCode”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\CAS\SiteNotif_WSyncMgr]
“Active”=dword:00000001
“Table”=”SiteNotification”
“Action”=”Insert, Update”
“Target Service”=”WSUS Sync Manager”
“File Extension”=”SHA”
“Key Name”=”SiteCode”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\CAS\SiteReassign_Upd_HMAN_SR1]
“Active”=dword:00000001
“Table”=”DeviceSiteReassignment”
“Action”=”Update”
“Target Service”=”Hierarchy Manager (Site Reassign)”
“File Extension”=”SR1”
“Key Name”=”SiteCode”
“Filter”=”NOT EXISTS(SELECT * FROM TableChangeNotifications WHERE Component = N’SiteReassign_Upd_HMAN_SR1′ AND Key1 = ISNULL(SiteCode, N”)) AND EXISTS (SELECT * FROM DELETED WHERE Flag = 0) AND INSERTED.Flag = 1 AND INSERTED.SiteCode = dbo.fnGetSiteCode()”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\CAS\SiteReassign_Upd_HMAN_SR2]
“Active”=dword:00000001
“Table”=”DeviceSiteReassignment”
“Action”=”Update”
“Target Service”=”Hierarchy Manager (Site Reassign)”
“File Extension”=”SR2”
“Key Name”=”SiteCode”
“Filter”=”NOT EXISTS(SELECT * FROM TableChangeNotifications WHERE Component = N’SiteReassign_Upd_HMAN_SR2′ AND Key1 = ISNULL(SiteCode, N”)) AND EXISTS (SELECT * FROM DELETED WHERE Flag != 2) AND INSERTED.Flag = 2 AND INSERTED.MachineID BETWEEN dbo.fnGetSiteRangeStart() AND dbo.fnGetSiteRangeEnd()”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\CAS\SiteReassign_Upd_HMAN_SR5]
“Active”=dword:00000001
“Table”=”DeviceSiteReassignment”
“Action”=”Update”
“Target Service”=”Hierarchy Manager (Site Reassign)”
“File Extension”=”SR5”
“Key Name”=”SiteCode”
“Filter”=”NOT EXISTS(SELECT * FROM TableChangeNotifications WHERE Component = N’SiteReassign_Upd_HMAN_SR5′ AND Key1 = ISNULL(SiteCode, N”)) AND EXISTS (SELECT * FROM DELETED WHERE Flag != 5) AND INSERTED.Flag = 5 AND INSERTED.MachineID BETWEEN dbo.fnGetSiteRangeStart() AND dbo.fnGetSiteRangeEnd()”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\CAS\SiteServerUpdate_AddUpd_HMAN]
“Active”=dword:00000001
“Table”=”SC_SysResUse”
“Action”=”Insert, Update”
“Target Service”=”Hierarchy Manager”
“File Extension”=”SSC”
“Key Name”=”SiteNumber”
“Filter”=”RoleTypeID IN (SELECT RoleTypeID FROM SC_RoleType WHERE RoleName = ‘SMS Site Server’) AND UPDATE(NALPath) AND SiteNumber = dbo.fnGetSiteNumber()”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\CAS\SiteSQLCert_ADDUPD_HMAN]
“Active”=dword:00000001
“Table”=”SC_SiteDefinition_Property”
“Action”=”Insert, Update”
“Target Service”=”Hierarchy Manager”
“File Extension”=”CEU”
“Key Name”=”SiteNumber”
“Filter”=”Name = ‘SQLServerCertificate’ AND UPDATE(Value2) AND (dbo.fnIsParentOrChildSite(SiteNumber) != 0 OR SiteNumber = dbo.fnGetSiteNumber())”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\CAS\SiteSQLService_Restart_HMAN]
“Active”=dword:00000001
“Table”=”SC_SiteDefinition”
“Action”=”Update”
“Target Service”=”Hierarchy Manager”
“File Extension”=”SQR”
“Key Name”=”SiteNumber”
“Filter”=”1 = 0”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\CAS\SiteStatus_UPD_HMAN]
“Active”=dword:00000001
“Table”=”ServerData”
“Action”=”Update”
“Target Service”=”Hierarchy Manager”
“File Extension”=”IPK”
“Key Name”=”SiteCode”
“Filter”=”SiteStatus = 125 AND EXISTS (SELECT * FROM DELETED D WHERE D.ID = INSERTED.ID AND D.SiteStatus != 125) AND EXISTS (SELECT * FROM SMSData WHERE ThisSiteCode = INSERTED.SiteCode) “

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\CAS\SiteSystemNotification_iu_CertMgr]
“Active”=dword:00000001
“Table”=”SiteSystemNotification”
“Action”=”Insert, Update”
“Target Service”=”Certificate Manager”
“File Extension”=”CMN”
“Key Name”=”RoleTypeID,SiteSystemName”
“Filter”=”SiteSystemName NOT IN (SELECT sc.ServerName FROM vSMS_SC_SysResUse sc WHERE sc.NALResType=’Windows Azure’)”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\CAS\Sites_AddUpd_HMAN]
“Active”=dword:00000001
“Table”=”Sites”
“Action”=”Insert, Update”
“Target Service”=”Hierarchy Manager”
“File Extension”=”SSU”
“Key Name”=”SiteCode”
“Filter”=”SiteCode != N’ ‘ AND ((EXISTS (SELECT * FROM Sites S JOIN SMSData D ON S.SiteCode = D.ThisSiteCode AND S.DetailedStatus = 125) AND DetailedStatus = 125) OR SiteType = 1)”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\CAS\Sites_Add_CertMgr]
“Active”=dword:00000001
“Table”=”Sites”
“Action”=”Update”
“Target Service”=”Certificate Manager”
“File Extension”=”CMS”
“Key Name”=”SiteCode”
“Filter”=” UPDATE(DetailedStatus) AND DetailedStatus=125 AND ReportToSite<>N” AND SiteType=2 AND NOT EXISTS (SELECT * FROM DELETED D WHERE D.SiteCode = inserted.SiteCode AND D.DetailedStatus = 125)”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\CAS\Sites_Del_HMAN]
“Active”=dword:00000001
“Table”=”Sites”
“Action”=”Delete”
“Target Service”=”Hierarchy Manager”
“File Extension”=”SSD”
“Key Name”=”SiteCode”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\CAS\Sites_Interop_Update_HMAN]
“Active”=dword:00000001
“Table”=”Sites”
“Action”=”Update”
“Target Service”=”Hierarchy Manager”
“File Extension”=”ITC”
“Key Name”=”SiteCode”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\CAS\SMSDBMON_RunNow]
“Active”=dword:00000001
“Table”=”SQLTaskStatus”
“Action”=”Update”
“Target Service”=””
“File Extension”=””
“Key Name”=”TaskName,TaskType”
“Filter”=”RunNow=1”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\CAS\SMSPackages_G_Avail_iu]
“Active”=dword:00000001
“Table”=”SMSPackages_G”
“Action”=”Insert, Update”
“Target Service”=”Object Replication Manager”
“File Extension”=”PAN”
“Key Name”=”PkgID”
“Filter”=”dbo.fnIsPrimary()=1 AND PackageType = 0”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\CAS\SMS_Advertisement_del_SMSProv]
“Active”=dword:00000001
“Table”=”ProgramOffers_L”
“Action”=”delete”
“Target Service”=”SMS Provider”
“File Extension”=””
“Key Name”=”OfferID”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\CAS\SMS_Advertisement_ins_upd_SMSProv]
“Active”=dword:00000001
“Table”=”ProgramOffers_L”
“Action”=”insert,update”
“Target Service”=”SMS Provider”
“File Extension”=””
“Key Name”=”OfferID”
“Filter”=”inserted.Action!=0 and inserted.Action!=3”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\CAS\SMS_Alert_ins_upd_SMSProv]
“Active”=dword:00000001
“Table”=”Alert”
“Action”=”insert,update”
“Target Service”=”SMS Provider”
“File Extension”=””
“Key Name”=”AlertID”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\CAS\SMS_Alert_upd_SMSProv_AlertForTrigger]
“Active”=dword:00000001
“Table”=”AlertForTrigger”
“Action”=”update”
“Target Service”=”SMS Provider”
“File Extension”=””
“Key Name”=”AlertID”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\CAS\SMS_Collection_del_SMSProv]
“Active”=dword:00000001
“Table”=”Collections_G”
“Action”=”delete”
“Target Service”=”SMS Provider”
“File Extension”=””
“Key Name”=”SiteID”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\CAS\SMS_Collection_ins_upd_SMSProv]
“Active”=dword:00000001
“Table”=”Collection_Maint”
“Action”=”insert,update”
“Target Service”=”SMS Provider”
“File Extension”=””
“Key Name”=”CollectionID”
“Filter”=”inserted.CStatus!=0”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\CAS\SMS_Package_del_SMSProv]
“Active”=dword:00000001
“Table”=”SMSPackages_G”
“Action”=”delete”
“Target Service”=”SMS Provider”
“File Extension”=””
“Key Name”=”PkgID”
“Filter”=”PackageType=0”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\CAS\SMS_Package_ins_upd_SMSProv]
“Active”=dword:00000001
“Table”=”SMSPackages_G”
“Action”=”insert,update”
“Target Service”=”SMS Provider”
“File Extension”=””
“Key Name”=”PkgID”
“Filter”=”inserted.PackageType=0 and inserted.Action!=0 and inserted.Action!=3”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\CAS\SqlControlProperty_DView]
“Active”=dword:00000001
“Table”=”RcmSqlControlProperty”
“Action”=”Insert, Update,delete”
“Target Service”=”Replication Configuration And Monitoring Inbox”
“File Extension”=”DVC”
“Key Name”=”ID”
“Filter”=”ControlID IN (select ID from rcmsqlcontrol where typeid = 3) AND Name IN (N’DviewForHINV’, N’DviewForSINV’, N’DviewForStatusMessages’)”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\CAS\SqlControlProperty_RCM]
“Active”=dword:00000001
“Table”=”RcmSqlControlProperty”
“Action”=”Insert, Update”
“Target Service”=”Replication Configuration And Monitoring Inbox”
“File Extension”=”RSC”
“Key Name”=”ID”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\CAS\SQLServerSSBPORT_UPD_HMAN]
“Active”=dword:00000001
“Table”=”SC_SiteDefinition_Property”
“Action”=”Update”
“Target Service”=”Hierarchy Manager”
“File Extension”=”SBP”
“Key Name”=”SiteNumber”
“Filter”=”Name = ‘SSBPort’ AND UPDATE(Value3) AND (dbo.fnIsParentOrChildSite(SiteNumber) != 0 OR SiteNumber = dbo.fnGetSiteNumber())”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\CAS\SR_SingleSummaryRequest_ins_upd]
“Active”=dword:00000001
“Table”=”SR_SingleSummaryRequest”
“Action”=”Insert, Update”
“Target Service”=”State System”
“File Extension”=”SSR”
“Key Name”=”RequestID”
“Filter”=”SiteCode=dbo.fnGetSiteCode()”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\CAS\SR_SummaryTasks_upd]
“Active”=dword:00000001
“Table”=”SR_SummaryTasks_L”
“Action”=”Update”
“Target Service”=”State System”
“File Extension”=”RUN”
“Key Name”=”TaskID”
“Filter”=”RunNow=1”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\CAS\SubNotify_d_WCM]
“Active”=dword:00000001
“Table”=”CI_UpdateCategorySubscription”
“Action”=”Delete”
“Target Service”=”WSUS Configuration Manager”
“File Extension”=”CSB”
“Key Name”=”CategoryInstanceID”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\CAS\SubNotify_iu_WCM]
“Active”=dword:00000001
“Table”=”CI_UpdateCategorySubscription”
“Action”=”Insert, Update”
“Target Service”=”WSUS Configuration Manager”
“File Extension”=”CSB”
“Key Name”=”CategoryInstanceID”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\CAS\SyncNotif_WSyncMgr]
“Active”=dword:00000001
“Table”=”Update_SyncStatus”
“Action”=”Insert, Update”
“Target Service”=”WSUS Sync Manager”
“File Extension”=”SYN”
“Key Name”=”SyncNow”
“Filter”=”SiteCode=dbo.fnGetSiteCode() and SyncNow in (‘SELF’, ‘FULL’)”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\CAS\TestConnection_TST]
“Active”=dword:00000001
“Table”=”AlertEmailTestConnection”
“Action”=”Insert”
“Target Service”=”Alert Notification Inbox”
“File Extension”=”TST”
“Key Name”=”TestID”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\CAS\UpdSrcNotify_iud]
“Active”=dword:00000001
“Table”=”CI_UpdateSources”
“Action”=”Insert, Update”
“Target Service”=”Object Replication Manager”
“File Extension”=”SCN”
“Key Name”=”UpdateSource_ID”
“Filter”=””

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\CAS\ViewData_RCM]
“Active”=dword:00000001
“Table”=”ViewData”
“Action”=”Insert, Update, Delete”
“Target Service”=”Replication Configuration And Monitoring Inbox”
“File Extension”=”RCM”
“Key Name”=”ID”
“Filter”=””

 SCCM 2007  Primary Server

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\TO1]
“Polling Directory”=”D:\\SCCM\\bin\\i386\\routing”
“SMS Primary Site”=”WTZMCM01”

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\TO1\AIHinvClass_Upd_Dataldr]
“Target Service”=”Client Data Files Source Directory”
“Filter”=”ActualReportState<>RequestedReportState”
“Action”=”Update”
“Key Name”=”ClassName”
“Table”=”AIHinvClass”
“Named Pipe Path”=””
“File Extension”=”AHC”
“Active”=dword:00000001

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\TO1\AMT_Add_OTP]
“Target Service”=”SMS_AMT_PROXY_PROV”
“Filter”=””
“Action”=”Insert, Update, NonZeroByteFile”
“Key Name”=”MachineID”
“Table”=”AMT_OTPs”
“Named Pipe Path”=””
“File Extension”=”OTP”
“Active”=dword:00000001

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\TO1\AttrMap_Add_SMSProv]
“Target Service”=”SMS Provider”
“Filter”=””
“Action”=”Insert”
“Key Name”=”ArchitectureKey,GroupKey,AttributeName”
“Table”=”AttributeMap”
“Named Pipe Path”=”SMSPROVIDER_”
“File Extension”=””
“Active”=dword:00000001

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\TO1\CategoryNotify_iud]
“Target Service”=”Object Replication Manager”
“Filter”=”SourceSite = ‘TO1′”
“Action”=”Insert, Update”
“Key Name”=”CategoryInstanceID”
“Table”=”CI_CategoryInstances”
“Named Pipe Path”=””
“File Extension”=”CTN”
“Active”=dword:00000001

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\TO1\CEP_ADD_Upd]
“Target Service”=”Collection Evaluator”
“Filter”=”SourceSite = ‘TO1′”
“Action”=”Insert, Update”
“Key Name”=”CollectionID”
“Table”=”CEP_CollectionExtendedProperties”
“Named Pipe Path”=””
“File Extension”=”CEP”
“Active”=dword:00000001

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\TO1\CIAssignmentNotify_d]
“Target Service”=”CI Assignment Manager”
“Filter”=”IsTombstoned = 0”
“Action”=”Delete”
“Key Name”=”Assignment_UniqueID”
“Table”=”CI_CIAssignments”
“Named Pipe Path”=””
“File Extension”=”CAD”
“Active”=dword:00000001

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\TO1\CIAssignmentNotify_iu]
“Target Service”=”CI Assignment Manager”
“Filter”=”SourceSite = ‘TO1′”
“Action”=”Insert, Update”
“Key Name”=”AssignmentID”
“Table”=”CI_CIAssignments”
“Named Pipe Path”=””
“File Extension”=”CIA”
“Active”=dword:00000001

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\TO1\CINotify_iud]
“Target Service”=”Object Replication Manager”
“Filter”=”SourceSite = ‘TO1′”
“Action”=”Insert, Update”
“Key Name”=”CI_ID”
“Table”=”CI_ConfigurationItems”
“Named Pipe Path”=””
“File Extension”=”CIN”
“Active”=dword:00000001

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\TO1\Collection_Del]
“Target Service”=”Offer Manager”
“Filter”=””
“Action”=”Delete”
“Key Name”=”SiteID”
“Table”=”Collections”
“Named Pipe Path”=””
“File Extension”=”CMN”
“Active”=dword:00000001

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\TO1\Coll_Add]
“Target Service”=”Collection Evaluator”
“Filter”=””
“Action”=”Insert”
“Key Name”=”CollectionID”
“Table”=”Collection_Maint”
“Named Pipe Path”=””
“File Extension”=”ADC”
“Active”=dword:00000001

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\TO1\Coll_Add_OFFERMGR]
“Target Service”=”Offer Manager”
“Filter”=””
“Action”=”Insert”
“Key Name”=”CollectionID”
“Table”=”Collection_MemberChg_Notif”
“Named Pipe Path”=””
“File Extension”=”CMN”
“Active”=dword:00000001

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\TO1\Coll_Del]
“Target Service”=”Collection Evaluator”
“Filter”=””
“Action”=”Delete”
“Key Name”=”CollectionID”
“Table”=”Collection_Maint”
“Named Pipe Path”=””
“File Extension”=”DC”
“Active”=dword:00000001

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\TO1\Coll_Upd]
“Target Service”=”Collection Evaluator”
“Filter”=””
“Action”=”Update”
“Key Name”=”CollectionID”
“Table”=”Collection_Maint”
“Named Pipe Path”=””
“File Extension”=”UDC”
“Active”=dword:00000001

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\TO1\DeviceSettingItemNotify_iud]
“Target Service”=”Object Replication Manager”
“Filter”=”SourceSite = ‘TO1′”
“Action”=”Insert, Update”
“Key Name”=”DeviceSettingItemID”
“Table”=”DeviceSettingItems”
“Named Pipe Path”=””
“File Extension”=”DSN”
“Active”=dword:00000001

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\TO1\DiscProps_Add_SMSProv]
“Target Service”=”SMS Provider”
“Filter”=””
“Action”=”Insert”
“Key Name”=”DiscArchKey,PropertyName”
“Table”=”DiscPropertyDefs”
“Named Pipe Path”=”SMSPROVIDER_”
“File Extension”=””
“Active”=dword:00000001

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\TO1\DPNotify_ADD]
“Target Service”=”Distribution Manager”
“Filter”=””
“Action”=”Insert”
“Key Name”=”DPID”
“Table”=”DPNotification”
“Named Pipe Path”=””
“File Extension”=”DPN”
“Active”=dword:00000001

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\TO1\EULANotify_iud]
“Target Service”=”Object Replication Manager”
“Filter”=”SourceSite = ‘TO1′”
“Action”=”Insert, Update”
“Key Name”=”EULAContentID”
“Table”=”EULA_Content”
“Named Pipe Path”=””
“File Extension”=”EUN”
“Active”=dword:00000001

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\TO1\GroupMap_Add_SMSProv]
“Target Service”=”SMS Provider”
“Filter”=””
“Action”=”Insert”
“Key Name”=”ArchitectureKey,GroupKey”
“Table”=”GroupMap”
“Named Pipe Path”=”SMSPROVIDER_”
“File Extension”=””
“Active”=dword:00000001

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\TO1\InventoryAction_Chg]
“Target Service”=”Policy Provider”
“Filter”=””
“Action”=”Insert, Update, NonZeroByteFile”
“Key Name”=”ActionID”
“Table”=”InventoryAction”
“Named Pipe Path”=””
“File Extension”=”IAC”
“Active”=dword:00000001

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\TO1\MEP_ADD_Upd]
“Target Service”=”Policy Provider”
“Filter”=”SourceSite = ‘TO1′”
“Action”=”Insert, Update, NonZeroByteFile”
“Key Name”=”MachineID”
“Table”=”MEP_MachineExtendedProperties”
“Named Pipe Path”=””
“File Extension”=”MEP”
“Active”=dword:00000001

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\TO1\MeterRuleChanges_Ins_SWMPROC]
“Target Service”=”Software Metering Processor (Site)”
“Filter”=””
“Action”=”Insert”
“Key Name”=”RuleID”
“Table”=”MeterRuleChanges”
“Named Pipe Path”=””
“File Extension”=”RCH”
“Active”=dword:00000001

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\TO1\MtrRule_Chg]
“Target Service”=”Policy Provider”
“Filter”=””
“Action”=”Insert, NonZeroByteFile”
“Key Name”=”RuleID”
“Table”=”MeterRuleChanges”
“Named Pipe Path”=””
“File Extension”=”MRN”
“Active”=dword:00000001

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\TO1\OfferNotify_Add]
“Target Service”=”Offer Manager”
“Filter”=””
“Action”=”Insert”
“Key Name”=”OfferID”
“Table”=”OfferNotification”
“Named Pipe Path”=””
“File Extension”=”OFN”
“Active”=dword:00000001

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\TO1\Offer_Del]
“Target Service”=”Offer Manager”
“Filter”=””
“Action”=”Delete”
“Key Name”=”OfferID”
“Table”=”ProgramOffers”
“Named Pipe Path”=””
“File Extension”=”DEL”
“Active”=dword:00000001

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\TO1\PeerDPResMap_d]
“Target Service”=”Policy Provider”
“Filter”=””
“Action”=”Delete, NonZeroByteFile”
“Key Name”=”DPID”
“Table”=”PeerDPResMap”
“Named Pipe Path”=””
“File Extension”=”DPN”
“Active”=dword:00000001

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\TO1\PeerDPResMap_iu]
“Target Service”=”Policy Provider”
“Filter”=””
“Action”=”Insert, Update, NonZeroByteFile”
“Key Name”=”DPID”
“Table”=”PeerDPResMap”
“Named Pipe Path”=””
“File Extension”=”DPN”
“Active”=dword:00000001

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\TO1\PkgNotify_Add]
“Target Service”=”Distribution Manager”
“Filter”=””
“Action”=”Insert”
“Key Name”=”PkgID”
“Table”=”PkgNotification”
“Named Pipe Path”=””
“File Extension”=”PKN”
“Active”=dword:00000001

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\TO1\PolicyTargetEvalNotify_iud]
“Target Service”=”Policy Targeting Evaluator”
“Filter”=””
“Action”=”Insert, Update”
“Key Name”=”CollectionID”
“Table”=”Collections”
“Named Pipe Path”=””
“File Extension”=”CCN”
“Active”=dword:00000001

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\TO1\SDMNotify_iud]
“Target Service”=”Object Replication Manager”
“Filter”=”SourceSite = ‘TO1′”
“Action”=”Insert, Update”
“Key Name”=”SDMPackage_ID”
“Table”=”CI_SDMPackages”
“Named Pipe Path”=””
“File Extension”=”SDN”
“Active”=dword:00000001

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\TO1\SiteControl_AddUpd_HMAN]
“Target Service”=”Hierarchy Manager”
“Filter”=””
“Action”=”Insert”
“Key Name”=”SiteCode,TypeFlag”
“Table”=”SiteControl”
“Named Pipe Path”=””
“File Extension”=”SCU”
“Active”=dword:00000001

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\TO1\SiteCtrlNot_Add_DDM]
“Target Service”=”Discovery Data Manager (Notification)”
“Filter”=””
“Action”=”Insert, Update”
“Key Name”=”SiteCode”
“Table”=”SiteControlNotification”
“Named Pipe Path”=””
“File Extension”=”SCA”
“Active”=dword:00000001

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\TO1\SiteCtrlNot_Del_DDM]
“Target Service”=”Discovery Data Manager (Notification)”
“Filter”=””
“Action”=”Delete”
“Key Name”=”SiteCode”
“Table”=”SiteControlNotification”
“Named Pipe Path”=””
“File Extension”=”SCD”
“Active”=dword:00000001

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\TO1\SiteNotif_AIKbMgr]
“Target Service”=”Asset Intelligence KB Manager”
“Filter”=””
“Action”=”Insert, Update”
“Key Name”=”SiteCode”
“Table”=”SiteNotification”
“Named Pipe Path”=””
“File Extension”=”SHA”
“Active”=dword:00000001

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\TO1\SiteNotif_CIA_CIAMgr]
“Target Service”=”CI Assignment Manager”
“Filter”=””
“Action”=”Insert, Update”
“Key Name”=”SiteCode”
“Table”=”SiteNotification”
“Named Pipe Path”=””
“File Extension”=”SHA”
“Active”=dword:00000001

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\TO1\SiteNotif_Del_SWMPROC]
“Target Service”=”Software Metering Processor (Site)”
“Filter”=””
“Action”=”Delete”
“Key Name”=”SiteCode”
“Table”=”SiteNotification”
“Named Pipe Path”=””
“File Extension”=”SHD”
“Active”=dword:00000001

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\TO1\SiteNotif_iu_WCM]
“Target Service”=”WSUS Configuration Manager”
“Filter”=”(SiteCode = ‘TO1’ or ReportToSite = ‘TO1’) and BuildNumber > 5200”
“Action”=”Insert, Update”
“Key Name”=”SiteCode”
“Table”=”Sites”
“Named Pipe Path”=””
“File Extension”=”SHA”
“Active”=dword:00000001

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\TO1\SiteNotif_OBJ_ObjReplMgr]
“Target Service”=”Object Replication Manager”
“Filter”=””
“Action”=”Insert, Update”
“Key Name”=”SiteCode”
“Table”=”SiteNotification”
“Named Pipe Path”=””
“File Extension”=”SHA”
“Active”=dword:00000001

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\TO1\SiteNotif_Upd_CE]
“Target Service”=”Collection Evaluator”
“Filter”=””
“Action”=”Insert, Update”
“Key Name”=”SiteCode”
“Table”=”SiteNotification”
“Named Pipe Path”=””
“File Extension”=”SHA”
“Active”=dword:00000001

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\TO1\SiteNotif_Upd_DDM]
“Target Service”=”Discovery Data Manager”
“Filter”=””
“Action”=”Update”
“Key Name”=”SiteCode”
“Table”=”SiteNotification”
“Named Pipe Path”=””
“File Extension”=”SHA”
“Active”=dword:00000001

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\TO1\SiteNotif_Upd_DistMgr]
“Target Service”=”Distribution Manager”
“Filter”=””
“Action”=”Update”
“Key Name”=”SiteCode”
“Table”=”SiteNotification”
“Named Pipe Path”=””
“File Extension”=”SHA”
“Active”=dword:00000001

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\TO1\SiteNotif_Upd_OfferMgr]
“Target Service”=”Offer Manager”
“Filter”=””
“Action”=”Update”
“Key Name”=”SiteCode”
“Table”=”SiteNotification”
“Named Pipe Path”=””
“File Extension”=”SHA”
“Active”=dword:00000001

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\TO1\SiteNotif_Upd_SWMPROC]
“Target Service”=”Software Metering Processor (Site)”
“Filter”=””
“Action”=”Update”
“Key Name”=”SiteCode”
“Table”=”SiteNotification”
“Named Pipe Path”=””
“File Extension”=”SHA”
“Active”=dword:00000001

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\TO1\SiteNotif_WSyncMgr]
“Target Service”=”WSUS Sync Manager”
“Filter”=””
“Action”=”Insert, Update”
“Key Name”=”SiteCode”
“Table”=”SiteNotification”
“Named Pipe Path”=””
“File Extension”=”SHA”
“Active”=dword:00000001

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\TO1\Sites_AddUpd_HMAN]
“Target Service”=”Hierarchy Manager”
“Filter”=””
“Action”=”Insert, Update”
“Key Name”=”SiteCode”
“Table”=”Sites”
“Named Pipe Path”=””
“File Extension”=”SSU”
“Active”=dword:00000001

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\TO1\Sites_Del_HMAN]
“Target Service”=”Hierarchy Manager”
“Filter”=””
“Action”=”Delete”
“Key Name”=”SiteCode”
“Table”=”Sites”
“Named Pipe Path”=””
“File Extension”=”SSD”
“Active”=dword:00000001

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\TO1\SMSDBMON_RunNow]
“Target Service”=””
“Filter”=”RunNow=1”
“Action”=”Update”
“Key Name”=”TaskName,TaskType”
“Table”=”SQLTaskStatus”
“Named Pipe Path”=”UnusedNamedPipe”
“File Extension”=””
“Active”=dword:00000001

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\TO1\SR_SummaryTasks_upd]
“Target Service”=”State System”
“Filter”=”RunNow=1”
“Action”=”Update”
“Key Name”=”TaskID”
“Table”=”SR_SummaryTasks”
“Named Pipe Path”=””
“File Extension”=”RUN”
“Active”=dword:00000001

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\TO1\SubNotify_d_WCM]
“Target Service”=”WSUS Configuration Manager”
“Filter”=””
“Action”=”Delete”
“Key Name”=”CategoryInstanceID”
“Table”=”CI_UpdateCategorySubscription”
“Named Pipe Path”=””
“File Extension”=”CSB”
“Active”=dword:00000001

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\TO1\SubNotify_iu_WCM]
“Target Service”=”WSUS Configuration Manager”
“Filter”=””
“Action”=”Insert, Update”
“Key Name”=”CategoryInstanceID”
“Table”=”CI_UpdateCategorySubscription”
“Named Pipe Path”=””
“File Extension”=”CSB”
“Active”=dword:00000001

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\TO1\Tuple$FolderMembers$_i]
“Target Service”=”Object Replication Manager”
“Filter”=”SourceSite = ‘TO1′”
“Action”=”Insert”
“Key Name”=”MemberID”
“Table”=”FolderMembers”
“Named Pipe Path”=””
“File Extension”=”MEN”
“Active”=dword:00000001

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\TO1\Tuple$FolderMembers$_ud]
“Target Service”=”Object Replication Manager”
“Filter”=”SourceSite = ‘TO1’ and exists (select 1 from deleted join inserted on deleted.MemberID=inserted.MemberID where (inserted.SourceSite<>deleted.SourceSite or inserted.IsDeleted<>deleted.IsDeleted or inserted.rowversion<>deleted.rowversion))”
“Action”=”Update”
“Key Name”=”MemberID”
“Table”=”FolderMembers”
“Named Pipe Path”=””
“File Extension”=”MEN”
“Active”=dword:00000001

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\TO1\Tuple$Folders$_i]
“Target Service”=”Object Replication Manager”
“Filter”=”SourceSite = ‘TO1′”
“Action”=”Insert”
“Key Name”=”ContainerNodeID”
“Table”=”Folders”
“Named Pipe Path”=””
“File Extension”=”FLN”
“Active”=dword:00000001

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\TO1\Tuple$Folders$_ud]
“Target Service”=”Object Replication Manager”
“Filter”=”SourceSite = ‘TO1’ and exists (select 1 from deleted join inserted on deleted.ContainerNodeID=inserted.ContainerNodeID where (inserted.SourceSite<>deleted.SourceSite or inserted.IsDeleted<>deleted.IsDeleted or inserted.rowversion<>deleted.rowversion))”
“Action”=”Update”
“Key Name”=”ContainerNodeID”
“Table”=”Folders”
“Named Pipe Path”=””
“File Extension”=”FLN”
“Active”=dword:00000001

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\TO1\UpdSrcNotify_iud]
“Target Service”=”Object Replication Manager”
“Filter”=”SourceSite = ‘TO1′”
“Action”=”Insert, Update”
“Key Name”=”UpdateSource_ID”
“Table”=”CI_UpdateSources”
“Named Pipe Path”=””
“File Extension”=”SCN”
“Active”=dword:00000001

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\TO1\UpdSyncStatus_iu]
“Target Service”=”Policy Provider”
“Filter”=”SiteCode = ‘TO1′”
“Action”=”Insert, Update, NonZeroByteFile”
“Key Name”=”UpdateSource_UniqueID”
“Table”=”Update_SyncStatus”
“Named Pipe Path”=””
“File Extension”=”STN”
“Active”=dword:00000001

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Triggers\TO1\WOLMgr_WOLScheduleMap_iu]
“Target Service”=”SMS_WAKEONLAN_MANAGER”
“Filter”=””
“Action”=”Insert, Update”
“Key Name”=”ScheduleMapID”
“Table”=”WOLScheduleMap”
“Named Pipe Path”=””
“File Extension”=”WLN”
“Active”=dword:00000001

We are on WhatsApp now. To get the latest step-by-step guides, news, and updates, Join our Channel. Click here. HTMD WhatsApp.

Author

Anoop C Nair is Microsoft MVP from 2015 onwards for consecutive 10 years! He is a Workplace Solution Architect with more than 22+ years of experience in Workplace technologies. He is a Blogger, Speaker, and Local User Group Community leader. His primary focus is on Device Management technologies like SCCM and Intune. He writes about technologies like Intune, SCCM, Windows, Cloud PC, Windows, Entra, Microsoft Security, Career etc…