myITforum.com Community Forum myITforum.com Community Forum

Home  Forums  Blogs  Live Support chat  Search Articles  Wiki  FAQ  Email Lists  Register  Login  My Profile  Inbox  Address Book  My Subscription  My Forums 

Photo Gallery  Member List  Search  Calendars  FAQ  Ticket List  Log Out

All Forums RSS Feed Subscription:


  


Collection Requirement

 
View related threads: (in this forum | in all forums)

Logged in as: Guest
  Printable Version
All Forums >> [Management Products] >> Microsoft Systems Management Server >> SMS 2003 >> Collection Requirement Page: [1]
Login
Message << Older Topic   Newer Topic >>
Collection Requirement - 10/24/2008 5:36:37 PM   
gwenger

 

Posts: 69
Score: 6
Joined: 3/13/2006
Status: offline 		Has anyone created a collection of 'Computers where a specific advertisement is applicable' ?

I find that when using a large base for my patches it requires that you have a mandatory assignment on a re-occurring schedule to catch failed or uninstalled deployments.

-Gary
Post #: 1
RE: Collection Requirement - 10/24/2008 5:44:50 PM   
Rickym61

 

Posts: 140
Score: 10
Joined: 4/4/2007
Status: offline 		Yep, this should help (for SMS 2003/ITMU)

http://msmvps.com/blogs/lduncan/articles/16129.aspx


The following is a query that you can use to create an SMS collection of systems that are missing a patch. In the code snipplet you'd need to change the "" reference to the actual Knowledge Base article number that you're looking for.
 
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_PATCHSTATEEX on SMS_G_System_PATCHSTATEEX.ResourceID = SMS_R_System.ResourceId
where SMS_G_System_PATCHSTATEEX.QNumbers = " " and
SMS_G_System_PATCHSTATEEX.Status = "Applicable"
 
Alternatively, you can use the following code snipplet to base the collection on the MS bulletin ID. Just replace the "MS04-025" with the appropriate bulletin ID.
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_PATCHSTATEEX on SMS_G_System_PATCHSTATEEX.ResourceID = SMS_R_System.ResourceId
where SMS_G_System_PATCHSTATEEX.Status = "Applicable" and
SMS_G_System_PATCHSTATEEX.ID = "MS04-025"

_____________________________

Rickym61
What being arm twisted by Sherry Kissenger results in i.e. My Blog

(in reply to gwenger)
Post #: 2
RE: Collection Requirement - 10/24/2008 11:55:23 PM   
gwenger

 

Posts: 69
Score: 6
Joined: 3/13/2006
Status: offline 		That's only good for a single patch. I'm looking for the same output from a advertisement containing mutiple patches within a single package.

(in reply to Rickym61)
Post #: 3
RE: Collection Requirement - 10/25/2008 2:47:03 PM   
Rickym61

 

Posts: 140
Score: 10
Joined: 4/4/2007
Status: offline 		sorry misread, I dont have access to SMS at the moment, but from my email archive, I have this query for other half of what you require. You could easily link the 2 to get your results. Im sure the SQL guru #2 would be able to rattle you up the correct query, he usually lurks.

How To: Create a Collection Based on an Advertisement Status
You may encounter a time when you want to target systems that reported a failure message for an advertisement, or reported a specific failure exit code. This is an example of how to create a query-based collection of all systems that reported a failure for AdvertisementID LAB20089.

SELECT sys.ResourceID,sys.ResourceType,sys.Name,sys.SMSUniqueIdentifier ,sys.ResourceDomainORWorkgroup,sys.Client FROM sms_r_system as sys inner join SMS_ClientAdvertisementStatus as offer on sys.ResourceID=offer.ResourceID
WHERE AdvertisementID = 'LAB20089' and LastStateName = "Failed"
 
You should be able to paste this WQL directly into a new query-based membership rule, and modify the AdvertisementID for your environment.


_____________________________

Rickym61
What being arm twisted by Sherry Kissenger results in i.e. My Blog

(in reply to gwenger)
Post #: 4
RE: Collection Requirement - 10/25/2008 7:36:26 PM   
gwenger

 

Posts: 69
Score: 6
Joined: 3/13/2006
Status: offline 		Close but what is really required is a collection where a 'Advertisement' is 'Applicable'

(in reply to Rickym61)
Post #: 5
Page:   [1]
All Forums >> [Management Products] >> Microsoft Systems Management Server >> SMS 2003 >> Collection Requirement Page: [1]
Jump to:





New Messages No New Messages
Hot Topic w/ New Messages Hot Topic w/o New Messages
Locked w/ New Messages Locked w/o New Messages
 Post New Thread
 Reply to Message
 Post New Poll
 Submit Vote
 Delete My Own Post
 Delete My Own Thread
 Rate Posts



  
Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI

0.219