Skip to content

Instantly share code, notes, and snippets.

@avdhoot
Last active April 8, 2022 12:42
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save avdhoot/08f57f34f15309ad434d36768b18e333 to your computer and use it in GitHub Desktop.
Save avdhoot/08f57f34f15309ad434d36768b18e333 to your computer and use it in GitHub Desktop.
Export sumologic users
import sys
import requests
import csv
from requests.auth import HTTPBasicAuth
# how to get keys --> https://api.sumologic.com/docs/#section/Getting-Started/Authentication
sumo_key = ''
sumo_secret = ''
sumo_region = 'us2'
#Script will need change to support more than 1000 users
print("Getting users")
response = requests.get(f'https://api.{sumo_region}.sumologic.com/api/v1/users?limit=1000', auth = HTTPBasicAuth(sumo_key, sumo_secret))
if response.status_code != 200:
print(f"Failed to get user from sumologic reason --> {response.reason}")
sys.exit(1)
with open('users.csv', mode='w') as csv_file:
fieldnames = ['firstName', 'lastName', 'email', 'createdAt', 'createdBy', 'modifiedAt', 'modifiedBy', 'id', 'isActive', 'isLocked', 'isMfaEnabled', 'lastLoginTimestamp']
writer = csv.DictWriter(csv_file, fieldnames=fieldnames)
writer.writeheader()
for user in response.json()['data']:
user.pop('roleIds')
writer.writerow(user)
print("Created CSV")
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment