RE: Collection not showing ALL of the clients correctly

Another strange observation:

I right clicked on one of the machines that I have been having problems with
(from the ALL SYSTEMS collection) and selected "Distribute Software" ran
through the query to create a new collection and that seemed to work. I then
added the other machines that have not been showing up as "Direct" and I now
have a new collection with the machines that continually would not show in
the other collection. BUT, they still are not accepting the Software Package
that I attempted to distribute to them. :-(



"David M" wrote:

Thank you for your help on this. I created the new Collection and Query but
still get the same results. Could it be a problem with the way SMS is seeing
the client? Is there any troubleshooting to do at the client level? I just
don't understand why I wouldn't be able to query for the same machine that
DOES exist in the "All System" query. I also tried the "Membership Rule
Wizard", used the wild card to query for the machine names. It came back
with all the machines that met that criteria, I selected all of them and it
aded them as "Direct". Yet when I quick on the collection name to show all
the machines I am still missing 3 machines (in this case). I have even tried
putting in the full hostname and it still doesn't find them when the query
runs?

Any other suggestions?

Thank you again.

"RobM" wrote:

Create a new collection, create a new query for this collection ... paste in
this code ...

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_SYSTEM on
SMS_G_System_SYSTEM.ResourceID = SMS_R_System.ResourceId where
SMS_G_System_SYSTEM.Name like "%<MACHINENAME>%"

Change <MACHINENAME> to describe what you are looking for

Limit the queries scope (collection limiting) to a specific collection (all
systems in this case)

Give that a go.

--

Rob - Windows Management User Group

www.wmug.co.uk





"David M" wrote:

I have created a new collection based on the ALL Systems collection to search
for host names based on a critiera that I provide i.e. XXXXX% would be all
the machines in a specific department. The problem I am having is that it
only returns about 1/2 of the machines. If I click on the All Systems
collection I can see the machines listed but I can not get them to show in
the collection that I have created. Copy of the commands:

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_COMPUTER_SYSTEM on
SMS_G_System_COMPUTER_SYSTEM.ResourceID = SMS_R_System.ResourceId where
SMS_G_System_COMPUTER_SYSTEM.Name like "pawbqp%"

I have tried the Computer_System and System options - still no go...

Thank you for any help you can provide.

D.
.

Relevant Pages

  • Re: Excel "Web Query"
    ... write a macro to find a reliable source. ... .....I've been using Excel's "Web Query" for a while now but I've ... on "some" machines and not others. ... So, upon further investigation, it appears when you "Edit Web Query" ...
    (microsoft.public.excel)
  • Re: Excel "Web Query"
    ... .....I've been using Excel's "Web Query" for a while now but I've ... on "some" machines and not others. ... I know.....aren't pretty much ALL web queries used to do this :-) ... So, upon further investigation, it appears when you "Edit Web Query" ...
    (microsoft.public.excel)
  • Re: Collection not showing ALL of the clients correctly
    ... If I'm not getting hardware inventory then the client is ... "David M" wrote: ... Change your query to: ... I right clicked on one of the machines that I have been having ...
    (microsoft.public.sms.admin)
  • Re: Collection not showing ALL of the clients correctly
    ... If I'm not getting hardware inventory then the client is ... "David M" wrote: ... I right clicked on one of the machines that I have been having ... through the query to create a new collection and that seemed to work. ...
    (microsoft.public.sms.admin)
  • Re: Design view (select query with link table issues)
    ... but they do not work on some user's machines? ... you try to open the table directly in the database window, ... you are talking about a query that draws from tables that are not ... >> permissions, Windows user permissions, or file-share permissions. ...
    (microsoft.public.access.queries)