Proactive Hardware Monitoring Installation Instructions

Prerequisites

• Minimum Version: Requires SysTrack 10.1 or later.

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_Proactive Hardware Monitoring Role.

• This DEX Pack only tracks data from physical systems. Data from Virtual Machines will not be tracked.

Installation Steps

To install this DEX Pack, complete the following steps:

1. Import the Kit.

2. Create the Battery Health View.

3. Assign the Battery Health View to the Proactive Hardware Monitoring Role.

4. Create the Boot View.

5. Assign the Boot View to the Proactive Hardware Monitoring Role.

6. Assign the Proactive Hardware Monitoring Role to Relevant Configurations.

Import the Kit

Create the Battery Health View

NOTE: This step is only required for versions prior to 11.2.

Battery Health data requires you to make a View for the SF_Proactive Hardware Monitoring 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 the SF_BATTDAILY SQL Query, and paste it into the box under SQL Selection > Generic.

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

5. Click Create View at the top-right

SF_BATTDAILY SQL Query

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

Assign the Battery Health View to the Proactive Hardware Monitoring Role

To assign the new View:

1. Navigate to Configure > Roles.

2. Use the drop-down at the top to select the SF_Proactive Hardware Monitoring 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 fully populate this DEX Pack.

Create the Boot View

NOTE: This step is only required for versions prior to 11.2.

Boot data requires you to make a View for the SF_Proactive Hardware Monitoring 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_BootCount

   2. Existing Category: Customization

   3. Description: System View for Proactive Hardware Monitoring DEX Pack

   4. Expires in: 30 Days

   5. When Expired: Overwrite Data

   6. Check When overdue by 1 day(s).

   7. Set the Refresh drop-downs to Daily, Inside, 24x7, and Every Day.

   8. Copy the SF_BOOTCOUNT SQL Query, and paste it into the box under SQL Selection > Generic.

   9. Click Test SQL. A Success message should appear at the top of the screen. If the test is not successful, the query may have been copied incorrectly.

5. Click Create View at the top-right.

SF_BOOTCOUNT SQL Query

SELECT
    WGUID
    ,GETUTCDATE() AS VWTIME
    ,COUNT(*) AS BOOT_COUNT
FROM
    SABOOTTIMES
WHERE
    STARTTIME >= GETUTCDATE() - 90
GROUP BY
    WGUID

Assign the Boot View to the Proactive Hardware Monitoring Role.

NOTE: This step is only required for versions prior to 11.2.

To assign the new View:

1. Navigate to Configure > Roles.

2. Use the drop-down at the top to select the SF_Proactive Hardware Monitoring Role.

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

4. Click Save Changes at the top-right.

Assign the Proactive Hardware Monitoring Role to Relevant Configurations

This DEX Pack requires you to assign the SF_Proactive Hardware Monitoring 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 the SF_Proactive Hardware Monitoring 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.