RE: Collection not showing ALL of the clients correctly

Ok - now we are getting somewhere (I think). It doesn't look like this
machine has ever done a hardware inventory. When I right click the machine
from the "All Systems" collection and select "Start Resource Explorer", under
Hardware Scans - it is empty. So how do I initiate a hardware discovery on
this client? I have my site setup to do an inventory every 3 days.

Suggestions?

Thank you,
David M.

"IanG" wrote:

Hi David,

Are you sure your clients have returned an inventory?

If they are in your database then they will have discovery data
such as name, IP, AD site, etc. which exists under SMS_R_System

SMS_G_System requires hardware inventory to have been collected

Change your query to:
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 where
SMS_R_System.Name like "pawbqp%"

IanG@xxxxxx

"David M" wrote:

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: 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: Collection not showing ALL of the clients correctly
    ... If I'm not getting hardware inventory then the client is not ... through the query to create a new collection and that seemed to work. ... added the other machines that have not been showing up as "Direct" and I now ...
    (microsoft.public.sms.admin)
  • RE: Collection not showing ALL of the clients correctly
    ... through the query to create a new collection and that seemed to work. ... added the other machines that have not been showing up as "Direct" and I now ... "David M" wrote: ... Is there any troubleshooting to do at the client level? ...
    (microsoft.public.sms.admin)
  • Re: sms2003 inventory on servers
    ... You could create different sites and assign the different machines to the ... > desktops, but for servers do it at 1am. ...
    (microsoft.public.sms.admin)
Loading