Battery Intelligence Installation Instructions

Minimum Version

This DEX Pack requires SysTrack version 10.0.

Notes

  • After this DEX Pack is installed, it may take up to 24 hours for data to appear.

  • If you update or reinstall this DEX Pack, you must reassign any Views created below to the SF_Battery Intelligence Role

  • This is for releases prior to 10.12.

Import Kit

To use this DEX Pack, the corresponding Kit must be imported to SysTrack.

If you have already imported the DEX Pack directly from the Kits page, the Import Kit step is complete. You may move on to the next step.

If you are viewing this DEX Pack in the Customer Gateway, follow these steps to import this DEX Pack Kit:

  1. On the DEX Pack page, download the DEX Pack ZIP file

  2. In SysTrack, open Kits

  3. Under Local, click Select Kit File

  4. Select the DEX Pack ZIP File

Battery Health View

Battery Health data requires you to make a View for the SF_Battery Intelligence Role.

To create the new View:

  1. Navigate to Configure > Views

  2. Click the padlock icon in the upper-right to enable editing

  3. Click the plus icon to add a new View

  4. Fill in the Settings as follows:

    1. View Name: SF_BATTDAILY

    2. Expires in: 6 Months

    3. When Expired: Append Data

    4. Do NOT check “When overdue by 1 day(s)”

    5. Set the Refresh drop-downs to Weekly, Inside, 24x7, and “Every 1 week(s)”

    6. Copy this SQL query, and paste it into the box under SQL Selection > Generic

    7. Click Test SQL. A Test Success message should appear. If the test is not successful, the query may have been copied incorrectly

  5. Click Create View at the top-right

To assign the new View:

  1. Navigate to Configure > Roles

  2. Use the drop-down at the top to select the SF_Battery Intelligence Role

  3. Click Views, then check the box next to SF_BATTDAILY

  4. Click Save Changes at the top-right

Some forms of Battery Health data will not begin to be tracked until this View is assigned. It may take several weeks before some forms of Battery Health data to fully populate this DEX Pack.

Copy SF_BATTDAILY

Copy 
SELECT
    T0.WGUID,
    GETUTCDATE() AS VWTIME,
    S0.STRVALUE AS DEVICE_NAME,
    (T0.FULL_CHARGE_CAPACITY / CAST(T0.DESIGN_CAPACITY AS FLOAT)) * 100 AS BATTERY_HEALTH,
    T1.MAX_BATTERY_LVL,
    T1.AVG_BATTERY_LVL,
    T1.MIN_BATTERY_LVL,
    T1.STDEV_BATTERY_LVL
FROM SABATTERY AS T0
,SASTR AS S0
,(
    SELECT
        MAX(BATTERY_LEVEL) * 100.0 AS MAX_BATTERY_LVL,
        AVG(BATTERY_LEVEL) * 100.0 AS AVG_BATTERY_LVL,
        MIN(BATTERY_LEVEL) * 100.0 AS MIN_BATTERY_LVL,
        STDEV(BATTERY_LEVEL) * 100.0 AS STDEV_BATTERY_LVL
    FROM SASYS
    WHERE
        WTYPE = 1
        AND WTIME > <LASTREFRESHTIME>
) AS T1
WHERE
    ISNULL(T0.DESIGN_CAPACITY,0) > 0
    AND ISNULL(T0.FULL_CHARGE_CAPACITY,0) > 0
    AND T0.DEVICEID = S0.STRINGID

Battery Intelligence Role

This DEX Pack requires you to assign the SF_Battery Intelligence Role to the relevant

Configurations:

  1. Navigate to Configure > Configurations

  2. Click the padlock icon in the upper-right to enable editing

  3. Use the drop-down at the top to select a relevant Configuration, or create a new Configuration

  4. Assign SF_Battery Intelligence Role to the Configuration by dragging it from Available Roles to Assigned Roles

  5. Click Save Changes at the top-right

  6. Repeat this process for any other relevant Configurations