Has anyone constructed a report to show all user's duplicate PCs, i.e. computers assigned to a user that has more than one computer assigned to them? A "deduplication" report? We have a problem with our users having multiple PCs in their name (our economic model says, one computer, one user!) Any help would be appreciated. Thank you!
Answer Summary:
Cancel
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Answer Chosen by the Author

0
This report uses the Assignee function in version 7.0:
SELECT OWNER_ID, USER.USER_NAME, COUNT(ASSET.ID) as Assets,
GROUP_CONCAT(M.NAME) as Computers
FROM ASSET
LEFT JOIN USER on USER.ID = ASSET.OWNER_ID
LEFT JOIN MACHINE M on M.ID = ASSET.MAPPED_ID
WHERE ASSET_TYPE_ID = 5
and OWNER_ID != 0

GROUP BY OWNER_ID
HAVING Assets > 1
ORDER BY Assets DESC

Answered 04/20/2017 by: chucksteel
Red Belt

  • Wow! Worked on the first try, thank you very much Chuck!
Please log in to comment

Answers

Answer this question or Comment on this question for clarity