This guide will create a report in the K1000 that will display all of the allocated assets for a User imported into your K1000 appliance.
- Go to Reporting -> Choose Action -> Add New SQL
- Give Your Report a Title and Category
- In the SQL Select Statement copy and paste the Following:
SELECT U.USER_NAME, A.NAME, AT.NAME
FROM ASSET A, ASSET_TYPE AT, USER U
WHERE AT.ID = A.ASSET_TYPE_ID
AND A.OWNER_ID = U.ID
- Break on Columns: U.USER_NAME
- Select Save
Now, you can schedule this report or run it manually via HTML, CSV or TEXT format.