кто-то собирал инфу по остаточной емкости акб на ноутах?
SELECT
comp.Name
,note.SN as `Serial No`
,note.instance_number as `Inventory No`
,comp.DeviceOS
,comp.DeviceOSBuild
,comp.PrimaryUser, comp.CurrentLogonUser, comp.LastLogonUser
,b2.FullChargedCapacity0
,b1.DesignedCapacity0
,100 * b2.FullChargedCapacity0 / b1.DesignedCapacity0 as ChargePercent
FROM
v_GS_BATTERYSTATICDATA as b1
join v_GS_BATTERYFULLCHARGEDCAPACITY as b2 on b1.ResourceID = b2.ResourceID
join v_CombinedDeviceResources as comp on comp.MachineID = b1.ResourceID
left join cmdb/notebooks as note on note.SN = comp.`SerialNumber`
WHERE
(100 * b2.FullChargedCapacity0 / b1.DesignedCapacity0) < 40
and comp.IsObsolete = 0 and comp.IsClient = 1
ORDER BY ChargePercent