Duplicate Serial Numbers

Comments

6 comments

  • Bouma, Colby

    My approach isn't perfect, but should be good enough.

     

    Computer, Serial Number, "Serial Number",
    Computer, Name, "Count", Count

     

    You can sort by the Count column and copy pasta the serial numbers that are > 1 into PDQI's search box. 

     

    0
    Comment actions Permalink
  • James Witt III

    Thank you, this works well enough :-)

    0
    Comment actions Permalink
  • Michael Muni

    Create an SQL report and past the following into it.

     

    SELECT UPPER(SerialNumber) AS SerialNumber, Name AS Computer
    FROM Computers where SerialNumber IN (SELECT SerialNumber FROM Computers GROUP BY SerialNumber HAVING COUNT(*) > 1)
    AND NOT SerialNumber = '' AND <ComputerFilter>
    ORDER BY SerialNumber ASC

    0
    Comment actions Permalink
  • Michael Muni

    I forgot to mention what it does. That SQL report will display a list of serial numbers and computers for any duplicate computers with the same serial number. It then sorts the list by serial number so that all the same serial numbers will be grouped together and you will see exactly witch computer accounts have the same serial.

    One step further I think would be to add the ONLINE status to show what one is currently being used.

    0
    Comment actions Permalink
  • Michael Muni

    Here is the updated one with Online Status:

     

    SELECT UPPER(SerialNumber) AS SerialNumber, Name AS Computer, Computers.IsOnline AS Online
    FROM Computers where SerialNumber IN (SELECT SerialNumber FROM Computers GROUP BY SerialNumber HAVING COUNT(*) > 1)
    AND NOT SerialNumber = '' AND <ComputerFilter>
    ORDER BY SerialNumber ASC

    1
    Comment actions Permalink
  • summdal

    Duplicate serial number is fake serial number that is very awful thing when you trying to use it. Once in my life I go to the best dissertation service review there is the men who trying to use fake serial number and he caught that by police.

    0
    Comment actions Permalink

Please sign in to leave a comment.