We're running 9.0 SP2 and we've hit a snag. We'd like to modify the canned Vulnerability Status Summary report to exclude servers. All I need is to be able to exclude any OS that contains the word "server." I can do that in a query, but I'm not an SQL Ninja and have not been able to modify it correctly with my limited skills in the Advanced Report Designer. The bottom line is that we really want the pie chart that shows up on the first page of the canned report but we want to filter it. Using the ability to use an existing LDMS query doesn't allow us the pie chart that we desire.
Nevermind.. I got it. I took a query that I already had and pasted the WHERE stuff from the query to the report. then I renamed the stuff that failed to match the query that was already in the report and it worked.