Have a cross-tab pulling in data for 3 vulnerability types (New, Existing, Rolled), date (week of), how many days the vulnerability has been around and summing (counting) the number of vunerabilities for each host (ip address).
I am getting exactly what I need except I am getting a extra column at the begging of the cross-tab which is counting the vulnerabilities that are not associated to the particulare date I choose.
Let's see if I can show what is going on since I can not paste a table or image in this post.
| | 5/12/2009 / 0-30 | 5/12/2009 / 31-60 |
| | Existing New | Existing New |
Total | 2958 | 217 489 | 493 2 |
In my example the bold red column is the extra column I would like to get rid of.
IP Logged
