Hey guys and gals.
I have two reports that I want to write and I need some help.
One is, I am looking for a report where I could pull up telling me which devices were unmanaged and when.
The other is I have a whole bunch of AP's all over my campus. I want to know how many indivdual people connect to it. I am able to see how many clients connect using:
SELECT TOP 10000 Convert(DateTime,Floor(Cast((DateTime) as Float)*24)/24,0) AS SummaryDateTime,
COUNT(NPM_NV_WL_REPORT_APS_V.ClientsCount) AS COUNT_of_Avg_Clients_Count,
NPM_NV_WL_REPORT_APS_V.WirelessType AS Wireless_Type
FROM
NPM_NV_WL_REPORT_APS_V
WHERE
( DateTime BETWEEN 40139 AND 40140 )
GROUP BY Convert(DateTime,Floor(Cast((DateTime) as Float)*24)/24,0),
NPM_NV_WL_REPORT_APS_V.WirelessType
ORDER BY SummaryDateTime ASC
This lookup will only prodide me with clients regardless how many time. This isn't good information 'cause of the wireless voip devices we use. So it'll count every AP association (I think) This lookup doesn't look at the MAC addresses. I know I need to look for 'distinct' in regards to MAC's but I don't know how to accomplish that.
I have a very weak skillset in SQL so any help would be really appreciated. I am doing my best to figure this stuff out though.
I don't even know if these are possible to do.
You guidance would be greatly appreciated. Thank you.
