Skip to main content

Graylog

This Integration is part of the Graylog Pack.#

Integration with Graylog to search for logs and events This integration was integrated and tested with version 3.3.6 of Graylog

Configure Graylog on Cortex XSOAR#

  1. Navigate to Settings > Integrations > Servers & Services.
  2. Search for Graylog.
  3. Click Add instance to create and configure a new integration instance.
ParameterDescriptionRequired
urlServer URL (e.g. https://serverurl:9000)True
credentialsUsernameTrue
insecureTrust any certificate (not secure)False
proxyUse system proxy settingsFalse
fetch_timeFirst fetch timestamp (<number> <time unit>, e.g., 12 hours, 7 days)False
fetch_queryThe query that is used to fetch events as incidents (lucene syntax)False
isFetchFetch incidentsFalse
incidentTypeIncident typeFalse
  1. Click Test to validate the URLs, token, and connection.

Commands#

You can execute these commands from the Cortex XSOAR CLI, as part of an automation, or in a playbook. After you successfully execute a command, a DBot message appears in the War Room with the command details.

graylog-cluster-status#


Get Cluster nodes status

Base Command#

graylog-cluster-status

Input#

Argument NameDescriptionRequired

Context Output#

PathTypeDescription
Graylog.ClusterStatusStringStatus of nodes in the Cluster

Command Example#

!graylog-cluster-status

Context Example#

{
"Graylog": {
"ClusterStatus": {
"95ba5102-13c9-4520-ac75-c8736f206953": {
"cluster_id": "70a69af5-7368-4244-ac12-cf5b87c83ac2",
"codename": "Sloth Rocket",
"facility": "graylog-server",
"hostname": "graylog",
"is_processing": true,
"lb_status": "alive",
"lifecycle": "running",
"node_id": "95ba5102-13c9-4520-ac75-c8736f206953",
"operating_system": "Linux 4.15.0-118-generic",
"started_at": "2020-10-07T16:04:07.506Z",
"timezone": "UTC",
"version": "3.3.6+92fb41e"
}
}
}
}

Human Readable Output#

Results#

95ba5102-13c9-4520-ac75-c8736f206953
facility: graylog-server
codename: Sloth Rocket
node_id: 95ba5102-13c9-4520-ac75-c8736f206953
cluster_id: 70a69af5-7368-4244-ac12-cf5b87c83ac2
version: 3.3.6+92fb41e
started_at: 2020-10-07T16:04:07.506Z
hostname: graylog
lifecycle: running
lb_status: alive
timezone: UTC
operating_system: Linux 4.15.0-118-generic
is_processing: true

graylog-cluster-node-jvm#


Get JVM status of a node in cluster

Base Command#

graylog-cluster-node-jvm

Input#

Argument NameDescriptionRequired
nodeIdNode ID of the cluster memberRequired

Context Output#

PathTypeDescription
Graylog.ClusterNodeJVMStringJVM info of Node

Command Example#

!graylog-cluster-node-jvm nodeId=95ba5102-13c9-4520-ac75-c8736f206953

Context Example#

{
"Graylog": {
"ClusterNodeJVM": {
"free_memory": {
"bytes": 387725360,
"kilobytes": 378638,
"megabytes": 369
},
"info": "Private Build 1.8.0_265 on Linux 4.15.0-118-generic",
"max_memory": {
"bytes": 1020067840,
"kilobytes": 996160,
"megabytes": 972
},
"node_id": "95ba5102-13c9-4520-ac75-c8736f206953",
"pid": "550",
"total_memory": {
"bytes": 1020067840,
"kilobytes": 996160,
"megabytes": 972
},
"used_memory": {
"bytes": 632342480,
"kilobytes": 617521,
"megabytes": 603
}
}
}
}

Human Readable Output#

Results#

free_memoryinfomax_memorynode_idpidtotal_memoryused_memory
bytes: 387725360
kilobytes: 378638
megabytes: 369
Private Build 1.8.0_265 on Linux 4.15.0-118-genericbytes: 1020067840
kilobytes: 996160
megabytes: 972
95ba5102-13c9-4520-ac75-c8736f206953550bytes: 1020067840
kilobytes: 996160
megabytes: 972
bytes: 632342480
kilobytes: 617521
megabytes: 603

graylog-cluster-inputstates#


Get input states of the cluster

Base Command#

graylog-cluster-inputstates

Input#

Argument NameDescriptionRequired

Context Output#

PathTypeDescription
Graylog.ClusterInputStatesStringInput states of the cluster

Command Example#

!graylog-cluster-inputstates

Context Example#

{
"Graylog": {
"ClusterInputStates": {
"95ba5102-13c9-4520-ac75-c8736f206953": [
{
"detailed_message": null,
"id": "5f7433f60f4d9c360092a070",
"message_input": {
"attributes": {
"bind_address": "0.0.0.0",
"max_message_size": 2097152,
"number_worker_threads": 2,
"port": 5555,
"recv_buffer_size": 1048576,
"store_full_message": false,
"tcp_keepalive": false,
"tls_cert_file": "",
"tls_client_auth": "disabled",
"tls_client_auth_cert_file": "",
"tls_enable": false,
"tls_key_file": "",
"tls_key_password": "",
"use_null_delimiter": false
},
"content_pack": null,
"created_at": "2020-09-30T07:29:58.169Z",
"creator_user_id": "harri",
"global": true,
"id": "5f7433f60f4d9c360092a070",
"name": "Palo Alto Networks TCP (PAN-OS v9.x)",
"node": null,
"static_fields": {},
"title": "PAN-OS-input",
"type": "org.graylog.integrations.inputs.paloalto9.PaloAlto9xInput"
},
"started_at": "2020-10-07T16:04:28.814Z",
"state": "RUNNING"
},
]
}
}
}

Human Readable Output#

Results#

95ba5102-13c9-4520-ac75-c8736f206953
{'id': '5f7433f60f4d9c360092a070', 'state': 'RUNNING', 'started_at': '2020-10-07T16:04:28.814Z', 'detailed_message': None, 'message_input': {'title': 'PAN-OS-input', 'global': True, 'name': 'Palo Alto Networks TCP (PAN-OS v9.x)', 'content_pack': None, 'created_at': '2020-09-30T07:29:58.169Z', 'type': 'org.graylog.integrations.inputs.paloalto9.PaloAlto9xInput', 'creator_user_id': 'harri', 'attributes': {'recv_buffer_size': 1048576, 'tcp_keepalive': False, 'use_null_delimiter': False, 'number_worker_threads': 2, 'tls_client_auth_cert_file': '', 'bind_address': '0.0.0.0', 'tls_cert_file': '', 'store_full_message': False, 'port': 5555, 'tls_key_file': '', 'tls_enable': False, 'tls_key_password': '', 'max_message_size': 2097152, 'tls_client_auth': 'disabled'}, 'static_fields': {}, 'node': None, 'id': '5f7433f60f4d9c360092a070'}}

graylog-cluster-processing-status#


Shows the processing status of the cluster

Base Command#

graylog-cluster-processing-status

Input#

Argument NameDescriptionRequired

Context Output#

PathTypeDescription
Graylog.ClusterProcessingStatusStringProcessing status of the cluster

Command Example#

!graylog-cluster-processing-status

Context Example#

{
"Graylog": {
"ClusterProcessingStatus": {
"95ba5102-13c9-4520-ac75-c8736f206953": {
"receive_times": {
"ingest": "2020-10-08T10:08:29.353Z",
"post_indexing": "2020-10-08T10:08:29.353Z",
"post_processing": "2020-10-08T10:08:29.353Z"
}
}
}
}
}

Human Readable Output#

Results#

95ba5102-13c9-4520-ac75-c8736f206953
receive_times: {"ingest": "2020-10-08T10:08:29.353Z", "post_processing": "2020-10-08T10:08:29.353Z", "post_indexing": "2020-10-08T10:08:29.353Z"}

graylog-indexer-cluster-health#


Get health of the indexer

Base Command#

graylog-indexer-cluster-health

Input#

Argument NameDescriptionRequired

Context Output#

PathTypeDescription
Graylog.IndexerHealthStringHealth of Indexer

Command Example#

!graylog-indexer-cluster-health

Context Example#

{
"Graylog": {
"IndexerHealth": {
"shards": {
"active": 20,
"initializing": 0,
"relocating": 0,
"unassigned": 0
},
"status": "green"
}
}
}

Human Readable Output#

Results#

shardsstatus
active: 20
initializing: 0
relocating: 0
unassigned: 0
green

graylog-search#


Search for messages in a relative timerange, specified as seconds from now. Example: 300 means search from 5 minutes ago to now.

Base Command#

graylog-search

Input#

Argument NameDescriptionRequired
queryQuery (Lucene syntax)Required
rangeRelative timeframe to search in. Default 300sOptional
limitMaximum number of messages to return. Default 20Optional
offsetoffset (integer)Optional
filterfilterOptional
fieldsComma separated list of fields to returnOptional
sortSorting (field:asc / field:desc)Optional
decorateRun decorators on search result (default True)Optional

Context Output#

PathTypeDescription
Graylog.SearchStringSearch results

Command Example#

!graylog-search query=\<query here\>

Context Example#

{
"Graylog": {
"Search": {
"built_query": "{\n \"from\" : 0,\n \"size\" : 20,\n \"query\" : {\n \"bool\" : {\n \"must\" : [\n {\n \"query_string\" : {\n \"query\" : \"\<query here\>\",\n \"fields\" : [ ],\n \"use_dis_max\" : true,\n \"tie_breaker\" : 0.0,\n \"default_operator\" : \"or\",\n \"auto_generate_phrase_queries\" : false,\n \"max_determinized_states\" : 10000,\n \"allow_leading_wildcard\" : false,\n \"enable_position_increments\" : true,\n \"fuzziness\" : \"AUTO\",\n \"fuzzy_prefix_length\" : 0,\n \"fuzzy_max_expansions\" : 50,\n \"phrase_slop\" : 0,\n \"escape\" : false,\n \"split_on_whitespace\" : true,\n \"boost\" : 1.0\n }\n }\n ],\n \"filter\" : [\n {\n \"bool\" : {\n \"must\" : [\n {\n \"range\" : {\n \"timestamp\" : {\n \"from\" : \"2020-10-08 00:08:57.306\",\n \"to\" : \"2020-10-08 10:08:57.306\",\n \"include_lower\" : true,\n \"include_upper\" : true,\n \"boost\" : 1.0\n }\n }\n }\n ],\n \"disable_coord\" : false,\n \"adjust_pure_negative\" : true,\n \"boost\" : 1.0\n }\n }\n ],\n \"disable_coord\" : false,\n \"adjust_pure_negative\" : true,\n \"boost\" : 1.0\n }\n },\n \"sort\" : [\n {\n \"timestamp\" : {\n \"order\" : \"desc\"\n }\n }\n ]\n}",
"decoration_stats": null,
"fields": [
"event_received_time",
"pan_log_subtype",
"pan_dev_group_level_4",
"pan_dev_group_level_3",
"network_interface_out",
"source",
"pan_url_index",
"vendor_event_action",
"pan_dev_group_level_2",
"pan_dev_group_level_1",
"source_ip",
"host_virtfw_id",
"application_name",
"destination_ip",
"pan_ppid",
"alert_indicator",
"host_hostname",
"source_location_name",
"alert_signature_id",
"rule_name",
"source_zone",
"gl2_message_id",
"network_protocol",
"network_tunnel_type",
"alert_definitions_version",
"destination_nat_ip",
"pan_log_action",
"pan_http2",
"source_nat_ip",
"destination_nat_port",
"http_url_category",
"policy_uid",
"destination_port",
"pan_log_panorama",
"pan_tunnel_id",
"pan_alert_direction",
"vendor_alert_severity",
"event_uid",
"destination_location_name",
"source_port",
"event_log_name",
"event_repeat_count",
"timestamp",
"event_source_product",
"source_nat_port",
"destination_zone",
"session_id",
"message",
"alert_category",
"pan_parent_session_id",
"host_id",
"network_interface_in",
"pan_wildfire_report_id",
"pan_pcap_id",
"pan_flags",
"pan_assoc_id",
"pan_monitor_tag"
],
"from": "2020-10-08T00:08:57.306Z",
"messages": [
{
"decoration_stats": null,
"highlight_ranges": {},
"index": "graylog_0",
"message": {
"_id": "1acb0472-0923-11eb-a959-000c29d42d8e",
"alert_category": "news",
"alert_definitions_version": "AppThreat-0-0",
"alert_indicator": "\<query here\>/",
"alert_signature_id": "(9999)",
"application_name": "ssl",
"destination_ip": "aaa.aaa.aaa.aaa",
"destination_location_name": "United States",
"destination_nat_ip": "aaa.aaa.aaa.aaa",
"destination_nat_port": 443,
"destination_port": 443,
"destination_zone": "Untrust-L3",
"event_log_name": "THREAT",
"event_received_time": "2020/10/08 07:59:53",
"event_repeat_count": 1,
"event_source_product": "PAN",
"event_uid": "7665475",
"gl2_accounted_message_size": 2027,
"gl2_message_id": "ABCD",
"gl2_remote_ip": "bbb.bbb.bbb.bbb",
"gl2_remote_port": 51371,
"gl2_source_input": "5f7433f60f4d9c360092a070",
"gl2_source_node": "95ba5102-13c9-4520-ac75-c8736f206953",
"host_hostname": "PA-220",
"host_id": "ABCDEFGHIJK",
"host_virtfw_id": "vsys1",
"http_url_category": "news,low-risk",
"message": "1,2020/10/08 07:59:53,ABCDEFGHIJK,THREAT,url,2560,2020/10/08 07:59:53,ccc.ccc.ccc.ccc,aaa.aaa.aaa.aaa,ddd.ddd.ddd.ddd,aaa.aaa.aaa.aaa,FromTrust,,,ssl,vsys1,Trust-L3,Untrust-L3,ethernet1/3,ethernet1/4,default,2020/10/08 07:59:53,23366,1,61323,443,48189,443,0x816400,tcp,alert,\"\<query here\>/\",(9999),news,informational,client-to-server,7665475,0xa000000000000000,192.168.0.0-192.168.255.255,United States,0,,0,,,0,,,,,,,,0,0,0,0,0,,PA-220,,,,,0,,0,,N/A,unknown,AppThreat-0-0,0x0,0,4294967295,,\"news,low-risk\",4093544d-2f66-4d80-af2d-17f361609984,0,,0.0.0.0,,,,,,,,,,,,,,,,,,,,,,,,,,,0,2020-10-08T07:59:54.289+03:00,,,",
"network_interface_in": "ethernet1/3",
"network_interface_out": "ethernet1/4",
"network_protocol": "tcp",
"network_tunnel_type": "N/A",
"pan_alert_direction": "client-to-server",
"pan_assoc_id": 0,
"pan_dev_group_level_1": 0,
"pan_dev_group_level_2": 0,
"pan_dev_group_level_3": 0,
"pan_dev_group_level_4": 0,
"pan_flags": "0x816400",
"pan_http2": "0",
"pan_log_action": "default",
"pan_log_panorama": "0xa000000000000000",
"pan_log_subtype": "url",
"pan_monitor_tag": 0,
"pan_parent_session_id": "0",
"pan_pcap_id": "0",
"pan_ppid": 4294967295,
"pan_tunnel_id": "0",
"pan_url_index": 0,
"pan_wildfire_report_id": 0,
"policy_uid": "4093544d-2f66-4d80-af2d-17f361609984",
"rule_name": "FromTrust",
"session_id": 23366,
"source": "PA-220",
"source_ip": "ccc.ccc.ccc.ccc",
"source_location_name": "192.168.0.0-192.168.255.255",
"source_nat_ip": "ddd.ddd.ddd.ddd",
"source_nat_port": 48189,
"source_port": 61323,
"source_zone": "Trust-L3",
"streams": [
"000000000000000000000001"
],
"timestamp": "2020-10-08T04:59:55.169Z",
"vendor_alert_severity": "informational",
"vendor_event_action": "alert"
}
},
{
"decoration_stats": null,
"highlight_ranges": {},
"index": "graylog_0",
"message": {
"_id": "1acb0470-0923-11eb-a959-000c29d42d8e",
"alert_category": "news",
"alert_definitions_version": "AppThreat-0-0",
"alert_indicator": "\<query here\>/",
"alert_signature_id": "(9999)",
"application_name": "ssl",
"destination_ip": "aaa.aaa.aaa.aaa",
"destination_location_name": "United States",
"destination_nat_ip": "aaa.aaa.aaa.aaa",
"destination_nat_port": 443,
"destination_port": 443,
"destination_zone": "Untrust-L3",
"event_log_name": "THREAT",
"event_received_time": "2020/10/08 07:59:53",
"event_repeat_count": 1,
"event_source_product": "PAN",
"event_uid": "7665473",
"gl2_accounted_message_size": 2027,
"gl2_message_id": "ABCD",
"gl2_remote_ip": "bbb.bbb.bbb.bbb",
"gl2_remote_port": 51371,
"gl2_source_input": "5f7433f60f4d9c360092a070",
"gl2_source_node": "95ba5102-13c9-4520-ac75-c8736f206953",
"host_hostname": "PA-220",
"host_id": "ABCDEFGHIJK",
"host_virtfw_id": "vsys1",
"http_url_category": "news,low-risk",
"message": "1,2020/10/08 07:59:53,ABCDEFGHIJK,THREAT,url,2560,2020/10/08 07:59:53,ccc.ccc.ccc.ccc,aaa.aaa.aaa.aaa,ddd.ddd.ddd.ddd,aaa.aaa.aaa.aaa,FromTrust,,,ssl,vsys1,Trust-L3,Untrust-L3,ethernet1/3,ethernet1/4,default,2020/10/08 07:59:53,24085,1,61322,443,29959,443,0x816400,tcp,alert,\"\<query here\>/\",(9999),news,informational,client-to-server,7665473,0xa000000000000000,192.168.0.0-192.168.255.255,United States,0,,0,,,0,,,,,,,,0,0,0,0,0,,PA-220,,,,,0,,0,,N/A,unknown,AppThreat-0-0,0x0,0,4294967295,,\"news,low-risk\",4093544d-2f66-4d80-af2d-17f361609984,0,,0.0.0.0,,,,,,,,,,,,,,,,,,,,,,,,,,,0,2020-10-08T07:59:54.289+03:00,,,",
"network_interface_in": "ethernet1/3",
"network_interface_out": "ethernet1/4",
"network_protocol": "tcp",
"network_tunnel_type": "N/A",
"pan_alert_direction": "client-to-server",
"pan_assoc_id": 0,
"pan_dev_group_level_1": 0,
"pan_dev_group_level_2": 0,
"pan_dev_group_level_3": 0,
"pan_dev_group_level_4": 0,
"pan_flags": "0x816400",
"pan_http2": "0",
"pan_log_action": "default",
"pan_log_panorama": "0xa000000000000000",
"pan_log_subtype": "url",
"pan_monitor_tag": 0,
"pan_parent_session_id": "0",
"pan_pcap_id": "0",
"pan_ppid": 4294967295,
"pan_tunnel_id": "0",
"pan_url_index": 0,
"pan_wildfire_report_id": 0,
"policy_uid": "4093544d-2f66-4d80-af2d-17f361609984",
"rule_name": "FromTrust",
"session_id": 24085,
"source": "PA-220",
"source_ip": "ccc.ccc.ccc.ccc",
"source_location_name": "192.168.0.0-192.168.255.255",
"source_nat_ip": "ddd.ddd.ddd.ddd",
"source_nat_port": 29959,
"source_port": 61322,
"source_zone": "Trust-L3",
"streams": [
"000000000000000000000001"
],
"timestamp": "2020-10-08T04:59:55.169Z",
"vendor_alert_severity": "informational",
"vendor_event_action": "alert"
}
}
],
"query": "\<query here\>",
"time": 11,
"to": "2020-10-08T10:08:57.306Z",
"total_results": 2,
"used_indices": [
{
"begin": "1970-01-01T00:00:00.000Z",
"calculated_at": "2020-09-30T07:24:40.163Z",
"end": "1970-01-01T00:00:00.000Z",
"index_name": "graylog_0",
"took_ms": 0
}
]
}
}
}

Human Readable Output#

Results#

built_querydecoration_statsfieldsfrommessagesquerytimetototal_resultsused_indices
{
"from" : 0,
"size" : 20,
"query" : {
"bool" : {
"must" : [
{
"query_string" : {
"query" : "\<query here>",
"fields" : [ ],
"use_dis_max" : true,
"tie_breaker" : 0.0,
"default_operator" : "or",
"auto_generate_phrase_queries" : false,
"max_determinized_states" : 10000,
"allow_leading_wildcard" : false,
"enable_position_increments" : true,
"fuzziness" : "AUTO",
"fuzzy_prefix_length" : 0,
"fuzzy_max_expansions" : 50,
"phrase_slop" : 0,
"escape" : false,
"split_on_whitespace" : true,
"boost" : 1.0
}
}
],
"filter" : [
{
"bool" : {
"must" : [
{
"range" : {
"timestamp" : {
"from" : "2020-10-08 00:08:57.306",
"to" : "2020-10-08 10:08:57.306",
"include_lower" : true,
"include_upper" : true,
"boost" : 1.0
}
}
}
],
"disable_coord" : false,
"adjust_pure_negative" : true,
"boost" : 1.0
}
}
],
"disable_coord" : false,
"adjust_pure_negative" : true,
"boost" : 1.0
}
},
"sort" : [
{
"timestamp" : {
"order" : "desc"
}
}
]
}
event_received_time,
pan_log_subtype,
pan_dev_group_level_4,
pan_dev_group_level_3,
network_interface_out,
source,
pan_url_index,
vendor_event_action,
pan_dev_group_level_2,
pan_dev_group_level_1,
source_ip,
host_virtfw_id,
application_name,
destination_ip,
pan_ppid,
alert_indicator,
host_hostname,
source_location_name,
alert_signature_id,
rule_name,
source_zone,
gl2_message_id,
network_protocol,
network_tunnel_type,
alert_definitions_version,
destination_nat_ip,
pan_log_action,
pan_http2,
source_nat_ip,
destination_nat_port,
http_url_category,
policy_uid,
destination_port,
pan_log_panorama,
pan_tunnel_id,
pan_alert_direction,
vendor_alert_severity,
event_uid,
destination_location_name,
source_port,
event_log_name,
event_repeat_count,
timestamp,
event_source_product,
source_nat_port,
destination_zone,
session_id,
message,
alert_category,
pan_parent_session_id,
host_id,
network_interface_in,
pan_wildfire_report_id,
pan_pcap_id,
pan_flags,
pan_assoc_id,
pan_monitor_tag
2020-10-08T00:08:57.306Z{'highlight_ranges': {}, 'message': {'event_received_time': '2020/10/08 07:59:53', 'pan_log_subtype': 'url', 'gl2_remote_ip': 'bbb.bbb.bbb.bbb', 'gl2_remote_port': 51371, 'pan_dev_group_level_4': 0, 'pan_dev_group_level_3': 0, 'network_interface_out': 'ethernet1/4', 'source': 'PA-220', 'gl2_source_input': '5f7433f60f4d9c360092a070', 'pan_url_index': 0, 'vendor_event_action': 'alert', 'pan_dev_group_level_2': 0, 'pan_dev_group_level_1': 0, 'source_ip': 'ccc.ccc.ccc.ccc', 'host_virtfw_id': 'vsys1', 'application_name': 'ssl', 'destination_ip': 'aaa.aaa.aaa.aaa', 'pan_ppid': 4294967295, 'gl2_source_node': '95ba5102-13c9-4520-ac75-c8736f206953', 'alert_indicator': '\<query here>/', 'host_hostname': 'PA-220', 'source_location_name': '192.168.0.0-192.168.255.255', 'gl2_accounted_message_size': 2027, 'alert_signature_id': '(9999)', 'rule_name': 'FromTrust', 'source_zone': 'Trust-L3', 'streams': ['000000000000000000000001'], 'gl2_message_id': 'ABCD', 'network_protocol': 'tcp', 'network_tunnel_type': 'N/A', 'alert_definitions_version': 'AppThreat-0-0', 'destination_nat_ip': 'aaa.aaa.aaa.aaa', 'pan_log_action': 'default', 'pan_http2': '0', 'source_nat_ip': 'ddd.ddd.ddd.ddd', '_id': '1acb0472-0923-11eb-a959-000c29d42d8e', 'destination_nat_port': 443, 'http_url_category': 'news,low-risk', 'policy_uid': '4093544d-2f66-4d80-af2d-17f361609984', 'destination_port': 443, 'pan_log_panorama': '0xa000000000000000', 'pan_tunnel_id': '0', 'pan_alert_direction': 'client-to-server', 'vendor_alert_severity': 'informational', 'event_uid': '7665475', 'destination_location_name': 'United States', 'source_port': 61323, 'event_log_name': 'THREAT', 'event_repeat_count': 1, 'timestamp': '2020-10-08T04:59:55.169Z', 'event_source_product': 'PAN', 'source_nat_port': 48189, 'destination_zone': 'Untrust-L3', 'session_id': 23366, 'message': '1,2020/10/08 07:59:53,ABCDEFGHIJK,THREAT,url,2560,2020/10/08 07:59:53,ccc.ccc.ccc.ccc,aaa.aaa.aaa.aaa,ddd.ddd.ddd.ddd,aaa.aaa.aaa.aaa,FromTrust,,,ssl,vsys1,Trust-L3,Untrust-L3,ethernet1/3,ethernet1/4,default,2020/10/08 07:59:53,23366,1,61323,443,48189,443,0x816400,tcp,alert,"\<query here>/",(9999),news,informational,client-to-server,7665475,0xa000000000000000,192.168.0.0-192.168.255.255,United States,0,,0,,,0,,,,,,,,0,0,0,0,0,,PA-220,,,,,0,,0,,N/A,unknown,AppThreat-0-0,0x0,0,4294967295,,"news,low-risk",4093544d-2f66-4d80-af2d-17f361609984,0,,0.0.0.0,,,,,,,,,,,,,,,,,,,,,,,,,,,0,2020-10-08T07:59:54.289+03:00,,,', 'alert_category': 'news', 'pan_parent_session_id': '0', 'host_id': 'ABCDEFGHIJK', 'network_interface_in': 'ethernet1/3', 'pan_wildfire_report_id': 0, 'pan_pcap_id': '0', 'pan_flags': '0x816400', 'pan_assoc_id': 0, 'pan_monitor_tag': 0}, 'index': 'graylog_0', 'decoration_stats': None},
{'highlight_ranges': {}, 'message': {'event_received_time': '2020/10/08 07:59:53', 'pan_log_subtype': 'url', 'gl2_remote_ip': 'bbb.bbb.bbb.bbb', 'gl2_remote_port': 51371, 'pan_dev_group_level_4': 0, 'pan_dev_group_level_3': 0, 'network_interface_out': 'ethernet1/4', 'source': 'PA-220', 'gl2_source_input': '5f7433f60f4d9c360092a070', 'pan_url_index': 0, 'vendor_event_action': 'alert', 'pan_dev_group_level_2': 0, 'pan_dev_group_level_1': 0, 'source_ip': 'ccc.ccc.ccc.ccc', 'host_virtfw_id': 'vsys1', 'application_name': 'ssl', 'destination_ip': 'aaa.aaa.aaa.aaa', 'pan_ppid': 4294967295, 'gl2_source_node': '95ba5102-13c9-4520-ac75-c8736f206953', 'alert_indicator': '\<query here>/', 'host_hostname': 'PA-220', 'source_location_name': '192.168.0.0-192.168.255.255', 'gl2_accounted_message_size': 2027, 'alert_signature_id': '(9999)', 'rule_name': 'FromTrust', 'source_zone': 'Trust-L3', 'streams': ['000000000000000000000001'], 'gl2_message_id': 'ABCD', 'network_protocol': 'tcp', 'network_tunnel_type': 'N/A', 'alert_definitions_version': 'AppThreat-0-0', 'destination_nat_ip': 'aaa.aaa.aaa.aaa', 'pan_log_action': 'default', 'pan_http2': '0', 'source_nat_ip': 'ddd.ddd.ddd.ddd', '_id': '1acb0470-0923-11eb-a959-000c29d42d8e', 'destination_nat_port': 443, 'http_url_category': 'news,low-risk', 'policy_uid': '4093544d-2f66-4d80-af2d-17f361609984', 'destination_port': 443, 'pan_log_panorama': '0xa000000000000000', 'pan_tunnel_id': '0', 'pan_alert_direction': 'client-to-server', 'vendor_alert_severity': 'informational', 'event_uid': '7665473', 'destination_location_name': 'United States', 'source_port': 61322, 'event_log_name': 'THREAT', 'event_repeat_count': 1, 'timestamp': '2020-10-08T04:59:55.169Z', 'event_source_product': 'PAN', 'source_nat_port': 29959, 'destination_zone': 'Untrust-L3', 'session_id': 24085, 'message': '1,2020/10/08 07:59:53,ABCDEFGHIJK,THREAT,url,2560,2020/10/08 07:59:53,ccc.ccc.ccc.ccc,aaa.aaa.aaa.aaa,ddd.ddd.ddd.ddd,aaa.aaa.aaa.aaa,FromTrust,,,ssl,vsys1,Trust-L3,Untrust-L3,ethernet1/3,ethernet1/4,default,2020/10/08 07:59:53,24085,1,61322,443,29959,443,0x816400,tcp,alert,"\<query here>/",(9999),news,informational,client-to-server,7665473,0xa000000000000000,192.168.0.0-192.168.255.255,United States,0,,0,,,0,,,,,,,,0,0,0,0,0,,PA-220,,,,,0,,0,,N/A,unknown,AppThreat-0-0,0x0,0,4294967295,,"news,low-risk",4093544d-2f66-4d80-af2d-17f361609984,0,,0.0.0.0,,,,,,,,,,,,,,,,,,,,,,,,,,,0,2020-10-08T07:59:54.289+03:00,,,', 'alert_category': 'news', 'pan_parent_session_id': '0', 'host_id': 'ABCDEFGHIJK', 'network_interface_in': 'ethernet1/3', 'pan_wildfire_report_id': 0, 'pan_pcap_id': '0', 'pan_flags': '0x816400', 'pan_assoc_id': 0, 'pan_monitor_tag': 0}, 'index': 'graylog_0', 'decoration_stats': None}
\<query here>112020-10-08T10:08:57.306Z2{'index_name': 'graylog_0', 'begin': '1970-01-01T00:00:00.000Z', 'end': '1970-01-01T00:00:00.000Z', 'calculated_at': '2020-09-30T07:24:40.163Z', 'took_ms': 0}

graylog-events-search#


Events overview and search

Base Command#

graylog-events-search

Input#

Argument NameDescriptionRequired
queryQuery to useOptional
filterfilter to useOptional
pagenumber of pages as integerOptional
sort_directionAscending or DescendingOptional
per_pagehow many per page (integer)Optional
timerangeRelative timerange to search in secondsOptional
sort_byhow to sortOptional

Context Output#

PathTypeDescription
Graylog.EventsSearchStringResult of Events Search

Command Example#

!graylog-events-search query=gmail timerange=1000

Context Example#

{
"Graylog": {
"EventsSearch": {
"context": {
"event_definitions": {
"5f7436c60f4d9c360092a3ac": {
"description": "",
"id": "5f7436c60f4d9c360092a3ac",
"title": "Gmail"
}
},
"streams": {
"000000000000000000000002": {
"description": "Stream containing all events created by Graylog",
"id": "000000000000000000000002",
"title": "All events"
}
}
},
"duration": 4,
"events": [
{
"event": {
"alert": false,
"event_definition_id": "5f7436c60f4d9c360092a3ac",
"event_definition_type": "aggregation-v1",
"fields": {},
"id": "ABCD",
"key": null,
"key_tuple": [],
"message": "Gmail",
"origin_context": "urn:graylog:message:es:graylog_0:e6befc60-094d-11eb-a959-000c29d42d8e",
"priority": 1,
"source": "graylog",
"source_streams": [],
"streams": [
"000000000000000000000002"
],
"timerange_end": null,
"timerange_start": null,
"timestamp": "2020-10-08T10:06:16.169Z",
"timestamp_processing": "2020-10-08T10:07:04.269Z"
},
"index_name": "gl-events_1",
"index_type": "message"
},
{
"event": {
"alert": false,
"event_definition_id": "5f7436c60f4d9c360092a3ac",
"event_definition_type": "aggregation-v1",
"fields": {},
"id": "ABCD",
"key": null,
"key_tuple": [],
"message": "Gmail",
"origin_context": "urn:graylog:message:es:graylog_0:c265df01-094d-11eb-a959-000c29d42d8e",
"priority": 1,
"source": "graylog",
"source_streams": [],
"streams": [
"000000000000000000000002"
],
"timerange_end": null,
"timerange_start": null,
"timestamp": "2020-10-08T10:05:15.169Z",
"timestamp_processing": "2020-10-08T10:07:04.269Z"
},
"index_name": "gl-events_1",
"index_type": "message"
},
{
"event": {
"alert": false,
"event_definition_id": "5f7436c60f4d9c360092a3ac",
"event_definition_type": "aggregation-v1",
"fields": {},
"id": "ABCD",
"key": null,
"key_tuple": [],
"message": "Gmail",
"origin_context": "urn:graylog:message:es:graylog_0:9e9e0521-094d-11eb-a959-000c29d42d8e",
"priority": 1,
"source": "graylog",
"source_streams": [],
"streams": [
"000000000000000000000002"
],
"timerange_end": null,
"timerange_start": null,
"timestamp": "2020-10-08T10:04:15.169Z",
"timestamp_processing": "2020-10-08T10:07:04.269Z"
},
"index_name": "gl-events_1",
"index_type": "message"
},
{
"event": {
"alert": false,
"event_definition_id": "5f7436c60f4d9c360092a3ac",
"event_definition_type": "aggregation-v1",
"fields": {},
"id": "ABCD",
"key": null,
"key_tuple": [],
"message": "Gmail",
"origin_context": "urn:graylog:message:es:graylog_0:7ad9d4c1-094d-11eb-a959-000c29d42d8e",
"priority": 1,
"source": "graylog",
"source_streams": [],
"streams": [
"000000000000000000000002"
],
"timerange_end": null,
"timerange_start": null,
"timestamp": "2020-10-08T10:03:15.169Z",
"timestamp_processing": "2020-10-08T10:07:04.269Z"
},
"index_name": "gl-events_1",
"index_type": "message"
},
{
"event": {
"alert": false,
"event_definition_id": "5f7436c60f4d9c360092a3ac",
"event_definition_type": "aggregation-v1",
"fields": {},
"id": "ABCD",
"key": null,
"key_tuple": [],
"message": "Gmail",
"origin_context": "urn:graylog:message:es:graylog_0:571c5b22-094d-11eb-a959-000c29d42d8e",
"priority": 1,
"source": "graylog",
"source_streams": [],
"streams": [
"000000000000000000000002"
],
"timerange_end": null,
"timerange_start": null,
"timestamp": "2020-10-08T10:02:16.169Z",
"timestamp_processing": "2020-10-08T10:07:04.269Z"
},
"index_name": "gl-events_1",
"index_type": "message"
},
{
"event": {
"alert": false,
"event_definition_id": "5f7436c60f4d9c360092a3ac",
"event_definition_type": "aggregation-v1",
"fields": {},
"id": "ABCD",
"key": null,
"key_tuple": [],
"message": "Gmail",
"origin_context": "urn:graylog:message:es:graylog_0:3351e930-094d-11eb-a959-000c29d42d8e",
"priority": 1,
"source": "graylog",
"source_streams": [],
"streams": [
"000000000000000000000002"
],
"timerange_end": null,
"timerange_start": null,
"timestamp": "2020-10-08T10:01:16.169Z",
"timestamp_processing": "2020-10-08T10:02:04.510Z"
},
"index_name": "gl-events_1",
"index_type": "message"
},
{
"event": {
"alert": false,
"event_definition_id": "5f7436c60f4d9c360092a3ac",
"event_definition_type": "aggregation-v1",
"fields": {},
"id": "ABCD",
"key": null,
"key_tuple": [],
"message": "Gmail",
"origin_context": "urn:graylog:message:es:graylog_0:10cb68f1-094d-11eb-a959-000c29d42d8e",
"priority": 1,
"source": "graylog",
"source_streams": [],
"streams": [
"000000000000000000000002"
],
"timerange_end": null,
"timerange_start": null,
"timestamp": "2020-10-08T10:00:17.169Z",
"timestamp_processing": "2020-10-08T10:02:04.510Z"
},
"index_name": "gl-events_1",
"index_type": "message"
},
{
"event": {
"alert": false,
"event_definition_id": "5f7436c60f4d9c360092a3ac",
"event_definition_type": "aggregation-v1",
"fields": {},
"id": "ABCD",
"key": null,
"key_tuple": [],
"message": "Gmail",
"origin_context": "urn:graylog:message:es:graylog_0:ef65e911-094c-11eb-a959-000c29d42d8e",
"priority": 1,
"source": "graylog",
"source_streams": [],
"streams": [
"000000000000000000000002"
],
"timerange_end": null,
"timerange_start": null,
"timestamp": "2020-10-08T09:59:21.169Z",
"timestamp_processing": "2020-10-08T10:02:04.510Z"
},
"index_name": "gl-events_1",
"index_type": "message"
},
{
"event": {
"alert": false,
"event_definition_id": "5f7436c60f4d9c360092a3ac",
"event_definition_type": "aggregation-v1",
"fields": {},
"id": "ABCD",
"key": null,
"key_tuple": [],
"message": "Gmail",
"origin_context": "urn:graylog:message:es:graylog_0:c805f451-094c-11eb-a959-000c29d42d8e",
"priority": 1,
"source": "graylog",
"source_streams": [],
"streams": [
"000000000000000000000002"
],
"timerange_end": null,
"timerange_start": null,
"timestamp": "2020-10-08T09:58:15.169Z",
"timestamp_processing": "2020-10-08T10:02:04.510Z"
},
"index_name": "gl-events_1",
"index_type": "message"
},
{
"event": {
"alert": false,
"event_definition_id": "5f7436c60f4d9c360092a3ac",
"event_definition_type": "aggregation-v1",
"fields": {},
"id": "ABCD",
"key": null,
"key_tuple": [],
"message": "Gmail",
"origin_context": "urn:graylog:message:es:graylog_0:a441c3f0-094c-11eb-a959-000c29d42d8e",
"priority": 1,
"source": "graylog",
"source_streams": [],
"streams": [
"000000000000000000000002"
],
"timerange_end": null,
"timerange_start": null,
"timestamp": "2020-10-08T09:57:15.169Z",
"timestamp_processing": "2020-10-08T10:02:04.510Z"
},
"index_name": "gl-events_1",
"index_type": "message"
}
],
"parameters": {
"filter": {
"alerts": "include",
"event_definitions": []
},
"page": 1,
"per_page": 10,
"query": "gmail",
"sort_by": "timestamp",
"sort_direction": "desc",
"timerange": {
"range": 1000,
"type": "relative"
}
},
"total_events": 14,
"used_indices": [
"gl-events_1",
"gl-system-events_1"
]
}
}
}

Human Readable Output#

Results#

contextdurationeventsparameterstotal_eventsused_indices
event_definitions: {"5f7436c60f4d9c360092a3ac": {"id": "5f7436c60f4d9c360092a3ac", "title": "Gmail", "description": ""}}
streams: {"000000000000000000000002": {"id": "000000000000000000000002", "title": "All events", "description": "Stream containing all events created by Graylog"}}
4{'event': {'id': 'ABCD', 'event_definition_type': 'aggregation-v1', 'event_definition_id': '5f7436c60f4d9c360092a3ac', 'origin_context': 'urn:graylog:message🇪🇸graylog_0:e6befc60-094d-11eb-a959-000c29d42d8e', 'timestamp': '2020-10-08T10:06:16.169Z', 'timestamp_processing': '2020-10-08T10:07:04.269Z', 'timerange_start': None, 'timerange_end': None, 'streams': ['000000000000000000000002'], 'source_streams': [], 'message': 'Gmail', 'source': 'graylog', 'key_tuple': [], 'key': None, 'priority': 1, 'alert': False, 'fields': {}}, 'index_name': 'gl-events_1', 'index_type': 'message'},
{'event': {'id': 'ABCD', 'event_definition_type': 'aggregation-v1', 'event_definition_id': '5f7436c60f4d9c360092a3ac', 'origin_context': 'urn:graylog:message🇪🇸graylog_0:c265df01-094d-11eb-a959-000c29d42d8e', 'timestamp': '2020-10-08T10:05:15.169Z', 'timestamp_processing': '2020-10-08T10:07:04.269Z', 'timerange_start': None, 'timerange_end': None, 'streams': ['000000000000000000000002'], 'source_streams': [], 'message': 'Gmail', 'source': 'graylog', 'key_tuple': [], 'key': None, 'priority': 1, 'alert': False, 'fields': {}}, 'index_name': 'gl-events_1', 'index_type': 'message'},
{'event': {'id': 'ABCD', 'event_definition_type': 'aggregation-v1', 'event_definition_id': '5f7436c60f4d9c360092a3ac', 'origin_context': 'urn:graylog:message🇪🇸graylog_0:9e9e0521-094d-11eb-a959-000c29d42d8e', 'timestamp': '2020-10-08T10:04:15.169Z', 'timestamp_processing': '2020-10-08T10:07:04.269Z', 'timerange_start': None, 'timerange_end': None, 'streams': ['000000000000000000000002'], 'source_streams': [], 'message': 'Gmail', 'source': 'graylog', 'key_tuple': [], 'key': None, 'priority': 1, 'alert': False, 'fields': {}}, 'index_name': 'gl-events_1', 'index_type': 'message'},
{'event': {'id': 'ABCD', 'event_definition_type': 'aggregation-v1', 'event_definition_id': '5f7436c60f4d9c360092a3ac', 'origin_context': 'urn:graylog:message🇪🇸graylog_0:7ad9d4c1-094d-11eb-a959-000c29d42d8e', 'timestamp': '2020-10-08T10:03:15.169Z', 'timestamp_processing': '2020-10-08T10:07:04.269Z', 'timerange_start': None, 'timerange_end': None, 'streams': ['000000000000000000000002'], 'source_streams': [], 'message': 'Gmail', 'source': 'graylog', 'key_tuple': [], 'key': None, 'priority': 1, 'alert': False, 'fields': {}}, 'index_name': 'gl-events_1', 'index_type': 'message'},
{'event': {'id': 'ABCD', 'event_definition_type': 'aggregation-v1', 'event_definition_id': '5f7436c60f4d9c360092a3ac', 'origin_context': 'urn:graylog:message🇪🇸graylog_0:571c5b22-094d-11eb-a959-000c29d42d8e', 'timestamp': '2020-10-08T10:02:16.169Z', 'timestamp_processing': '2020-10-08T10:07:04.269Z', 'timerange_start': None, 'timerange_end': None, 'streams': ['000000000000000000000002'], 'source_streams': [], 'message': 'Gmail', 'source': 'graylog', 'key_tuple': [], 'key': None, 'priority': 1, 'alert': False, 'fields': {}}, 'index_name': 'gl-events_1', 'index_type': 'message'},
{'event': {'id': 'ABCD', 'event_definition_type': 'aggregation-v1', 'event_definition_id': '5f7436c60f4d9c360092a3ac', 'origin_context': 'urn:graylog:message🇪🇸graylog_0:3351e930-094d-11eb-a959-000c29d42d8e', 'timestamp': '2020-10-08T10:01:16.169Z', 'timestamp_processing': '2020-10-08T10:02:04.510Z', 'timerange_start': None, 'timerange_end': None, 'streams': ['000000000000000000000002'], 'source_streams': [], 'message': 'Gmail', 'source': 'graylog', 'key_tuple': [], 'key': None, 'priority': 1, 'alert': False, 'fields': {}}, 'index_name': 'gl-events_1', 'index_type': 'message'},
{'event': {'id': 'ABCD', 'event_definition_type': 'aggregation-v1', 'event_definition_id': '5f7436c60f4d9c360092a3ac', 'origin_context': 'urn:graylog:message🇪🇸graylog_0:10cb68f1-094d-11eb-a959-000c29d42d8e', 'timestamp': '2020-10-08T10:00:17.169Z', 'timestamp_processing': '2020-10-08T10:02:04.510Z', 'timerange_start': None, 'timerange_end': None, 'streams': ['000000000000000000000002'], 'source_streams': [], 'message': 'Gmail', 'source': 'graylog', 'key_tuple': [], 'key': None, 'priority': 1, 'alert': False, 'fields': {}}, 'index_name': 'gl-events_1', 'index_type': 'message'},
{'event': {'id': 'ABCD', 'event_definition_type': 'aggregation-v1', 'event_definition_id': '5f7436c60f4d9c360092a3ac', 'origin_context': 'urn:graylog:message🇪🇸graylog_0:ef65e911-094c-11eb-a959-000c29d42d8e', 'timestamp': '2020-10-08T09:59:21.169Z', 'timestamp_processing': '2020-10-08T10:02:04.510Z', 'timerange_start': None, 'timerange_end': None, 'streams': ['000000000000000000000002'], 'source_streams': [], 'message': 'Gmail', 'source': 'graylog', 'key_tuple': [], 'key': None, 'priority': 1, 'alert': False, 'fields': {}}, 'index_name': 'gl-events_1', 'index_type': 'message'},
{'event': {'id': 'ABCD', 'event_definition_type': 'aggregation-v1', 'event_definition_id': '5f7436c60f4d9c360092a3ac', 'origin_context': 'urn:graylog:message🇪🇸graylog_0:c805f451-094c-11eb-a959-000c29d42d8e', 'timestamp': '2020-10-08T09:58:15.169Z', 'timestamp_processing': '2020-10-08T10:02:04.510Z', 'timerange_start': None, 'timerange_end': None, 'streams': ['000000000000000000000002'], 'source_streams': [], 'message': 'Gmail', 'source': 'graylog', 'key_tuple': [], 'key': None, 'priority': 1, 'alert': False, 'fields': {}}, 'index_name': 'gl-events_1', 'index_type': 'message'},
{'event': {'id': 'ABCD', 'event_definition_type': 'aggregation-v1', 'event_definition_id': '5f7436c60f4d9c360092a3ac', 'origin_context': 'urn:graylog:message🇪🇸graylog_0:a441c3f0-094c-11eb-a959-000c29d42d8e', 'timestamp': '2020-10-08T09:57:15.169Z', 'timestamp_processing': '2020-10-08T10:02:04.510Z', 'timerange_start': None, 'timerange_end': None, 'streams': ['000000000000000000000002'], 'source_streams': [], 'message': 'Gmail', 'source': 'graylog', 'key_tuple': [], 'key': None, 'priority': 1, 'alert': False, 'fields': {}}, 'index_name': 'gl-events_1', 'index_type': 'message'}
page: 1
per_page: 10
timerange: {"type": "relative", "range": 1000}
query: gmail
filter: {"alerts": "include", "event_definitions": []}
sort_by: timestamp
sort_direction: desc
14gl-events_1,
gl-system-events_1

graylog-search-absolute#


Search with absolute times

Base Command#

graylog-search-absolute

Input#

Argument NameDescriptionRequired
queryQuery in lucene syntaxRequired
fromSearch for messages using an absolute timerange, specified as from/to with format yyyy-MM-ddTHH:mm:ss.SSSZ (e.g. 2014-01-23T15:34:49.000Z) or yyyy-MM-dd HH:mm:ss.Required
toSearch for messages using an absolute timerange, specified as from/to with format yyyy-MM-ddTHH:mm:ss.SSSZ (e.g. 2014-01-23T15:34:49.000Z) or yyyy-MM-dd HH:mm:ss.Required
limitMaximum number of messages to return.Optional
offsetOffsetOptional
filterFilterOptional
fieldsComma separated list of fields to returnOptional
sortSorting (field:asc / field:desc)Optional
decorateRun decorators on search resultOptional

Context Output#

PathTypeDescription
Graylog.SearchAbsoluteStringSearch results of Absolute search

Command Example#

!graylog-search-absolute query="\<query here\>" from=<timefrom> to=<timeto>

Context Example#

{
"Graylog": {
"SearchAbsolute": {
"built_query": "{\n \"from\" : 0,\n \"size\" : 20,\n \"query\" : {\n \"bool\" : {\n \"must\" : [\n {\n \"query_string\" : {\n \"query\" : \"\<query here\>\",\n \"fields\" : [ ],\n \"use_dis_max\" : true,\n \"tie_breaker\" : 0.0,\n \"default_operator\" : \"or\",\n \"auto_generate_phrase_queries\" : false,\n \"max_determinized_states\" : 10000,\n \"allow_leading_wildcard\" : false,\n \"enable_position_increments\" : true,\n \"fuzziness\" : \"AUTO\",\n \"fuzzy_prefix_length\" : 0,\n \"fuzzy_max_expansions\" : 50,\n \"phrase_slop\" : 0,\n \"escape\" : false,\n \"split_on_whitespace\" : true,\n \"boost\" : 1.0\n }\n }\n ],\n \"filter\" : [\n {\n \"bool\" : {\n \"must\" : [\n {\n \"range\" : {\n \"timestamp\" : {\n \"from\" : \"2020-10-04 15:34:49.000\",\n \"to\" : \"2020-10-08 15:34:49.000\",\n \"include_lower\" : true,\n \"include_upper\" : true,\n \"boost\" : 1.0\n }\n }\n }\n ],\n \"disable_coord\" : false,\n \"adjust_pure_negative\" : true,\n \"boost\" : 1.0\n }\n }\n ],\n \"disable_coord\" : false,\n \"adjust_pure_negative\" : true,\n \"boost\" : 1.0\n }\n },\n \"sort\" : [\n {\n \"timestamp\" : {\n \"order\" : \"desc\"\n }\n }\n ]\n}",
"decoration_stats": null,
"fields": [
"event_received_time",
"pan_log_subtype",
"pan_dev_group_level_4",
"pan_dev_group_level_3",
"network_interface_out",
"source",
"pan_url_index",
"vendor_event_action",
"pan_dev_group_level_2",
"pan_dev_group_level_1",
"source_ip",
"host_virtfw_id",
"application_name",
"destination_ip",
"pan_ppid",
"alert_indicator",
"host_hostname",
"source_location_name",
"alert_signature_id",
"rule_name",
"source_zone",
"gl2_message_id",
"network_protocol",
"network_tunnel_type",
"alert_definitions_version",
"destination_nat_ip",
"pan_log_action",
"pan_http2",
"source_nat_ip",
"destination_nat_port",
"http_url_category",
"policy_uid",
"destination_port",
"pan_log_panorama",
"pan_tunnel_id",
"pan_alert_direction",
"vendor_alert_severity",
"event_uid",
"destination_location_name",
"source_port",
"event_log_name",
"event_repeat_count",
"timestamp",
"event_source_product",
"source_nat_port",
"destination_zone",
"session_id",
"message",
"alert_category",
"pan_parent_session_id",
"host_id",
"network_interface_in",
"pan_wildfire_report_id",
"pan_pcap_id",
"pan_flags",
"pan_assoc_id",
"pan_monitor_tag"
],
"from": "2020-10-04T15:34:49.000Z",
"messages": [
{
"decoration_stats": null,
"highlight_ranges": {},
"index": "graylog_0",
"message": {
"_id": "1acb0472-0923-11eb-a959-000c29d42d8e",
"alert_category": "news",
"alert_definitions_version": "AppThreat-0-0",
"alert_indicator": "\<query here\>/",
"alert_signature_id": "(9999)",
"application_name": "ssl",
"destination_ip": "aaa.aaa.aaa.aaa",
"destination_location_name": "United States",
"destination_nat_ip": "aaa.aaa.aaa.aaa",
"destination_nat_port": 443,
"destination_port": 443,
"destination_zone": "Untrust-L3",
"event_log_name": "THREAT",
"event_received_time": "2020/10/08 07:59:53",
"event_repeat_count": 1,
"event_source_product": "PAN",
"event_uid": "7665475",
"gl2_accounted_message_size": 2027,
"gl2_message_id": "ABCD",
"gl2_remote_ip": "bbb.bbb.bbb.bbb",
"gl2_remote_port": 51371,
"gl2_source_input": "5f7433f60f4d9c360092a070",
"gl2_source_node": "95ba5102-13c9-4520-ac75-c8736f206953",
"host_hostname": "PA-220",
"host_id": "ABCDEFGHIJK",
"host_virtfw_id": "vsys1",
"http_url_category": "news,low-risk",
"message": "1,2020/10/08 07:59:53,ABCDEFGHIJK,THREAT,url,2560,2020/10/08 07:59:53,ccc.ccc.ccc.ccc,aaa.aaa.aaa.aaa,ddd.ddd.ddd.ddd,aaa.aaa.aaa.aaa,FromTrust,,,ssl,vsys1,Trust-L3,Untrust-L3,ethernet1/3,ethernet1/4,default,2020/10/08 07:59:53,23366,1,61323,443,48189,443,0x816400,tcp,alert,\"\<query here\>/\",(9999),news,informational,client-to-server,7665475,0xa000000000000000,192.168.0.0-192.168.255.255,United States,0,,0,,,0,,,,,,,,0,0,0,0,0,,PA-220,,,,,0,,0,,N/A,unknown,AppThreat-0-0,0x0,0,4294967295,,\"news,low-risk\",4093544d-2f66-4d80-af2d-17f361609984,0,,0.0.0.0,,,,,,,,,,,,,,,,,,,,,,,,,,,0,2020-10-08T07:59:54.289+03:00,,,",
"network_interface_in": "ethernet1/3",
"network_interface_out": "ethernet1/4",
"network_protocol": "tcp",
"network_tunnel_type": "N/A",
"pan_alert_direction": "client-to-server",
"pan_assoc_id": 0,
"pan_dev_group_level_1": 0,
"pan_dev_group_level_2": 0,
"pan_dev_group_level_3": 0,
"pan_dev_group_level_4": 0,
"pan_flags": "0x816400",
"pan_http2": "0",
"pan_log_action": "default",
"pan_log_panorama": "0xa000000000000000",
"pan_log_subtype": "url",
"pan_monitor_tag": 0,
"pan_parent_session_id": "0",
"pan_pcap_id": "0",
"pan_ppid": 4294967295,
"pan_tunnel_id": "0",
"pan_url_index": 0,
"pan_wildfire_report_id": 0,
"policy_uid": "4093544d-2f66-4d80-af2d-17f361609984",
"rule_name": "FromTrust",
"session_id": 23366,
"source": "PA-220",
"source_ip": "ccc.ccc.ccc.ccc",
"source_location_name": "192.168.0.0-192.168.255.255",
"source_nat_ip": "ddd.ddd.ddd.ddd",
"source_nat_port": 48189,
"source_port": 61323,
"source_zone": "Trust-L3",
"streams": [
"000000000000000000000001"
],
"timestamp": "2020-10-08T04:59:55.169Z",
"vendor_alert_severity": "informational",
"vendor_event_action": "alert"
}
},
{
"decoration_stats": null,
"highlight_ranges": {},
"index": "graylog_0",
"message": {
"_id": "1acb0470-0923-11eb-a959-000c29d42d8e",
"alert_category": "news",
"alert_definitions_version": "AppThreat-0-0",
"alert_indicator": "\<query here\>/",
"alert_signature_id": "(9999)",
"application_name": "ssl",
"destination_ip": "aaa.aaa.aaa.aaa",
"destination_location_name": "United States",
"destination_nat_ip": "aaa.aaa.aaa.aaa",
"destination_nat_port": 443,
"destination_port": 443,
"destination_zone": "Untrust-L3",
"event_log_name": "THREAT",
"event_received_time": "2020/10/08 07:59:53",
"event_repeat_count": 1,
"event_source_product": "PAN",
"event_uid": "7665473",
"gl2_accounted_message_size": 2027,
"gl2_message_id": "ABCD",
"gl2_remote_ip": "bbb.bbb.bbb.bbb",
"gl2_remote_port": 51371,
"gl2_source_input": "5f7433f60f4d9c360092a070",
"gl2_source_node": "95ba5102-13c9-4520-ac75-c8736f206953",
"host_hostname": "PA-220",
"host_id": "ABCDEFGHIJK",
"host_virtfw_id": "vsys1",
"http_url_category": "news,low-risk",
"message": "1,2020/10/08 07:59:53,ABCDEFGHIJK,THREAT,url,2560,2020/10/08 07:59:53,ccc.ccc.ccc.ccc,aaa.aaa.aaa.aaa,ddd.ddd.ddd.ddd,aaa.aaa.aaa.aaa,FromTrust,,,ssl,vsys1,Trust-L3,Untrust-L3,ethernet1/3,ethernet1/4,default,2020/10/08 07:59:53,24085,1,61322,443,29959,443,0x816400,tcp,alert,\"\<query here\>/\",(9999),news,informational,client-to-server,7665473,0xa000000000000000,192.168.0.0-192.168.255.255,United States,0,,0,,,0,,,,,,,,0,0,0,0,0,,PA-220,,,,,0,,0,,N/A,unknown,AppThreat-0-0,0x0,0,4294967295,,\"news,low-risk\",4093544d-2f66-4d80-af2d-17f361609984,0,,0.0.0.0,,,,,,,,,,,,,,,,,,,,,,,,,,,0,2020-10-08T07:59:54.289+03:00,,,",
"network_interface_in": "ethernet1/3",
"network_interface_out": "ethernet1/4",
"network_protocol": "tcp",
"network_tunnel_type": "N/A",
"pan_alert_direction": "client-to-server",
"pan_assoc_id": 0,
"pan_dev_group_level_1": 0,
"pan_dev_group_level_2": 0,
"pan_dev_group_level_3": 0,
"pan_dev_group_level_4": 0,
"pan_flags": "0x816400",
"pan_http2": "0",
"pan_log_action": "default",
"pan_log_panorama": "0xa000000000000000",
"pan_log_subtype": "url",
"pan_monitor_tag": 0,
"pan_parent_session_id": "0",
"pan_pcap_id": "0",
"pan_ppid": 4294967295,
"pan_tunnel_id": "0",
"pan_url_index": 0,
"pan_wildfire_report_id": 0,
"policy_uid": "4093544d-2f66-4d80-af2d-17f361609984",
"rule_name": "FromTrust",
"session_id": 24085,
"source": "PA-220",
"source_ip": "ccc.ccc.ccc.ccc",
"source_location_name": "192.168.0.0-192.168.255.255",
"source_nat_ip": "ddd.ddd.ddd.ddd",
"source_nat_port": 29959,
"source_port": 61322,
"source_zone": "Trust-L3",
"streams": [
"000000000000000000000001"
],
"timestamp": "2020-10-08T04:59:55.169Z",
"vendor_alert_severity": "informational",
"vendor_event_action": "alert"
}
},
],
"query": "\<query here\>",
"time": 2,
"to": "2020-10-08T15:34:49.000Z",
"total_results": 2,
"used_indices": [
{
"begin": "1970-01-01T00:00:00.000Z",
"calculated_at": "2020-09-30T07:24:40.163Z",
"end": "1970-01-01T00:00:00.000Z",
"index_name": "graylog_0",
"took_ms": 0
}
]
}
}
}

Human Readable Output#

Results#

built_querydecoration_statsfieldsfrommessagesquerytimetototal_resultsused_indices
{
"from" : 0,
"size" : 20,
"query" : {
"bool" : {
"must" : [
{
"query_string" : {
"query" : "\<query here>",
"fields" : [ ],
"use_dis_max" : true,
"tie_breaker" : 0.0,
"default_operator" : "or",
"auto_generate_phrase_queries" : false,
"max_determinized_states" : 10000,
"allow_leading_wildcard" : false,
"enable_position_increments" : true,
"fuzziness" : "AUTO",
"fuzzy_prefix_length" : 0,
"fuzzy_max_expansions" : 50,
"phrase_slop" : 0,
"escape" : false,
"split_on_whitespace" : true,
"boost" : 1.0
}
}
],
"filter" : [
{
"bool" : {
"must" : [
{
"range" : {
"timestamp" : {
"from" : "2020-10-04 15:34:49.000",
"to" : "2020-10-08 15:34:49.000",
"include_lower" : true,
"include_upper" : true,
"boost" : 1.0
}
}
}
],
"disable_coord" : false,
"adjust_pure_negative" : true,
"boost" : 1.0
}
}
],
"disable_coord" : false,
"adjust_pure_negative" : true,
"boost" : 1.0
}
},
"sort" : [
{
"timestamp" : {
"order" : "desc"
}
}
]
}
event_received_time,
pan_log_subtype,
pan_dev_group_level_4,
pan_dev_group_level_3,
network_interface_out,
source,
pan_url_index,
vendor_event_action,
pan_dev_group_level_2,
pan_dev_group_level_1,
source_ip,
host_virtfw_id,
application_name,
destination_ip,
pan_ppid,
alert_indicator,
host_hostname,
source_location_name,
alert_signature_id,
rule_name,
source_zone,
gl2_message_id,
network_protocol,
network_tunnel_type,
alert_definitions_version,
destination_nat_ip,
pan_log_action,
pan_http2,
source_nat_ip,
destination_nat_port,
http_url_category,
policy_uid,
destination_port,
pan_log_panorama,
pan_tunnel_id,
pan_alert_direction,
vendor_alert_severity,
event_uid,
destination_location_name,
source_port,
event_log_name,
event_repeat_count,
timestamp,
event_source_product,
source_nat_port,
destination_zone,
session_id,
message,
alert_category,
pan_parent_session_id,
host_id,
network_interface_in,
pan_wildfire_report_id,
pan_pcap_id,
pan_flags,
pan_assoc_id,
pan_monitor_tag
2020-10-04T15:34:49.000Z{'highlight_ranges': {}, 'message': {'event_received_time': '2020/10/08 07:59:53', 'pan_log_subtype': 'url', 'gl2_remote_ip': 'bbb.bbb.bbb.bbb', 'gl2_remote_port': 51371, 'pan_dev_group_level_4': 0, 'pan_dev_group_level_3': 0, 'network_interface_out': 'ethernet1/4', 'source': 'PA-220', 'gl2_source_input': '5f7433f60f4d9c360092a070', 'pan_url_index': 0, 'vendor_event_action': 'alert', 'pan_dev_group_level_2': 0, 'pan_dev_group_level_1': 0, 'source_ip': 'ccc.ccc.ccc.ccc', 'host_virtfw_id': 'vsys1', 'application_name': 'ssl', 'destination_ip': 'aaa.aaa.aaa.aaa', 'pan_ppid': 4294967295, 'gl2_source_node': '95ba5102-13c9-4520-ac75-c8736f206953', 'alert_indicator': '\<query here>/', 'host_hostname': 'PA-220', 'source_location_name': '192.168.0.0-192.168.255.255', 'gl2_accounted_message_size': 2027, 'alert_signature_id': '(9999)', 'rule_name': 'FromTrust', 'source_zone': 'Trust-L3', 'streams': ['000000000000000000000001'], 'gl2_message_id': 'ABCD', 'network_protocol': 'tcp', 'network_tunnel_type': 'N/A', 'alert_definitions_version': 'AppThreat-0-0', 'destination_nat_ip': 'aaa.aaa.aaa.aaa', 'pan_log_action': 'default', 'pan_http2': '0', 'source_nat_ip': 'ddd.ddd.ddd.ddd', '_id': '1acb0472-0923-11eb-a959-000c29d42d8e', 'destination_nat_port': 443, 'http_url_category': 'news,low-risk', 'policy_uid': '4093544d-2f66-4d80-af2d-17f361609984', 'destination_port': 443, 'pan_log_panorama': '0xa000000000000000', 'pan_tunnel_id': '0', 'pan_alert_direction': 'client-to-server', 'vendor_alert_severity': 'informational', 'event_uid': '7665475', 'destination_location_name': 'United States', 'source_port': 61323, 'event_log_name': 'THREAT', 'event_repeat_count': 1, 'timestamp': '2020-10-08T04:59:55.169Z', 'event_source_product': 'PAN', 'source_nat_port': 48189, 'destination_zone': 'Untrust-L3', 'session_id': 23366, 'message': '1,2020/10/08 07:59:53,ABCDEFGHIJK,THREAT,url,2560,2020/10/08 07:59:53,ccc.ccc.ccc.ccc,aaa.aaa.aaa.aaa,ddd.ddd.ddd.ddd,aaa.aaa.aaa.aaa,FromTrust,,,ssl,vsys1,Trust-L3,Untrust-L3,ethernet1/3,ethernet1/4,default,2020/10/08 07:59:53,23366,1,61323,443,48189,443,0x816400,tcp,alert,"\<query here>/",(9999),news,informational,client-to-server,7665475,0xa000000000000000,192.168.0.0-192.168.255.255,United States,0,,0,,,0,,,,,,,,0,0,0,0,0,,PA-220,,,,,0,,0,,N/A,unknown,AppThreat-0-0,0x0,0,4294967295,,"news,low-risk",4093544d-2f66-4d80-af2d-17f361609984,0,,0.0.0.0,,,,,,,,,,,,,,,,,,,,,,,,,,,0,2020-10-08T07:59:54.289+03:00,,,', 'alert_category': 'news', 'pan_parent_session_id': '0', 'host_id': 'ABCDEFGHIJK', 'network_interface_in': 'ethernet1/3', 'pan_wildfire_report_id': 0, 'pan_pcap_id': '0', 'pan_flags': '0x816400', 'pan_assoc_id': 0, 'pan_monitor_tag': 0}, 'index': 'graylog_0', 'decoration_stats': None},
{'highlight_ranges': {}, 'message': {'event_received_time': '2020/10/08 07:59:53', 'pan_log_subtype': 'url', 'gl2_remote_ip': 'bbb.bbb.bbb.bbb', 'gl2_remote_port': 51371, 'pan_dev_group_level_4': 0, 'pan_dev_group_level_3': 0, 'network_interface_out': 'ethernet1/4', 'source': 'PA-220', 'gl2_source_input': '5f7433f60f4d9c360092a070', 'pan_url_index': 0, 'vendor_event_action': 'alert', 'pan_dev_group_level_2': 0, 'pan_dev_group_level_1': 0, 'source_ip': 'ccc.ccc.ccc.ccc', 'host_virtfw_id': 'vsys1', 'application_name': 'ssl', 'destination_ip': 'aaa.aaa.aaa.aaa', 'pan_ppid': 4294967295, 'gl2_source_node': '95ba5102-13c9-4520-ac75-c8736f206953', 'alert_indicator': '\<query here>/', 'host_hostname': 'PA-220', 'source_location_name': '192.168.0.0-192.168.255.255', 'gl2_accounted_message_size': 2027, 'alert_signature_id': '(9999)', 'rule_name': 'FromTrust', 'source_zone': 'Trust-L3', 'streams': ['000000000000000000000001'], 'gl2_message_id': 'ABCD', 'network_protocol': 'tcp', 'network_tunnel_type': 'N/A', 'alert_definitions_version': 'AppThreat-0-0', 'destination_nat_ip': 'aaa.aaa.aaa.aaa', 'pan_log_action': 'default', 'pan_http2': '0', 'source_nat_ip': 'ddd.ddd.ddd.ddd', '_id': '1acb0470-0923-11eb-a959-000c29d42d8e', 'destination_nat_port': 443, 'http_url_category': 'news,low-risk', 'policy_uid': '4093544d-2f66-4d80-af2d-17f361609984', 'destination_port': 443, 'pan_log_panorama': '0xa000000000000000', 'pan_tunnel_id': '0', 'pan_alert_direction': 'client-to-server', 'vendor_alert_severity': 'informational', 'event_uid': '7665473', 'destination_location_name': 'United States', 'source_port': 61322, 'event_log_name': 'THREAT', 'event_repeat_count': 1, 'timestamp': '2020-10-08T04:59:55.169Z', 'event_source_product': 'PAN', 'source_nat_port': 29959, 'destination_zone': 'Untrust-L3', 'session_id': 24085, 'message': '1,2020/10/08 07:59:53,ABCDEFGHIJK,THREAT,url,2560,2020/10/08 07:59:53,ccc.ccc.ccc.ccc,aaa.aaa.aaa.aaa,ddd.ddd.ddd.ddd,aaa.aaa.aaa.aaa,FromTrust,,,ssl,vsys1,Trust-L3,Untrust-L3,ethernet1/3,ethernet1/4,default,2020/10/08 07:59:53,24085,1,61322,443,29959,443,0x816400,tcp,alert,"\<query here>/",(9999),news,informational,client-to-server,7665473,0xa000000000000000,192.168.0.0-192.168.255.255,United States,0,,0,,,0,,,,,,,,0,0,0,0,0,,PA-220,,,,,0,,0,,N/A,unknown,AppThreat-0-0,0x0,0,4294967295,,"news,low-risk",4093544d-2f66-4d80-af2d-17f361609984,0,,0.0.0.0,,,,,,,,,,,,,,,,,,,,,,,,,,,0,2020-10-08T07:59:54.289+03:00,,,', 'alert_category': 'news', 'pan_parent_session_id': '0', 'host_id': 'ABCDEFGHIJK', 'network_interface_in': 'ethernet1/3', 'pan_wildfire_report_id': 0, 'pan_pcap_id': '0', 'pan_flags': '0x816400', 'pan_assoc_id': 0, 'pan_monitor_tag': 0}, 'index': 'graylog_0', 'decoration_stats': None}
\<query here>22020-10-08T15:34:49.000Z2{'index_name': 'graylog_0', 'begin': '1970-01-01T00:00:00.000Z', 'end': '1970-01-01T00:00:00.000Z', 'calculated_at': '2020-09-30T07:24:40.163Z', 'took_ms': 0}