Aruba 7210 - User connections on Main Dashboard

northernscum

Hi there

 I am wondering if someone knows how to create a chart that shows the number of connections from an Aruba network (7210) using the 8.x code.
Thanks and have a great day  

stuartd

Presumably you can see the Thin APs via the wireless tab?

Assuming yes, then what we did was create a custom SWQL query widget with the following code:

SELECT 
wap.DisplayName as [AP_Name],
CONCAT('/Orion/Wireless/ThinAccessPointDetailsView.aspx?NetObject=WLTAP:',wap.ID) as [_linkfor_AP_Name],
'/Orion/Wireless/images/Object-WAP_Thin-Up.png' as [_iconfor_AP_Name],
wap.IPAddress as [IP Address],
apdata.model as [Model],
n.Caption as [Controller],
n.detailsurl as [_linkfor_Controller],
apdata.serial as [Serial],
wap.Clients



FROM Orion.Wireless.AccessPoints wap
--to retrieve detailsurl and name for controller
LEFT JOIN Orion.Nodes n ON wap.NodeID = n.NodeID
LEFT JOIN Orion.NodesCustomProperties cp ON wap.NodeID = cp.NodeID

--apdata is the core table with the serial and model data in line with the AP name
LEFT JOIN (
SELECT name.label as name, serial.Label as serial, model.label as model FROM Orion.NPM.CustomPollerLabels serial
LEFT JOIN (
SELECT CustomPollerAssignmentID, RowID, Label FROM Orion.NPM.CustomPollerLabels
WHERE CustompollerassignmentID IN (SELECT CustomPollerAssignmentID FROM Orion.NPM.CustomPollerAssignment WHERE CustomPollerOID like '1.3.6.1.4.1.14179.2.2.1.1.3' and Status = '1')
) name ON name.RowID = serial.RowID
LEFT JOIN (
SELECT CustomPollerAssignmentID, RowID, Label FROM Orion.NPM.CustomPollerLabels
WHERE CustompollerassignmentID IN (SELECT CustomPollerAssignmentID FROM Orion.NPM.CustomPollerAssignment WHERE CustomPollerOID like '1.3.6.1.4.1.14179.2.2.1.1.16' and Status = '1')
) model ON model.RowID = serial.RowID
WHERE serial.CustomPollerAssignmentID IN (SELECT CustomPollerAssignmentID FROM Orion.NPM.CustomPollerAssignment WHERE CustomPollerOID like '1.3.6.1.4.1.14179.2.2.1.1.17' and Status = '1')
) apdata ON apdata.name = wap.DisplayName

Where wap.Status = '1' 
--AND n.Vendor LIKE 'Cisco%'

--UnComment following line for adding to WLC node view
AND wap.NodeID =  '${NodeID}'  
--UnComment following line for search box
--AND (wap.DisplayName LIKE '%${SEARCH_STRING}%' OR n.Caption LIKE '%${SEARCH_STRING}%' OR apdata.Model LIKE '%${SEARCH_STRING}%' OR wap.IPAddress LIKE '%${SEARCH_STRING}%' OR apdata.Serial LIKE '%${SEARCH_STRING}%')  
ORDER BY [AP_Name]