/build/static/layout/Breadcrumb_cap_w.png

Systems Management Question


K1000 report to show duplicate PCs assigned to users?

04/19/2017 1562 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!
 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ