Re: Collection not showing ALL of the clients correctly

Nothing useful :-( - contents below:

<![LOG[Inventory: Message [Type=InventoryAction,
ActionID={00000000-0000-0000-0000-000000000003}, Report=Full] already in
queue. Message ignored.]LOG]!><time="13:49:13.291+420" date="05-09-2006"
component="InventoryAgent" context="" type="1" thread="1872"
file="agentendpoint.cpp:229">
<![LOG[Inventory: Message [Type=SiteChange, ActionID=, Report=] already in
queue. Message ignored.]LOG]!><time="13:49:13.291+420" date="05-09-2006"
component="InventoryAgent" context="" type="1" thread="1516"
file="agentendpoint.cpp:229">
<![LOG[Inventory: Message [Type=InventoryAction,
ActionID={00000000-0000-0000-0000-000000000003}, Report=Full] already in
queue. Message ignored.]LOG]!><time="13:49:13.291+420" date="05-09-2006"
component="InventoryAgent" context="" type="1" thread="1784"
file="agentendpoint.cpp:229">
<![LOG[Inventory: *********************** Start of message processing.
***********************]LOG]!><time="13:49:13.291+420" date="05-09-2006"
component="InventoryAgent" context="" type="1" thread="1792"
file="agentendpoint.cpp:323">
<![LOG[Inventory: Message type is
InventoryAction]LOG]!><time="13:49:13.291+420" date="05-09-2006"
component="InventoryAgent" context="" type="1" thread="1792"
file="agentendpoint.cpp:324">
<![LOG[Inventory: Temp directory =
C:\WINNT\system32\CCM\Inventory\Temp\]LOG]!><time="13:49:13.291+420"
date="05-09-2006" component="InventoryAgent" context="" type="1"
thread="1792" file="agentstate.cpp:2369">
<![LOG[Inventory: Clearing old collected
files.]LOG]!><time="13:49:13.291+420" date="05-09-2006"
component="InventoryAgent" context="" type="1" thread="1792"
file="agentstate.cpp:1596">
<![LOG[Inventory: Opening store for action
{00000000-0000-0000-0000-000000000003} ...]LOG]!><time="13:49:13.385+420"
date="05-09-2006" component="InventoryAgent" context="" type="1"
thread="1792" file="datastore.cpp:175">
<![LOG[Inventory: Action=Discovery
ReportType=Full]LOG]!><time="13:49:13.400+420" date="05-09-2006"
component="InventoryAgent" context="" type="1" thread="1792"
file="agentstate.cpp:1464">
<![LOG[Inventory: Initialization completed in 0.078
seconds]LOG]!><time="13:49:13.400+420" date="05-09-2006"
component="InventoryAgent" context="" type="1" thread="1792"
file="agentstate.cpp:504">
<![LOG[Collection: Namespace = \\.\root\ccm; Query = SELECT __CLASS, __PATH,
__RELPATH, ClientIdChangeDate, PreviousClientId FROM CCM_Client; Timeout =
600 secs.]LOG]!><time="13:49:13.478+420" date="05-09-2006"
component="InventoryAgent" context="" type="1" thread="1792"
file="collectiontask.cpp:330">
<![LOG[Collection: Namespace = \\.\root\ccm; Query = SELECT __CLASS, __PATH,
__RELPATH, Name FROM SMS_Authority; Timeout = 600
secs.]LOG]!><time="13:49:13.494+420" date="05-09-2006"
component="InventoryAgent" context="" type="1" thread="1792"
file="collectiontask.cpp:330">
<![LOG[Collection: Namespace = \\.\root\ccm\invagt; Query = SELECT __CLASS,
__PATH, __RELPATH, ADSiteName FROM CCM_ADSiteInfo; Timeout = 600
secs.]LOG]!><time="13:49:13.510+420" date="05-09-2006"
component="InventoryAgent" context="" type="1" thread="1792"
file="collectiontask.cpp:330">
<![LOG[Collection: Namespace = \\.\root\ccm\invagt; Query = SELECT __CLASS,
__PATH, __RELPATH, IPSubnet FROM CCM_NetworkAdapterConfiguration; Timeout =
600 secs.]LOG]!><time="13:49:13.588+420" date="05-09-2006"
component="InventoryAgent" context="" type="1" thread="1792"
file="collectiontask.cpp:330">
<![LOG[Collection: Namespace = \\.\root\ccm\invagt; Query = SELECT __CLASS,
__PATH, __RELPATH, PlatformID FROM CCM_DiscoveryData; Timeout = 600
secs.]LOG]!><time="13:49:13.619+420" date="05-09-2006"
component="InventoryAgent" context="" type="1" thread="1792"
file="collectiontask.cpp:330">
<![LOG[Collection: Namespace = \\.\root\ccm\invagt; Query = SELECT __CLASS,
__PATH, __RELPATH, Domain FROM CCM_ComputerSystem; Timeout = 600
secs.]LOG]!><time="13:49:13.869+420" date="05-09-2006"
component="InventoryAgent" context="" type="1" thread="1792"
file="collectiontask.cpp:330">
<![LOG[Collection: Namespace = \\.\root\cimv2; Query = SELECT __CLASS,
__PATH, __RELPATH, UserName FROM Win32_ComputerSystem; Timeout = 600
secs.]LOG]!><time="13:49:13.885+420" date="05-09-2006"
component="InventoryAgent" context="" type="1" thread="1792"
file="collectiontask.cpp:330">
<![LOG[Collection: Namespace = \\.\root\cimv2; Query = SELECT __CLASS,
__PATH, __RELPATH, IPAddress, MACAddress FROM
Win32_NetworkAdapterConfiguration WHERE IPEnabled=TRUE; Timeout = 600
secs.]LOG]!><time="13:49:14.369+420" date="05-09-2006"
component="InventoryAgent" context="" type="1" thread="1792"
file="collectiontask.cpp:330">
<![LOG[Collection: Namespace = \\.\root\ccm; Query = SELECT __CLASS, __PATH,
__RELPATH, HardwareID1 FROM CCM_ClientIdentificationInformation; Timeout =
600 secs.]LOG]!><time="13:49:14.385+420" date="05-09-2006"
component="InventoryAgent" context="" type="1" thread="1792"
file="collectiontask.cpp:330">
<![LOG[Collection: Signing turned off. Skipping query SELECT __CLASS,
__PATH, __RELPATH, EncodedSigningPublicKey FROM
CCM_ClientSecurityInformation; ]LOG]!><time="13:49:14.400+420"
date="05-09-2006" component="InventoryAgent" context="" type="1"
thread="1792" file="collectiontask.cpp:326">
<![LOG[Collection: 9/10 inventory data items successfully
inventoried.]LOG]!><time="13:49:14.400+420" date="05-09-2006"
component="InventoryAgent" context="" type="1" thread="1792"
file="collectiontask.cpp:265">
<![LOG[Inventory: Collection Task completed in 0.953
seconds]LOG]!><time="13:49:14.400+420" date="05-09-2006"
component="InventoryAgent" context="" type="1" thread="1792"
file="agentstate.cpp:779">
<![LOG[Inventory: 1 Collection Task(s)
failed.]LOG]!><time="13:49:14.400+420" date="05-09-2006"
component="InventoryAgent" context="" type="2" thread="1792"
file="agentstate.cpp:793">
<![LOG[Inventory: Temp report =
C:\WINNT\system32\CCM\Inventory\Temp\7486394d-f32b-4b17-8c85-995f4e9b553c.xml]LOG]!><time="13:49:14.463+420"
date="05-09-2006" component="InventoryAgent" context="" type="1"
thread="1792" file="agentstate.cpp:2112">
<![LOG[Inventory: Starting reporting task.]LOG]!><time="13:49:14.478+420"
date="05-09-2006" component="InventoryAgent" context="" type="1"
thread="1888" file="reporttask.cpp:240">
<![LOG[Reporting: 9 report entries created.]LOG]!><time="13:49:14.556+420"
date="05-09-2006" component="InventoryAgent" context="" type="1"
thread="1888" file="reporttask.cpp:260">
<![LOG[Inventory: Reporting Task completed in 0.078
seconds]LOG]!><time="13:49:14.556+420" date="05-09-2006"
component="InventoryAgent" context="" type="1" thread="1888"
file="agentstate.cpp:846">
<![LOG[Inventory: Successfully sent report. Destination:mp:MP_DdrEndpoint,
ID: {96C80B9B-E02C-4565-95E0-2433FD3D33BB}, Timeout: 80640 minutes MsgMode:
Not Signed, Not Encrypted]LOG]!><time="13:49:14.760+420" date="05-09-2006"
component="InventoryAgent" context="" type="1" thread="1888"
file="agentstate.cpp:2025">
<![LOG[Inventory: Cycle completed in 1.625
seconds]LOG]!><time="13:49:14.916+420" date="05-09-2006"
component="InventoryAgent" context="" type="1" thread="1888"
file="agentstate.cpp:1520">
<![LOG[Inventory: Action completed.]LOG]!><time="13:49:14.916+420"
date="05-09-2006" component="InventoryAgent" context="" type="1"
thread="1888" file="agentstate.cpp:1530">
<![LOG[Inventory: ************************ End of message processing.
************************]LOG]!><time="13:49:14.931+420" date="05-09-2006"
component="InventoryAgent" context="" type="1" thread="1888"
file="agentendpoint.cpp:410">
<![LOG[Inventory: *********************** Start of message processing.
***********************]LOG]!><time="13:49:14.931+420" date="05-09-2006"
component="InventoryAgent" context="" type="1" thread="1888"
file="agentendpoint.cpp:323">
<![LOG[Inventory: Message type is SiteChange]LOG]!><time="13:49:14.931+420"
date="05-09-2006" component="InventoryAgent" context="" type="1"
thread="1888" file="agentendpoint.cpp:324">
<![LOG[Inventory: Clearing Action Status]LOG]!><time="13:49:14.931+420"
date="05-09-2006" component="InventoryAgent" context="" type="1"
thread="1888" file="agentendpoint.cpp:702">
<![LOG[Inventory: ************************ End of message processing.
************************]LOG]!><time="13:49:14.947+420" date="05-09-2006"
component="InventoryAgent" context="" type="1" thread="1888"
file="agentendpoint.cpp:410">


"Kim Oppalfens <MVP>" wrote:

A note stating that hardware inventory report was delivered to hinv
endpoint.
Endpoint is a good word to wade through the log searching for the reports.

--
Kim Oppalfens
Telindus Belgium
MVP Windows Server System - SMS
"David M" <DavidM@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:0FBF68DE-BCCF-4FE4-9519-B87A09470B79@xxxxxxxxxxxxxxxx
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: Systems with no client
    ... I have this query ... setup in Collection to show me which machines do not have the sms client ... For some reason I am getting machines which DO have sms client ...
    (microsoft.public.sms.admin)