Employee Wellbeing Installation Instructions

Minimum Version

This DEX Pack requires SysTrack version 10.1 or higher.

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_Employee Wellbeing Role.

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

Healthy Working View

The Healthy Working Dashboard requires you to make a View for the SF_Employee Wellbeing 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_USERSDAILY

    2. Expires in: 30 Days

    3. Existing Category: Custom

    4. When Expired: Append Data

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

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

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

    8. 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_Employee Wellbeing Role.

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

  4. Click Save Changes at the top-right

After this View is assigned, Screen Time data will be collected each day. It will take 30 days before the data in this Dashboard is fully populated.

Copy SF_USERSDAILY

Copy 
SELECT
    WGUID,
    GETUTCDATE() AS VWTIME,
    UNAME,
    DOTY,
    ACTIVE_TIME,
    SUM_BREAK_TIME,
    MAX_BREAK_TIME
FROM (
    SELECT
        T0.WGUID,
        GETUTCDATE() AS VWTIME,
        S0.STRVALUE AS UNAME,
        DATEADD(D,DATEDIFF(D,0,T0.WTIME),0) AS DOTY,
        COUNT(*) * 10 AS ACTIVE_TIME,
        SUM(CASE WHEN DATEDIFF(N,PREVIOUS_TIME,WTIME) BETWEEN 15 AND 180 THEN DATEDIFF(N,PREVIOUS_TIME,WTIME) ELSE 0 END) AS SUM_BREAK_TIME,
        MAX(CASE WHEN DATEDIFF(N,PREVIOUS_TIME,WTIME) BETWEEN 15 AND 180 THEN DATEDIFF(N,PREVIOUS_TIME,WTIME) ELSE 0 END) AS MAX_BREAK_TIME
    FROM (
        SELECT
            T0.WGUID,
            T0.WTIME,
            T0.ACCOUNT_ID,
            MAX(T1.WTIME) AS PREVIOUS_TIME
        FROM (
            SELECT
                T0.WGUID,
                T0.WTIME,
                T0.ACCOUNT_ID
            FROM SASYSUSERS AS T0
            INNER JOIN (
                SELECT ACCOUNT_ID
                FROM SAAPP
                WHERE SYSACCOUNT = 0
                GROUP BY ACCOUNT_ID
                HAVING SUM(FOCUS_TIME) > 0
            ) AS T1 ON T0.ACCOUNT_ID = T1.ACCOUNT_ID
            WHERE
                WTYPE = 1
                AND WUSAGE = 3
        ) AS T0
        LEFT JOIN (
            SELECT
                T0.WTIME,
                T0.ACCOUNT_ID
            FROM SASYSUSERS AS T0
            INNER JOIN (
                SELECT ACCOUNT_ID
                FROM SAAPP
                WHERE SYSACCOUNT = 0
                GROUP BY ACCOUNT_ID
                HAVING SUM(FOCUS_TIME) > 0
            ) AS T1 ON T0.ACCOUNT_ID = T1.ACCOUNT_ID
            WHERE
                WTYPE = 1
                AND WUSAGE = 3
        ) AS T1 ON T0.WTIME > T1.WTIME AND T0.ACCOUNT_ID = T1.ACCOUNT_ID
        GROUP BY
            T0.WGUID,
            T0.WTIME,
            T0.ACCOUNT_ID
    ) AS T0
    INNER JOIN SASTRUSER AS S0 ON T0.ACCOUNT_ID = S0.STRINGID
    GROUP BY
        T0.WGUID,
        S0.STRVALUE,
        DATEADD(D,DATEDIFF(D,0,T0.WTIME),0)
) AS T0
WHERE
    DATEDIFF(D, DOTY, <LASTREFRESHTIME>) <= 0
    AND DATEDIFF(D, DOTY, GETUTCDATE()) > 0

Employee Wellbeing Role

The Employee Wellbeing DEX Pack requires you to assign the SF_Employee Wellbeing 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_Employee Wellbeing Role to the Configuration by dragging it from Available Roles to Assigned Roles

  5. Enable View by selecting XenApp Sessions

  6. Click Save Changes at the top-right

  7. Repeat this process for any other relevant Configurations

Security Role

Due to the sensitive nature of the data in this DEX Pack, only specific users can view this DEX Pack. By default, the Employee Wellbeing Security Role is applied. With this Security Role, only users with Dashboard Builder access can view this DEX Pack.

To edit the users who can view this DEX Pack:

  1. Open Dashboard Builder

  2. Click the key icon in the top-left

  3. Click Employee Wellbeing Security Role

  4. Use the Role Membership pane to add or remove users as needed. You can add individual users or dynamic groups of users

By default, only those with Dashboard Builder access can view this DEX Pack.