SMSUG.ca

...your virtual communITy
Welcome to SMSUG.ca Sign in | Join | Help
in Search

Garth Jones

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 )

Published Jun 16 2009, 07:40 AM by Garth
Filed under: , ,

Comments

No Comments

This Blog

Syndication

News

Training

Powered by Community Server (Non-Commercial Edition), by Telligent Systems