Filtering duplicate serial numbers
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,
-
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"
Please sign in to leave a comment.
Comments
2 comments