Web Browsing Intelligence 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_Web Browsing Intelligence 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

Web Browser View

The Web Browsing Intelligence Dashboard requires you to make a two Views. The first is for the SF_BROWSERPERFDAILY.

  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_BROWSERPERFDAILY

    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

    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_Web Browsing Intelligence Role

  3. Click Views, the check the box next to SF_BROWSERPERFDAILY

  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_BROWSERPERFDAILY

Copy 
SELECT
    T0.WGUID,
    GETUTCDATE() AS VWTIME,
    T0.DOTY,
    T0.APPNAME,
    T0.APPVER,
    T0.AVG_MIPS AS TOTAL_AVG_MIPS,
    T0.AVG_IOPS AS TOTAL_AVG_IOPS,
    T0.AVG_MB AS TOTAL_AVG_MBS,
    T1.AVG_MIPS AS SINGLE_AVG_MIPS,
    T1.AVG_IOPS AS SINGLE_AVG_IOPS,
    T1.AVG_MB AS SINGLE_AVG_MB,
    T1.FOCUS_SEC
FROM (
    SELECT
        WGUID,
        APPNAME,
        APPVER,
        DATEADD(D, DATEDIFF(D, 0, WTIME), 0) AS DOTY,
        AVG(TOTMI) AS AVG_MIPS,
        AVG(TOTIO) AS AVG_IOPS,
        AVG(TOTMEM) AS AVG_MB
    FROM (
        SELECT
            T0.WGUID,
            T0.WTIME,
            T1.APPNAME,
            T1.APPVER,
            SUM(T1.TOTMI/(T1.TOTAL_TIME/1000)) AS TOTMI,
            SUM(T1.TOTIO/(T1.TOTAL_TIME/1000)) AS TOTIO,
            SUM(T1.MEM_USED/(T1.TOTAL_TIME/1000/60)) AS TOTMEM
        FROM (
            SELECT
                WGUID,
                WTIME
            FROM SASYS
            WHERE
                WTYPE = 0
                AND WUSAGE > 1
                AND DATEDIFF(D, WTIME, <LASTREFRESHTIME>) <= 0
                AND DATEDIFF(D, WTIME, GETUTCDATE()) > 0
        ) AS T0
        INNER JOIN (
            SELECT
                S0.STRVALUE AS APPNAME,
                S1.STRVALUE AS APPVER,
                T0.START_TIME,
                T0.END_TIME,
                T0.TOTAL_TIME,
                T0.KERN_TOTMI+T0.USER_TOTMI AS TOTMI,
                T0.MEM_USED,
                T0.IOREADS+T0.IOWRITES AS TOTIO
            FROM ((SAAPP AS T0
            INNER JOIN SASTRAPP AS S0 ON T0.APP_ID = S0.STRINGID)
            INNER JOIN SAAPPINFO AS T1 ON T0.APP_ID = T1.APP_ID AND T0.MD5HASH = T1.MD5HASH)
            INNER JOIN SASTR AS S1 ON T1.PROD_VER_ID = S1.STRINGID
            WHERE S0.STRVALUE IN (
                'chrome.exe',
                'firefox.exe',
                'iexplore.exe',
                'msedge.exe',

                'safari.exe',
                'opera.exe'
            )
        ) AS T1 ON T0.WTIME >= T1.START_TIME AND T0.WTIME <= T1.END_TIME
        GROUP BY
            T0.WGUID,
            T0.WTIME,
            T1.APPNAME,
            T1.APPVER
    ) AS T0
    GROUP BY
        WGUID,
        APPNAME,
        APPVER,
        DATEADD(D, DATEDIFF(D, 0, WTIME), 0)
) AS T0
INNER JOIN (
    SELECT
        T0.WGUID,
        S0.STRVALUE AS APPNAME,
        S1.STRVALUE AS APPVER,
        DATEADD(D, DATEDIFF(D, 0, START_TIME), 0) AS DOTY,
        SUM(KERN_TOTMI+USER_TOTMI) / SUM(CASE WHEN TOTAL_TIME < 1000 THEN 1000 ELSE TOTAL_TIME END / 1000) AS AVG_MIPS,
        SUM(IOREADS+IOWRITES) / SUM(CASE WHEN TOTAL_TIME < 1000 THEN 1000 ELSE TOTAL_TIME END / EXEC_COUNT / 1000) AS AVG_IOPS,
        SUM(MEM_USED * 60000) / SUM(CASE WHEN TOTAL_TIME < 1000 THEN 1000 ELSE TOTAL_TIME END) AS AVG_MB,
        SUM(FOCUS_TIME/1000.0) AS FOCUS_SEC
    FROM ((SAAPP AS T0
    INNER JOIN SASTRAPP AS S0 ON T0.APP_ID = S0.STRINGID)
    INNER JOIN SAAPPINFO AS T1 ON T0.APP_ID = T1.APP_ID AND T0.MD5HASH = T1.MD5HASH)
    INNER JOIN SASTR AS S1 ON T1.PROD_VER_ID = S1.STRINGID
    WHERE
        S0.STRVALUE IN (
            'chrome.exe',
            'firefox.exe',
            'iexplore.exe',
            'msedge.exe',

            'safari.exe',
            'opera.exe'
        )
        AND DATEDIFF(D, START_TIME, <LASTREFRESHTIME>) <= 0
        AND DATEDIFF(D, START_TIME, GETUTCDATE()) > 0
    GROUP BY
        T0.WGUID,
        S0.STRVALUE,
        S1.STRVALUE,
        DATEADD(D, DATEDIFF(D, 0, START_TIME), 0)
) AS T1 ON T0.APPNAME = T1.APPNAME AND T0.APPVER = T1.APPVER AND T0.DOTY = T1.DOTY

Web Error Code View

The Web Browsing Intelligence Dashboard requires you to make a two Views. The first is for the SF_WEBERRORCODES.

  1. Navigate to Configure > Views

  2. Click the padlock icon at the top right to unlock the editing

  3. Click the plus icon to add a new View

  4. Fill in the Settings as follows:

    1. View Name: SF_WEBERRORCODES

    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

    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_Web Browser Intelligence Role.

  3. Click the Views tab in the center of the page

  4. Check the Enable box for SF_WEBERRORCODES from the list

  5. Click Save Changes at the top right

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

Copy SF_WEBERRORCODES

Copy 
SELECT
    T0.WGUID,
    S0.STRVALUE AS WEBURL,
    T0.STATUSCODE,
    COUNT(*) AS NUMOCCURRENCES
FROM SAWEB AS T0
INNER JOIN SAWEBSTR AS S0 ON T0.[URL] = S0.STRINGID
WHERE
    T0.STATUSCODE >= 400
    AND T0.FIRST_USE BETWEEN GETUTCDATE() - 30 AND GETUTCDATE()
GROUP BY
    T0.WGUID,
    S0.STRVALUE,
    T0.STATUSCODE

Enable Roles

This DEX Pack requires you to assign the SF_Web Browsing Intelligence 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_Web Browsing Intelligence Role to the Configuration by dragging it from Available Roles to Assigned Roles

  5. Click Save Changes at the top-right