Trevor Sullivan's Tech Room

Minding the gap between administration and development

ConfigMgr: Report of VMware Guests Missing VMTools

Posted by Trevor Sullivan on 2011/06/20


I needed to get a report of server systems that are missing the VMware Tools installation. This is pretty easy to do with a subselect query in Microsoft’s System Center Configuration Manager (SCCM / ConfigMgr). Here is the query I put together for this purpose:

select
    [sys].[AD_Site_Name0]
    , [sys].[Name0]
    , [cs].[Manufacturer0]

from v_R_System [sys]

join v_GS_COMPUTER_SYSTEM [cs] on [sys].[ResourceID] = [cs].[ResourceID]

where
    [sys].[ResourceID] not in
    (
        select [sys].ResourceID

        from v_R_System [sys]

        join v_GS_SERVICE [svc] on [sys].[ResourceID] = [svc].[ResourceID]

        join v_GS_COMPUTER_SYSTEM [cs] on [sys].[ResourceID] = [cs].[ResourceID]

        where
            [svc].[Name0] = ‘vmtools’
    )
   
    and [cs].[Manufacturer0] = ‘VMware, Inc.’
    and [sys].[Client0] = 1

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: