---
title: "Web Browsing Intelligence Installation Instructions"
slug: "web-browsing-intelligence-installation-instructions"
updated: 2026-10-06T14:03:23Z
published: 2026-10-06T14:03:23Z
canonical: "documentation.lakesidesoftware.com/web-browsing-intelligence-installation-instructions"
---

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

# Web Browsing Intelligence Installation Instructions

## Prerequisites

- Minimum Version: Requires SysTrack 10.1 or later.

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

## Installation Steps

To install this DEX Pack, complete the following steps:

1. [Import the Kit](/documentation/docs/web-browsing-intelligence-installation-instructions#import-kit).
2. [Create the Web Browser View](/documentation/docs/web-browsing-intelligence-installation-instructions#web-browser-view).
3. [Assign the Web Browser View to the Web Browsing Intelligence Role](/documentation/docs/web-browsing-intelligence-installation-instructions#assign-the-web-browser-view-to-the-web-browsing-intelligence-role).
4. [Create the Web Error Code View](/documentation/docs/web-browsing-intelligence-installation-instructions#web-error-code-view).
5. [Assign the Web Error Code View to the Web Browser Intelligence Role](/documentation/docs/web-browsing-intelligence-installation-instructions#assign-the-web-error-code-view-to-the-web-browser-intelligence-role).
6. [Assign the Web Browsing Intelligence Role to Relevant Configurations](/documentation/docs/web-browsing-intelligence-installation-instructions#enable-roles).

### Import the Kit

There are two ways to import the DEX Pack to SysTrack:

- Import the pack directly from the Kits page in SysTrack. See the [Import Online Kits](/documentation/docs/import-online-kits) guide for more information.
- Import a local file downloaded from the [DEX and Kit Downloads](/documentation/docs/dex-packs-dex-and-kit-downloads) page. Click the **Download Kit** link for the pack and follow the [Import Local Kits](/documentation/docs/import-local-kits) guide to finish the import.

### Create the 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 the [SF_BROWSERPERFDAILY SQL Query](/documentation/docs/web-browsing-intelligence-installation-instructions#sfbrowserperfdaily-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_BROWSERPERFDAILY SQL Query

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

### Assign the Web Browser View to the Web Browsing Intelligence Role

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, HTTP status code data will be collected **each day**. It will take **30 days** before the data in this Dashboard is fully populated.

### Create the Web Error Code View

The Web Browsing Intelligence Dashboard requires you to make a two Views. The second one 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: Overwrite**
  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 the [SF_WEBERRORCODES SQL Query](/documentation/docs/web-browsing-intelligence-installation-instructions#sfweberrorcodes-sql-query1), and paste it into the box under SQL **Selection** > **Generic**.
  8. Click **Test SQL**. A **Success** message should appear at the top of the screen. If the test is not successful, the query may have been copied incorrectly.
5. Click **Create View** at the top-right.

#### SF_WEBERRORCODES SQL Query

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

### Assign the Web Error Code View to the Web Browser Intelligence Role

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, it retrieves HTTP status code data for the previous 30 days each day, overwriting the data from the previous run.

### Assign the Web Browsing Intelligence Role to Relevant Configurations

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.