Tuesday, March 10, 2015

SCCM ConfigMgr 2012 Inbox File Types Extensions and Associated Components



With the numerous SCCM ConfigMgr 2012 Inbox file extensions, it could get pretty confusing and intimidating to figure out what extension is for what purpose and where it goes. 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.

Microsoft does provide the information which is downloadable from the gallery and the pivot table is available here too

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.


SCCM 2012 File Extensions and related components


SCCM 2012 File ExtensionsTrigger NameSCCM 2012 Thread Service
.TRGActiveDirectoryForests_HMANHierarchy Manager
.TRGActiveDirectoryForests_SITECOMPSite Component Manager
.ALEAlertForTrigger_ALEAlert Notification Inbox
.ALTAlert_ALTAlert Notification Inbox
.RCMArticleData_RCMReplication Configuration And Monitoring Inbox
.AUCAutoClientUpgradeConfigs_UPD_HMANHierarchy Manager
.BNDBoundaryEx_EventDiscovery Data Manager (Notification)
.TRGBoundaryEx_HMANHierarchy Manager
.BNDBoundaryGroupMembers_EventDiscovery Data Manager (Notification)
.TRGBoundaryGroupMembers_HMANHierarchy Manager
.BNDBoundaryGroup_EventDiscovery Data Manager (Notification)
.TRGBoundaryGroup_HMANHierarchy Manager
.CTNCategoryNotify_iudObject Replication Manager
.CFECFDGo_INS_UPD_HMANHierarchy Manager (CFD)
.CIACIAssignmentNotify_iuObject Replication Manager
.CINCINotify_iudObject Replication Manager
.CINCI_ApplicationModelInfo_CINotifyObject Replication Manager
.CIACI_AssignmentTargetedCIs_CIAMGRObject Replication Manager
.CINCI_ConfigurationItemRelations_Flat_From_iudObject Replication Manager
CI_ConfigurationItemRelations_FromVE_ToDT_iud
.GCSClientAgentProperty_Value_iudObject Replication Manager
.OPAClientOperation_iuObject Replication Manager
.GCAClientSettingsAssignments_iuObject Replication Manager
.GCSClientSettings_iudObject Replication Manager
.CSDCloudSubscription_CSDReplication Configuration And Monitoring Inbox
.RECCRP_CertRevokeCertificate Manager
.LQUCurrentSiteSQL_AddUpd_HMANHierarchy Manager
.ICPDataLdr_InventoryActionClient Data Files Source Directory
.ICPDataLdr_InventoryClassClient Data Files Source Directory
.ICPDataLdr_InventoryClassPropertyClient Data Files Source Directory
.RISDataLdr_RemoteInvSchemaClient Data Files Source Directory
.MDADeviceAction_iu_CertMgrCertificate Manager
.DSNDeviceSettingItemNotify_iudObject Replication Manager
.CRVDiscPropertyDefs_Ins_DDMDiscovery Data Manager (Notification)
DiscProps_Add_SMSProvSMS Provider
.PKNDistributionJobOrder_UpdatedSMS_PACKAGE_TRANSFER_MANAGER
.CANDistributionJob_CancelledSMS_PACKAGE_TRANSFER_MANAGER
.PKNDistributionJob_CreationSMS_PACKAGE_TRANSFER_MANAGER
.INSDistributionPoints_InsDistribution Manager
.INSDistributionPoints_UpdDistribution Manager
.DPNDPNotify_ADDDistribution Manager
.DPUDPNotify_UpgradeDistribution Manager
.INSDPNotify_Upgrade_InsDistribution Manager
.NOTDP_Properties_UpdDistribution Manager
.EUNEULANotify_iudObject Replication Manager
GroupMap_Add_SMSProvSMS Provider
.RCMInitPackageRequest_RCMReplication Configuration And Monitoring Inbox
.ITOInteropBlockList_AddDel_HMANHierarchy Manager
.CFEMDMCFDFeature_UPD_HMANHierarchy Manager (CFD)
.RSBMDMDeviceManagementStates_Local_INS_UPD_HMANHierarchy Manager
.MIGMIG_Job_MIGMigration Manager Inbox
.SYNMIG_SiteMapping_SYNMigration Manager Inbox
.MRUMonitoringRole_UPD_HMANHierarchy Manager
.CRPNDESCertificates_iud_CRPCertificate Manager
.RQUOtherSiteSQL_AddUpd_HMANHierarchy Manager
.RQDOtherSiteSQL_Del_HMANHierarchy Manager
.PKNPkgNotify_AddDistribution Manager
.PRNPkgPrograms_G_Avail_iuObject Replication Manager
.ENRPreEnrollmentRecords_Upd_AMTSMS_AMT_PROXY_COMPONENT
.OANProgramOffers_G_Avail_iuObject Replication Manager
.PULPullDPResponse_UpdInsDistribution Manager (Incoming)
.ROARAXSubNotify_iudObject Replication Manager
RBAC_Admins_ins_del_SMSProvSMS Provider
.RBCRbac_Sync_ChangeNotificationHierarchy Manager
.RCMRCM_DrsInitializationTracking_RCMReplication Configuration And Monitoring Inbox
.RIURecoveryInfo_UPD_HMANHierarchy Manager
.RCMReplicationData_RCMReplication Configuration And Monitoring Inbox
.RULRules_iudRule Engine
.RAUSCCMAutoUpdates_RAUReplication Configuration And Monitoring Inbox
.RCMServerData_RCMReplication Configuration And Monitoring Inbox
.SCASiteControl_Address_SchedulerScheduler
.SCUSiteControl_AddUpd_HMANHierarchy Manager
.CT0SiteControl_AddUpd_SiteCtrlSite Control Manager (Master Site Control File)
.SCASiteCtrlNot_Add_DDMDiscovery Data Manager (Notification)
.SCDSiteCtrlNot_Del_DDMDiscovery Data Manager (Notification)
.SDDSiteDefinition_DEL_HMANHierarchy Manager (Forwarding messages)
.SATSiteDefinition_INS_HMANHierarchy Manager (Forwarding messages)
.EXPSiteExpansion_INS_HMANHierarchy Manager
.SPKSiteKey_ADDUPD_HMANHierarchy Manager
.SHASiteNotif_AIKbMgrAsset Intelligence KB Manager
.SHASiteNotif_iu_WCMWSUS Configuration Manager
.SHASiteNotif_Upd_DDMDiscovery Data Manager
.SHASiteNotif_WSyncMgrWSUS Sync Manager
.SR1SiteReassign_Upd_HMAN_SR1Hierarchy Manager (Site Reassign)
.SR2SiteReassign_Upd_HMAN_SR2Hierarchy Manager (Site Reassign)
.SR5SiteReassign_Upd_HMAN_SR5Hierarchy Manager (Site Reassign)
.SSCSiteServerUpdate_AddUpd_HMANHierarchy Manager
.CEUSiteSQLCert_ADDUPD_HMANHierarchy Manager
.SQRSiteSQLService_Restart_HMANHierarchy Manager
.IPKSiteStatus_UPD_HMANHierarchy Manager
.CMNSiteSystemNotification_iu_CertMgrCertificate Manager
.SSUSites_AddUpd_HMANHierarchy Manager
.CMSSites_Add_CertMgrCertificate Manager
.SSDSites_Del_HMANHierarchy Manager
.ITCSites_Interop_Update_HMANHierarchy Manager
SMSDBMON_RunNow
.PANSMSPackages_G_Avail_iuObject Replication Manager
SMS_Advertisement_del_SMSProvSMS Provider
SMS_Advertisement_ins_upd_SMSProvSMS Provider
SMS_Alert_ins_upd_SMSProvSMS Provider
SMS_Alert_upd_SMSProv_AlertForTriggerSMS Provider
SMS_Collection_del_SMSProvSMS Provider
SMS_Collection_ins_upd_SMSProvSMS Provider
SMS_Package_del_SMSProvSMS Provider
SMS_Package_ins_upd_SMSProvSMS Provider
.DVCSqlControlProperty_DViewReplication Configuration And Monitoring Inbox
.RSCSqlControlProperty_RCMReplication Configuration And Monitoring Inbox
.SBPSQLServerSSBPORT_UPD_HMANHierarchy Manager
.SSRSR_SingleSummaryRequest_ins_updState System
.RUNSR_SummaryTasks_updState System
.CSBSubNotify_d_WCMWSUS Configuration Manager
.CSBSubNotify_iu_WCMWSUS Configuration Manager
.SYNSyncNotif_WSyncMgrWSUS Sync Manager
.TSTTestConnection_TSTAlert Notification Inbox
.SCNUpdSrcNotify_iudObject Replication Manager
.RCMViewData_RCMReplication Configuration And Monitoring Inbox
.TASKAzure_CloudServicesTask_CloudMgr_insCloud Services Manager Inbox
.SVCCERTAzure_Service_CloudMgr_ServiceCert_UpdCloud Services Manager Inbox
.CSCCcarSiteControl_AddUpd_PolicyPVPolicy Provider
.CEPCEP_ADD_UpdCollection Evaluator
.CITCINotify_TSApp_PolicyPv_iudPolicy Provider
.CPBClientPushMachine_G_InsertClient Configuration Record (Incoming)
.CPBClientPushMachine_G_Update_SiteClient Configuration Record (Incoming)
.GCAClientSettingsAssignments_iuObject Replication Manager
.CSVCloudServiceVersion_EventLicense Manager Inbox
.CSDCloudSubscription_CSDReplication Configuration And Monitoring Inbox
.CMNCollection_DelOffer Manager
.ADCCollG_AddCollection Evaluator
.DCCollG_DelCollection Evaluator
.UDCCollG_UpdCollection Evaluator
.CMNColl_Add_OFFERMGROffer Manager
.IACConfigMOF_iuPolicy Provider
.CPCCP_SC_Component_Properties_UpdateClient Configuration Record (Incoming)
.CRPCrpCertChg_NotifyPolicy Targeting Evaluator
.CRPCrpChange_Notify_insPolicy Targeting Evaluator
.CRPCrpResourceChg_NotifyPolicy Targeting Evaluator
.CRPCrpUserChg_NotifyPolicy Targeting Evaluator
.ICPDataLdr_SitesClient Data Files Source Directory
.NSADeviceSiteReassignment_ChgPolicy Provider
.UXDDISCChangeNotifications_insdelPolicy Targeting Evaluator
.CRVDiscPropertyDefs_Ins_DDMDiscovery Data Manager (Notification)
.IACInventoryAction_ChgPolicy Provider
.LPKLanguagePackStatus_ALL_HMANHierarchy Manager
.SLKLicenseKeys_EventLicense Manager Inbox
.LICLicenseRelation_ChgPolicy Provider
.CRTMDMCertificates_EventLicense Manager Inbox
.MEPMEP_ADD_UpdPolicy Provider
.SRCMPAdd_upd_PolicyPvPolicy Provider
.SRCMPDel_upd_PolicyPvPolicy Provider
.SRCMPInfoChg_upd_PolicyPvPolicy Provider
.MRNMtrRule_ChgPolicy Provider
.SCENDES_upd_PolicyPvPolicy Provider
.OFNOfferNotify_AddOffer Manager
.DELOffer_DelOffer Manager
.DPNPeerDPResMap_dPolicy Provider
.DPNPeerDPResMap_iuPolicy Provider
.CMNPolicyTargetEvalNotify_ColMember_iuPolicy Targeting Evaluator
.CCNPolicyTargetEvalNotify_iudPolicy Targeting Evaluator
.SRCPortalInfoChg_upd_PolicyPvPolicy Provider
.SRCPortalInfo_del_PolicyPvPolicy Provider
.CATPortalInfo_upd_PolicyPvPolicy Provider
.ADPreEnrollmentRecords_EventEnrollment Active Directory Service Inbox
.MPCERTSC_SysResUse_Property_CloudMgr_MPCert_InsUpdCloud Services Manager Inbox
.PROXYSC_SysResUse_Site_Server_Site_System_Property_UpdCloud Services Manager Inbox
.CTOServerData_Upd_SiteCtrlSite Control Manager (Master Site Control File)
.CASSiteControl_CAS_Upd_SiteCompSite Component Manager
.SHASiteNotif_Upd_OfferMgrOffer Manager
.MPDELSysResList_CloudMgr_delCloud Services Manager Inbox
.RUCSysResUse_Property_AddUpd_HMAN_SRSHierarchy Manager
.CPCSystem_SMS_Assign_ARR_InsertClient Configuration Record (Incoming)
.UEPUEP_ADD_UpdPolicy Provider
.UKSUnknownToKnownSystem_UpdPolicy Provider
.STNUpdSyncStatus_iuPolicy Provider
.UDAUserMachineRelation_ChgPolicy Provider
.UDAUserMachineSourceRelation_ChgPolicy Provider
.UDAUserMachineTypeRelation_ChgPolicy Provider
.WRCWebServiceInfoChg_upd_PolicyPvPolicy Provider
.WLNWOLMgr_WOLScheduleMap_iuSMS_WAKEONLAN_MANAGER
.AHCAIHinvClass_Upd_DataldrClient Data Files Source Directory (SCCM 2007)
.OTPAMT_Add_OTPSMS_AMT_PROXY_PROV (SCCM 2007)
.CTNCategoryNotify_iudObject Replication Manager (SCCM 2007)
.CEPCEP_ADD_UpdCollection 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

Thursday, January 29, 2015

Failed to Add Update Source for WUAgent of type 2 (Error = 0x80004005)

I ran across an issue this morning where Windows Updates were not getting deployed to a client. I checked the reports, and found that the client was not reporting any missing updates.
I knew this client was not working, as the compliance state was listed as unknown on the SCCM reports. The first thing I check was policy. I was unable to get to the policy editor and that seems tol point to something in this direction.
The execmgr.log was also clean.
Next, I checked the WUAHandler.log and true enough the error is in here

<![LOG[Failed to Add Update Source for WUAgent of type (2) and id ({CEF9E8E9-C241-47CC-B86A-A7380539BF47}). Error = 0x80004005

To resolve issue, delete the C:\Windows\System32\GroupPolicy folder and restart the SCCM Agent.
After which you should see entries similar to the below

<![LOG[Enabling WUA Managed server policy to use server: https://SINWSUS01.intlsos.com:8531]LOG]!><time="11:51:44.524+000" date="01-29-2015" component="WUAHandler" context="" type="1" thread="4228" file="sourcemanager.cpp:1054">
<![LOG[Waiting for 2 mins for Group Policy to notify of WUA policy change...]LOG]!><time="11:51:44.540+000" date="01-29-2015" component="WUAHandler" context="" type="1" thread="4228" file="sourcemanager.cpp:1060">
<![LOG[Waiting for 30 secs for policy to take effect on WU Agent.]LOG]!><time="11:52:05.792+000" date="01-29-2015" component="WUAHandler" context="" type="1" thread="4228" file="sourcemanager.cpp:1124">
<![LOG[Added Update Source ({CEF9E8E9-C241-47CC-B86A-A7380539BF47}) of content type: 2]LOG]!><time="11:52:35.827+000" date="01-29-2015" component="WUAHandler" context="" type="1" thread="4228" file="sourcemanager.cpp:1381">
<![LOG[Async searching of updates using WUAgent started.]LOG]!><time="11:52:35.936+000" date="01-29-2015" component="WUAHandler" context="" type="1" thread="4228" file="cwuahandler.cpp:587">

Monday, January 26, 2015

Backdoor to SQL Database


On a Monday when I am suffering from a sever bout of Garfield's Syndrome, I delete my own admin account which has been assigned sysadmin access to my SQL databases for my reporting server.

Shit! Does it mean I cannot access to the databases any more.
Then i thought of a backdoor method to access the database using the system account.

In order to do this, you will need to have a copy of the psexec which can be downloaded from here. Place this on the server and then in a command prompt execute this command:psexec -i -s SSMS.exe.

Once you are in, you will be able to very much do whatever you like :)