I have created SQL query for AP and clients but i have one concern ??

rajasekar

In the original Query am getting many duplicate entry for remove that i have added distinct in that query. It running in SWQL studio but not running in application widgets custom query ????

SELECT  distinct top 30

h.Name as Client_Name, c.IPAddress as Client_IP, c.MAC as Client_MAC, ap.DisplayName, c.SSID, CONCAT (c.SignalStrength,' dbm') AS Singnal_Strength

FROM orion.wireless.accesspoints ap

INNER JOIN Orion.Wireless.Clients c on ap.id=c.accesspointid

INNER JOIN Orion.Wireless.ClientsSessionHistory h ON c.AccessPointID=h.APID

--order by c.SignalStrength ASC

RichardLetts

adding distinct to a query is seldom the right answer to duplicate rows if you were not expecting duplicate rows.

Your query returns the worst performing signal strength for a client ever. I am not sure this is useful.

I'm almost sure you want something like [untested]

SELECT  top 30

h.Name as Client_Name, c.MAC as Client_MAC, ap.DisplayName, c.SSID, min(c.SignalStrength,) AS Signal_Strength

FROM orion.wireless.accesspoints ap

INNER JOIN Orion.Wireless.Clients c on ap.id=c.accesspointid

INNER JOIN Orion.Wireless.ClientsSessionHistory h ON c.AccessPointID=h.APID

where h.LastUpdate > '2019-01-01' -- or some date calculation

group by h.Name , c.MAC , ap.DisplayName, c.SSID

order by c.SignalStrength ASC

to show a clients worst signal on an AP since the start of 2019 (i'm still not sure this is that useful )