Filtering duplicate serial numbers

Follow

Sam_A

• November 17, 2020 11:09

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

• 

  Colby Bouma

  • November 17, 2020 15:23

  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"

  0

  Comment actions Permalink

Please sign in to leave a comment.