Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

SMS 2003 collection issue

2 views
Skip to first unread message

Amir Atary

unread,
Feb 14, 2010, 6:24:01 AM2/14/10
to
Hi to all,

Hope you can help.
In our organization we disterbute with SMS 2003 (sp3).
Windows 2003 server.

Till now all worked well.

I tried disterbuting MS10-002 but the collection is not filled with
computers names.

What is the basic step to troubleshoot collections that are not filled with
computer names?

Thank you
Amir :)

Garth

unread,
Feb 14, 2010, 11:08:13 AM2/14/10
to
What does your query look like?


"Amir Atary" <Amir...@discussions.microsoft.com> wrote in message
news:4D222DC6-AF48-4CA3...@microsoft.com:


--

Garth Jones
Chief Architect

www.Enhansoft.com
Enhancing Your Business


Amir Atary

unread,
Feb 15, 2010, 2:26:01 AM2/15/10
to
Thank you for responding.

It's seems that only Software updates collections stopped working.
Regular collection work fine.

In addition i found an error under "component status":
http://i50.tinypic.com/2hf5sav.jpg


This is the query:

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_OPERATING_SYSTEM on
SMS_G_System_OPERATING_SYSTEM.ResourceID = SMS_R_System.ResourceId inner
join SMS_G_System_PATCHSTATEEX on SMS_G_System_PATCHSTATEEX.ResourceID =
SMS_R_System.ResourceId where SMS_G_System_PATCHSTATEEX.ID = "MS10-002"
and SMS_G_System_PATCHSTATEEX.Status = "Applicable" and
SMS_G_System_OPERATING_SYSTEM.Version = "5.2.3790"

Thank you very much for your help.
Amir :)

Garth

unread,
Feb 15, 2010, 10:19:39 AM2/15/10
to
There is no difference between the collections. This would indicate that
there is an issue with your query. I'm OOT for 10 days or so I will not
be able to test this for you until I either my VPN connection to work or
until I get home.

Your AD discovery issue had nothing to do with your SU issue.

Nothing jumps out at me with your query but I would start by only
looking for PCs that are applicable, then add os version then add the
patch. This will help show where the issue is.

"Amir Atary" <Amir...@discussions.microsoft.com> wrote in message

news:4632C85A-59BB-430F...@microsoft.com:

0 new messages