Re: SMS 2003 vs SUS

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Rob Stevens (empty_at_address.com)
Date: 10/13/04 

Date: Wed, 13 Oct 2004 20:53:22 GMT

Figured out the query after a bunch of digging. Here's a copy if anyone is
interested.

-Rob

----------------------------------------------------------------------------
----------------
Select sys.Netbios_Name0, fcm.SiteCode, sys.User_Domain0,
sys.User_Name0, sys.Operating_System_Name_and0
from v_R_System sys
JOIN v_FullCollectionMembership fcm
on sys.ResourceID=fcm.ResourceID
where fcm.CollectionID = 'ABC00025'
and sys.ResourceID not in

(Select sys.ResourceID
FROM v_R_System sys
JOIN v_GS_ADD_REMOVE_PROGRAMS arp
ON sys.ResourceID = arp.ResourceID
JOIN v_FullCollectionMembership fcm
on sys.ResourceID=fcm.ResourceID
WHERE DisplayName0 = 'Windows XP Hotfix - KB885523'
and fcm.CollectionID = 'ABC00025')

Relevant Pages

  • Re: Recovery Console and Goback
    ... just have a bunch of apps cd's. ...
    (microsoft.public.windowsxp.general)
  • What is wrong with this query
    ... from v_R_System sys ... join v_FullCollectionMembership fcm on sys.ResourceID = fcm.ResourceID ... I thought "Install Verified" was a valid string to search ...
    (microsoft.public.sms.admin)
  • Re: codecs - where are those on windows?
    ... that's only the glue code. ... the actual data sets are provided by a bunch ... of built-in modules: ... >>> import sys ...
    (comp.lang.python)
  • Re: Daemonizing python
    ... import os, sys ... print "Entering program" ... Thanks a bunch, Paul. ...
    (comp.lang.python)