Microsoft KB Archive/291675

= SMS: Advertisements Incorrectly Go to All Computers =

Article ID: 291675

Article Last Modified on 10/27/2006

-

APPLIES TO


 * Microsoft Systems Management Server 2.0 Standard Edition

-



This article was previously published under Q291675



SYMPTOMS
When you create a new collection in the Systems Management Server (SMS) Administrator Console, the collection is created based on a query. In the Query box, only a name is displayed; the query statement stays in its default state, which results in the collection returning the results of all systems. The default query statement is:

SELECT * FROM SMS_R_SYSTEM



CAUSE
This behavior is by design.



WORKAROUND
To work around this behavior, when you create a new query, make sure to generate the proper query statement and do not leave the default settings.

Additional query words: prodsms

Keywords: kbbug kbprb KB291675

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.