Total Views

Tuesday, October 9, 2012

SCCM - Collection Query (Computers with VS 2008 Installed)

select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System inner join SMS_G_System_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceID = SMS_R_System.ResourceId where SMS_G_System_COMPUTER_SYSTEM.Name in (select distinct SMS_G_System_COMPUTER_SYSTEM.Name  from SMS_R_System  inner join SMS_G_System_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceID = SMS_R_System.ResourceId  inner join SMS_G_System_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = SMS_R_System.ResourceId  where SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like "%Visual Studio 2008%")
Posted by at

2 comments:

  1. UnknownNovember 7, 2012 at 10:51 PM

    how about a query that has all the different version of visual studio without the updates.

    so it would have visual studio ultimate 2010
    visual studio premium 2010

    etc,
    please help

    ReplyDelete
  2. Petar MilevNovember 13, 2012 at 7:07 PM

    Hi John,

    Simply remove 2008 from the last row:

    SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like "%Visual Studio%")

    Regards,
    Petar

    ReplyDelete

Subscribe to: Post Comments (Atom)