---
title: "Wireless Access Point Performance Installation Instructions"
slug: "wireless-access-point-performance-installation-instructions"
updated: 2026-02-16T09:50:32Z
published: 2026-02-16T09:50:32Z
---

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

# Wireless Access Point Performance Installation Instructions

## Minimum Version

This DEX Pack requires SysTrack version 11.6 or higher.

## Enable the Action

1. Verify you have unlocked the tenant next to your user name.
2. In **Configure**, click **Automations and Collection Extensions** on the left.
3. Click **Action Governance**.
4. Click **Pending Approval**.
5. Find **WAP_PERF**.
6. Check the **Approved** box.
7. Click **Save Changes** at the top right.

## Create the View

1. Go to Configure.
2. Go to **SysTrack Settings** > **Views**.
3. Click the **padlock icon** at the top-right of the screen to allow for editing.
4. Click the **plus icon** to create a new **View**.
5. 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**
6. In **SQL Generic**, paste the below SQL query:

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

1. Click **Test SQL** to validate the query. The top of the screen will display Success if the SQL code is valid.
2. Click **Create View**. It may take a few moments to see the new view in the view list.

## Assign the View to a Role

1. In Configure, go to **System Configuration** > **Roles**.
2. Select **SF_WAP Performance** from the drop down list.
3. At the bottom of the screen, select the **Views** tab.
4. Scroll to **WAP_PERF_DAILY** and select it.
5. Click **Save Changes**.