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: