this workaround refers to file 22-clienthistory.resource in folder 1-2-WirelessSummary which shows only an error even when u have version 8.1 of all.
the stats are modified for a better overview. we have decided to do this by own 'cause helpdesk of solarwind couldnt give us help for that problem. so our sql jockey wrote the resource new. maybe u would change the date statement; its for germany dates.
we are working also on the other problems in the wlan views eg the node id problem, still occurs in version 8.1. ; but we have a resolution which i'll post later after some testing.
some info: we have over 1000 access points running with more than 1200 users connecting to them, and at this time the wireless addon is not capable for this. means that the polling engine goes crazy on our server (dl380 4gigram an 2*core2duo)
u may give them a try
<!-- Title=Wireless Client History -->
<!--#include Virtual=/NetPerfMon/scripts/Resource.asp -->
<%
Dim Period
Dim SQL, SQL_SELECT, SQL_WHERE, SQL_GROUP_ORDER
Period = Resource.GetProperty("Period")
If Len(Period) =0 Then Period="Today"
Title=Resource.Title
If Len(Title)=0 Then Title="Wireless Client History"
SubTitle=Period
if Len(Resource.SubTitle)>0 Then SubTitle=Resource.SubTitle
HelpPage="AllNodes"
EditButton="/NetPerfMon/Resources/Filter.Edit.asp?ResourceID=" & Resource.ResourceID & "&ViewID=" & ViewID
DoResourceHeader
Set SQLResource = NetPerfMon.NewSQLResource
SQL_SELECT = "SELECT ClientMacAddress,IPAddress, MIN(TimeAssociated) TimeAssociated, MIN(TimeDeAssociated) TimeDeAssociated, SUM(TotalPacketsRx) TotalPacketsRx, SUM(TotalPacketsTx) TotalPacketsTx, SUM(TotalBytesRx) TotalBytesRx, SUM(TotalBytesTx) TotalBytesTx, COUNT(*) SessionCount FROM WirelessSessions "
SQL_WHERE = "WHERE IPAddress <> '0.0.0.0' AND (TimeDeAssociated <= 0 OR (YEAR(TimeDeAssociated) = YEAR(CONVERT(DATETIME,'${" & Period & "}',104)) and MONTH(TimeDeAssociated) = MONTH(CONVERT(DATETIME,'${" & Period & "}',104)) and DAY(TimeDeAssociated) = DAY(CONVERT(DATETIME,'${" & Period & "}',104)))) "
SQL_GROUP_ORDER = " GROUP BY ClientMacAddress, IPAddress Order By TimeDeAssociated, ClientMacAddress,IPAddress"
If Node Is Nothing Then
SQL = SQL_SELECT + SQL_WHERE + SQL_GROUP_ORDER
Else
SQL_WHERE = " AND Nodes.NodeID = " & Node.NodeID & " "
SQL = SQL_SELECT + SQL_WHERE + SQL_GROUP_ORDER
End If
SQLResource.SQL=SQL
SQLResource.Filter= Resource.GetProperty("Filter")
SQLResource.Execute
'Response.Write SQLResource.SQL
If SQLResource.RecordCount = 0 Then
Response.Write "<Span class=Text>No Wireless Clients at this time</Span><br>"
Else
DoReport
End If
Sub DoReport
%>
<table border="0" cellPadding="2" cellSpacing="0" width="100%">
<tr>
<td class="PropertyHeader">IP Address</td>
<td class="PropertyHeader">MAC Address</td>
<td class="PropertyHeader">Session Count</td>
<td class="PropertyHeader">Time<br>Associated</td>
<td colspan=2 class="PropertyHeader">Time<br>DeAssociated</td>
<td class="PropertyHeader">Total Bytes<br>Transmitted</td>
<td class="PropertyHeader">Total Bytes<br>Received</td>
</tr>
<%
Do While Not SQLResource.EOF
If CDate(SQLResource.GetProperty("TimeDeAssociated As Raw")) < #1/10/1900# Then
%>
<tr>
<td class="Property"><a href="")%>"><%=SQLResource.GetProperty("IPAddress")%></a>">thwack.solarwinds.com/.../View.asp </td>
<td class="Property"><a href="")%>"><%=SQLResource.GetProperty("ClientMACAddress")%></a>">thwack.solarwinds.com/.../View.asp </td>
<td class="Property"><%=SQLResource.GetProperty("SessionCount")%> </td>
<td class="Property"><a href="")%>"><%=SQLResource.GetProperty("TimeAssociated")%></a>">thwack.solarwinds.com/.../View.asp </td>
<td class="Property"><img src="\NetPerfMon\images\Small-Up.gif" border=0></td>
<td class="Property"><b>Still Active</b> </td>
<td class="Property"><%=SQLResource.GetProperty("TotalBytesTx")%> </td>
<td class="Property"><%=SQLResource.GetProperty("TotalBytesRx")%> </td>
</tr>
<% Else %>
<tr>
<td class="Property"><a href="")%>"><font">thwack.solarwinds.com/.../View.asp color=gray><%=SQLResource.GetProperty("IPAddress")%></a> </font></td>
<td class="Property"><a href="")%>"><font">thwack.solarwinds.com/.../View.asp color=gray><%=SQLResource.GetProperty("ClientMACAddress")%></a> </font></td>
<td class="Property"><font color=gray><%=SQLResource.GetProperty("SessionCount")%> </font></td>
<td class="Property"><a href="")%>"><font">thwack.solarwinds.com/.../View.asp color=gray><%=SQLResource.GetProperty("TimeAssociated")%></a> </font></td>
<td class="Property" colspan=2><font color=gray><a href="")%>"><font">thwack.solarwinds.com/.../View.asp color=gray><%=SQLResource.GetProperty("TimeDeAssociated")%></a> </font></td>
<td class="Property"><font color=gray><%=SQLResource.GetProperty("TotalBytesTx")%> </font></td>
<td class="Property"><font color=gray><%=SQLResource.GetProperty("TotalBytesRx")%> </font></td>
</tr>
<%
End If
SQLResource.MoveNext
Loop
%>
</table>
<%
End Sub
%>
<br>
