Advertisement

SCCM ConfigMgr 2012 Inbox File Types Extensions and Associated Components

I’ve seen loads of questions around the SCCM ConfigMgr 2012 Inbox file extensions. Some of the examples are, What type of files are *.TRG files in the SCCM 2012 Inbox ? I’ve backlog of *.UDC files in my SCCM 2012 or 2007 Inbox folder, can I delete these files? I’m not going to provide answers for these questions.  However, the following table can provide us some more details about SCCM ConfigMgr 2012 file extensions and the process/thread which are associated with each of these types of SCCM ConfigMgr 2012  files.

Download the file extension list for offline use from technet gallery here. Pivot table of Files here.

SCCM 2012 File Extensions 3

SCCM 2012 File Extensions 2

 

The best way to know more about these SCCM 2012 file extensions and details about the SQL actions get triggered with each type of file extensions is go to into registry of SCCM ConfigMgr 2012 primary or CAS server.  As shown in the below picture, each trigger like ActiveDirectoryForests_HMAN can provide us loads of information. For example, ActiveDirectoryForests_HMAN contains this loads of information ::: This is very interesting information for me. I don’t know what you feel ? Is this information useful in some troubleshooting ?

[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 and related components

SCCM 2012 File Extensions and related components

 

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

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

 

About Author 

Anoop is Microsoft MVP and Veeam Vanguard ! He is a Solution Architect on enterprise client management with more than 13 years of experience (calculation done on the year 2014) in IT. He is Blogger, Speaker and Local User Group Community leader. His main focus is on Device Management technologies like SCCM 2012,Current Branch, Intune. He writes about the technologies like SCCM, SCOM, Windows 10, Azure AD, Microsoft Intune, RMS, Hyper-V etc...

    Find more about me on:
  • googleplus
  • twitter
  • facebook
  • linkedin
  • youtube
Posted in: CM2012, ConfigMgr (SCCM), Configmgr2012, System Center 2012 Configuration Manager, System Center Configuration Manager

Leave a Comment and Contact Anoop