Minimum Version
This DEX Pack requires SysTrack version 11.6 or higher.
Enable the Action
Verify you have unlocked the tenant next to your user name.
In Configure, click Automations and Collection Extensions on the left.
Click Action Governance.
Click Pending Approval.
Find WAP_PERF.
Check the Approved box.
Click Save Changes at the top right.
Create the 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 View to a 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.