List PCs with Dup Serial Numbers

Select
    CS.Name0,
    Bios.SerialNumber0
From
    dbo.v_GS_COMPUTER_SYSTEM CS
    join dbo.v_GS_PC_BIOS Bios on CS.ResourceID = Bios.Resourceid
Where
    Bios.SerialNumber0 in (Select
                                Bios.SerialNumber0
                            From
                                dbo.v_GS_PC_BIOS Bios
                            Group by
                                Bios.SerialNumber0
                            Having
                                count(Bios.SerialNumber0) > 1 )

Leave a Reply

Your email address will not be published. Required fields are marked *