Client Management Suite

Hello, is it possible to setup a scheduled push to windows 7 machines which don't contain the client?

Would I need to create group/filters?

Also all the computer needing it all have a hostname that begins with the 'PC' prefix. i.e. pc7122

Thanks in advance.

Build a Raw SQL filter like that.

SELECT
   [vri1_Computer].[Guid],
   [vri1_Computer].[Name]
FROM
   [vComputer] AS [vri1_Computer]
WHERE
([vri1_Computer].[OS Name] LIKE '%Windows 7%'
AND [vri1_Computer].[Name] LIKE 'PC%'
AND [vri1_Computer].[IsManaged] =  0)

Use it in the target for the Rollout. It includes all unmanaged Windows 7 computer starting with PC..

Hi, thanks for taking the time to assist me with this issue.

This only brings back two results, im guessing because the CMDB doesn't know which computers are 'Windows 7' with out an agent.

Please could this be modified to excluse %Windows 7% and include

like 'PC7%'

Thanks.

This should do it.

SELECT
   [vri1_Computer].[Guid],
   [vri1_Computer].[Name]
FROM
   [vComputer] AS [vri1_Computer]
WHERE
([vri1_Computer].[Name] LIKE 'PC7%'
AND [vri1_Computer].[IsManaged] =  0)

If you import your computer from AD it should actually fill the OS name. I guess you only discovered yours by simple network discovery?!