cancel
Showing results for 
Search instead for 
Did you mean: 
feeeds
Level 9
Report Inappropriate Content
Message 1 of 5

Reporting overview

I'm looking for a way to generate some custom reports showing top x machines with vulnerabilites, with just a listing of the vulnerabilites.  I've been running reports for a few days now, and they all seem to be hundreds of pages in length.  I would like a high level report that only shows assets and the vulnerabilites.  thanks,

4 Replies

Re: Reporting overview

I created a vulnerability set, and then applied it to the custom report to pull just the vulnerabilities I wanted. It takes a few minutes to build, and there is a little trial and error, but that did the trick for me

Re: Reporting overview

I think one really decent way is to leverage excelcustom reports, and  the vulnerabilities.csv.

example..

Excel:tab 1-paste contents of the vulns.csv

excel tab 2-pivot table with the system names as the source. adjacent columns searching "tab 1" for the number of occurences of each system name coupled with the risk level(using the countifs function)-this will give you system name, highs, mediums, lows for each system..and you can easily add another column to total

Excel tab 3 if youre interested in getting affected system counts by for each vuln, you can do another pivot table with the vuln name from "tab 1" as the source. then add a column to count the number of occurrences of each vuln name in "tab 1"

You can do this outside of excel too with scripting, use a custom built app, or there are also some vendor solutions that can help.

feeeds
Level 9
Report Inappropriate Content
Message 4 of 5

Re: Reporting overview

Hey John,  I appreciate the contribution...  I have not messed with pivot tables in several years, and franky the product should provide top x canned reports out of the box. We should not have to go through all this effort to accomplish something that seems so basic.

Highlighted

Re: Reporting overview

I have found the most efficient and modular approach to obtain data from MVM is via writing your own SQL queries. It provides a much simpler facility for dynamically pulling the data you want - I do it in VBA so results come straight into Excel formatted however I desire.If you want reporting customized to your needs read the database schema and starting writing SQL queries !

Message was edited by: edburns on 2/1/13 12:39:53 AM CST
More McAfee Tools to Help You
  • Subscription Service Notification (SNS)
  • How-to: Endpoint Removal Tool
  • Support: Endpoint Security
  • eSupport: Policy Orchestrator
  • Community Help Hub

      New to the forums or need help finding your way around the forums? There's a whole hub of community resources to help you.

    • Find Forum FAQs
    • Learn How to Earn Badges
    • Ask for Help
    Go to Community Help

    Join the Community

      Thousands of customers use the McAfee Community for peer-to-peer and expert product support. Enjoy these benefits with a free membership:

    • Get helpful solutions from McAfee experts.
    • Stay connected to product conversations that matter to you.
    • Participate in product groups led by McAfee employees.
    Join the Community
    Join the Community