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?
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.
Answers (1)
Thank you Kevin. it is great to have something that actually works.
Top Answer
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
Comments:
-
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. - tburkeinVT 4 years ago
