How to export data from Reports page
The module facilitates scheduled and ad hoc reporting, all at once or granularly, in order to gain a complete compliance and operational summary into IT.
The data can be exported as follows:
Authenticate in the CyberQuest web interface as an user with administrative rights.
Navigate to “Reports” page and select a report from the list. In this case we will select the "Self Audit Reports". This report is in the Custom reports folder.
Choose the time interval and the fields according to which the information in the report will be sorted and press the "Execute Report" button.
Execution options allow you to control in detail what data will be included in the report:
You can set a specific Start Date and End Date for reported data.
By pressing Items on page drill-down, you can select from 100, 50 and 10 items to be displayed on each page.
If checking Time interval box, you can choose for each day in your selection, which time interval will be reported on.
Note time reference on the right (local time, GMT or event time). Function of selected option, the reported data will change time values accordingly.
The Filter Data text box allows you to filter which information will be included in the report, based on the free text searches entered here. The text box acts like the Search field in Dashboards, Browser and Investigations modules and supports the same syntax.
The drill-down below Filter Data text box allows you to select which event fields will be added to report. By default, the report includes only Computer, Description, Destination IP and LocalTime listed as report columns. Check or uncheck any other field you consider being needed.
Reports can be run scheduled.
After running the report, click the "Export" button. You will have more data export options.
Choose a data export type from the following:
Export Object - Export report to CQO format;
Export to HTML - Export data to HTML format;
Export to CSV - Export data to CSV format;
Export to XLS - Export data to XLS format;
Export to XLSX - Export data to XLSX format;
Export to XML - Export data to XML format;
Export PDF - Export data to PDF format;
Start the export by pressing the "Start export" button or you can cancel the export by pressing the "Cancel" button.
After export is copleted, press "Download" button to save on local machine the desired information.