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.

Example Report: