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:

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 guide for more information.
Import a local file downloaded from the DEX and Kit Downloads page. Click the Download Kit link for the pack and follow the 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.

Navigate to Configure > Views.
Click the padlock icon in the upper-right to enable editing.
Click the plus icon to add a new View.
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, 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.
Click Create View at the top right.

SF_BROWSERPERFDAILY SQL Query

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:

Navigate to Configure > Roles.
Use the drop-down at the top to select the SF_Web Browsing Intelligence Role.
Click Views, the check the box next to SF_BROWSERPERFDAILY.
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.

Navigate to Configure > Views.
Click the padlock icon at the top right to unlock the editing.
Click the plus icon to add a new View.
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, 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.
Click Create View at the top-right.

SF_WEBERRORCODES SQL Query

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:

Navigate to Configure > Roles.
Use the drop-down at the top to select the SF_Web Browser Intelligence Role.
Click the Views tab in the center of the page.
Check the Enable box for SF_WEBERRORCODES from the list.
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:

Navigate to Configure > Configurations.
Click the padlock icon in the upper-right to enable editing.
Use the drop-down at the top to select a relevant Configuration, or create a new Configuration.
Assign SF_Web Browsing Intelligence Role to the Configuration by dragging it from Available Roles to Assigned Roles.
Click Save Changes at the top-right.