Remote Working Installation Instructions

  • Published on Feb 23, 2026
  • 8 minute(s) read
Prev Next

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_Remote Working Role. You must also repeat the steps listed under Office Subnets Setup.

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

Performance Data View

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

Some performance data in the DEX Pack requires you to create a 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_NETPERFDAILY

    2. Existing Category: General

    3. Expires in: 30 Days

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

SF_NETPERFDAILY SQL Query

SELECT
	T1.WGUID,
	GETUTCDATE() AS VWTIME,
	DATEADD(D, DATEDIFF(D, 0, T1.WTIME), 0) AS DOTY,
	T1.VPN_FLAG,
	T1.ADPT_DESC,
	T1.ADPT_IP4_ADDR,
	MAX(T1.WLAN_SEC_ENABLED) AS WLAN_SEC_ENABLED,
	MAX(T1.NET_INTERNET_CONN) AS NET_INTERNET_CONN,
	AVG(T1.NET_UTIL) AS NET_UTIL,
	AVG(T1.FRAME_RATE) AS FRAME_RATE,
	AVG(T1.BYTE_RATE) AS BYTE_RATE,
	AVG(T1.BCAST_RATE) AS BCAST_RATE,
	AVG(T1.OUTQLEN) AS OUTQLEN,
	AVG(T1.REXMIT) AS REXMIT,
	AVG(T1.WIFI_SIGNALQ) AS WIFI_SIGNALQ,
	AVG(T1.WIFI_TRANS_RATE) AS WIFI_TRANS_RATE,
	AVG(T1.WIFI_RECV_RATE ) AS WIFI_RECV_RATE,
	SUM(T2.LATENCY) AS HEALTH_LATENCY_MINS,
	SUM(T2.NET) AS HEALTH_NET_MINS,
	COUNT(T1.WTIME) * 10 AS CONN_MINS,
	COUNT(T3.WTIME) * 10 AS ACTIVE_MINS
FROM (((
	SELECT
		T0.WTIME,
		MAX(T1.VPN_FLAG) AS VPN_FLAG
	FROM SANET AS T0
	LEFT JOIN (
		SELECT
			CASE WHEN (S0.STRVALUE LIKE '%VPN%' OR S2.STRVALUE = 'Demand' OR T0.ADPT_MACADDR IS NULL OR S1.STRVALUE LIKE '%VPN%' OR S1.STRVALUE LIKE '%Cisco%' OR S1.STRVALUE LIKE '%Perimeter%' OR S1.STRVALUE LIKE '%Windscribe%' OR S1.STRVALUE LIKE '%twingate%' OR S1.STRVALUE LIKE '%Juniper%' OR S1.STRVALUE LIKE '%Nord%' OR S1.STRVALUE LIKE '%torguard%' OR S1.STRVALUE LIKE '%encrypt%' OR S1.STRVALUE LIKE '%avast%' OR S1.STRVALUE LIKE '%AVG%' OR S1.STRVALUE LIKE '%PANGP%') AND S1.STRVALUE NOT LIKE '%AVASTAR%' THEN 1 ELSE 0 END AS VPN_FLAG,
			T0.CONN_TIME,
			T0.DISCONN_TIME,
			S1.STRVALUE AS ADPT_DESC,
			S3.STRVALUE AS ADPT_IP4_ADDR
		FROM ((((SANET_CONN_HISTORY AS T0
		LEFT JOIN SASTRDEVICE AS S0 ON T0.ADPT_FRIENDLY_ID = S0.STRINGID)
		LEFT JOIN SASTRDEVICE AS S1 ON T0.ADPT_DESC_ID = S1.STRINGID)
		LEFT JOIN SASTRDEVICE AS S2 ON T0.ADPT_CONN_TYPE = S2.STRINGID)
		LEFT JOIN SASTRDEVICE AS S3 ON T0.ADPT_IP4_ADDR_ID = S3.STRINGID)
		LEFT JOIN SASTRDEVICE AS S4 ON T0.NET_DNSSUFFIX_ID = S4.STRINGID
		WHERE
			S4.STRVALUE <> 'Identifying...'
			AND T0.DISCONN_TIME IS NOT NULL
			AND T0.DISCONN_TIME >= GETUTCDATE() - 30
			AND S0.STRVALUE NOT LIKE '%VMWARE%'
		UNION
		SELECT
			T0.VPN_FLAG,
			T0.CONN_TIME,
			T0.DISCONN_TIME,
			T0.ADPT_DESC,
			T0.ADPT_IP4_ADDR
		FROM (
			SELECT
				CASE WHEN (S0.STRVALUE LIKE '%VPN%' OR S2.STRVALUE = 'Demand' OR T0.ADPT_MACADDR IS NULL OR S1.STRVALUE LIKE '%VPN%' OR S1.STRVALUE LIKE '%Cisco%' OR S1.STRVALUE LIKE '%Perimeter%' OR S1.STRVALUE LIKE '%Windscribe%' OR S1.STRVALUE LIKE '%twingate%' OR S1.STRVALUE LIKE '%Juniper%' OR S1.STRVALUE LIKE '%Nord%' OR S1.STRVALUE LIKE '%torguard%' OR S1.STRVALUE LIKE '%encrypt%' OR S1.STRVALUE LIKE '%avast%' OR S1.STRVALUE LIKE '%AVG%' OR S1.STRVALUE LIKE '%PANGP%') AND S1.STRVALUE NOT LIKE '%AVASTAR%' THEN 1 ELSE 0 END AS VPN_FLAG,
				T0.CONN_TIME AS CONN_TIME,
				GETUTCDATE() AS DISCONN_TIME,
				S1.STRVALUE AS ADPT_DESC,
				S3.STRVALUE AS ADPT_IP4_ADDR
			FROM ((((SANET_CONN_HISTORY AS T0
			LEFT JOIN SASTRDEVICE AS S0 ON T0.ADPT_FRIENDLY_ID = S0.STRINGID)
			LEFT JOIN SASTRDEVICE AS S1 ON T0.ADPT_DESC_ID = S1.STRINGID)
			LEFT JOIN SASTRDEVICE AS S2 ON T0.ADPT_CONN_TYPE = S2.STRINGID)
			LEFT JOIN SASTRDEVICE AS S3 ON T0.ADPT_IP4_ADDR_ID = S3.STRINGID)
			LEFT JOIN SASTRDEVICE AS S4 ON T0.NET_DNSSUFFIX_ID = S4.STRINGID
			WHERE
				S4.STRVALUE <> 'Identifying...'
				AND T0.DISCONN_TIME IS NULL
				AND S0.STRVALUE NOT LIKE '%VMWARE%'
		) AS T0
		INNER JOIN (
			SELECT
				MAX(T0.CONN_TIME) AS CONN_TIME,
				S1.STRVALUE AS ADPT_DESC
			FROM (SANET_CONN_HISTORY AS T0
			LEFT JOIN SASTRDEVICE AS S1 ON T0.ADPT_DESC_ID = S1.STRINGID)
			LEFT JOIN SASTRDEVICE AS S4 ON T0.NET_DNSSUFFIX_ID = S4.STRINGID
			WHERE
				S4.STRVALUE <> 'Identifying...'
				AND T0.DISCONN_TIME IS NULL
			GROUP BY S1.STRVALUE
		) AS T1 ON T0.ADPT_DESC = T1.ADPT_DESC AND T0.CONN_TIME = T1.CONN_TIME
	) AS T1 ON T0.WTIME >= T1.CONN_TIME AND T0.WTIME < T1.DISCONN_TIME
	WHERE
		T0.WTYPE = 1
		AND DATEDIFF(D, T0.WTIME, <LASTREFRESHTIME>) <= 0
		AND DATEDIFF(D, T0.WTIME, GETUTCDATE()) > 0
	GROUP BY T0.WTIME
) AS T0
INNER JOIN (
	SELECT
		T0.WGUID,
		T0.WTIME,
		T1.VPN_FLAG,
		T1.ADPT_DESC,
		T1.ADPT_IP4_ADDR,
		T0.NET_UTIL,
		T0.FRAME_RATE,
		T0.BYTE_RATE,
		T0.BCAST_RATE,
		T0.OUTQLEN,
		T0.REXMIT,
		T0.WIFI_SIGNALQ,
		T0.WIFI_TRANS_RATE,
		T0.WIFI_RECV_RATE,
		T1.WLAN_SEC_ENABLED,
		T1.NET_INTERNET_CONN
	FROM SANET AS T0
	LEFT JOIN (
		SELECT
			CASE WHEN (S0.STRVALUE LIKE '%VPN%' OR S2.STRVALUE = 'Demand' OR T0.ADPT_MACADDR IS NULL OR S1.STRVALUE LIKE '%VPN%' OR S1.STRVALUE LIKE '%Cisco%' OR S1.STRVALUE LIKE '%Perimeter%' OR S1.STRVALUE LIKE '%Windscribe%' OR S1.STRVALUE LIKE '%twingate%' OR S1.STRVALUE LIKE '%Juniper%' OR S1.STRVALUE LIKE '%Nord%' OR S1.STRVALUE LIKE '%torguard%' OR S1.STRVALUE LIKE '%encrypt%' OR S1.STRVALUE LIKE '%avast%' OR S1.STRVALUE LIKE '%AVG%' OR S1.STRVALUE LIKE '%PANGP%') AND S1.STRVALUE NOT LIKE '%AVASTAR%' THEN 1 ELSE 0 END AS VPN_FLAG,
			T0.CONN_TIME,
			T0.DISCONN_TIME,
			S1.STRVALUE AS ADPT_DESC,
			S3.STRVALUE AS ADPT_IP4_ADDR,
			T0.WLAN_SEC_ENABLED,
			T0.NET_INTERNET_CONN
		FROM ((((SANET_CONN_HISTORY AS T0
		LEFT JOIN SASTRDEVICE AS S0 ON T0.ADPT_FRIENDLY_ID = S0.STRINGID)
		LEFT JOIN SASTRDEVICE AS S1 ON T0.ADPT_DESC_ID = S1.STRINGID)
		LEFT JOIN SASTRDEVICE AS S2 ON T0.ADPT_CONN_TYPE = S2.STRINGID)
		LEFT JOIN SASTRDEVICE AS S3 ON T0.ADPT_IP4_ADDR_ID = S3.STRINGID)
		LEFT JOIN SASTRDEVICE AS S4 ON T0.NET_DNSSUFFIX_ID = S4.STRINGID
		WHERE
			S4.STRVALUE <> 'Identifying...'
			AND T0.DISCONN_TIME IS NOT NULL
			AND T0.DISCONN_TIME >= GETUTCDATE() - 30
			AND S0.STRVALUE NOT LIKE '%VMWARE%'
		UNION
		SELECT
			T0.VPN_FLAG,
			T0.CONN_TIME,
			T0.DISCONN_TIME,
			T0.ADPT_DESC,
			T0.ADPT_IP4_ADDR,
			T0.WLAN_SEC_ENABLED,
				T0.NET_INTERNET_CONN
		FROM (
			SELECT
				CASE WHEN (S0.STRVALUE LIKE '%VPN%' OR S2.STRVALUE = 'Demand' OR T0.ADPT_MACADDR IS NULL OR S1.STRVALUE LIKE '%VPN%' OR S1.STRVALUE LIKE '%Cisco%' OR S1.STRVALUE LIKE '%Perimeter%' OR S1.STRVALUE LIKE '%Windscribe%' OR S1.STRVALUE LIKE '%twingate%' OR S1.STRVALUE LIKE '%Juniper%' OR S1.STRVALUE LIKE '%Nord%' OR S1.STRVALUE LIKE '%torguard%' OR S1.STRVALUE LIKE '%encrypt%' OR S1.STRVALUE LIKE '%avast%' OR S1.STRVALUE LIKE '%AVG%' OR S1.STRVALUE LIKE '%PANGP%') AND S1.STRVALUE NOT LIKE '%AVASTAR%' THEN 1 ELSE 0 END AS VPN_FLAG,
				T0.CONN_TIME AS CONN_TIME,
				GETUTCDATE() AS DISCONN_TIME,
				S1.STRVALUE AS ADPT_DESC,
				S3.STRVALUE AS ADPT_IP4_ADDR,
				T0.WLAN_SEC_ENABLED,
				T0.NET_INTERNET_CONN
			FROM ((((SANET_CONN_HISTORY AS T0
			LEFT JOIN SASTRDEVICE AS S0 ON T0.ADPT_FRIENDLY_ID = S0.STRINGID)
			LEFT JOIN SASTRDEVICE AS S1 ON T0.ADPT_DESC_ID = S1.STRINGID)
			LEFT JOIN SASTRDEVICE AS S2 ON T0.ADPT_CONN_TYPE = S2.STRINGID)
			LEFT JOIN SASTRDEVICE AS S3 ON T0.ADPT_IP4_ADDR_ID = S3.STRINGID)
			LEFT JOIN SASTRDEVICE AS S4 ON T0.NET_DNSSUFFIX_ID = S4.STRINGID
			WHERE
				S4.STRVALUE <> 'Identifying...'
				AND T0.DISCONN_TIME IS NULL
				AND S0.STRVALUE NOT LIKE '%VMWARE%'
		) AS T0
		INNER JOIN (
			SELECT
				MAX(T0.CONN_TIME) AS CONN_TIME,
				S1.STRVALUE AS ADPT_DESC
			FROM (SANET_CONN_HISTORY AS T0
			LEFT JOIN SASTRDEVICE AS S1 ON T0.ADPT_DESC_ID = S1.STRINGID)
			LEFT JOIN SASTRDEVICE AS S4 ON T0.NET_DNSSUFFIX_ID = S4.STRINGID
			WHERE
				S4.STRVALUE <> 'Identifying...'
				AND T0.DISCONN_TIME IS NULL
			GROUP BY S1.STRVALUE
		) AS T1 ON T0.ADPT_DESC = T1.ADPT_DESC AND T0.CONN_TIME = T1.CONN_TIME
	) AS T1 ON T0.WTIME >= T1.CONN_TIME AND T0.WTIME < T1.DISCONN_TIME
	WHERE
		T0.WTYPE = 1
		AND DATEDIFF(D, T0.WTIME, <LASTREFRESHTIME>) <= 0
		AND DATEDIFF(D, T0.WTIME, GETUTCDATE()) > 0
) AS T1 ON T0.WTIME = T1.WTIME AND T0.VPN_FLAG = T1.VPN_FLAG)
LEFT JOIN (
	SELECT
		WTIME,
		NET,
		LATENCY
	FROM SAHEALTH
	WHERE
		WTYPE = 1
		AND DATEDIFF(D, WTIME, <LASTREFRESHTIME>) <= 0
		AND DATEDIFF(D, WTIME, GETUTCDATE()) > 0
) AS T2 ON T0.WTIME = T2.WTIME)
LEFT JOIN (
	SELECT WTIME
	FROM SASYS
	WHERE
		WTYPE = 1
		AND WUSAGE >= 3
		AND DATEDIFF(D, WTIME, <LASTREFRESHTIME>) <= 0
		AND DATEDIFF(D, WTIME, GETUTCDATE()) > 0
) AS T3 ON T0.WTIME = T3.WTIME
GROUP BY
	T1.WGUID,
	DATEADD(D, DATEDIFF(D, 0, T1.WTIME), 0),
	T1.VPN_FLAG,
	T1.ADPT_DESC,
	T1.ADPT_IP4_ADDR

External USB Devices View

The External USB Devices Dashboard requires you to create a 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_USB

    2. Existing Category: General

    3. Expires in: 30 Days

    4. When Expired: Overwrite 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

SF_USB SQL Query

SELECT
	T0.WGUID,
	GETUTCDATE() AS VWTIME,
	S0.STRVALUE AS DEVICE_NAME,
	S2.STRVALUE AS MANUFACTURER
FROM ((SAPNP AS T0
INNER JOIN SASTR AS S0 ON T0.CAPTION = S0.STRINGID)
INNER JOIN SASTR AS S1 ON T0.DEVICEID = S1.STRINGID)
INNER JOIN SASTR AS S2 ON T0.MANUFAC = S2.STRINGID
WHERE
	S1.STRVALUE LIKE 'USB%'
	AND S2.STRVALUE NOT IN ('(Standard USB HUBs)',
	'(Standard system devices)',
	'(Standard USB Host Controller)',
	'(Generic USB Hub)')

Assign Views

After the above Views have been created, they must be assigned to the SF_Remote Working Role:

  1. Navigate to Configure > Roles

  2. Use the drop-down at the top to select the SF_Remote Working Role

  3. Click Views, then check the boxes next to  SF_NETPERFDAILY, and SF_USB.

  4. Click Save Changes at the top-right

Remote Working Role

This DEX Pack requires you to assign the SF_Remote Working 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_Remote Working 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

Office Subnets Setup

Most Dashboards in this DEX Pack can be configured to ignore systems connected to your office subnets. If configured correctly, data in those Dashboards will be restricted to remote systems.

The default office subnets (10.0.0.0/8) may already cover most of the office subnets in your enterprise. If not, then you can manually enter new office subnets:

  1. Open the Remote Working Dashboard in Dashboard Viewer

  2. Navigate to Remote Connectivity > Home Connectivity

  3. To quickly open a Dashboard in Dashboard Builder, replace the word “viewer” in the URL with the word “builder”

  4. Click the blue Page Context box connected to an Office Subnets box. This box is usually located in the lower-right section

  5. Paste a list of your office subnets in the Default Value text box, separated by commas. There is a 1,000-character limit for this text box

  6. Click Apply

  7. To quickly return to Dashboard Viewer, click the Viewer button or the Back button in your browser

  8. Repeat this process for every Dashboard in this DEX Pack containing an Office Subnets pane under Advanced Options. This includes every Dashboard except the Overview, Summary, and Remote Session Intelligence panes.

You must repeat this process any time you reinstall this DEX Pack.

Related articles

© 2017 - 2026 Lakeside Software, LLC. All Rights Reserved

X (formerly Twitter) icon YouTube icon LinkedIn icon