def nessus_parser(root, project_id, scan_id):
"""
The function is for parser of Nessus scan file as .nessus.
:param root:
:param project_id:
:param scan_id:
:return:
"""
global agent, description, fname,\
plugin_modification_date, plugin_name,\
plugin_publication_date, plugin_type,\
risk_factor, script_version, solution,\
synopsis, plugin_output, see_also, scan_ip, \
pluginName, pluginID, protocol, severity,\
svc_name, pluginFamily, port
for data in root:
for reportHost in data.iter('ReportHost'):
ip = reportHost.attrib
try:
for key, value in ip.viewitems():
scan_ip = value
except:
continue
for ReportItem in reportHost.iter('ReportItem'):
for key, value in ReportItem.attrib.viewitems():
if key == 'pluginName':
pluginName = value
if key == 'pluginID':
pluginID = value
if key == 'protocol':
protocol = value
if key == 'severity':
severity = value
if key == 'svc_name':
svc_name = value
if key == 'pluginFamily':
pluginFamily = value
if key == 'port':
port = value
try:
agent = ReportItem.find('agent').text
except:
agent = "NA"
try:
description = ReportItem.find('description').text
except:
description = "NA"
try:
fname = ReportItem.find('fname').text
except:
fname = "NA"
try:
plugin_modification_date = ReportItem.find(
'plugin_modification_date').text
except:
plugin_modification_date = "NA"
try:
plugin_name = ReportItem.find('plugin_name').text
except:
plugin_name = "NA"
try:
plugin_publication_date = ReportItem.find(
'plugin_publication_date').text
except:
plugin_publication_date = "NA"
try:
plugin_type = ReportItem.find('plugin_type').text
except:
plugin_type = "NA"
try:
risk_factor = ReportItem.find('risk_factor').text
except:
risk_factor = "NA"
try:
script_version = ReportItem.find('script_version').text
except:
script_version = "NA"
try:
see_also = ReportItem.find('see_also').text
except:
see_also = "NA"
try:
solution = ReportItem.find('solution').text
except:
solution = "NA"
try:
synopsis = ReportItem.find('synopsis').text
except:
synopsis = "NA"
try:
plugin_output = ReportItem.find('plugin_output').text
except:
plugin_output = "NA"
vul_id = uuid.uuid4()
dup_data = scan_ip + plugin_name + severity + port
duplicate_hash = hashlib.sha256(dup_data).hexdigest()
match_dup = nessus_report_db.objects.filter(
dup_hash=duplicate_hash).values('dup_hash').distinct()
lenth_match = len(match_dup)
if lenth_match == 1:
duplicate_vuln = 'Yes'
elif lenth_match == 0:
duplicate_vuln = 'No'
else:
duplicate_vuln = 'None'
global false_positive
false_p = nessus_report_db.objects.filter(
false_positive_hash=duplicate_hash)
fp_lenth_match = len(false_p)
if fp_lenth_match == 1:
false_positive = 'Yes'
else:
false_positive = 'No'
if risk_factor == 'None':
risk_factor = 'Informational'
all_data_save = nessus_report_db(
project_id=project_id,
scan_id=scan_id,
scan_ip=scan_ip,
vul_id=vul_id,
agent=agent,
description=description,
fname=fname,
plugin_modification_date=plugin_modification_date,
plugin_name=plugin_name,
plugin_publication_date=plugin_publication_date,
plugin_type=plugin_type,
risk_factor=risk_factor,
script_version=script_version,
see_also=see_also,
solution=solution,
synopsis=synopsis,
plugin_output=plugin_output,
pluginName=pluginName,
pluginID=pluginID,
protocol=protocol,
severity=severity,
svc_name=svc_name,
pluginFamily=pluginFamily,
port=port,
false_positive=false_positive,
vuln_status='Open',
dup_hash=duplicate_hash,
vuln_duplicate=duplicate_vuln)
all_data_save.save()
del_na = nessus_report_db.objects.filter(plugin_name='NA')
del_na.delete()
ov_all_vul = nessus_report_db.objects.filter(
scan_id=scan_id).order_by('scan_id')
total_vul = len(ov_all_vul)
total_critical = len(ov_all_vul.filter(risk_factor="Critical"))
total_high = len(ov_all_vul.filter(risk_factor="High"))
total_medium = len(ov_all_vul.filter(risk_factor="Medium"))
total_low = len(ov_all_vul.filter(risk_factor="Low"))
total_info = len(
ov_all_vul.filter(risk_factor="Informational"))
total_duplicate = len(ov_all_vul.filter(vuln_duplicate='Yes'))
nessus_scan_db.objects.filter(scan_id=scan_id) \
.update(total_vul=total_vul,
critical_total=total_critical,
high_total=total_high,
medium_total=total_medium,
low_total=total_low,
info_total=total_info,
total_dup=total_duplicate,
)
def updated_nessus_parser(root, project_id, scan_id, username):
global agent, description, fname, \
plugin_modification_date, plugin_name, \
plugin_publication_date, plugin_type, \
risk_factor, script_version, solution, \
synopsis, plugin_output, see_also, scan_ip, \
pluginName, pluginID, protocol, severity, \
svc_name, pluginFamily, port, vuln_color
for data in root:
for reportHost in data.iter('ReportHost'):
print("reportHost = " + str(reportHost.attrib))
try:
for key, value in reportHost.items():
scan_ip = value
print("IP = " + str(scan_ip))
except:
continue
scan_status = "100"
date_time = datetime.datetime.now()
scan_dump = nessus_scan_db(scan_ip=scan_ip,
scan_id=scan_ip,
date_time=date_time,
project_id=project_id,
scan_status=scan_status,
username=username)
scan_dump.save()
for ReportItem in reportHost.iter('ReportItem'):
for key, value in ReportItem.attrib.items():
if key == 'pluginName':
pluginName = value
# print ("pluginName = "+str(value))
if key == 'pluginID':
pluginID = value
# print ("pluginID = "+str(value))
if key == 'protocol':
protocol = value
# print ("protocol = "+str(value))
if key == 'severity':
severity = value
# print ("severity = "+str(value))
if key == 'svc_name':
svc_name = value
# print ("svc_name = "+str(value))
if key == 'pluginFamily':
pluginFamily = value
# print ("pluginFamily = "+str(value))
if key == 'port':
port = value
# print ("port = "+str(value))
try:
agent = ReportItem.find('agent').text
except:
agent = "NA"
try:
description = ReportItem.find('description').text
except:
description = "NA"
try:
fname = ReportItem.find('fname').text
except:
fname = "NA"
try:
plugin_modification_date = ReportItem.find(
'plugin_modification_date').text
except:
plugin_modification_date = "NA"
try:
plugin_name = ReportItem.find('plugin_name').text
except:
plugin_name = "NA"
try:
plugin_publication_date = ReportItem.find(
'plugin_publication_date').text
except:
plugin_publication_date = "NA"
try:
plugin_type = ReportItem.find('plugin_type').text
except:
plugin_type = "NA"
try:
risk_factor = ReportItem.find('risk_factor').text
except:
risk_factor = "NA"
try:
script_version = ReportItem.find('script_version').text
except:
script_version = "NA"
try:
see_also = ReportItem.find('see_also').text
except:
see_also = "NA"
try:
solution = ReportItem.find('solution').text
except:
solution = "NA"
try:
synopsis = ReportItem.find('synopsis').text
except:
synopsis = "NA"
try:
plugin_output = ReportItem.find('plugin_output').text
except:
plugin_output = "NA"
vul_id = uuid.uuid4()
dup_data = scan_ip + plugin_name + severity + port
duplicate_hash = hashlib.sha256(
dup_data.encode('utf-8')).hexdigest()
match_dup = nessus_report_db.objects.filter(
username=username,
dup_hash=duplicate_hash).values('dup_hash').distinct()
lenth_match = len(match_dup)
if severity == '0':
vuln_color = 'info'
if severity == '1':
vuln_color = 'info'
if severity == '2':
vuln_color = 'warning'
if severity == '3':
vuln_color = 'danger'
if severity == '4':
vuln_color = 'danger'
if lenth_match == 1:
duplicate_vuln = 'Yes'
elif lenth_match == 0:
duplicate_vuln = 'No'
else:
duplicate_vuln = 'None'
global false_positive
false_p = nessus_report_db.objects.filter(
username=username, false_positive_hash=duplicate_hash)
fp_lenth_match = len(false_p)
if fp_lenth_match == 1:
false_positive = 'Yes'
else:
false_positive = 'No'
if risk_factor == 'None':
risk_factor = 'Informational'
all_data_save = nessus_report_db(
project_id=project_id,
scan_id=scan_ip,
scan_ip=scan_ip,
vul_id=vul_id,
agent=agent,
description=description,
fname=fname,
plugin_modification_date=plugin_modification_date,
plugin_name=plugin_name,
plugin_publication_date=plugin_publication_date,
plugin_type=plugin_type,
risk_factor=risk_factor,
script_version=script_version,
see_also=see_also,
solution=solution,
synopsis=synopsis,
plugin_output=plugin_output,
pluginName=pluginName,
pluginID=pluginID,
protocol=protocol,
severity=severity,
svc_name=svc_name,
pluginFamily=pluginFamily,
port=port,
false_positive=false_positive,
vuln_status='Open',
dup_hash=duplicate_hash,
vuln_duplicate=duplicate_vuln,
severity_color=vuln_color,
username=username,
)
all_data_save.save()
print("RESULTS = " + str(all_data_save.scan_id))
del_na = nessus_report_db.objects.filter(username=username,
plugin_name='NA')
del_na.delete()
ov_all_vul = nessus_report_db.objects.filter(
username=username, scan_id=scan_ip).order_by('scan_ip')
total_vul = len(ov_all_vul)
total_critical = len(ov_all_vul.filter(risk_factor="Critical"))
total_high = len(ov_all_vul.filter(risk_factor="High"))
total_medium = len(ov_all_vul.filter(risk_factor="Medium"))
total_low = len(ov_all_vul.filter(risk_factor="Low"))
total_info = len(
ov_all_vul.filter(risk_factor="Informational"))
total_duplicate = len(ov_all_vul.filter(vuln_duplicate='Yes'))
nessus_scan_db.objects.filter(username=username, scan_id=scan_ip) \
.update(total_vul=total_vul,
critical_total=total_critical,
high_total=total_high,
medium_total=total_medium,
low_total=total_low,
info_total=total_info,
total_dup=total_duplicate,
scan_ip=scan_ip,
)
subject = 'Archery Tool Scan Status - Nessus Report Uploaded'
message = 'Nessus Scanner has completed the scan ' \
' %s <br> Total: %s <br>High: %s <br>' \
'Medium: %s <br>Low %s' % (scan_id, total_vul, total_high, total_medium, total_low)
email_sch_notify(subject=subject, message=message)
def nessus_parser(root, project_id, scan_id):
"""
The function is for parser of Nessus scan file as .nessus.
:param root:
:param project_id:
:param scan_id:
:return:
"""
global agent, description, fname,\
plugin_modification_date, plugin_name,\
plugin_publication_date, plugin_type,\
risk_factor, script_version, solution,\
synopsis, plugin_output, see_also, scan_ip, \
pluginName, pluginID, protocol, severity,\
svc_name, pluginFamily, port
for data in root:
for report in data:
if report.tag == 'ReportHost':
global ip
ip = report.attrib
for key, value in ip.viewitems():
scan_ip = value
for data in root:
for report in data:
for reportHost in report:
report_attrib = reportHost.attrib
for key, values in report_attrib.viewitems():
if key == 'pluginName':
pluginName = values
if key == 'pluginID':
pluginID = values
if key == 'protocol':
protocol = values
if key == 'severity':
severity = values
if key == 'svc_name':
svc_name = values
if key == 'pluginFamily':
pluginFamily = values
if key == 'port':
port = values
for ReportItem in reportHost:
if ReportItem.tag == 'agent':
if ReportItem.text is None:
agent = "NA"
else:
agent = ReportItem.text
if ReportItem.tag == 'description':
if ReportItem.text is None:
description = "NA"
else:
description = ReportItem.text
if ReportItem.tag == 'fname':
if ReportItem.text is None:
fname = "NA"
else:
fname = ReportItem.text
if ReportItem.tag == 'plugin_modification_date':
if ReportItem.text is None:
plugin_modification_date = "NA"
else:
plugin_modification_date = ReportItem.text
if ReportItem.tag == 'plugin_name':
if ReportItem.text is None:
plugin_name = "NA"
else:
plugin_name = ReportItem.text
if ReportItem.tag == 'plugin_publication_date':
if ReportItem.text is None:
plugin_publication_date = "NA"
else:
plugin_publication_date = ReportItem.text
if ReportItem.tag == 'plugin_type':
if ReportItem.text is None:
plugin_type = "NA"
else:
plugin_type = ReportItem.text
if ReportItem.tag == 'risk_factor':
if ReportItem.text is None:
risk_factor = "NA"
else:
risk_factor = ReportItem.text
if ReportItem.tag == 'script_version':
if ReportItem.text is None:
script_version = "NA"
else:
script_version = ReportItem.text
if ReportItem.tag == 'see_also':
if ReportItem.text is None:
see_also = "NA"
else:
see_also = ReportItem.text
if ReportItem.tag == 'solution':
if ReportItem.text is None:
solution = "NA"
else:
solution = ReportItem.text
if ReportItem.tag == 'synopsis':
if ReportItem.text is None:
synopsis = "NA"
else:
synopsis = ReportItem.text
if ReportItem.tag == 'plugin_output':
if ReportItem.text is None:
plugin_output = "NA"
else:
plugin_output = ReportItem.text
vul_id = uuid.uuid4()
all_data_save = nessus_report_db(project_id=project_id,
scan_id=scan_id,
scan_ip=scan_ip,
vul_id=vul_id,
agent=agent,
description=description,
fname=fname,
plugin_modification_date=plugin_modification_date,
plugin_name=plugin_name,
plugin_publication_date=plugin_publication_date,
plugin_type=plugin_type,
risk_factor=risk_factor,
script_version=script_version,
see_also=see_also,
solution=solution,
synopsis=synopsis,
plugin_output=plugin_output,
pluginName=pluginName,
pluginID=pluginID,
protocol=protocol,
severity=severity,
svc_name=svc_name,
pluginFamily=pluginFamily,
port=port,
false_positive='No'
)
all_data_save.save()
del_na = nessus_report_db.objects.filter(plugin_name='NA')
del_na.delete()
ov_all_vul = nessus_report_db.objects.filter(scan_id=scan_id).order_by('scan_id')
total_vul = len(ov_all_vul)
total_critical = len(ov_all_vul.filter(risk_factor="Critical"))
total_high = len(ov_all_vul.filter(risk_factor="High"))
total_medium = len(ov_all_vul.filter(risk_factor="Medium"))
total_low = len(ov_all_vul.filter(risk_factor="Low"))
nessus_scan_db.objects.filter(scan_id=scan_id) \
.update(total_vul=total_vul,
critical_total=total_critical,
high_total=total_high,
medium_total=total_medium,
low_total=total_low)
def nessus_parser(root, project_id, scan_id):
"""
The function is for parser of Nessus scan file as .nessus.
:param root:
:param project_id:
:param scan_id:
:return:
"""
global agent, description, fname,\
plugin_modification_date, plugin_name,\
plugin_publication_date, plugin_type,\
risk_factor, script_version, solution,\
synopsis, plugin_output, see_also, scan_ip, \
pluginName, pluginID, protocol, severity,\
svc_name, pluginFamily, port
for data in root:
for report in data:
if report.tag == 'ReportHost':
global ip
ip = report.attrib
for key, value in ip.viewitems():
scan_ip = value
for data in root:
for report in data:
for reportHost in report:
report_attrib = reportHost.attrib
for key, values in report_attrib.viewitems():
if key == 'pluginName':
pluginName = values
if key == 'pluginID':
pluginID = values
if key == 'protocol':
protocol = values
if key == 'severity':
severity = values
if key == 'svc_name':
svc_name = values
if key == 'pluginFamily':
pluginFamily = values
if key == 'port':
port = values
for ReportItem in reportHost:
if ReportItem.tag == 'agent':
if ReportItem.text is None:
agent = "NA"
else:
agent = ReportItem.text
if ReportItem.tag == 'description':
if ReportItem.text is None:
description = "NA"
else:
description = ReportItem.text
if ReportItem.tag == 'fname':
if ReportItem.text is None:
fname = "NA"
else:
fname = ReportItem.text
if ReportItem.tag == 'plugin_modification_date':
if ReportItem.text is None:
plugin_modification_date = "NA"
else:
plugin_modification_date = ReportItem.text
if ReportItem.tag == 'plugin_name':
if ReportItem.text is None:
plugin_name = "NA"
else:
plugin_name = ReportItem.text
if ReportItem.tag == 'plugin_publication_date':
if ReportItem.text is None:
plugin_publication_date = "NA"
else:
plugin_publication_date = ReportItem.text
if ReportItem.tag == 'plugin_type':
if ReportItem.text is None:
plugin_type = "NA"
else:
plugin_type = ReportItem.text
if ReportItem.tag == 'risk_factor':
if ReportItem.text is None:
risk_factor = "NA"
else:
risk_factor = ReportItem.text
if ReportItem.tag == 'script_version':
if ReportItem.text is None:
script_version = "NA"
else:
script_version = ReportItem.text
if ReportItem.tag == 'see_also':
if ReportItem.text is None:
see_also = "NA"
else:
see_also = ReportItem.text
if ReportItem.tag == 'solution':
if ReportItem.text is None:
solution = "NA"
else:
solution = ReportItem.text
if ReportItem.tag == 'synopsis':
if ReportItem.text is None:
synopsis = "NA"
else:
synopsis = ReportItem.text
if ReportItem.tag == 'plugin_output':
if ReportItem.text is None:
plugin_output = "NA"
else:
plugin_output = ReportItem.text
vul_id = uuid.uuid4()
all_data_save = nessus_report_db(
project_id=project_id,
scan_id=scan_id,
scan_ip=scan_ip,
vul_id=vul_id,
agent=agent,
description=description,
fname=fname,
plugin_modification_date=plugin_modification_date,
plugin_name=plugin_name,
plugin_publication_date=plugin_publication_date,
plugin_type=plugin_type,
risk_factor=risk_factor,
script_version=script_version,
see_also=see_also,
solution=solution,
synopsis=synopsis,
plugin_output=plugin_output,
pluginName=pluginName,
pluginID=pluginID,
protocol=protocol,
severity=severity,
svc_name=svc_name,
pluginFamily=pluginFamily,
port=port,
false_positive='No',
vuln_status='Open')
all_data_save.save()
del_na = nessus_report_db.objects.filter(plugin_name='NA')
del_na.delete()
ov_all_vul = nessus_report_db.objects.filter(
scan_id=scan_id).order_by('scan_id')
total_vul = len(ov_all_vul)
total_critical = len(ov_all_vul.filter(risk_factor="Critical"))
total_high = len(ov_all_vul.filter(risk_factor="High"))
total_medium = len(ov_all_vul.filter(risk_factor="Medium"))
total_low = len(ov_all_vul.filter(risk_factor="Low"))
nessus_scan_db.objects.filter(scan_id=scan_id) \
.update(total_vul=total_vul,
critical_total=total_critical,
high_total=total_high,
medium_total=total_medium,
low_total=total_low)