<table class="table table-bordered table-hover table-striped">
<thead>
<tr>
<th>Type</th>
<th>APP</th>
<th>IPAddress</th>
<th>MacAddress</th>
</tr>
</thead>
<tbody>
<%
Dim dbconn As SqlConnection
Dim dbCMD As SqlCommand
Dim dtr As SqlDataReader
dbconn = New SqlConnection("Data Source=192.168.103.124;Initial Catalog=KIWI;User ID=sa;Password=P@ssw0rd")
dbconn.Open()
dbCMD = New SqlCommand("SELECT top 5 Type_,App_,Src,Smac,count(Src) as num FROM EventLogd group by Type_,App_,Src,Smac order by count(Src) Desc", dbconn) ' slow query
dtr = dbCMD.ExecuteReader()
Dim virus As String
While dtr.Read()
virus = dtr(0)
Dim Date_ As String = dtr(1)
Dim Src As String = dtr(2)
Dim Smac As String = dtr(3)
%>
<tr>
<td><%= virus %></td>
<td><%= Date_ %></td>
<td><%= Src %></td>
<td><%= Smac %> </td>
</tr>
<% End While
dtr.Close()
dbconn.Close()
%>
</tbody>
</table>