hello all
trying to get used to the new filters in 7.0.
i'm trying to setup filters- xp computer(s) for showing who has what software, and more importantly who doesn't
i've been trying to use both the guid ID's , and the add/remove displayname like xxxxx.
i can get the filters set to show me who has it, but i'm getting into trouble on who doesn't
using the guid ID's I can see both who has or doesn't but it doesn't differentiate between xp, vista, win 7, 2003 server, etc.. how do i include the os windows xp?
an example is
SELECT DISTINCT
[vri1_Computer].[Guid] AS [_ResourceGuid]
FROM
[vRM_Computer_Item] AS [vri1_Computer]
INNER JOIN [Inv_InstalledSoftware] AS [dca2_InstalledSoftware]
ON [vri1_Computer].[Guid] = [dca2_InstalledSoftware].[_ResourceGuid]
INNER JOIN [vComputerResource] AS [ajs3_vComputerResource]
ON [vri1_Computer].[Guid] = [ajs3_vComputerResource].[Guid]
WHERE
(
(
([ajs3_vComputerResource].[IsManaged] = 1) AND _ResourceGuid IN (SELECT _ResourceGuid FROM
Inv_InstalledSoftware WHERE InstallFlag = 1 AND (_SoftwareComponentGuid = '9b68cc0c-1980-4665-a634-8495add2e363') OR
(_SoftwareComponentGuid = '443c2ce1-b95c-440a-a230-19d509b63a3b')))
)
as for add/remove displayname like xxxxx ,
DECLARE @v1_TrusteeScope nvarchar(122)
SET @v1_TrusteeScope = xxxxxxxxx'
SELECT
[vri2_Computer].[Guid] AS [_ItemGuid],
[vri2_Computer].[Name]
FROM
[vRM_Computer_Item] AS [vri2_Computer]
LEFT OUTER JOIN [Inv_AddRemoveProgram] AS [dca3_AddRemoveProgram]
ON ([vri2_Computer].[Guid] = [dca3_AddRemoveProgram].[_ResourceGuid])
WHERE
(
(
([dca3_AddRemoveProgram].[DisplayName] LIKE N'SoftWareName')
)
AND
([vri2_Computer].[Guid] IN (SELECT [ResourceGuid] FROM [ScopeMembership] WHERE [ScopeCollectionGuid] IN (SELECT [ScopeCollectionGuid] FROM dbo.fnGetTrusteeScopeCollections(@v1_TrusteeScope))))
Also, i've tried to make a filter for just all windows xp computers and put the filter that list all whom have the software, in the exclusions section, and it does not work. Yet i believe that this should work.
thoughts , directions , all are welcome.