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:

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

from v_R_System [sys]

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

    [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]

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


Leave a Reply

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

You are commenting using your 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: