Discussion:
Wsus Database only showing 169 computers
(too old to reply)
longman111
2010-02-04 22:15:02 UTC
Permalink
I have observed today that I have only 169 computers showing up in the wsus
console. I know I have well over 200. For those computers that are not
showing up, if I force a detection on 1, it will be added to the wsus
console, however when it is added a different computer is removed from the
console, always leaving the total count at 169. This sounds like a database
issue - maybe a size issue - not sure. I am using the Windows Database.
Thoughts?
Al Williams
2010-02-04 22:45:18 UTC
Permalink
Most likely your clients were deployed with non-sysprep'd images that have
duplicate client ID's in them that WSUS uses to identify the machine.
You'll need to reset them at the client. See:

http://www.wsuswiki.com/ClientFAQ

http://msmvps.com/blogs/athif/pages/66376.aspx
--
Allan Williams
Post by longman111
I have observed today that I have only 169 computers showing up in
the wsus console. I know I have well over 200. For those computers
that are not showing up, if I force a detection on 1, it will be
added to the wsus console, however when it is added a different
computer is removed from the console, always leaving the total count
at 169. This sounds like a database issue - maybe a size issue - not
sure. I am using the Windows Database. Thoughts?
Lawrence Garvin [MVP]
2010-02-04 23:52:48 UTC
Permalink
Post by Al Williams
Most likely your clients were deployed with non-sysprep'd images that have
duplicate client ID's in them that WSUS uses to identify the machine.
http://www.wsuswiki.com/ClientFAQ
http://msmvps.com/blogs/athif/pages/66376.aspx
Or.... the authoritative source at http://support.microsoft.com/kb/903262

Which is undoubtably more up-to-date than either of the above cited
references. :-)
--
Lawrence Garvin, M.S., MCITP:EA, MCDBA, MCSA
Principal/CTO, Onsite Technology Solutions, Houston, Texas
Microsoft MVP - Software Distribution (2005-2010)

My Blog: http://onsitechsolutions.spaces.live.com
Microsoft WSUS Website: http://www.microsoft.com/wsus
My MVP Profile: http://mvp.support.microsoft.com/profile/Lawrence.Garvin
longman111
2010-02-05 00:31:01 UTC
Permalink
Thanks guys - figured it out about an hour ago. Wrote a quick script and
fixed about 40 computers. Will speak with the workstation admin tomorrow
about the cloning issue.
Post by Lawrence Garvin [MVP]
Post by Al Williams
Most likely your clients were deployed with non-sysprep'd images that have
duplicate client ID's in them that WSUS uses to identify the machine.
http://www.wsuswiki.com/ClientFAQ
http://msmvps.com/blogs/athif/pages/66376.aspx
Or.... the authoritative source at http://support.microsoft.com/kb/903262
Which is undoubtably more up-to-date than either of the above cited
references. :-)
--
Lawrence Garvin, M.S., MCITP:EA, MCDBA, MCSA
Principal/CTO, Onsite Technology Solutions, Houston, Texas
Microsoft MVP - Software Distribution (2005-2010)
My Blog: http://onsitechsolutions.spaces.live.com
Microsoft WSUS Website: http://www.microsoft.com/wsus
My MVP Profile: http://mvp.support.microsoft.com/profile/Lawrence.Garvin
Loading...