---
title: "Employee Wellbeing Installation Instructions"
slug: "employee-wellbeing-installation-instructions"
updated: 2026-02-23T15:45:58Z
published: 2026-02-23T15:45:58Z
---

> ## Documentation Index
> Fetch the complete documentation index at: https://documentation.lakesidesoftware.com/llms.txt
> Use this file to discover all available pages before exploring further.

# 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**

> [!NOTE]
> **NOTE**: If the existing Category does not contain Custom, create a new category for **Custom** in the **New Category** text box.
  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](/documentation/docs/employee-wellbeing-installation-instructions#copy-sfusersdaily), 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.

#### SF_USERSDAILY SQL Query

```sql
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.