SMS 2003 vs SUS
From: Rob Stevens (empty_at_address.com)
Date: 10/12/04
- Next message: John Potter: "SMS Distribution Point Question"
- Previous message: Rhonda: "RE: Query to show who last logged at a specific machine"
- Next in thread: Rob Stevens: "Re: SMS 2003 vs SUS"
- Reply: Rob Stevens: "Re: SMS 2003 vs SUS"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 12 Oct 2004 20:36:25 GMT
Hi All,
I have a client that has been actively using SUS server to deploy patches.
We are installing SMS 2003 and they would prefer to use the SUS server for
general patch management since they are used to it / it's easier to just
click on the updates etc..
My questions are:
A: Is there a way to add all the updates into SMS that show up in SUS using
syncxml.exe or is it just a fact that syncxml.exe only discovers
vulnerabilities and not general windows update type items. (This is a big
reason they want to stick with SUS) I understand that they can download them
manually and distribute them as regular packages but they do not want to do
this.
B: If they do stick with SUS, they would like to use SMS to report on the
patch installation status for all the machines. What I'd like to be able to
leave them with is a report that shows "Computers WITHOUT specific software
registered in Add Remove Programs" so they can simply enter in the patch
number or any other software title into the prompt, and display all the
machines that do not have the patch / software installed.
I'm having a hard time wrapping my head around how to reverse the built in
report that shows computers with specific software registered.
This SQL query below is obviously broken since it retrieves every
DisplayName0 instance that is not like my example patch. How would I limit
the query to just retrieve the machines that do not have the software
installed without listing every single item?
Thanks in advance for any help or thoughts!
-Rob
----------------------------------------------------------------------------
--------
Select sys.Netbios_Name0, fcm.SiteCode, sys.User_Domain0,
sys.User_Name0, sys.Operating_System_Name_and0, arp.DisplayName0
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 not like 'Windows XP Hotfix - KB885523'
and fcm.CollectionID = 'ABC00025'
- Next message: John Potter: "SMS Distribution Point Question"
- Previous message: Rhonda: "RE: Query to show who last logged at a specific machine"
- Next in thread: Rob Stevens: "Re: SMS 2003 vs SUS"
- Reply: Rob Stevens: "Re: SMS 2003 vs SUS"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
