Reports

Secure60’s flexible reporting system enables organisations to create custom dashboards and reports using a powerful JSON-based configuration system. Reports are built through the Portal UI and support multiple chart types, data sources, and visualisation options.


Report Configuration

Component Structure

Each report consists of multiple components, where each component is defined by a JSON configuration with three main areas:

Flexible Data Queries

The Data section supports all backend API call types with endless flexibility. You can add any items to the JSON object (like "query", "aggregation", "time_range", etc.) which become GET parameters in the backend query, allowing you to construct exactly the data request you need.

Portal UI Configuration

Example Report

Here’s an example of a comprehensive Host Analysis Report showing the various chart types and layout capabilities:

Host Analysis Report Example

Chart Types

Data Table (datatable)

Interactive tables displaying structured data with sorting, filtering, and export capabilities.

Features:

Example Configuration:

{
  "chart": {
    "title": "Top Hosts by Event Count",
    "type": "datatable",
    "visible_rows": "10",
    "columns": [
      {
        "title": "Host Name",
        "field_name": "host_name",
        "add_link_to_search": "Y"
      },
      {
        "title": "Event Count",
        "field_name": "_count",
        "display_number_formatted": "Y"
      }
    ],
    "show_common_fields_filter": "Y"
  }
}

Line Chart (linechart)

Time-series visualisations for trend analysis and temporal data patterns.

Features:

Example Configuration:

{
  "chart": {
    "title": "Unique Host Entities Detected",
    "type": "linechart",
    "line_colour": "#585687",
    "background_colour": "#000000",
    "x_data_fieldname": "_timestamp_timezone",
    "y_data_fieldname": "_count"
  }
}

Bar Chart (barchart)

Vertical bar charts for categorical data comparison and analysis.

Features:

Configuration Options:

Example Configuration:

{
  "chart": {
    "title": "Events by Source Type",
    "type": "barchart",
    "background_colour": "#000000",
    "x_data_fieldname": "source_type",
    "y_data_fieldname": "_count"
  }
}

Pie Chart (piechart)

Circular charts displaying proportional data and percentage distributions.

Features:

Configuration Options:

Example Configuration:

{
  "chart": {
    "title": "Event Distribution by Category",
    "type": "piechart",
    "x_data_fieldname": "event_category",
    "y_data_fieldname": "_count"
  }
}

Total Chart (totalchart)

Single metric displays for key performance indicators and summary statistics.

Features:

Example Configuration:

{
  "chart": {
    "title": "Total Unique Host Entities",
    "type": "totalchart",
    "text_colour": "#585687",
    "background_colour": "#000000",
    "display_number_formatted": "Y"
  }
}

Text Panel (textpanel)

HTML content panels for displaying formatted text, instructions, and contextual information.

Features:

Configuration Options:

Example Configuration:

{
  "chart": {
    "title": "Report Overview",
    "type": "textpanel",
    "text_content": "<p>This report provides <strong>comprehensive analysis</strong> of host activity patterns.</p><ul><li>Entity tracking</li><li>Event correlation</li><li>Performance metrics</li></ul>"
  }
}

Layout Configuration

The Layout section controls component positioning using a grid-based system:

Example:

{
  "layout": {
    "row_start": "1",
    "row_finish": "1", 
    "column_start": "2",
    "column_finish": "3"
  }
}

Data Configuration

The Data section describes the backend API query and supports all API call types with complete flexibility. Any parameters you add become GET parameters in the backend request.

Common Data Types

Flexible Parameters

Add any parameters to customize your data query - they all become GET parameters:

Example:

{
  "data": {
    "data_type": "entities_detail",
    "query": "_entity_name='host_name'",
    "aggregation": "sum",
    "query_group_by_fields": "_entity_name",
    "query_group_distinct": "_entity_value"
  }
}

Interactive Features

Search Integration

List Integration

Analysis Tools


Report Templates

Host Analysis Report

Comprehensive host monitoring and entity analysis:

Security Operations Dashboard

Daily security operations metrics:

Network Traffic Analysis

Network activity monitoring and analysis:

Compliance Reporting

Audit-ready compliance data:


Best Practices

Report Design

Data Strategy

User Experience

For detailed configuration examples and advanced features, contact our support team or refer to the built-in template library within the Portal UI.

Back to top