File: //opt/cpguard/app/resources/email_templates/manual_scan/dbscanner.html
{% if dbscan_rows|length > 0 %}
<table border="0" cellpadding="0" cellspacing="0" class="to100pc" width="100%"
style="background:#ffffff;max-width: 600px;">
<tr style="-webkit-text-size-adjust: none;">
<td height="16" style="-webkit-text-size-adjust: none;margin: 0;padding: 0;height: 16px;">
<img alt="" height="16" src="https://opsshield.com/assets/mail/space.gif"
style="-webkit-text-size-adjust: none;display: block;margin: 0;padding: 0;border: 0;height: 16px;">
</td>
<!-- spacer -->
</tr>
<tr>
<td align="center" width="76%" style="padding:30px 0 10px 0"><span
style="font-size:18px; line-height:14px; font-family:'Avenir Next', Avenir, Helvetica, sans-serif; color:#BABEC5; font-weight: 500;">
DATABASE SCANNER REPORT</span>
</td>
</tr>
<tr>
<td align="center">
<table width="100%" cellpadding="0" cellspacing="0" border="0" style=" padding:0 20px;">
<tr>
<td align="center">
<table cellpadding="0" cellspacing="0" border="0">
<tr>
<!-- Left Card -->
<td style="padding:10px; width:150px;" valign="middle" align="center">
<h5 style="font-size:40px;margin: 0;">{{ db_threats_count }}</h5>
<p style="margin-top:5px;">INFECTIONS</pv>
</td>
<td style="padding:10px; width:150px;" valign="middle" align="center">
<h5 style="font-size:40px;margin: 0;">{{ table_counts }}</h5>
<p style="margin-top:5px;">TABLES</pv>
</td>
<td style="padding:10px; width:150px;" valign="middle" align="center">
<h5 style="font-size:40px;margin: 0;">{{ db_counts }}</h5>
<p style="margin-top:5px;">DATABASES</pv>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
<tr style="-webkit-text-size-adjust: none;">
<td height="16" style="-webkit-text-size-adjust: none;margin: 0;padding: 0;height: 16px;">
<img alt="" height="16" src="https://opsshield.com/assets/mail/space.gif"
style="-webkit-text-size-adjust: none;display: block;margin: 0;padding: 0;border: 0;height: 16px;">
</td>
<!-- spacer -->
</tr>
<tr>
<td>
<h3 style="color:#686669;text-align:center;margin-bottom:5px;">Database threats
found</h3>
</td>
</tr>
<tr>
<td align="center" style="-webkit-text-size-adjust: none;padding-top: 15px;">
<table width="460">
<tr>
<td
style="width:18px;color:#585858;font-family:'Google Sans',Roboto,Arial,sans-serif;font-size:12px;line-height:26px; border-bottom: solid 1px #e6e6e6;border-top: solid 1px #e6e6e6;">
</td>
<td
style="color:#585858;font-family:'Google Sans',Roboto,Arial,sans-serif;font-size:12px;line-height:26px; border-bottom: solid 1px #e6e6e6;border-top: solid 1px #e6e6e6;">
DATABASE
</td>
<td align=""
style="color:#585858;font-family:'Google Sans',Roboto,Arial,sans-serif;font-size:12px;line-height:26px;padding-right: 15px;border-bottom: solid 1px #e6e6e6;border-top: solid 1px #e6e6e6;">
TABLE
</td>
<td align=""
style="color:#585858;font-family:'Google Sans',Roboto,Arial,sans-serif;font-size:12px;line-height:26px;padding-right: 15px;border-bottom: solid 1px #e6e6e6;border-top: solid 1px #e6e6e6;">
INFECTED ROWS
</td>
</tr>
{% for dbname, value in dbscan_rows %}
{% for table_name, count in value %}
<tr>
<td style="border-bottom:solid 1px #e6e6e6;padding:10px 0;vertical-align: top;" width="25">
{{ loop.index }}
</td>
<td style="border-bottom:solid 1px #e6e6e6;padding:10px 0;vertical-align: top;font-size:13px;">
{{ dbname }}
</td>
<td
style="border-bottom:solid 1px #e6e6e6;padding:10px 5px;line-height: 1.8;vertical-align: top;color:#676767;font-size:13px;">
{{ table_name }}
</td>
<td
style="border-bottom:solid 1px #e6e6e6;padding:10px 5px;line-height: 1.8;vertical-align: top;color:#676767;font-size:13px;">
{{ count }}</td>
</tr>
{% endfor %}
{% endfor %}
<tr>
<td colspan="3" align="center"
style="color:#585858;font-weight:500;font-family:'Google Sans',Roboto,Arial,sans-serif;padding: 20px 0;">
</td>
</tr>
</table>
</td>
</tr>
<!-- T&BP paragraph 1 start -->
<tr>
<td height="20" style="height:20px;"> </td>
</tr>
</table>
{% endif %}