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
SELECT DISTINCT Guid FROM (SELECT c.[Guid]
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'
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.
MINIMUM REQUIREMENT
Configured Hierarchy environment ITMS 7.1 SP2 with rollup v4
HOW TO INSTALL THIS POINTFIX
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