/build/static/layout/Breadcrumb_cap_w.png

KACE Product Support Question


Easy (hopefully) question on a custom report...

02/27/2017 579 views
Hey guys!!

Looking for some assistance on creating a custom report, or actually more just add a column to an existing report.

The report I want to modify is the report "Dell Warranty Expired" 

I simply need to add a column for 'last check in' or 'last inventory' column to this existing report... any suggestions? 

Any help is appreciated! Thanks!
0 Comments   [ + ] Show comments

Comments


All Answers

0
The last inventory timestamp is stored in the LAST_INVENTORY column, so you should be able to add it to the list of selected columns in the SQL statement.
Answered 02/28/2017 by: chucksteel
Red Belt

  • awesome, thank you that worked! I was able to add it as the first column. Is there a way to sort by this column? Seems like it is sorting by machine name by default.
    • Yes, you can order the report using the order by statement. Add this to the end of the query:
      ORDER BY LAST_INVENTORY
      for instance.

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
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