Client Management Suite

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.

Create a software resource (e.g. Microsoft Office 2007)

Deploy it using a Managed Software Delivery, targeting the computers you want to have the application (e.g. Windows Workstations)

Right-click on the MSD and choose Reports > Installed Software Report to see who has the software installed.

Right-click on the MSD and choose Reports > Software Compliance Report to see who still requires the software.

Does this work?  It's probably loads easier.

I believe is the idea.

So you have a filter of  machines with xxxx app and another of XP machines. Then you can make a target of :

Exclude Computers not in > Filter > xxxx app

Exclude Conputers not in > Filter > XP machines

If you use Managed Delivery Policies and Detection rules you don't care who's already got the software, just use a filter with all machines you want to have the software as the target and the Managed Delivery Policy will only run the install where it doesb't detect the software already installed.

will look at this

the software had already been pushed out

thanks for the quick responce

will let you know shortly

If you're looking to get a filter with machines w/out a certain software installed, I agree with the suggestions to use the exclusion, this has worked well for me, just make sure to keep it updated if it's not used in any policies).

However, if you want to get a report w/machines missing X software and specifying a particular OS, here is an example of one I put together.  It includes machines missing TWO different pieces of software, but you can easily modify it to look for one.

Basically, you filter for the software name(s) as part of the join and then in the where, you grab null computer names which gives you computers that do NOT have the software.  Beyond that, you can grab a particular OS or whatever other criteria is desired.. 

DECLARE @v1_TrusteeScope nvarchar(max)
   SET @v1_TrusteeScope = N'%TrusteeScope%'
SELECT
   [vri2_Computer].[Name],
   [dca4_AeX AC Identification].[Client Date]
FROM
   [vRM_Computer_Item] AS [vri2_Computer]
      LEFT OUTER JOIN [Inv_AddRemoveProgram] AS [dca3_AddRemoveProgram]
         ON ([vri2_Computer].[Guid] = [dca3_AddRemoveProgram].[_ResourceGuid] AND ([dca3_AddRemoveProgram].DisplayName = N'Symantec Endpoint Protection' OR [dca3_AddRemoveProgram].DisplayName = N'Symantec Antivirus'))

      LEFT OUTER JOIN [Inv_AeX_AC_Identification] AS [dca4_AeX AC Identification]
         ON ([vri2_Computer].[Guid] = [dca4_AeX AC Identification].[_ResourceGuid])

      LEFT OUTER JOIN [vAsset] AS [ajs4_vAsset]
         ON ([vri2_Computer].[Guid] = [ajs4_vAsset].[_ResourceGuid])
      LEFT OUTER JOIN [vOSOperatingSystem] AS [vOS]
         ON ([vri2_Computer].[Guid] = [vOS].[_ResourceGuid])

WHERE
   (
      (
        
            [dca3_AddRemoveProgram].[_ResourceGuid] IS NULL
           AND
            ([ajs4_vAsset].[Status] = N'Active')
           AND
            ([vOS].[Name] LIKE '%Windows XP%')

           
        
      )
      AND
      ([vri2_Computer].[Guid] IN (SELECT [ResourceGuid] FROM [ScopeMembership] WHERE [ScopeCollectionGuid] IN (SELECT [ScopeCollectionGuid] FROM dbo.fnGetTrusteeScopeCollections(@v1_TrusteeScope))))

   )

actually both of the suggestions will work here

put it as Managed Delivery Policies and De livery and then  filter for the software name(s) as part of the join and then in the where, you grab null computer names which gives you computers that do NOT have the software

how does one mark 2 of the suggestions as solution.

thanks for the responces and information