Re: Duplicate Computers in Query Results

From: jj12 (anonymous_at_discussions.microsoft.com)
Date: 03/11/04 

Date: Thu, 11 Mar 2004 06:25:59 -0800

Thanks for the response Sangee...We are running SMS 2.0
with SP4. Yes in the PC_BIOS_DATA table in the SQL
database each client appears to have 2 entries. One
entry appears to contain valid data, the other entry each
attribute contains <NULL>. Is there anything that can be
done to remove the second entry?

Thanks.
>-----Original Message-----
>How many entries does each client have in the PC_BIOS
table? Is this on SMS
>2.0 or SMS 2003?
>
>Due to Duplicate GUIDs or firmware change, there were
more than one row in
>PC_BIOS table in SMS2.0 where the old entry was retained
in the _DATA table
>and not in the _HIST table. This has been fixed in SMS
2003.
>
>--
>Hope this helps!
>Sangee
>
>P.S:Please do not send e-mail directly to this alias.
This alias is for
>newsgroup purposes only.
>
>"This posting is provided AS IS with no warranties and
confers no rights."
>This posting is provided AS IS with no warranties and
confers no rights.
>
>"jj12" <anonymous@discussions.microsoft.com> wrote in
message
>news:CDCE0694-ACA7-40BC-9877-
9EDC855D8266@microsoft.com...
>> We have been seeing duplicate computer entries
returned from queries that
>have the PC BIOS Class and Serial Number attribute as
part of the query. I
>found a post from 2001 that describes the same issue but
have been unable to
>find a solution or any responses to the original
post..........here is a
>copy of the original post.... Thanks for any insight!
>>
>>
>>
>> Here's my problem ---
>>
>> Within the last 2 weeks, I've been seeing duplicate
computer entries
>> returned from queries that have the PC BIOS Class and
Serial Number
>> Attribute as part of the returned query values . I
think that this may
>have
>> started a week or so after I advertised WMI 1.5 to all
computers. I know
>> that WMI has loaded and is working on my clients
because I am now able to
>> query for Computer Serial Number and most return
values now.
>>
>> If I remove the PC BIOS - Serial Number entry from the
query results list,
>I
>> don't get duplicates! I also tried adding the PC
BIOS - Serial Number
>value
>> back to the results list and checked Omit Duplicate
Rows (select
>distinct),
>> but I stll get many duplicates!
>>
>> Any suggestions?
>>
>
>
>.
>

Relevant Pages

  • RE: Computers that may share the same SMS Unique ID
    ... there are duplicate GUIDs. ... It is abnormal if there are duplicated GUIDs entries in SMS. ... Data Records that have a different SMSID to the SMS Site Server, ... will not recognize the computer as a previous SMS client. ...
    (microsoft.public.sms.admin)
  • Duplicate Computer objects on brand new builds
    ... I am seeing an increase in duplicate computer objects being added by SMS when ... What I am seeing a lot of recently is SMS creating two computer objects ... duplicate GUID reports, and that is also double-checked by visual ... verification on the client. ...
    (microsoft.public.sms.admin)
  • Re: Duplicate Amounts dont show up in Union Query
    ... I have 2 separate queries that show the correct data and number of entries. ... system so duplicate entries are possible. ... Anyone have any thoughts on this or can a Union Query just not handle exact ... Record the number of rows returned by the UNION ALL query. ...
    (microsoft.public.access.queries)
  • [9fans] Duplicate entries in fresh plan9.ini
    ... I've been looking for the cause of these duplicate entries, ... appear to have been introduced together with the third boot option on ... quick and dirty change like the following line (which add everything ...
    (comp.os.plan9)
  • Re: Duplicates by groups
    ... Copy and Past the entries with C values greater than 0 ... duplicate records in column B for each group of customers in column A. ... for Joe (as Eggs are the duplicate in Column B); ... and Apples; Susan Bread and Cereal; etc. ...
    (microsoft.public.excel.misc)
Loading