Duplicate entries in R Tables again

[Rob Buxton]

I'm running HPSIM 4.2 SP1 on a W2003 Server.

I'm now seeing duplicate entries in the Reports Tables again.
These can show up in both the standard reports and some home built ones. e.g. from MS Query:
SELECT R_OperatingSystem.DeviceName, R_OperatingSystem.SubDesc, R_OperatingSystem.Version, R_OperatingSystem.Description
FROM Insight_v1_0_15758423.dbo.R_OperatingSystem R_OperatingSystem
WHERE (R_OperatingSystem.SnapshotID=-1) AND (R_OperatingSystem.OSVendor='Microsoft') AND (R_OperatingSystem.DeviceName Not Like '10.%')
ORDER BY R_OperatingSystem.DeviceName

This should just give me a list of MS Servers and removes any ILO / RILOE Cards. But for all of the Windows 2000 Servers I get duplicate entries.
Testing on the above table I get:

aegis Service Pack 4, Build 2195 Uniprocessor Free 5.0 Microsoft Windows 2000 Server Service Pack 4
aegis IT Production / Development Server 5.0.2195 Microsoft Windows 2000 Server

For the two lines. So, there seems to be an older entry where the version is different and the OS Description is the Server Description.

Again, this seems to be another ramification of the R_Tables not being cleaned out in between updates from the Bi-Weekly process.

Anyone seen similar?

Interestingly this does not happen for our W2003 or NT4 Servers.