I have just started playing around in qualys and I was wondering if it was possible to change a dtd template so that i could decide what the XML export would look like?
The end goal would be so that i can flatten the XML to put it in a database. This way it would be much easier to create decent dashboards without the use of excel (which is horrible).
At this point my excel looks something like this. Just the "total app" and the last 5 columns are calculated values (so not from the scan itself)
|IP||Server Name||total APP||Domain||Company||Application||Environment||Tier||OS Type||DNS||NetBIOS||Tracking Method||OS||IP Status||QID||Title||Vuln Type||Vuln Status||Type||Severity||Port||Protocol||FQDN||SSL||First Detected||Last Detected||Times Detected||Date Last Fixed||CVE ID||Vendor Reference||Bugtraq ID||CVSS||CVSS Base||CVSS Temporal||CVSS Environment||CVSS3||CVSS3 Base||CVSS3 Temporal||Results||PCI Vuln||Ticket State||Instance||Category||patchable||Time "Text Format"||Time "Date Format"||MyCategory||Older then 6 months||UID|
I wanna switch to sql as this would be a much more reliable and quicker data source then excel.