Hi all,
Thanks for the answers.
Yes, I've found that hotfixes and SP aren't in the catalog so I can't deploy them using Patch Management. I've discovered too that version 7.1 will address this (as I know it seems that this version will appear in May 2011).
In the meantime I need to deploy these hotfixes using Software Management. But, if I'm not wrong, I need to have Inventory plugin working to be able to select the computers where this hotfix is not installed.
My problem is that my computers are Windows 7 and the default filter "Windows Computers without Inventory Plug-in" for the deploy task of the inventory plugin doesn't collect this OS. I've upgraded my CMS installation to SP2 MR3 without results.
Here is the SQL code of the filter:
SELECT vc.[Guid] FROM vRM_Computer vc
JOIN dbo.Inv_AeX_AC_Identification d
ON d._ResourceGuid = vc.Guid
WHERE
vc.[Guid] NOT IN
(
SELECT DISTINCT agent.[_ResourceGuid] FROM Inv_AeX_AC_Client_Agent agent
WHERE agent.[Agent Class Guid] = '11E36ED4-A571-4304-90AA-F0CD2366C335' and [Product Version] like '7.0.%'
)
AND
(
LOWER(d.[OS Name]) LIKE '%windows 2000%'
OR LOWER(d.[OS Name]) LIKE '%windows xp%'
OR LOWER(d.[OS Name]) LIKE '%server 2003%'
OR LOWER(d.[OS Name]) LIKE '%2008%'
OR LOWER(d.[OS Name]) LIKE '%vista%'
OR d.[OS Name] LIKE '%7%'
)
AND d.[System Type] IN ('Win32','Win64')
AND vc.Guid NOT IN
(SELECT _ResourceGuid FROM Inv_AeX_AC_Client_Agent t1
WHERE t1.[Agent Name] = 'Altiris eXpress NS Client'
--AND CAST(t1.[Build Number] as INT) < %AltirisAgentBuildVersion%
AND t1.[Product Version] < SUBSTRING ('%ClientPkgBuild%',0,LEN ('%ClientPkgBuild%') - CHARINDEX ('.',REVERSE ('%ClientPkgBuild%')) + 1)
)
AND vc.[IsManaged] = 1
Why I'm having this problem? Is not solved in my version?
Thanks.