Python script to run sumologic search job api queries
sumologic_environment:
api_base_url: https://api.us2.sumologic.com/api
api_access_id: TBD
api_access_key: TBD
sumologic_search:
type: records # records (aggregated results) or messages
query: |
_sourceCategory=*
| count as Total by _collector, _source, _sourceCategory
| order by Total
| Limit 20
from: -24h # exact date like "2024-05-03T16:31:50", or relative ones using -15m, -2h, -5d, -2w
to: now # exact date like "2024-05-03T16:31:50", or relative ones using -15m, -2h, -5d, -2w, or the string "now"
timeZone: UTC # UTC, America/New_York, America/Los_Angeles, etc
byReceiptTime: false # true or false
autoParsingMode: Manual # Manual or AutoParse
processing:
debug: false # true/false
timeout: 120 # in seconds before killing query
batch: 1000 # 1 to 10,000 batch records to download
output_type: csv # screen, csv
#screen_max_cell_width: 60 # xx
output_destination: output.csv # test.csv
python3 ./sumologic-search-api.py -c config/config_slps_1.yaml
![image](https://private-user-images.githubusercontent.com/1272790/328640990-3fabc61a-a784-42b8-bf39-7cf7101318a5.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MTkwMTk0MTcsIm5iZiI6MTcxOTAxOTExNywicGF0aCI6Ii8xMjcyNzkwLzMyODY0MDk5MC0zZmFiYzYxYS1hNzg0LTQyYjgtYmYzOS03Y2Y3MTAxMzE4YTUucG5nP1gtQW16LUFsZ29yaXRobT1BV1M0LUhNQUMtU0hBMjU2JlgtQW16LUNyZWRlbnRpYWw9QUtJQVZDT0RZTFNBNTNQUUs0WkElMkYyMDI0MDYyMiUyRnVzLWVhc3QtMSUyRnMzJTJGYXdzNF9yZXF1ZXN0JlgtQW16LURhdGU9MjAyNDA2MjJUMDExODM3WiZYLUFtei1FeHBpcmVzPTMwMCZYLUFtei1TaWduYXR1cmU9NWUwNmRmMGUwZjg2YjgyZjNjNTViNmI3ZjNlY2QyZGJkODVlMWNjNDc1OTc5ZjQ4Njc4NWFmYTdmODk4YWIzOSZYLUFtei1TaWduZWRIZWFkZXJzPWhvc3QmYWN0b3JfaWQ9MCZrZXlfaWQ9MCZyZXBvX2lkPTAifQ.GAUhVhvmsE0zxQlyDnbIK0IrG5OYvS613Zw5RwaXrSM)