/build/static/layout/Breadcrumb_cap_w.png

K1000 report to show duplicate PCs assigned to users?

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!

1 Comment   [ + ] Show comment
  • 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. - HarborIT 6 years ago

Answers (1)

Answer Summary:
Posted by: chucksteel 6 years ago
Red Belt
0

Top Answer

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


Comments:
  • Wow! Worked on the first try, thank you very much Chuck! - ajr3 6 years ago

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
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