cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
akerr
Reliable Contributor
Reliable Contributor
Report Inappropriate Content
Message 1 of 5

Creating Predefined Queries For CSV Reports

If a report is required in CSV format, the SIEM only allows you to use what it calls “PreDefined Queries”. You can not edit or create these from the report interface, though you can add additional filtering after. To create a new predefined query, or edit an existing one, you'll need to do it from the edit dashboard panel. You can either create new dashboard or edit an existing one.

Create a new Table (bar charts, lists, etc. don't seem to work).  The Query Wizard will pop up with a list of queries we can edit, including any ones we've created. Here you can edit them by clicking Edit, or Copy an existing one to create a new one.

predefined-queries-1.png

If creating new, copy the “Events” Query and give it an appropriate name (looks like about a 40 char limit on names), click OK

Select the Report you are creating or want to Edit and Click Edit.  I would recommend against editing any of the default ones, instead copy them to create new versions for your use.

This brings up the Query Wizard where you can define the fields in the Query, and Filters, and a Sort order

Once you have the fields, filters and sort order in place, Click Finish on the Query Wizard. This will save the Query and it is now accessible for CSV reporting.

predefined-queries-2.png

At this point, you are back to the window to create the chart in the dashboard. You can close the window and delete the dashboard as it is not required for the query

Now, when you create a report and use the CSV option, the query you created here will be listed in the pre-defined query drop down.  Please be aware that the list is alphabetical, but treats upper and lower case characters differently so AB will come before Aa.

4 Replies
Don_B
Level 7
Report Inappropriate Content
Message 2 of 5

Re: Creating Predefined Queries For CSV Reports

I have followed the instructions but the new query doesn't show in the predefined queries list.  Am I missing a step?

jamesmac
Level 10
Report Inappropriate Content
Message 3 of 5

Re: Creating Predefined Queries For CSV Reports

Same here. I can see we need to edit the Query rather than just the View, but it's not showing.

(For reference: does this need to be done on the Flash dashboard, or can you do it from HTML5 as well?)

jamesmac
Level 10
Report Inappropriate Content
Message 4 of 5

Re: Creating Predefined Queries For CSV Reports

...oh, and one further thing:

Even assuming you can generate a table view, there appears to be no way of combining that with a count, at least on the Flash side of the SIEM.

Report queries like - say - top Source IPs by number of associated events where the subtype is denied need Event count (*) and the mathematical function SUM (Event Count), and these are not made available.

This is actually quite a basic requirement (I know you can export manually to CSV, but reporting allows you to automate, run it to a schedule, set persistent filters...)

Sorry, rant over. Kind regards

James

Re: Creating Predefined Queries For CSV Reports

Only Solution in whole Community, Kudos
You Deserve an Award
Don't forget, when your helpful posts earn a kudos or get accepted as a solution you can unlock perks and badges. Those aren't the only badges, either. How many can you collect? Click here to learn more.

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