Remote Working 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_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

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

Copy SF_NETPERFDAILY

Copy 
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

Copy SF_USB

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