/build/static/layout/Breadcrumb_cap_w.png

KACE Product Support Question


Is there an existing report or how would i construct a sql script in K1000 appliance/reports--to create a report of battery health (such as current charge, design capacity etc) on our hundreds of Dell 3300 latitudes?

04/20/2020 169 views

From everything i read in these forums:  Can one create a report in k1000 appliance using the variables such as: BatteryFullChargedCapacity, BatteryStaticData and DesignedCapacity and create a report on our current inventory of Dell 3300 latitudes?  The quick change between batteryfullchargeCapacity and DesignedCapacity tends to predict battery failure within the first year of deployment.  Our network/Kace administrators are reluctant to create a Kace rule such as the powerscript offered by Jardan Nolan as well as the Dell Command Module suggestion.   Using the report wizard, is there a way to obtain this information? Even trial and error did not lead me to the correct category and topic/subtopic where i generate such a report on battery health.  Thank you in advance.  

Answer Summary:
Thank you Kevin. it is great to have something that actually works.
0 Comments   [ + ] Show comments

Comments


Answer Chosen by the Author

0

Keep in mind that the data you will be reporting on,  will be what is in the database from the last inventory collected from that device. This is not real time.

In the reporting module you can select "New (SQL) " and paste the following SQL statement to get you started.  You can modify the columns collected to meet your needs


select M.NAME as "Device Name ",
MACHINE_BATTERY.* from MACHINE_BATTERY
join MACHINE M on M.ID = MACHINE_BATTERY.ID

Answered 04/20/2020 by: KevinG
4th Degree Black Belt

  • Kevin...Thank you so much. It works perfect. I have been battling with our network engineers for 2 years for something like this. Thank you again.

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