Re: Collection based upon pc's with missed patch

You are correct in what we are trying to get

Unfortunately, that showed me every pc we have...over 9500 computers
I know by looking at software updates that we have successfully
patched about 7500, so we should see 2000 in the collection. Thanks
for the quick response

On Feb 21, 1:34 pm, Matthew Hudson
<MatthewHud...@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
Is this what you are looking for, a collection of computers that don't have
this kb listed in the add remove programs? You can also do this through
another query if you have ITMU installed? Let me know if this is what you
want?
------------------------------
select
SMS_R_System.ResourceID,SMS_R_System.ResourceType,SMS_R_System.Name,SMS_R_S­ystem.SMSUniqueIdentifier,SMS_R_System.ResourceDomainORWorkgroup,SMS_R_Syst­em.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 not 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 "%KB931836 %")
--------------------



"gato...@xxxxxxxxxxx" wrote:
I would like to create a collection where KB931836 (dst patch) is not
installed

I have tried saying add/remove where product id does not equal the
above number but it doesn't give the correct results

If anybody can walk me through the specifics or the sql code, I would
appreciate it- Hide quoted text -

- Show quoted text -


.

Relevant Pages

  • RE: How to combine existing collections to include or exclude...
    ... "Matthew Hudson" wrote: ... Servers you want minus the ones you don't want ... Add computers you don't want to show up in Collection B ... will see if I can't just send you the collection queries and the query ...
    (microsoft.public.sms.admin)
  • Re: How to combine existing collections to include or exclude...
    ... "Matthew Hudson" wrote: ... Servers you want minus the ones you don't want ... [edit query statement/Criteria] ... Add computers you don't want to show up in Collection B ...
    (microsoft.public.sms.admin)
  • RE: How to combine existing collections to include or exclude...
    ... "Matthew Hudson" wrote: ... is selecting the computers in my remote offices via AD but limits it only to ... then edit the collection and do a query "Sub selected values" you can then ... This will grab all the computers that are in the limited collected minus the ...
    (microsoft.public.sms.admin)
  • Re: Collection based upon pcs with missed patch
    ... that showed me every pc we have...over 9500 computers ... I know by looking at software updates that we have successfully ... The query looks fine, with one minor exception. ... '%KB931836 %' If you remove the space and re-run the query, ...
    (microsoft.public.sms.inventory)
  • Re: Distribute to user account objects in specific AD group in SCC
    ... For your second query, perhaps try using the subselect 'not in' ... This gave me a list of all the computers in the AD group. ... It does NOT work the same way as users in a usergroup. ... problem upon removing the computer account from the AD group and invoking ...
    (microsoft.public.sms.admin)