﻿﻿<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
  <HEAD>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
    <meta HTTP-EQUIV="PRAGMA" CONTENT="NO-CACHE"/>
    <meta HTTP-EQUIV="CACHE-CONTROL" CONTENT="NO-CACHE"/>
  <title>PortalProtect 2.5</title>
  <style type="text/css">
<!--
body {
	FONT-SIZE: 10px;
	COLOR: #000000;
	FONT-FAMILY: "Verdana", "Arial", "Helvetica", "sans-serif";
	padding-top: 0px;
	BACKGROUND-COLOR: #ffffff;
}
td {
	FONT-SIZE: 10px;
	COLOR: #000000;
}         
.CodeComments {
	color: #008000;
}
.CodeCommentsSectionStart {
	color: #008000;
}
.CodeGroupByStatement {
	text-indent: 10px;
}
.CodeAliasName {
	font-weight: bold;
}
-->
  </style>
</head>
<BODY>
<DIV>
</DIV>
    <table width="700" border="0" cellspacing="0" cellpadding="0">
      
      <tr>
        <td colspan="3"><span class="CodeCommentsSectionStart">/* -------------------- SQL commands for Scan status summary -------------------- */</span></td>
      </tr>
      <tr>
        <td colspan="3"><span class="CodeComments">/* Summary */</span></td>
      </tr>
      <tr>
        <td colspan="3">SELECT</td>
      </tr>
      <tr>
        <td style="width:20px">&nbsp;</td>
        <td style="width:300px">SUM(summary_virus_detected_count)</td>
        <td>as <span class="CodeAliasName">virus_detected_count</span>,</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>SUM(summary_virus_uncleanable_count)</td>
        <td>as <span class="CodeAliasName">virus_uncleanable_count</span>,</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>SUM(summary_spyware_detected_count)</td>
        <td>as <span class="CodeAliasName">spyware_detected_count</span>,</td>
      </tr>      
      <tr>
        <td>&nbsp;</td>
        <td>SUM(summary_total_message_count)</td>
        <td>as <span class="CodeAliasName">total_message_count</span>,</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>SUM(summary_attachment_blocked_count)</td>
        <td>as <span class="CodeAliasName">attachment_blocked_count</span>,</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>SUM(summary_content_filtered_count)</td>
        <td>as <span class="CodeAliasName">content_filtered_count</span>,</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>SUM(summary_suspicious_url_count)</td>
        <td>as <span class="CodeAliasName">url_detected_count</span>,</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>SUM(summary_unscannable_entity_count)</td>
        <td>as <span class="CodeAliasName">unscannable_entity_count</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2">FROM tblSummary WHERE summary_datetime &gt;= N'1/31/2010 2:00:00 AM' and summary_datetime &lt; N'2/1/2010 2:00:00 AM'</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
      </tr>
      <tr>
        <td colspan="3" class="CodeComments">/* SQL commands for Security risk scan summary */</td>
      </tr>
      <tr>
        <td colspan="3">SELECT</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>Sum(summary_total_message_count)</td>
        <td>as <span class="CodeAliasName">total_message_count, </td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>Sum(summary_virus_detected_count)</td>
        <td>as <span class="CodeAliasName">virus_detected_count</span>,</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>Sum(summary_virus_uncleanable_count)</td>
        <td>as <span class="CodeAliasName">virus_uncleanable_count</span>,</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>Sum(summary_spyware_detected_count)</td>
        <td>as <span class="CodeAliasName">spyware_detected_count</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2">FROM tblSummary WHERE summary_datetime &gt;= N'1/31/2010 2:00:00 AM' AND summary_datetime &lt; N'2/1/2010 2:00:00 AM';</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
      </tr>
      <tr>
        <td colspan="3" class="CodeComments">/* Virus graph */</td>
      </tr>
      <tr>
        <td colspan="3">SELECT</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>Min(summary_datetime)</td>
        <td>as <span class="CodeAliasName">datetime_first</span>,</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>Sum(summary_total_message_count)</td>
        <td>as <span class="CodeAliasName">total_message_count</span>,</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>Sum(summary_virus_detected_count)</td>
        <td>as <span class="CodeAliasName">virus_detected_count</span>,</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>Sum(summary_virus_uncleanable_count)</td>
        <td>as <span class="CodeAliasName">virus_uncleanable_count</span>,</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>Max(summary_datetime)</td>
        <td>as <span class="CodeAliasName">datetime_last</span>,</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>Year(summary_datetime)</td>
        <td>as <span class="CodeAliasName">datetime_year</span>,</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>Month(summary_datetime) </td>
        <td>as <span class="CodeAliasName">datetime_month</span>,</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>Day(summary_datetime)</td>
        <td>as <span class="CodeAliasName">datetime_day</span>,</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>DatePart(hour, summary_datetime)</td>
        <td>as <span class="CodeAliasName">datetime_hour</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2">FROM tblSummary WHERE summary_datetime &gt;= N'1/31/2010 2:00:00 AM' AND summary_datetime &lt; N'2/1/2010 2:00:00 AM'</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2">GROUP BY</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td class="CodeGroupByStatement">Year(summary_datetime)</span>,</td>
        <td>&nbsp;</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td class="CodeGroupByStatement">Month(summary_datetime)</span>,</td>
        <td>&nbsp;</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td class="CodeGroupByStatement">Day(summary_datetime)</span>,</td>
        <td>&nbsp;</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td class="CodeGroupByStatement">DatePart(hour, summary_datetime);</td>
        <td>&nbsp;</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
      </tr>
      <tr>
        <td colspan="3" class="CodeComments">/* Top N Viruses */</td>
      </tr>
      <tr>
        <td colspan="3">SELECT TOP 10 WITH TIES</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>virusinfo_value</td>
        <td>as <span class="CodeAliasName">virus_name</span>,</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>Sum(virusinfo_count)</td>
        <td>as <span class="CodeAliasName">virus_count</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2">FROM tblVirusInfo </td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2">WHERE virusinfo_cate_id = (150 + 1) AND virusinfo_datetime &gt;= N'1/31/2010 2:00:00 AM' AND virusinfo_datetime &lt; N'2/1/2010 2:00:00 AM'</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2">GROUP BY virusinfo_value</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2">ORDER BY Sum(virusinfo_count) DESC;</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
      </tr>
      <tr>
        <td colspan="3" class="CodeComments">/* Virus violators */</td>
      </tr>
      <tr>
        <td colspan="3">SELECT TOP 10 WITH TIES</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>virusinfo_value</td>
        <td>as <span class="CodeAliasName">virus_violator</span>,</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>Sum(virusinfo_count)</td>
        <td>as <span class="CodeAliasName">virus_count</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2">FROM tblVirusInfo </td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2">WHERE virusinfo_cate_id = (150 + 6) AND virusinfo_datetime &gt;= N'1/31/2010 2:00:00 AM' AND virusinfo_datetime &lt; N'2/1/2010 2:00:00 AM'</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2">GROUP BY virusinfo_value</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2">ORDER BY Sum(virusinfo_count) DESC;</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
      </tr>
      <tr>
        <td colspan="3" class="CodeComments">/* Virus action taken */ </td>
      </tr>
      <tr>
        <td colspan="3" class="CodeComments">/* File &lt;PP Install Dir&gt;\web\xml\action_descriptions.xml describes action id name mapping */ </td>
      </tr>
      <tr>
        <td colspan="3">SELECT</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>virusinfo_value</td>
        <td>as <span class="CodeAliasName">virus_action</span>,</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>Sum(virusinfo_count)</td>
        <td>as <span class="CodeAliasName">virus_count</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2">FROM tblVirusInfo</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2">WHERE virusinfo_cate_id = (150 + 3) AND virusinfo_datetime &gt;= N'1/31/2010 2:00:00 AM' AND virusinfo_datetime &lt; N'2/1/2010 2:00:00 AM'</td>
      </tr>
      <tr>
        <td height="21">&nbsp;</td>
        <td colspan="2">GROUP BY virusinfo_value</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2">ORDER BY Sum(virusinfo_count) DESC;</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
      </tr>
      <tr>
        <td colspan="3" class="CodeComments">/* Spyware graph */</td>
      </tr>
      <tr>
        <td colspan="3">SELECT</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>Min(summary_datetime)</td>
        <td>as <span class="CodeAliasName">datetime_first</span>,</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>Sum(summary_total_message_count)</td>
        <td>as <span class="CodeAliasName">total_message_count</span>,</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>Sum(summary_spyware_detected_count)</td>
        <td>as <span class="CodeAliasName">spyware_detected_count</span>,</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>Max(summary_datetime)</td>
        <td>as <span class="CodeAliasName">datetime_last</span>,</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>Year(summary_datetime)</td>
        <td>as <span class="CodeAliasName">datetime_year</span>,</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>Month(summary_datetime)</td>
        <td>as <span class="CodeAliasName">datetime_month</span>,</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>Day(summary_datetime)</td>
        <td>as <span class="CodeAliasName">datetime_day</span>,</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>DatePart(hour, summary_datetime)</td>
        <td>as <span class="CodeAliasName">datetime_hour</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2">FROM tblSummary WHERE summary_datetime &gt;= N'1/31/2010 2:00:00 AM' AND summary_datetime &lt; N'2/1/2010 2:00:00 AM'</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2">GROUP BY</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2" class="CodeGroupByStatement">Year(summary_datetime)</span>,</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2" class="CodeGroupByStatement">Month(summary_datetime)</span>,</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2" class="CodeGroupByStatement">Day(summary_datetime)</span>,</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2" class="CodeGroupByStatement">DatePart(hour, summary_datetime);</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
      </tr>
      <tr>
        <td colspan="3" class="CodeComments">/* Top N Spyware */</td>
      </tr>
      <tr>
        <td colspan="3">SELECT TOP 10 WITH TIES</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>virusinfo_value</td>
        <td>as <span class="CodeAliasName">spyware_name</span>,</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>Sum(virusinfo_count)</td>
        <td>as <span class="CodeAliasName">spyware_count</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2">FROM tblVirusInfo</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2">WHERE virusinfo_cate_id = (150 + 4) AND virusinfo_datetime &gt;= N'1/31/2010 2:00:00 AM' AND virusinfo_datetime &lt; N'2/1/2010 2:00:00 AM'</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2">GROUP BY virusinfo_value</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2">ORDER BY Sum(virusinfo_count) DESC;</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
      </tr>
      <tr>
        <td colspan="3" class="CodeComments">/* Spyware action taken */</td>
      </tr>
      <tr>
        <td colspan="3" class="CodeComments">/* File &lt;PP Install Dir&gt;\web\xml\action_descriptions.xml describes action id name mapping */ </td>
      </tr>
      <tr>
        <td colspan="3">SELECT</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>virusinfo_value</td>
        <td>as <span class="CodeAliasName">spyware_action</span>,</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>Sum(virusinfo_count)</td>
        <td>as <span class="CodeAliasName">spyware_count</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2">FROM tblVirusInfo</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2">WHERE virusinfo_cate_id = (150 + 5) AND virusinfo_datetime &gt;= N'1/31/2010 2:00:00 AM' AND virusinfo_datetime &lt; N'2/1/2010 2:00:00 AM'</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2">GROUP BY virusinfo_value</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2">ORDER BY Sum(virusinfo_count) DESC;</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
      </tr>
      <tr>
        <td colspan="3" class="CodeComments">/* Top N Spyware violators */</td>
      </tr>
      <tr>
        <td colspan="3">SELECT TOP 10 WITH TIES</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>virusinfo_value</td>
        <td>as <span class="CodeAliasName">spyware_violator</span>,</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>Sum(virusinfo_count)</td>
        <td>as <span class="CodeAliasName">spyware_count</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2">FROM tblVirusInfo</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2">WHERE virusinfo_cate_id = (150 + 7) AND virusinfo_datetime &gt;= N'1/31/2010 2:00:00 AM' AND virusinfo_datetime &lt; N'2/1/2010 2:00:00 AM'</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2">GROUP BY virusinfo_value</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2">ORDER BY Sum(virusinfo_count) DESC;</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
      </tr>
      <tr>
        <td colspan="3" class="CodeComments">/* Security risk types */</td>
      </tr>
      <tr>
        <td colspan="3" class="CodeComments">/* File <PP Install Dir>\web\xml\localization.xml section '&lt;group name="virus_types"&gt;' describes security risk id name mapping */ </td>
      </tr>
      <tr>
        <td colspan="3">SELECT</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>virusinfo_value</td>
        <td>as <span class="CodeAliasName">security_risk_type</span>,</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>Sum(virusinfo_count)</td>
        <td>as <span class="CodeAliasName">security_risk_count</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2">FROM tblVirusInfo</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2">WHERE virusinfo_cate_id = (150 + 2) AND virusinfo_datetime &gt;= N'1/31/2010 2:00:00 AM' AND virusinfo_datetime &lt; N'2/1/2010 2:00:00 AM'</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2">GROUP BY virusinfo_value</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2">ORDER BY Sum(virusinfo_count) DESC;</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
      </tr>
      <tr>
        <td colspan="3" class="CodeCommentsSectionStart">/* -------------------- SQL commands for File Blocking -------------------- */</td>
      </tr>
      <tr>
        <td colspan="3"><span class="CodeComments">/* Summary */</span></td>
      </tr>
      <tr>
        <td colspan="3">SELECT</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>Sum(summary_total_attachment_count)</td>
        <td>as <span class="CodeAliasName">total_file_count</span>,</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>Sum(summary_attachment_blocked_count)</td>
        <td>as <span class="CodeAliasName">file_blocked_count</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2">FROM tblSummary</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2">WHERE summary_datetime &gt;= N'1/31/2010 2:00:00 AM' AND summary_datetime &lt;N'2/1/2010 2:00:00 AM';</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
      </tr>
      <tr>
        <td colspan="3" class="CodeComments">/* Blocked file graph */</td>
      </tr>
      <tr>
        <td colspan="3">SELECT</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>Min(summary_datetime)</td>
        <td>as <span class="CodeAliasName">datetime_first</span>,</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>Sum(summary_total_attachment_count)</td>
        <td>as <span class="CodeAliasName">total_file_count</span>,</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>Sum(summary_attachment_blocked_count)</td>
        <td>as <span class="CodeAliasName">file_blocked_count</span>,</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>Max(summary_datetime)</td>
        <td>as <span class="CodeAliasName">datetime_last</span>,</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>Year(summary_datetime)</td>
        <td>as <span class="CodeAliasName">datetime_year</span>,</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>Month(summary_datetime)</td>
        <td>as <span class="CodeAliasName">datetime_month</span>,</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>Day(summary_datetime)</td>
        <td>as <span class="CodeAliasName">datetime_day</span>,</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>DatePart(hour, summary_datetime)</td>
        <td>as <span class="CodeAliasName">datetime_hour</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2">FROM tblSummary WHERE summary_datetime &gt;= N'1/31/2010 2:00:00 AM' AND summary_datetime &lt; N'2/1/2010 2:00:00 AM'</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2">GROUP BY</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2" class="CodeGroupByStatement">Year(summary_datetime)</span>,</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2" class="CodeGroupByStatement">Month(summary_datetime)</span>,</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2" class="CodeGroupByStatement">Day(summary_datetime)</span>,</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2" class="CodeGroupByStatement">DatePart(hour, summary_datetime);</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
      </tr>
      <tr>
        <td colspan="3" class="CodeComments">/* Top N blocked file names */</td>
      </tr>
      <tr>
        <td colspan="3">SELECT TOP 10 WITH TIES</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>attachinfo_value</td>
        <td>as <span class="CodeAliasName">file_name</span>,</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>Sum(attachinfo_count)</td>
        <td>as <span class="CodeAliasName">file_count</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2">FROM tblAttachmentInfo </td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2">WHERE attachinfo_cate_id = (200 + 3) AND attachinfo_datetime &gt;= N'1/31/2010 2:00:00 AM' AND attachinfo_datetime &lt; N'2/1/2010 2:00:00 AM'</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2">GROUP BY attachinfo_value</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2">ORDER BY Sum(attachinfo_count) DESC;</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
      </tr>
      <tr>
        <td colspan="3" class="CodeComments">/* Top N blocked file types */</td>
      </tr>
      <tr>
        <td colspan="3">SELECT TOP 10 WITH TIES</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>attachinfo_value</td>
        <td>as <span class="CodeAliasName">file_type</span>,</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>Sum(attachinfo_count)</td>
        <td>as <span class="CodeAliasName">file_count</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2">FROM tblAttachmentInfo </td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2">WHERE attachinfo_cate_id = (200 + 1) AND attachinfo_datetime &gt;= N'1/31/2010 2:00:00 AM' AND attachinfo_datetime &lt; N'2/1/2010 2:00:00 AM'</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2">GROUP BY attachinfo_value</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2">ORDER BY Sum(attachinfo_count) DESC;</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
      </tr>
      <tr>
        <td colspan="3" class="CodeComments">/* Top N blocked file extensions */</td>
      </tr>
      <tr>
        <td colspan="3">SELECT TOP 10 WITH TIES</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>attachinfo_value</td>
        <td>as <span class="CodeAliasName">file_ext</span>,</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>Sum(attachinfo_count)</td>
        <td>as <span class="CodeAliasName">file_count</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2">FROM tblAttachmentInfo </td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2">WHERE attachinfo_cate_id = (200 + 2) AND attachinfo_datetime &gt;= N'1/31/2010 2:00:00 AM' AND attachinfo_datetime &lt; N'2/1/2010 2:00:00 AM'</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2">GROUP BY attachinfo_value</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2">ORDER BY Sum(attachinfo_count) DESC;</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
      </tr>
      <tr>
        <td colspan="3" class="CodeComments">/* Top N violators */</td>
      </tr>
      <tr>
        <td colspan="3">SELECT TOP 10 WITH TIES</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>attachinfo_value</td>
        <td>as <span class="CodeAliasName">violator</span>,</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>Sum(attachinfo_count)</td>
        <td>as <span class="CodeAliasName">file_count</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2">FROM tblAttachmentInfo </td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2">WHERE attachinfo_cate_id = (200 + 4) AND attachinfo_datetime &gt;= N'1/31/2010 2:00:00 AM' AND attachinfo_datetime &lt; N'2/1/2010 2:00:00 AM'</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2">GROUP BY attachinfo_value</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2">ORDER BY Sum(attachinfo_count) DESC;</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
      </tr>
      <tr>
        <td colspan="3" class="CodeComments">/* Top N triggered policy */</td>
      </tr>
      <tr>
        <td colspan="3">SELECT TOP 10 WITH TIES</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>attachinfo_value</td>
        <td>as <span class="CodeAliasName">policy_name</span>,</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>Sum(attachinfo_count)</td>
        <td>as <span class="CodeAliasName">triggered_count</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2">FROM tblAttachmentInfo </td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2">WHERE attachinfo_cate_id = (200 + 5) AND attachinfo_datetime &gt;= N'1/31/2010 2:00:00 AM' AND attachinfo_datetime &lt; N'2/1/2010 2:00:00 AM'</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2">GROUP BY attachinfo_value</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2">ORDER BY Sum(attachinfo_count) DESC;</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
      </tr>
      <tr>
        <td colspan="3" class="CodeCommentsSectionStart">/* -------------------- SQL commands for Content filtering -------------------- */</td>
      </tr>
      <tr>
        <td colspan="3"><span class="CodeComments">/* Summary */</span></td>
      </tr>
      <tr>
        <td colspan="3">SELECT</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>Sum(summary_total_message_count)</td>
        <td>as <span class="CodeAliasName">total_message_count</span>,</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>Sum(summary_content_filtered_count)</td>
        <td>as <span class="CodeAliasName">content_filtered_count </td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2">FROM tblSummary WHERE summary_datetime &gt;= N'1/31/2010 2:00:00 AM' AND summary_datetime &lt; N'2/1/2010 2:00:00 AM';</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
      </tr>
      <tr>
        <td colspan="3" class="CodeComments">/* Content filtering graph */ </td>
      </tr>
      <tr>
        <td colspan="3">SELECT</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>Min(summary_datetime)</td>
        <td>as <span class="CodeAliasName">datetime_first</span>,</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>Sum(summary_total_message_count) </td>
        <td>as <span class="CodeAliasName">total_message_count</span>,</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>Sum(summary_content_filtered_count)</td>
        <td>as <span class="CodeAliasName">content_filtered_count</span>,</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>Max(summary_datetime)</td>
        <td>as <span class="CodeAliasName">datetime_last</span>,</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>Year(summary_datetime)</td>
        <td>as <span class="CodeAliasName">datetime_year</span>,</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>Month(summary_datetime)</td>
        <td>as <span class="CodeAliasName">datetime_month</span>,</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>Day(summary_datetime)</td>
        <td>as <span class="CodeAliasName">datetime_day</span>,</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>DatePart(hour, summary_datetime)</td>
        <td>as <span class="CodeAliasName">datetime_hour</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2">FROM tblSummary WHERE summary_datetime &gt;= N'1/31/2010 2:00:00 AM' AND summary_datetime &lt; N'2/1/2010 2:00:00 AM'</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2">GROUP BY</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2" class="CodeGroupByStatement">Year(summary_datetime)</span>,</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2" class="CodeGroupByStatement">Month(summary_datetime)</span>,</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2" class="CodeGroupByStatement">Day(summary_datetime)</span>,</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2" class="CodeGroupByStatement">DatePart(hour, summary_datetime);</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
      </tr>
      <tr>
        <td colspan="3" class="CodeComments">/* Top N violators */</td>
      </tr>
      <tr>
        <td colspan="3">SELECT TOP 10 WITH TIES</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>contentinfo_value</td>
        <td>as <span class="CodeAliasName">violator</span>,</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>Sum(contentinfo_count)</td>
        <td>as <span class="CodeAliasName">filtered_count</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2">FROM tblContentInfo </td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2">WHERE contentinfo_cate_id = (250 + 1) AND contentinfo_datetime &gt;= N'1/31/2010 2:00:00 AM' AND contentinfo_datetime &lt; N'2/1/2010 2:00:00 AM'</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2">GROUP BY contentinfo_value</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2">ORDER BY Sum(contentinfo_count) DESC;</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
      </tr>
      <tr>
        <td colspan="3" class="CodeComments">/* Top N triggered policy */</td>
      </tr>
      <tr>
        <td colspan="3">SELECT TOP 10 WITH TIES</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>contentinfo_value</td>
        <td>as <span class="CodeAliasName">policy_name</span>,</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>Sum(contentinfo_count)</td>
        <td>as <span class="CodeAliasName">triggered_count</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2">FROM tblContentInfo </td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2">WHERE contentinfo_cate_id = (250 + 3) AND contentinfo_datetime &gt;= N'1/31/2010 2:00:00 AM' AND contentinfo_datetime &lt; N'2/1/2010 2:00:00 AM'</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2">GROUP BY contentinfo_value</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2">ORDER BY Sum(contentinfo_count) DESC;</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
      </tr>
	  <tr>
        <td colspan="3" class="CodeCommentsSectionStart">/* -------------------- SQL commands for Data loss prevention -------------------- */</td>
      </tr>
      <tr>
        <td colspan="3"><span class="CodeComments">/* Summary */</span></td>
      </tr>
      <tr>
        <td colspan="3">SELECT</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>Sum(summary_total_message_count)</td>
        <td>as <span class="CodeAliasName">total_message_count</span>,</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>Sum(summary_dlp_filtered_count)</td>
        <td>as <span class="CodeAliasName">dlp_filtered_count </td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2">FROM tblSummary WHERE summary_datetime &gt;= N'1/31/2010 2:00:00 AM' AND summary_datetime &lt; N'2/1/2010 2:00:00 AM';</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
      </tr>
      <tr>
        <td colspan="3" class="CodeComments">/* Data loss prevention graph */ </td>
      </tr>
      <tr>
        <td colspan="3">SELECT</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>Min(summary_datetime)</td>
        <td>as <span class="CodeAliasName">datetime_first</span>,</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>Sum(summary_total_message_count) </td>
        <td>as <span class="CodeAliasName">total_message_count</span>,</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>Sum(summary_dlp_filtered_count)</td>
        <td>as <span class="CodeAliasName">dlp_filtered_count</span>,</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>Max(summary_datetime)</td>
        <td>as <span class="CodeAliasName">datetime_last</span>,</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>Year(summary_datetime)</td>
        <td>as <span class="CodeAliasName">datetime_year</span>,</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>Month(summary_datetime)</td>
        <td>as <span class="CodeAliasName">datetime_month</span>,</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>Day(summary_datetime)</td>
        <td>as <span class="CodeAliasName">datetime_day</span>,</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>DatePart(hour, summary_datetime)</td>
        <td>as <span class="CodeAliasName">datetime_hour</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2">FROM tblSummary WHERE summary_datetime &gt;= N'1/31/2010 2:00:00 AM' AND summary_datetime &lt; N'2/1/2010 2:00:00 AM'</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2">GROUP BY</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2" class="CodeGroupByStatement">Year(summary_datetime)</span>,</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2" class="CodeGroupByStatement">Month(summary_datetime)</span>,</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2" class="CodeGroupByStatement">Day(summary_datetime)</span>,</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2" class="CodeGroupByStatement">DatePart(hour, summary_datetime);</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
      </tr>
      <tr>
        <td colspan="3" class="CodeComments">/* Top N violators */</td>
      </tr>
      <tr>
        <td colspan="3">SELECT TOP 10 WITH TIES</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>dlpinfo_value</td>
        <td>as <span class="CodeAliasName">violator</span>,</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>Sum(dlpinfo_count)</td>
        <td>as <span class="CodeAliasName">filtered_count</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2">FROM tblDLPInfo </td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2">WHERE dlpinfo_cate_id = (450 + 1) AND dlpinfo_datetime &gt;= N'1/31/2010 2:00:00 AM' AND dlpinfo_datetime &lt; N'2/1/2010 2:00:00 AM'</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2">GROUP BY dlpinfo_value</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2">ORDER BY Sum(dlpinfo_count) DESC;</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
      </tr>
      <tr>
        <td colspan="3" class="CodeComments">/* Top N triggered policy */</td>
      </tr>
      <tr>
        <td colspan="3">SELECT TOP 10 WITH TIES</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>dlpinfo_value</td>
        <td>as <span class="CodeAliasName">policy_name</span>,</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>Sum(dlpinfo_count)</td>
        <td>as <span class="CodeAliasName">triggered_count</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2">FROM tblDLPInfo </td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2">WHERE dlpinfo_cate_id = (450 + 3) AND dlpinfo_datetime &gt;= N'1/31/2010 2:00:00 AM' AND dlpinfo_datetime &lt; N'2/1/2010 2:00:00 AM'</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2">GROUP BY dlpinfo_value</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2">ORDER BY Sum(dlpinfo_count) DESC;</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
      </tr>
	  <tr>
        <td colspan="3" class="CodeComments">/* Top N triggered template */</td>
      </tr>
      <tr>
        <td colspan="3">SELECT TOP 10 WITH TIES</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>dlpinfo_value</td>
        <td>as <span class="CodeAliasName">template_name</span>,</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>Sum(dlpinfo_count)</td>
        <td>as <span class="CodeAliasName">triggered_count</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2">FROM tblDLPInfo </td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2">WHERE dlpinfo_cate_id = (450 + 4) AND dlpinfo_datetime &gt;= N'1/31/2010 2:00:00 AM' AND dlpinfo_datetime &lt; N'2/1/2010 2:00:00 AM'</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2">GROUP BY dlpinfo_value</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2">ORDER BY Sum(dlpinfo_count) DESC;</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
      </tr>
      <tr>
        <td colspan="3" class="CodeCommentsSectionStart">/* -------------------- SQL commands for Web reputation -------------------- */</td>
      </tr>
      <tr>
        <td colspan="3"><span class="CodeComments">/* Summary */</span></td>
      </tr>
      <tr>
        <td colspan="3">SELECT</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>Sum(summary_total_message_count)</td>
        <td>as <span class="CodeAliasName">total_message_count</span>,</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>Sum(summary_suspicious_url_count)</td>
        <td>as <span class="CodeAliasName">suspicious_url_count</span></td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2">FROM tblSummary WHERE summary_datetime &gt;= N'1/31/2010 2:00:00 AM' AND summary_datetime &lt; N'2/1/2010 2:00:00 AM';</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
      </tr>
      <tr>
        <td colspan="3" class="CodeComments">/* Web reputation graph */ </td>
      </tr>
      <tr>
        <td colspan="3">SELECT</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>Min(summary_datetime)</td>
        <td>as <span class="CodeAliasName">datetime_first</span>,</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>Sum(summary_total_message_count) </td>
        <td>as <span class="CodeAliasName">total_message_count</span>,</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>Sum(summary_suspicious_url_count)</td>
        <td>as <span class="CodeAliasName">suspicious_url_count</span>,</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>Max(summary_datetime)</td>
        <td>as <span class="CodeAliasName">datetime_last</span>,</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>Year(summary_datetime)</td>
        <td>as <span class="CodeAliasName">datetime_year</span>,</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>Month(summary_datetime)</td>
        <td>as <span class="CodeAliasName">datetime_month</span>,</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>Day(summary_datetime)</td>
        <td>as <span class="CodeAliasName">datetime_day</span>,</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>DatePart(hour, summary_datetime)</td>
        <td>as <span class="CodeAliasName">datetime_hour</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2">FROM tblSummary WHERE summary_datetime &gt;= N'1/31/2010 2:00:00 AM' AND summary_datetime &lt; N'2/1/2010 2:00:00 AM'</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2">GROUP BY</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2" class="CodeGroupByStatement">Year(summary_datetime)</span>,</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2" class="CodeGroupByStatement">Month(summary_datetime)</span>,</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2" class="CodeGroupByStatement">Day(summary_datetime)</span>,</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2" class="CodeGroupByStatement">DatePart(hour, summary_datetime);</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
      </tr>
      <tr>
        <td colspan="3" class="CodeComments">/* Top N violators */ </td>
      </tr>
      <tr>
        <td colspan="3">SELECT TOP 10 WITH TIES</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>urlinfo_value</td>
        <td>as <span class="CodeAliasName">violator</span>,</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>Sum(urlinfo_count)</td>
        <td>as <span class="CodeAliasName">top_suspicious_url_count</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2">FROM tblURLInfo</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2">WHERE urlinfo_cate_id = (400 + 2) AND urlinfo_datetime &gt;= N'1/31/2010 2:00:00 AM' AND urlinfo_datetime &lt; N'2/1/2010 2:00:00 AM' </td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2">GROUP BY urlinfo_value </td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2">ORDER BY Sum(urlinfo_count) DESC;</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
      </tr>
      <tr>
        <td colspan="3" class="CodeComments">/* Top N URLs */ </td>
      </tr>
      <tr>
        <td colspan="3">SELECT TOP 10 WITH TIES</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>urlinfo_value</td>
        <td>as <span class="CodeAliasName">suspicious_url</span>,</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>Sum(urlinfo_count)</td>
        <td>as <span class="CodeAliasName">top_suspicious_url_count</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2">FROM tblURLInfo</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2">WHERE urlinfo_cate_id = (400 + 1) AND urlinfo_datetime &gt;= N'1/31/2010 2:00:00 AM' AND urlinfo_datetime &lt; N'2/1/2010 2:00:00 AM' </td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2">GROUP BY urlinfo_value </td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2">ORDER BY Sum(urlinfo_count) DESC;</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
      </tr>
      <tr>
        <td colspan="3" class="CodeCommentsSectionStart">/* -------------------- SQL command for Unscannable file -------------------- */</td>
      </tr>
      <tr>
        <td colspan="3"><span class="CodeComments">/* Summary */</span></td>
      </tr>
      <tr>
        <td colspan="3">SELECT</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>Sum(summary_unscannable_entity_count)</td>
        <td>as <span class="CodeAliasName">unscannable_entity_count</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2">FROM tblSummary WHERE summary_datetime &gt;= N'1/31/2010 2:00:00 AM' AND summary_datetime &lt; N'2/1/2010 2:00:00 AM';</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
      </tr>
      <tr>
        <td colspan="3" class="CodeComments">/* Unscannable file graph */</td>
      </tr>
      <tr>
        <td colspan="3">SELECT</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>Min(summary_datetime)</td>
        <td>as <span class="CodeAliasName">datetime_first</span>,</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>Sum(summary_unscannable_entity_count)</td>
        <td>as <span class="CodeAliasName">unscannable_entity_count, </td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>Max(summary_datetime)</td>
        <td>as <span class="CodeAliasName">datetime_last</span>,</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>Year(summary_datetime)</td>
        <td>as <span class="CodeAliasName">datetime_year</span>,</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>Month(summary_datetime)</td>
        <td>as <span class="CodeAliasName">datetime_month</span>,</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>Day(summary_datetime)</td>
        <td>as <span class="CodeAliasName">datetime_day</span>,</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td>DatePart(hour, summary_datetime)</td>
        <td>as <span class="CodeAliasName">datetime_hour</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2">FROM tblSummary WHERE summary_datetime &gt;= N'1/31/2010 2:00:00 AM' AND summary_datetime &lt; N'2/1/2010 2:00:00 AM'</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2">GROUP BY</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2" class="CodeGroupByStatement">Year(summary_datetime)</span>,</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2" class="CodeGroupByStatement">Month(summary_datetime)</span>,</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2" class="CodeGroupByStatement">Day(summary_datetime)</span>,</td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td colspan="2" class="CodeGroupByStatement">DatePart(hour, summary_datetime);</td>
      </tr>
    </table>
</BODY>
  </HEAD>
</HTML>
