How to do Timestamp extraction from hec?

dinesh_bendigo — Fri, 22 Sep 2023 18:16:39 GMT

hi Splunk Gurus

Looking for some help please

I am trying to extract timestamp from json sent via hec token.

I have my inputs.conf and props.conf in same app and are deployed on heavy forwarders.

My props:

[hec:azure:nonprod:json] MAX_TIMESTAMP_LOOKAHEAD = 512 TIME_PREFIX = createdDateTime\"\:\s+\" TIME_FORMAT = %Y-%m-%dT%H:%M:%S%Z TZ = UTC

Sample event:

{"@odata.type": "#microsoft.graph.group", "id": "XXXXXXXXXXXXX", "deletedDateTime": null, "classification": null, "createdDateTime": "2022-06-03T02:05:02Z", "creationOptions": [], "description": null, "displayName": "global_admin", "expirationDateTime": null, "groupTypes": [], "isAssignableToRole": true, "mail": null, "mailEnabled": false, "mailNickname": "XXXX", "membershipRule": null, "membershipRuleProcessingState": null, "onPremisesDomainName": null, "onPremisesLastSyncDateTime": null, "onPremisesNetBiosName": null, "onPremisesSamAccountName": null, "onPremisesSecurityIdentifier": null, "onPremisesSyncEnabled": null, "preferredDataLocation": null, "preferredLanguage": null, "proxyAddresses": [], "renewedDateTime": "2022-06-03T02:05:02Z", "resourceBehaviorOptions": [], "resourceProvisioningOptions": [], "securityEnabled": true, "securityIdentifier": "XXXXXXXXXXXXX", "theme": null, "visibility": "Private", "onPremisesProvisioningErrors": [], "serviceProvisioningErrors": [], "graphendpointtype": "directoryroles"}

Wanted to extract timestamp from createdDateTime field.

I tried TIMESTAMP_FIELDS = createdDateTime,

and

INGEST_EVAL=_time=strptime(spath(_raw,"createdDateTime"), "%Y-%m-%dT%H:%M:%S%Z")

as per previous answers.splunk posts but nothing worked, splunk still picks up index time only.

What am I doing wrong here?

Re: Timestamp extraction from hec

dvg06 — Fri, 22 Sep 2023 05:10:51 GMT

If you are using /services/collector/event end point to send events, try changing it to /services/collector/raw.

Test using below commands

curl -vvvv -k https://hecendpoint:8088/services/collector/raw -H "Authorization: Splunk XXXXXXXXXXXX" -d '{"id": "raw-message", "createdDateTime": "2023-09-23T11:11:11Z"}'

curl -vvvv -k https://splunkviphec.bbl.int:8088/services/collector/event -H "Authorization: Splunk XXXXXXXXXXXXXXX" -d '{"event":{"id": "event-message", "createdDateTime": "2023-09-23T11:11:11Z"}}'

topic Re: Timestamp extraction from hec in Getting Data In

How to do Timestamp extraction from hec?

Re: Timestamp extraction from hec