/build/static/layout/Breadcrumb_cap_w.png

K1000: User Asset Report

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:

 


Comments

This post is locked
 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ