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!
Please log in to answer
Posted by: chucksteel 4 years ago
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
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