Duplicate report in NIC status (4.1 sp2)

[Nick H]

When running a report for NIC (only) on one server, I get duplicate entries. This is expected when there are two NICs, but some columns are blank, and others are filled and vice versa.
When looking at over 100 servers filling-in-the-blanks is painful.

I want the
Server Name, MAC, IP, Speed, Duplex, Interface Name

I get
Servername01, Mac01, IP01, Speed01, (null), InterfaceName01
Servername01, Mac01, IP01, (null), FullDuplex01, InterfaceName01
Servername01, Mac02, IP02, Speed02, (null), InterfaceName02
Servername02, Mac02, IP02, (null), FullDuplex02, (null)

Basically, I have to do my own LEFT JOINS to see the data correctly.

I am not sure, but it looks like this is fixed in SIM 5.0 But I don't have enough delete and rediscover servers to confirm, but the SQL statements look better in 5.0.

My production is in SIM 4.1 SP2.

Thanks.

Nick