Sign In with your
Trend Micro Account
Need Help?
Need More Help?

Create a technical support case if you need further support.

How do I export a query result on the SMS?

    • Updated:
    • 13 Dec 2017
    • Product/Version:
    • TippingPoint SMS All
    • TippingPoint Virtual SMS
    • Platform:
Summary
After creating and running an event query, you can export the results of the query to a comma- or tab delimited file. This file can be imported into programs such as Crystal Reports or Microsoft Excel.

Note: When exporting query results, you must set the results to an analysis mode not including Real-Time. The results can export for Last Hour or date/time range.
Details
Public

Procedure:

  1. Log in to the SMS from a client.
  2. On the top Navigation menu click Events.
  3. Select Inspection Events or Firewall Events from the left navigational tree.
  4. Configure and run an attack event query.
  5. Select an analysis mode not including Real-Time. The results can export for Last Hour or date/time range.
  6. On the menu bar, click File > Export Query Results. A Save dialog box displays.
  7. Select Export to Local File or Export to SMS.
  8. Enter the desired file name. If you are exporting the query to a local file, click Browse to select the directory in which you want to save the file.
  9. For Results Limit, enter an integer to limit the number of results that are exported. Enter 0 if you do not want to impose a limit.
  10. Select a Field Delimiter from the drop-down menu.
  11. Click Export.

The system saves the query results to a comma- or tab-delimited.csv file. If the query is exported to the SMS Web server, the report will be visible in the Reports section of the SMS Web home page from which you downloaded the SMS client installer.

Note: You cannot export queries when the Real-Time option is selected in the IPS Events screen.

 

 

Reference: SMS User Guide

Premium
Internal
Rating:
Category:
Configure; Troubleshoot; Deploy
Solution Id:
TP000097004
Feedback
Did this article help you?

Thank you for your feedback!

To help us improve the quality of this article, please leave your email here so we can clarify further your feedback, if neccessary:
We will not send you spam or share your email address.

*This form is automated system. General questions, technical, sales, and product-related issues submitted through this form will not be answered.

If you need additional help, you may try to contact the support team. Contact Support


To help us improve the quality of this article, please leave your email here so we can clarify further your feedback, if neccessary:
We will not send you spam or share your email address.

*This form is automated system. General questions, technical, sales, and product-related issues submitted through this form will not be answered.