/build/static/layout/Breadcrumb_cap_w.png
04/19/2017 954 views
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:
1 Comment   [ + ] Show comment

Comments

  • Is there a way to have this report NOT show the retired/archived inventory? When I run a report like this almost everyone has duplicates due the assets being retired.

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!