Prerequisites
Minimum Version: Requires SysTrack 11.6 or later.
Notes
If you update or reinstall this DEX Pack, you must reassign any Views created below to the SF_WAP Performance Role and reapprove the WAP_PERF Action.
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.
Enable the WAP_PERF Action
Verify you have unlocked the tenant next to your username.
In Configure, click Automations and Collection Extensions on the left.
Select Action Governance, then click the Pending Approval tab.
Find the WAP_PERF Action and select the checkbox next to it.
Click Approve, then confirm. The action moves to the Actions tab and is enabled automatically.
NOTE: In SysTrack Cloud, the user who imported the Kit may not be allowed to approve its actions. If the checkbox is unavailable, ask another user with Action Governance – Management permission to approve the action.
Create the WAP_PERF_DAILY View
Go to Configure.
Go to SysTrack Settings > Views.
Click the padlock icon at the top-right of the screen to allow for editing.
Click the plus icon to create a new View.
Enter the following values in the Settings section:
View Name: WAP_PERF_DAILY
Existing Category: Custom
Expires in: 30 days
When Expired: Append Data
Refresh: Daily, Inside, 24x7
In SQL Generic, paste the below SQL query:
SELECT WGUID, GETUTCDATE() AS VWTIME, DOTY, SSID, BSSID, SUM(HOURSVAL) AS HOURSVAL, AVG(SignalStrength) AS SIGNAL_Q, AVG(ReceiveRate) AS REC_RATE, AVG(TransmitRate) AS TRANS_RATE FROM ( SELECT T0.WGUID, DATEADD(D,DATEDIFF(D,0,T0.WTIME),0) AS DOTY, POWER(2, DATEPART(HH,T0.WTIME)) AS HOURSVAL, S1.STRVALUE AS SSID, S0.STRVALUE AS BSSID, AVG(T0.SignalStrength) AS SignalStrength, AVG(T0.ReceiveRate) AS ReceiveRate, AVG(T0.TransmitRate) AS TransmitRate FROM DYNC_WAP_PERF AS T0 INNER JOIN SASTR_DYN AS S0 ON T0.BSSID = S0.STRINGID INNER JOIN SASTR_DYN AS S1 ON T0.SSID = S1.STRINGID WHERE T0.WTYPE = 0 AND DATEDIFF(D, T0.WTIME, <LASTREFRESHTIME>) <= 0 AND DATEDIFF(D, T0.WTIME, GETUTCDATE()) > 0 GROUP BY T0.WGUID, DATEADD(D,DATEDIFF(D,0,T0.WTIME),0), POWER(2, DATEPART(HH,T0.WTIME)), S1.STRVALUE, S0.STRVALUE ) AS T0 GROUP BY WGUID, DOTY, SSID, BSSIDClick Test SQL to validate the query. The top of the screen will display Success if the SQL code is valid.
Click Create View. It may take a few moments to see the new view in the view list.
Assign the WAP_PERF_DAILY View to the SF_WAP Performance Role
In Configure, go to System Configuration > Roles.
Select SF_WAP Performance from the drop down list.
At the bottom of the screen, select the Views tab.
Scroll to WAP_PERF_DAILY and select it.
Click Save Changes.