Re: Collection not showing ALL of the clients correctly

I checked the log file and didn't see anything obvious. Is there something I
should be looking for?

Thank you,
D.

"Kim Oppalfens <MVP>" wrote:

Check inventoryagent.log for successfull hardware inventory report or
errors.

--
Kim Oppalfens
Telindus Belgium
MVP Windows Server System - SMS
"David M" <DavidM@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:26972AE4-EFD4-4D69-B9EE-BFBEA64A31F1@xxxxxxxxxxxxxxxx
By the way - your SQL changed worked wonderfully. However the package
still
won't deploy. If I'm not getting hardware inventory then the client is
not
talking to server correctly???

D.

"David M" wrote:

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: Record Count Inconsistent
    ... show up when the file was accessed from the client end. ... The same query ("select * from QryReport) is run from all ... machines. ...
    (microsoft.public.access.queries)
  • 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: 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: 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)