KnowledgeBase Archive

An Archive of Early Microsoft KnowledgeBase Articles

View on GitHub

Q148649: INVPROC Should Force Pragma:Resync If There Is No History

Article: Q148649
Product(s): Microsoft Systems Management Server
Version(s): winnt:1.1
Operating System(s): 
Keyword(s): kbnetwork kbInventory smsinv
Last Modified: 25-JUL-2001

-------------------------------------------------------------------------------
The information in this article applies to:

- Microsoft Systems Management Server version 1.1 
-------------------------------------------------------------------------------


SUMMARY
=======

When you query a Systems Management Server database for SMSID in the Network
Table of Computer Properties, duplicate entries of the same ID appears.

MORE INFORMATION
================

When the client computer logs on to the network, the history of that logon is
recorded by Systems Management Server. INVPROC compares the new entry to the
history file and sends any changes. When a new user logs on using the same
SMSID, the INVPROC then sends up the history deltas to reflect the new logon
name (If there are no HMS or SMH files to compare, a new record is sent to the
SQL Server). It is sent with two fields: IDENT and NETWORK. The IDENT field has
a single entry only. The NETWORK field can have multiple entries. This process
is possibly the cause of duplicate SMSID's. If you query under IDENT, the
problem does not occur.

If there is no history file, INVPROC sends a RESYNC record to DATALOADER, which
forces the computer inventory to be synchronized only with the incoming current
inventory.

To get around the inventory resync, the HMS and SMH files are removed. This
action may create the multiple rows in the NETWORK section queries. INVPROC does
not have the base line to generate the removal of the older NETWORK group.

If you have a MIF with a group that is not currently in the SQL database, it is
added. If you are missing a group in the MIF and the SQL database has the group,
it is removed.

Additional query words: prodsms

======================================================================
Keywords          : kbnetwork kbInventory smsinv 
Technology        : kbSMSSearch kbSMS110
Version           : winnt:1.1

=============================================================================

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.