KACE Product Support Question

Adding up numeric asset fields

11/10/2015 697 views

Is it possible to add up numeric asset fields

in the k1000. For instance the cost of items

or any other asset field that has numbers.

Can I generate a report that adds up all the

fields and gives me a total ???

Thanks All.

0 Comments   [ + ] Show comments


All Answers


You cannot do math in reports when you create a report using the wizard: you need to use a SQL report.
What you can do to ease the creation of the SQL report is to create a sort of blueprint with the wizard and then modify the SQL of the report.

If you like to play a bit more interactively with the SQL and KACE you can enable in the Settings -> Security Settings the database access and use something like TOAD for MySQL or MySQL Workbench (free products) to better model your query.

This video explains how to connect to the K1000 database:

kind regards,
Marco - StockTrader
Answered 11/10/2015 by: StockTrader
Red Belt

  • Thanks for the quick reply Stocktrader...
    Cheers mate.

Don't be a Stranger!

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

Sign up! or login


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