I have a table with the following fields:
table qualys_id,exploit_cve_id,exploit_name,exploit_source,exploit_url
Doing a dedup on exploit_cve_id,exploit_name and exploit_cve_id,exploit_url yields different results. I'm guessing that there are some data integrity issues. I would like to view a table with a count of both the exploit_name and the exploit_url appended to each result so I can sort them and try and figure out where the differences are.
So, the table would ideally be:
table qualys_id,exploit_cve_id,exploit_name,exploit_source,exploit_url,name_count,url_count
Is this possible?
Thx.
Craig
... View more