1. PDQ Deploy & Inventory Help Center
  2. Community
  3. PDQ Inventory
 

Important Notice: On February 29th, this community was put into read-only mode. All existing posts will remain but customers are unable to add new posts or comment on existing. Please feel to join our Community Discord for any questions and discussions.

Filtering duplicate serial numbers

Avatar
Sam Auty

Hi,

 

Due to some miss management in AD and re-imagined devices, we have a number of duplicate serial numbers within our Inventory (Pro). Is there a filter that can be applied to a collection to view these duplicates?

Thanks,

0

Comments

2 comments
Date Votes
  • Avatar
    Colby Bouma

    It is not possible to create Collections for that. However, here is a SQL Report based on one that I created a couple years ago for duplicate AD GUIDs.

    SELECT
    	  Computers.Name		AS "Computer Name"
    	, DuplicateSerial.SerialNumber	AS "Serial Number"
    FROM
    	-- https://stackoverflow.com/a/21980136
    	(
    		SELECT
    			  Computers.SerialNumber
    			, COUNT(*) AS "Count"
    		FROM
    			Computers
    		WHERE
    				<ComputerFilter>
    			AND
    				Computers.SerialNumber NOT IN (
    					  ""
    					, "Default string"
    					, "Not Applicable"
    					, "System Serial Number"
    					, "To Be Filled By O.E.M."
    				)
    		GROUP BY
    			Computers.SerialNumber
    		HAVING
    			Count > 1
    	) DuplicateSerial
    INNER JOIN
    	Computers USING (SerialNumber)
    WHERE
    	<ComputerFilter>
    ORDER BY
    	"Computer Name"
    1
  • Avatar
    Sam Auty

    Thank you, I've just go to testing this and it works to display the information I required!

    0