Monday, November 16, 2015

Replication Group Error after SCCM Primary Site Recovery

I encountered a freak issue done by one of our Field IT guys. Well, he un-installled the SQl server that is being used the Primary Site SCCM Server . How is that possible? Well, I seriously do not have the answer for that. Fortunately, we have a working copy of the SCCM backup and so I went about performing the dreaded site recovery. (This part will be cover this in a separate post)
After some time, I managed to recovery the site but just when I was hoping to get some rest, I realized that the database replication between this Primary Site Server and the CAS failed.

The error was found in the rcmctrl.log is "Error: Replication group "General_Site_Data" has failed to initialize for subscribing site C00, setting link state to Error."



To resolve this, the steps are as below
1) Launch SQL server management studio with an account with sysadmin rights
2)  Run the TSQL command below to check the state of replication
select * from RCM_DrsInitializationTracking 
 where replicationGroup = 'General_Site_data' AND SiteFulfilling='P02'

3) To resolve the issue, run the TSQL command below

update RCM_DrsInitializationTracking set InitializationStatus = 7 where ReplicationGroup = 'general_site_data' and SiteRequesting = '<Central Site Code>' and SiteFulfilling = '<Primary Site Code>'

Run the replication link analyser again to check on the status.

Enable verbose logging for SCCM 2012



SCCM logging by default do not provide you with detailed information for you to do advanced analysis. To do so, you will need to enable Verbose / Debug or NAL. This logging will give you much more detailed information, and it will help you location the root of the problem.

Server verbose logging:

1 – open means

0 – off means

SCCM and components:

HKEY_LOCAL_MACHINE \ SOFTWARE \ Microsoft \ SMS \ Tracing \ ENABLED = 1 – (REG_DWORD – General SCCM turn on Logging)

HKEY_LOCAL_MACHINE \ SOFTWARE \ Microsoft \ SMS \ Tracing \ xxxxxxx \ Enabled = 1 – (REG_DWORD – The Role SCCM’de If you change the compositions according to him)

HKEY_LOCAL_MACHINE \ SOFTWARE \ Microsoft \ SMS \ Tracing \ xxxxxxx \ MaxFileSize = 3000000 – (REG_DWORD – 3 MB large – NAL and Debug Logging for growth with more than it is worth)

Important components to be linked to SQL for SQL logging, open the key:

HKEY_LOCAL_MACHINE \ SOFTWARE \ Microsoft \ SMS \ Tracing \ Sqlenabled = 1 – (REG_DWORD)

Component of SQL and SCCM logs, including:

ciamgr.log – SMS_CI_ASSIGNMENT_MANAGER

Colleval.log – SMS_COLLECTION_EVALUATOR

compsumm.log – SMS_COMPONENT_STATUS_SUMMARIZER

Dataldr.log – SMS_INVENTORY_DATA_LOADER

ddm.log – SMS_DISCOVERY_DATA_MANAGER

Distmgr.log – SMS_DISTRIBUTION_MANAGER

Hman.log – SMS_HIERARCHY_MANAGER

objreplmgr.log – SMS_OBJECT_REPLICATION_MANAGER

offermgr.log – SMS_OFFER_MANAGER

Offersum.log – SMS_OFFER_STATUS_SUMMARIZER

policypv.log – SMS_POLICY_PROVIDER

sinvproc.log – SMS_SOFTWARE_INVENTORY_PROCESSOR

Sitestat.log – SMS_SITE_SYSTEM_STATUS_SUMMARIZER

smsdbmon.log – SMS_DATABASE_NOTIFICATION_MONITOR

statesys.log – SMS_STATE_SYSTEM

Statmgr.log – SMS_STATUS_MANAGER

swmproc.log – SMS_SOFTWARE_METERING_PROCESSOR

wcm.log – SMS_WSUS_CONFIGURATION_MANAGER

wsyncmgr.log – SMS_WSUS_SYNC_MANAGER

SMS Provider

HKEY_LOCAL_MACHINE \ Software \ Microsoft \ SMS \ Providers \ Logging Level = 1 – (REG_DWORD)

HKEY_LOCAL_MACHINE \ Software \ Microsoft \ SMS \ Providers \ SQL Cache Logging Level = 1 – (REG_DWORD)

HKEY_LOCAL_MACHINE \ Software \ Microsoft \ SMS \ Providers \ Log Size MB = 1 – (REG_DWORD)

SCCM logumuz with logging provider are as follows:

Smsprov.log

NAL logging:

Sometimes it may be enough, and NAL logging verbose logging information in the pop-up. Caution: NAL logging Log file too big for him, keeping detailed logs have benefits.

HKEY_LOCAL_MACHINE \ SOFTWARE \ Microsoft \ NAL \ Logging

– DataType: REG_DWORD – Log To = 3

– DataType: REG_DWORD – Verbosity = 7

NAL logging, set the values:

NAL_LOG_VERBOSITY_LEVEL_1 = Errors

NAL_LOG_VERBOSITY_LEVEL_2 = Warnings

NAL_LOG_VERBOSITY_LEVEL_4 = Information

NAL_LOG_VERBOSITY_LEVEL_7 = Errors, Warnings, Information

SCCM loglarımız with NAL logging are as follows:

compsumm.log – SMS_COMPONENT_STATUS_SUMMARIZER

Distmgr.log – SMS_DISTRIBUTION_MANAGER

inboxmgr.log – SMS_INBOX_MANAGER

ntsvrdis.log – SMS_WINNT_SERVER_DISCOVERY_AGENT

sitecomp.log – SMS_SITE_COMPONENT_MANAGER

Sitestat.log – SMS_SITE_SYSTEM_STATUS_SUMMARIZER

smsexec.log – SMS_EXECUTIVE

IMPORTANT:Registry changes to work:

Stop the SMS_SITE_COMPONENT_MANAGER

Stop the SMS_EXECUTIVE

Start the SMS_EXECUTIVE

Start SMS_SITE_COMPONENT_MANAGER

SCCM Agent (Workstation):

CCM for the verbose logging:

For Administrator Key, “full rights” to provide the necessary – there is no default.

HKEY_LOCAL_MACHINE \ SOFTWARE \ Microsoft \ CCM \ Logging \ @ GLOBAL

Set of the following values:

LogEnabled = 1

LogLevel = 0

LogMaxSize = 40000000

LogDirectory = c: \ windows \ system32 \ ccm \ logs (If you want to print the logs to a different location)

LogMaxHistory = 1 (Although the size of the logs filled with incense,> here is one: will be holding an old log. Example: Execmgr.log and will execmgr.lo_.
Verbose logging is not enough DebugLogging CCM:

This is necessary to create the reg KEYI:

HKEY_LOCAL_MACHINE \ SOFTWARE \ Microsoft \ CCM \ Logging \ DebugLogging

– DataType: REG_SZ – Enabled = TRUE

WMI:

SCCM agent is based entirely WMI WMI is useful to turn verbose logging:

HKEY_LOCAL_MACHINE \ SOFTWARE \ Microsoft \ WBEM \ CIMOM \ Logging = 0 – (REG_SZ – Disabled)

HKEY_LOCAL_MACHINE \ SOFTWARE \ Microsoft \ WBEM \ CIMOM \ Logging = 1 – (REG_SZ – Error only)

HKEY_LOCAL_MACHINE \ SOFTWARE \ Microsoft \ WBEM \ CIMOM \ Logging = 2 – (REG_SZ – Verbose)
HKEY_LOCAL_MACHINE \ SOFTWARE \ Microsoft \ WBEM \ CIMOM \ Log File Max Size = 4000000 – (REG_DWORD – If you need to WMI 2)

IMPORTANT: To study the changes of registry and WMI:

Restart the Computer

Other important components are: WSUS + SCCM component:

Set HKLM \ SOFTWARE \ Microsoft \ SMS \ Components \ SMS_WSUS_SYNC_MANAGER

– DataType: REG_DWORD – LogLevel = 3
LOG_SUMMARY = 1;

LOG_DETAIL = 2; default

LOG_VERBOSE = 3;

LOG_DEBUG = 4;

Wednesday, October 21, 2015

SCCM Client Health State

Every SCCM Admin would have been asked this question, "Can you tell me which Client is not communicating back to the primary site server?"
All of us admin would know that a SCCM client is of no use if it does not communicate correctly back to the primary site server.
If it does not communicate, it will be be able to retrieve any machine policy.
If it does not communicate, it will be be able to send back the inventory information back to the Primary Site Server.
And of course the list goes on....

Using the query below, you will be able to do just that.
With the information that is made available, you will then be able to troubleshoot the client that are not working as expected.

SELECT [SMSID]
      ,[FQDN]
      ,[NetBiosName]
      ,[AssignedSiteCode]
      ,[HealthType]
      ,[HealthState]
      ,[HealthStateName]
      ,[ErrorCode]
      ,[ExtendedErrorCode]
      ,[LastHealthReportDate]
      ,substring(OU.System_OU_Name0,15,3) [Site]

  FROM [CM_C00].[dbo].[v_ClientHealthState] CHS
  left join v_R_System VRS on  VRS.Name0 = CHS.NetBiosName
  left join v_RA_System_SystemOUName OU on ou.ResourceID = VRS.ResourceID

order by HealthState desc


Friday, October 2, 2015

Capturing Windows Activation Key by SCCM

Most of the enterprise that are using Windows as the Operating System would most likely be using Microsoft Multiple Activation Keys or MAk for short for licensing.
There maybe a day which come when you may need to figure out how to get the number of clients in your environment that are activated using a particular product key. (This will NOT work for MAK but if needed, you can still use the generated product ID to tied to a valid ID)
This information unfortunately is not readily available in SCCM and would require some work to have it available.

The VBS that has been written below enables you to be able to retrieve the MAK and store it in a registry key (in the script, I have stored it on HKLM\Software\SCCM\ActivationKey).
Once you have this value available, you will be able to by means of SCCM to do a hardware inventory to retrieve the information and format it accordingly for use.
Hopefully this helps anyone who requires this.

Option Explicit 

Const HKEY_LOCAL_MACHINE = &H80000002
Dim objshell,path,DigitalID, Result ,Strcomputer,objregistry,strkeypath,strvaluename,strvalue,strvaluename1
Set objshell = CreateObject("WScript.Shell")
'Set registry key path
Path = "HKLM\SOFTWARE\Microsoft\Windows NT\CurrentVersion\"
'Registry key value
DigitalID = objshell.RegRead(Path & "DigitalProductId4")
Dim ProductName,ProductID,ProductKey,ProductData
'Get ProductName, ProductID, ProductKey
ProductName = "Product Name: " & objshell.RegRead(Path & "ProductName")
ProductID = "Product ID: " & objshell.RegRead(Path & "ProductID")
ProductKey = ConvertToKey(DigitalID) 
ProductData = ProductName  & vbNewLine & ProductID  & vbNewLine & ProductKey
'wscript.echo ProductData

strComputer = "."
Set objRegistry = GetObject("winmgmts:\\" & _ 
    strComputer & "\root\default:StdRegProv")

'Check for the existance of the key and create if it's not found.
strKeyPath = "SOFTWARE\SCCM\"
strValueName = "ActivationKey"
objRegistry.GetStringValue HKEY_LOCAL_MACHINE,strKeyPath,strValueName,strValue

If IsNull(strValue) Then

objregistry.CreateKey HKEY_LOCAL_MACHINE,strKeyPath
StrValueName1 = "ActivationKey"

objRegistry.SetStringValue HKEY_Local_Machine, strKeyPath, strValueName1,ProductKey

End If

'Convert binary to chars
Function ConvertToKey(Key)
    Const KeyOffset = 52
    Dim isWin8, Maps, i, j, Current, KeyOutput, Last, keypart1, insert
    'Check if OS is Windows 8
    isWin8 = (Key(66) \ 6) And 1
    Key(66) = (Key(66) And &HF7) Or ((isWin8 And 2) * 4)
    i = 24
    Maps = "BCDFGHJKMPQRTVWXY2346789"
    Do
        Current= 0
        j = 14
        Do
           Current = Current* 256
           Current = Key(j + KeyOffset) + Current
           Key(j + KeyOffset) = (Current \ 24)
           Current=Current Mod 24
            j = j -1
        Loop While j >= 0
        i = i -1
        KeyOutput = Mid(Maps,Current+ 1, 1) & KeyOutput
        Last = Current
    Loop While i >= 0 
    keypart1 = Mid(KeyOutput, 2, Last)
    insert = "N"
    KeyOutput = Replace(KeyOutput, keypart1, keypart1 & insert, 2, 1, 0)
    If Last = 0 Then KeyOutput = insert & KeyOutput
    ConvertToKey = Mid(KeyOutput, 1, 5) & "-" & Mid(KeyOutput, 6, 5) & "-" & Mid(KeyOutput, 11, 5) & "-" & Mid(KeyOutput, 16, 5) & "-" & Mid(KeyOutput, 21, 5)
   
    
End Function

Wednesday, September 30, 2015

Bridgeways Management Packs

BridgeWays, leading developers in monitoring, reporting and analytics software offers a variety of Management Packs for System Center Operation Manager.
Using BridgeWays Management Packs, you no longer need to monitor and manage other systems and applications using several disparate tools. Monitor your complete IT environment, bringing end-to-end visibility within a single, pane-of-glass view and reducing your total cost of ownership of Microsoft System Center.
In most enterprise there would be  critical in-house custom applications that requires monitoring.
Bridgeways will be able to help you with that by providing you custom management pack solutions. It can be a great solution for companies that are not familiar with System Center Operations Manager
This video shows a case study with BridgeWays Management Packs Dataport.
This video shows the features and benefits that you can expect to reap from using BridgeWays Management Packs.


The complete list of all available management packs offered by Bridgeways is listed below together with the features

You can contact BridgeWays using the links provided in each products to start a free trial or requests a quote.

Friday, July 10, 2015

Determining installed applications last use time

ConfigMgr will definitely be able to let SCCM admins know what are installed in the environment regardless if it is a server or workstation. SCCM by default comes with a set of reports that SCCM admins can utilize to gather information. The one that I am going to mention today is , "Computers that has a metered program but have not run the program since a specific date". What is so special about this report you may think, I had the same thinking as you but it is pretty interesting to know how is this data derived.
The data set for this is based on Software Inventory and this means gathering file types that are on machines. The last used time is gathered asp art of software metering.
This report will provide the information based on the files inventoried and their respective last used date. Nothing unique right?
Here comes the interesting part, picture the scenario as below.
All of us will know that in order for Microsoft Office to be used, it has to be installed and after installation, it will appear under the machine's add/remove program. This report which I mentioned reports based on not a usable application but just the executable file. This means that if I copy excel.exe from another machine to my desktop, it will take it that a working copy of Excel exists of my machine and report against that. Not very smart and logical huh?
For me, I would require to report against what has been installed and not used and not any executable files that is related to the application.
To address this, I have put together my own query as below. Hopefully it would help someone who could be in the same boat as I was. :)

select 
distinct VRS1.Name0,arp1.DisplayName0,z.ProductName,z.[Last Use],
case
when VRS1.Obsolete0 = 0  then 'Active'
when VRS1.Obsolete0 = 1  then 'inactive'
end as [SCCM Client Status]
,z.FileName,substring(OU.System_OU_Name0,15,3) [Site],VRS1.User_Name0,
case 
when d.IsMobile0 = 1 then 'Laptop'                
when d.IsMobile0 = 0  and e.SystemRole0 = 'Workstation' then 'Desktop'
when d.IsMobile0 = 0  and e.SystemRole0 = 'Server' then 'Server'
end as [Type]
from v_Add_Remove_Programs ARP1
Left join(Select distinct VRS.resourceid,VRS.name0,ARP.DisplayName0, mf.ProductName,
MF.FileName,MAX(mu.LastUsage)[Last Use]

from v_R_System VRS
left join v_MonthlyUsageSummary MU on MU.ResourceID = VRS.ResourceID
left join v_Add_Remove_Programs ARP on vrs.ResourceID = arp.ResourceID
left join v_MeteredFiles MF on MF.MeteredFileID = Mu.FileID

where arp.DisplayName0 like '%App Name%' and  mf.FileName = 'App Exe File'
Group by vrs.Name0,vrs.ResourceID,arp.DisplayName0,MF.FileName,mf.productname)Z on z.ResourceID = ARP1.resourceid
Left join v_R_System VRS1 on VRS1.ResourceID = ARP1.ResourceID
left join v_RA_System_SystemOUName OU on ou.ResourceID = VRS1.ResourceID
inner join v_GS_PROCESSOR d on d.ResourceID = VRS1.ResourceID
inner join v_GS_SYSTEM e on e.ResourceID = VRS1.resourceid

where arp1.DisplayName0 like '%App Name%' and vrs1.Name0 is not null

Friday, July 3, 2015

Query for SCCM 2012 DP Status Overview

SCCM Distribution points as we may know is an important part of an SCCM Setup.
A distribution point which is not operational due to various reasons would have repercussion effects on a package deployment. Issues that arises may be from the perspective of network bandwidth etc.
It is always welcome to have a single pane view of teh status of anything that we need to have visibility on and this includes the status of the DPs.
The SQL query below will enable you to gain that "Single Pane" view from the available disk space as well as the settings that are configured which is inclusive of Transfer rate among others.

SELECT [ServerName]
     ,IB.[SiteCode]
      ,[Priority]
      ,[TransferRate]
      ,[IsProtected]
      ,[PreStagingAllowed]
      ,[ResourceType]
      ,[SiteName]
      ,[DPFlags]
      ,[Name]
      ,[ID]
      ,[IsPXE]
      ,[IsActive]
      ,[ResponseDelay]
      ,[UdaSetting]
      ,[BindPolicy]
      ,[SupportUnknownMachines]
      ,[PXEPassword]
      ,[GroupCount]
      ,[HasRelationship]
      ,[InternetFacing]
      ,[HealthCheckEnabled]
      ,[HealthCheckPriority]
      ,[HealthCheckSchedule]
      ,[AddressScheduleEnabled]
      ,[RateLimitsEnabled]
     , DI.Drive
,DI.PercentFree
,DI.BytesFree
  FROM [CM_C00].[dbo].[v_DistributionPointInfoBase] IB
  left join dbo.v_DistributionPointDriveInfo DI on DI.NALPath = IB.NALPath

Thursday, June 18, 2015

Mass deleting Obsolete SCCM Clients

I would believe that every SCCM Admin would at some point of time need to cleanup obsolete SCCM Client objects from the SCCM Sites.
Most of the time when this is needed, all you will be provided is a list of the machines that are no longer in Active Directory and these SCCM Clients has to be purged from SCCM.
For this purpose, the below VBS will do just that

ON ERROR RESUME NEXT
Const ForReading = 1, ForWriting = 2, ForAppending = 8
Const TristateUseDefault = -2, TristateTrue = -1, TristateFalse = 0
I = 0

strServer=InputBox("Enter Site Server Nmae",,"SCCM-Pri-Site-Server")
strSiteCode=InputBox("Enter Site Code",,"P01")


Set fso = CreateObject("Scripting.FileSystemObject")
strfolder = fso.GetParentFolderName(wscript.ScriptFullName) 

'You may replace obsolete.txt with any text file name you prefer. The contents of this file is used to list out the SCCM clients that are to be purged.
FileName = strfolder & "\Obsolete.txt"
'Set objFSO = CreateObject("Scripting.FileSystemObject")
Set objFile = fso.OpenTextFile(Filename,ForReading)
strmachine = objFile.ReadAll
objFile.Close


arrcomp = split(strmachine, vbCrLf)
if isnull(strmachine) then
wscript.echo "No Machine info"
Else
For each strmachine in arrcomp
strcomputer = strmachine
Set locator = CreateObject("WbemScripting.SWbemLocator")
Set WbemServices1 = locator.ConnectServer(strServer,"root\SMS\site_" & strSiteCode)
ResID = getResID(strComputer, WbemServices1)


Set sResource = WbemServices1.Get("SMS_R_System='" & ResID & "'")
sResource.Delete_
Set sResource = Nothing
I = I +1
next

wscript.echo "Housekeep Done! A total of " & I & " obsolete SCCM records were deleted"
End if

Function getResID(strComputer, oWbem)
strQry = "Select ResourceID from SMS_R_System where Name=" & "'" & strComputer & "'"
Set objEnumerator = oWbem.ExecQuery(strQry)
If Err <> 0 Then
GetResID = 0
Exit Function
End If
For Each objInstance in objEnumerator
For Each oProp in objInstance.Properties_
GetResID = oProp.Value
Next
Next
Set objEnumerator = Nothing
End Function

Tuesday, June 9, 2015

Monitoring GPO changes using SCOM

It is pretty common for AD admins to want to be able to monitor changes to GPO via SCOM.
Of course, there are events that are logged for every change made to any GPO.
The real challenge is that we will not be able to know which GPO was changed without having to go through an extensive search through the GPMC or by means of powershell.
What is required is that the SCOM alert should include the name of the GPO so that the efforts and time of the IT Admins are keep to the minimum.

The below is an article from the community that will enable you to do just that
Click here

Wednesday, May 27, 2015

Translate SCOM GUID to hostname

In SCOM RMS Event log, you may receive events that flag issues about a healthservice.
The challenge that SCOM Admins face is that these events merely provide the GUID.
In order for the remediation to be done, what is needed is the exact hostname of the server that is having the issues.

There are 2 ways that this information required can be retrieved.
You can choose either ways and you will still get the information

Powershell

(Get-MonitoringObject -id 'GUID').DisplayName
or
SQL
If you have access to the SQL Database, you can run the query as below

select DisplayName, Path, basemanagedentityid from basemanagedentity where basemanagedentityid = 'GUID'

Thursday, May 21, 2015

Lync 2013 Client unable to see / add contacts

Encountered an interesting issue in our environment.
There is small pockets of users that encounter an issue of being unable to see existing contacts and add new contacts to their respective Lync clients.
The Lync client version were updated to the latest build of 15.0.4719.1000 but that did not help.
The error that they encountered is "Cannot add,remove or move contacts or groups at this time. Please try again later" as per the screenshot below












Resolution

Perform the actions below on the Lync client affected

  1. Go to Tools/Options
  2. On the pop up window, select Personal from the list on the right
  3. Change the personal information manager setting to None for at least 30 minutes (This will be based on your active directory replication interval)
  4. Then switch it back to Microsoft Exchange or Microsoft Outlook

Wednesday, April 22, 2015

SCCM MIF File Generator

This VBS will provide you with a mean to generate the NOIDMIF.mif files for SCCM clients based on a pre-populated Excel sheet. It has been shared in the Microsoft Community Gallery and it can be downloaded here.

Output MIF File will be similar to the screenshot below
Pre-work
1) The excelsheet should be populated base don the format below with the Values in Column A to C based on your own information of Ship Date (Aka Purchase Date) and Known Hardware Warranty Date.
The Excel should be named as ServersInventory.xlsx for servers and computersinventory.xlsx for clients.
 
2) The file should be executed on a machine with Excel installed
3) Modify the struser and strpwd in the vbs to the necessary credentials to enable the MIF files generated to be copied to the target mahcine
How to use
1) Save the excel files and the downloaded vbs file in the same folder
2) Execute the vbs
3) Enter 1 if you populating for servers and 2 if its for workstations/notebooks
4) Enter the OU that you wish to target against
Outcome
1) A scan will be done on the the specified OU against the information available in the excel sheet.
2) MIF files will be generated and copied for matches found and the machine name will be populated in the excel. (Screenshot as below)



Thursday, March 26, 2015

SSRS Reporting Structure Mapping

Documenting the structure of the SSRS reporting is often.
The below would enable you to be provide with the output in the sample screenshot with much ease.



--QUERY 1
USE ReportServer
GO

SELECT 
CASE WHEN C.Name = '' THEN 'Home' ELSE C.Name END AS ItemName, 
C.Description as Report_Description,
LEN(C.Path) - LEN(REPLACE(C.Path, '/', '')) AS ItemLevel, 
CASE 
WHEN C.type = 1 THEN '1-Folder' 
WHEN C.type = 2 THEN '2-Report' 
WHEN C.type = 3 THEN '3-File' 
WHEN C.type = 4 THEN '4-Linked Report' 
WHEN C.type = 5 THEN '5-Datasource' 
WHEN C.type = 6 THEN '6-Model' 
WHEN C.type = 7 Then '7-ReportPart'
WHEN C.type = 8 Then '8-Shared Dataset'
ELSE '9-Unknown' END AS ItemType, 
CASE WHEN C.Path = '' THEN 'Home' ELSE C.Path END AS Path, 
ISNULL(CASE WHEN CP.Name = '' THEN 'Home' ELSE CP.Name END, 'Home') AS ParentName, 
ISNULL(LEN(CP.Path) - LEN(REPLACE(CP.Path, '/', '')), 0) AS ParentLevel,
ISNULL(CASE WHEN CP.Path = '' THEN ' Home' ELSE CP.Path END, ' Home') AS ParentPath 
FROM 
dbo.Catalog AS CP 
RIGHT OUTER JOIN
dbo.Catalog AS C ON CP.ItemID = C.ParentID


The below will provide a much more detailed report level including who created and modified the report, when was the last exection  etc

USE ReportServer
GO

SELECT
CAT_PARENT.Name AS ParentName,
CAT.Name AS ReportName,
ReportCreatedByUsers.UserName AS ReportCreatedByUserName,
CAT.CreationDate AS ReportCreationDate,
ReportModifiedByUsers.UserName AS ReportModifiedByUserName,
CAT.ModifiedDate AS ReportModifiedDate,
CountExecution.CountStart AS ReportExecuteCount,
EL.InstanceName AS LastExecutedServerName,
EL.UserName AS LastExecutedbyUserName,
EL.TimeStart AS LastExecutedTimeStart,
EL.TimeEnd AS LastExecutedTimeEnd,
EL.Status AS LastExecutedStatus,
EL.ByteCount AS LastExecutedByteCount,
EL.[RowCount] AS LastExecutedRowCount,
SubscriptionOwner.UserName AS SubscriptionOwnerUserName,
SubscriptionModifiedByUsers.UserName AS SubscriptionModifiedByUserName,
SUB.ModifiedDate AS SubscriptionModifiedDate,
SUB.Description AS SubscriptionDescription,
SUB.LastStatus AS SubscriptionLastStatus,
SUB.LastRunTime AS SubscriptionLastRunTime
FROM
dbo.Catalog CAT
INNER JOIN
dbo.Catalog CAT_PARENT
ON 
CAT.ParentID = CAT_PARENT.ItemID
INNER JOIN
dbo.Users ReportCreatedByUsers
ON 
CAT.CreatedByID = ReportCreatedByUsers.UserID
INNER JOIN
dbo.Users ReportModifiedByUsers
ON 
CAT.ModifiedByID = ReportModifiedByUsers.UserID
LEFT OUTER JOIN
(
SELECT
ReportID,
MAX(TimeStart) LastTimeStart
FROM
dbo.ExecutionLog
GROUP BY
ReportID
) AS LatestExecution
ON 
CAT.ItemID = LatestExecution.ReportID
LEFT OUTER JOIN
(
SELECT
ReportID,
COUNT(TimeStart) CountStart
FROM
dbo.ExecutionLog
GROUP BY
ReportID
) AS CountExecution
ON 
CAT.ItemID = CountExecution.ReportID
LEFT OUTER JOIN
dbo.ExecutionLog AS EL
ON 
LatestExecution.ReportID = EL.ReportID
AND 
LatestExecution.LastTimeStart = EL.TimeStart
LEFT OUTER JOIN
dbo.Subscriptions SUB
ON 
CAT.ItemID = SUB.Report_OID
LEFT OUTER JOIN
dbo.Users SubscriptionOwner
ON 
SUB.OwnerID = SubscriptionOwner.UserID
LEFT OUTER JOIN
dbo.Users SubscriptionModifiedByUsers
ON
SUB.ModifiedByID = SubscriptionModifiedByUsers.UserID
ORDER BY
CAT_PARENT.Name,
CAT.Name

Wednesday, March 25, 2015

Retrieve monitors and rules on SCOM Agent

For SCOM admins, there is always a need to know what a servers has been monitored for.
There is a powershell that is provided by 2 MVPs previously (Stefan Stranger and Jeremy Pavleck) which serves this purpose.

To use run from OpsMgr Command Shell:
Get-OpsMgrWorkflows_v1.ps1 -agentname "myagent.contoso.com" | export-csv -path c:\temp\workflows.csv

Save the below as Get-OpsMgrWorkflows_v1.ps1
        
#param ([string]$agentname = $(read-host "Please enter OpsMgr Agent Name"))             
            
function Get-AgentWorkflow($agentname)            
{            
 #Original Script from Jeremy Pavleck.            
 #http://www.pavleck.net/2008/06/sp1-gem-finding-rules-running-on-remote-agents/            
 #Use the OpsMgr Task Show Running Rules and Monitors.            
 $taskobj = Get-Task | Where-Object {$_.Name -eq "Microsoft.SystemCenter.GetAllRunningWorkflows"}            
             
 # Grab HealthService class object            
 $hsobj = Get-MonitoringClass -name "Microsoft.SystemCenter.HealthService"            
 # Find HealthService object defined for named server            
 $monobj = Get-MonitoringObject -MonitoringClass $hsobj | Where-Object {$_.DisplayName -match $agentname}            
             
 #Start Task GetAllRunningWorkflows            
 $taskOut = Start-Task -Task $taskobj -TargetMonitoringObject $monobj            
 [xml]$taskXML = $taskOut.OutPut             
             
 #Get Workflows            
 $workflows=$taskXML.selectnodes("/DataItem/Details/Instance/Workflow")            
             
 #Retrieve Monitors            
 $monitors = get-monitor            
             
 #Retrieve Rules            
 $rules = get-rule            
             
 #Retrieve Discoveries"            
 #Used the Group-object because there are some discovery rules with the same DisplayName            
 $discoveries = get-discovery | select-object -Unique            
             
 #Get Overrides"            
 #monitoroverrides = foreach ($monitor in Get-ManagementPack | get-override | where {$_.monitor}) {get-monitor | where {$_.Id -eq $monitor.monitor.id}}            
 #$rulesoverrides = foreach ($rule in Get-ManagementPack | get-override | where {$_.rule}) {get-rule | where {$_.Id -eq $rule.rule.id}}            
 #$discoveryoverrides = foreach ($discovery in Get-ManagementPack | get-override | where {$_.discovery}) {get-discovery | where {$_.Id -eq $discovery.discovery.id}}            
            
            
 #Check for each workflow if it's a Rule or Monitor or Discovery.            
 foreach ($workflow in $workflows)            
 {            
  #Check for Monitor            
  $monitor = $monitors | where-object {$_.Name -eq $workflow."#text"}            
              
  if ($monitor -eq $null)            
  {            
   #Check for Rule            
   $rule = $rules | where-object {$_.Name -eq $workflow."#text"}            
   if ($rule -eq $null)            
   {             
    #Check for Discovery            
    $discovery = $discoveries | where-object {$_.Name -eq $workflow."#text"}            
    if ($discovery -eq $null)            
    {            
                
    }            
    else            
    {            
     #Get ManagementPack            
     $mp = $discovery.getmanagementpack()            
     #Check if Discovery has an override            
     #$flag = $discoveryoverrides | Where-Object {$_.DisplayName -eq $discovery.DisplayName}            
     #if ($flag -eq $null)            
     #{            
     # $override = "false"            
     #}            
     #else            
     #{            
     # $override = "true"            
     #}            
     $discobject = new-object System.Management.Automation.PSObject            
     $discobject = $discobject | add-member -membertype NoteProperty -name Type -value "Discovery" -passthru            
     $discobject = $discobject | add-member -membertype NoteProperty -name DisplayName -value $discovery.DisplayName -passthru            
     $discobject = $discobject | add-member -membertype NoteProperty -name Description -value $discovery.Description -passthru            
     #$discobject = $discobject | add-member -membertype NoteProperty -name Override -value $override -passthru            
     $discobject = $discobject | add-member -membertype NoteProperty -name ManagementPack -value $mp.DisplayName -passthru            
     $discobject            
    }            
   }            
   else            
   {            
    $mp = $rule.getmanagementpack()            
    #Check if Rule has an override            
    #$flag = $ruleoverrides | Where-Object {$_.DisplayName -eq $rule.DisplayName}            
    #if ($flag -eq $null)            
    #{            
    # $override = "false"            
    #}            
    #else            
    #{            
    # $override = "true"            
    #}            
    $ruleobject = new-object System.Management.Automation.PSObject            
    $ruleobject = $ruleobject | add-member -membertype NoteProperty -name Type -value "Rule" -passthru            
    $ruleobject = $ruleobject | add-member -membertype NoteProperty -name DisplayName -value $rule.DisplayName -passthru            
    $ruleobject = $ruleobject | add-member -membertype NoteProperty -name Description -value $rule.Description -passthru            
    #$ruleobject = $ruleobject | add-member -membertype NoteProperty -name Override -value $override -passthru            
    $ruleobject = $ruleobject | add-member -membertype NoteProperty -name ManagementPack -value $mp.DisplayName -passthru            
    $ruleobject            
   }            
  }            
  else            
  {            
   #Get ManagementPack for Monitor            
   $mp = $monitor.getmanagementpack()            
   #Check if Monitor has an override            
   #$flag = $monitoroverrides | Where-Object {$_.DisplayName -eq $monitor.DisplayName}            
   #if ($flag -eq $null)            
   #{            
   # $override = "false"            
   #}            
   #else            
   #{            
   # $override = "true"            
   #}            
   $monitorobject = new-object System.Management.Automation.PSObject            
   $monitorobject = $monitorobject | add-member -membertype NoteProperty -name Type -value "Monitor" -passthru            
   $monitorobject = $monitorobject | add-member -membertype NoteProperty -name DisplayName -value $monitor.DisplayName -passthru            
   $monitorobject = $monitorobject | add-member -membertype NoteProperty -name Description -value $monitor.Description -passthru            
   #$monitorobject = $monitorobject | add-member -membertype NoteProperty -name Override -value $override -passthru            
   $monitorobject = $monitorobject | add-member -membertype NoteProperty -name ManagementPack -value $mp.DisplayName -passthru            
   $monitorobject            
  }            
 }            
            
            
}            
            
Get-AgentWorkflow $agentname

Thursday, March 12, 2015

Windows Update Failed: Error Downloading Update

Windows update is a used by many IT Admin to keep the servers they manage to be updated with the latest patches so that it is compliant.
There could be times when the update failed to download for whatever reason and looking deeping into the issue can be done by going through the WindowsUpdate.log file located at C;\Windows.

For this instance, the update failed to download and you will see the error "0x80070005 occured while downloading update"

To resolve this issue, what is needed is just to stop the indexing service.
Once it id stopped, you can go ahead to attempt the Windows Update again.

Wednesday, March 11, 2015

ConfigMgr Software Update State: Enforcement State Unknown

I have pretty sure many SCCM admin would have encountered the infamous status of "Enforcement State Unknown" for Software Updates deployment via SCCM.



All the logs such as WUhandler,log etc looks normal and you could be pulling out your hair to get this resolved.
What can be done is to force a full resync of the state of the server to the primary site server.
This can be accomplished by adding the below copying the code below into a vbs file and execute it on the problem server

' Initialize the UpdatesStore variable. 
dim newCCMUpdatesStore 
' Create the COM object. 
set newCCMUpdatesStore = CreateObject ("Microsoft.CCM.UpdatesStore") 
' Refresh the server compliance state by running the RefreshServerComplianceState method. 
newCCMUpdatesStore.RefreshServerComplianceState

Once it is executed, you should see in the UpdatesStore.log file that the "Resend status completed successfully"


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