I need to include in my inventory count report those Wireless Access Points behind the Wireless Controller.
How can that be done?
This data should be in the DB just would need to create an advanced sql report
Did you create a sql report for this? I would love to have a report just like this.
Agree, I'm a bit lame when it comes to SQL...
Would the data be in a specific table? guessing not the node table....
Maybe some kind person will help us out
--
create an advanced SQL report with something like this in it:
Select count(*) as apCount, ap.controller
From NPM_NV_WL_APS AP
where ap.WirelessType='Thin'
and ap.status=1
group by ap.controller
if you need more details then NPM_NV_WL_APS is the starting point -- though it's not very well populated with information on my install -- inventory-wise the AP name and its IP address are about it. it doesn't even record the vendor/machineType
Richard
Hi, have you tried NPM RC1 & new reporting? It should be easier for you to build that report without using SQL
I am new to Orion....what is RC1? New Reporting? I am truly green in this software can you help me out?
RC means Release Candidate. A new version of NPM is coming out and before is goes public, a Release Candidate is release to users with maintenance and who want it. We users then provide feedback with support access and help make the platform more solid. This is a step between Beta and General release.
Loading the latest on my Dev system tonight.... Cant wait!!