KNOWN ISSUE: Delta Resource Membership Update doesn't refresh filters that have recently been replicated


Article ID: 157346


Updated On:


Management Platform (Formerly known as Notification Server)


When the parent replicates a filter, it replaces the filter on the child server and nulls the filter's membership. When the next "delta resource membership update" runs, only partial membership is updated. The customer has to run a complete resource membership update or update the filter manully via the console. This causes a big problem specifically when the "Software Portal Plug-in Policy" gets replicated. It uses the "Windows Computers with installed Software Management Plug-in" which has a guid of '091daff5-...'



The Delta Resource Membership Update populates memberships of those computers that have had a change in the inventory class data since the last Delta Resource Membership Update process. The update process looks at the modified dates of all resources in the resourceupdatesummary table and builds the collection base from the result set on this data. It then joins the filter descriptor with this data to determine the actual membership to be updated for a given filter.

It is very unlikely that ALL computers that belong to a filter will have a change in data since the last Delta Resource Membership Update process.

Below is the process that the "delta resource membership update" uses.

insert #ModifiedResources
select distinct Resourceguid as Guid from ResourceUpdateSummary where DataLastChangedDate > @minupdatedate --'2012-09-14 08:14:39.733'

--minidupdatedate is the last time the delta update ran. If the computer hasn't had any updates to its data classes since the last delta update, it won't be inserted into #ModifiedResources

insert #vRM_Computer
select * from vRM_Computer where Guid in (select m.guid from #ModifiedResources m)

DECLARE @now datetime
SET nocount on
SET @now = GetDate()
TRUNCATE TABLE #CurrentCollectionEval

INSERT INTO #CurrentCollectionEval
FROM #vRM_Computer c
JOIN Inv_AeX_AC_Client_Agent s ON s._ResourceGuid = c.[Guid]
WHERE c.IsManaged = 1
AND s.[Agent Class Guid] = '6E7FDCA4-E61F-4F5B-BE67-CE6E4E1774E1'
AND ( s.[Product Version] LIKE '7.1.%' AND s.[Build Number] > 1600 )
) dsQuery
SET nocount off SELECT @now

set nocount on

execute spDeltaUpdateCollection  @collectionguid = '091daff5-bca2-40aa-a839-28a0416cddc3'



Pointfix 2947893 was created to fix this issue


This Point-fix targets issue described in the incident 2947893: Delta Resource Membership Update doesn't refresh filters that have recently been replicated. This PointFix is intended to solve the issue with Delta Membership Update task, which may not update filers that were recently replicated from Parent NS.




Configured Hierarchy environment ITMS 7.1 SP2 with rollup v4



  1. Extract files from the archive to the NS hard drive. Make sure PointFix is not extracted to Altiris install directory (or any subfolder to it).
  2. Execute PFInstaller.exe under user with administrative privileges (right-click > Run as administrator).
  3. Accept UAC (User Account Control) prompt, select Install Files.

Contact Support if this pointfix is needed. This fix is for v4. A permanent fix will be in 7.1 Sp2 MP1 v2

Applies To

ITMS 7.1 SP2 V4


7.1_SP2_v4_2947893.rar get_app