Forum Discussion
Porter76
Aug 29, 2023Brass Contributor
How do I create a custom data table and is it necessary in this scenario?
Recently came across some documentation to push logs in an AWS S3 bucket to Sentinel using a lambda function via the log analytics API. Looking at the documentation it looks like I would have to setu...
Clive_Watson
Aug 29, 2023Bronze Contributor
Its the CustomLog value (see link) - its will append _CL to this for you. e.g. if you want the table to be called: test_CL use 'test' as the value.
https://github.com/Azure/Azure-Sentinel/tree/master/DataConnectors/S3-Lambda#edit-the-script
https://github.com/Azure/Azure-Sentinel/tree/master/DataConnectors/S3-Lambda#edit-the-script
Porter76
Aug 29, 2023Brass Contributor
Hey Clive,
So when this script is run, it will create the table? I see now in the github doc where it asks for the Workspace info and a custom log name.
I'm just a little confused on where this data goes, where its stored, and if there's anything more I need to do than simply run this script to get these logs into sentinel.
So when this script is run, it will create the table? I see now in the github doc where it asks for the Workspace info and a custom log name.
I'm just a little confused on where this data goes, where its stored, and if there's anything more I need to do than simply run this script to get these logs into sentinel.
- Clive_WatsonAug 29, 2023Bronze ContributorCorrect run the script to create the Table. The data is stored in Log Analytics just like non custom log data (Sentinel will store this for 90days - assuming you have set the workspace to 90days or more).
- Porter76Aug 29, 2023Brass ContributorIs it possible I can view this data in Log analytics before its stored in the custom data table the script will create?
- Clive_WatsonAug 29, 2023Bronze Contributor
you need to ingest the data into the Custom table to be able to query it. The custom table is where it's stored in log analytics.
You can check the schema before ingestion.
https://learn.microsoft.com/en-us/azure/sentinel/data-source-schema-reference