Easy (hopefully) question on a custom report...
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
Answers (1)
Please log in to answer
Posted by:
chucksteel
7 years ago
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.
Comments:
-
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. - natethegr8t 7 years ago
-
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. - chucksteel 7 years ago
