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 7 years ago
Answers (1)
Answer Summary:
Please log in to answer
Posted by:
chucksteel
7 years ago
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 7 years ago
