-
Notifications
You must be signed in to change notification settings - Fork 2
/
extract_all_clientconnections.py
75 lines (64 loc) · 3.06 KB
/
extract_all_clientconnections.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
##########################################################
# Author : Jerzy 'Yuri' Kramarz (op7ic) #
# Version : 1.0 #
# Type : Python #
# Description : See README.md for details #
# License : See LICENSE for details #
##########################################################
import csv
from datetime import datetime
import meraki
import os
# Instructions:
# Set APIKEY in environment variable MERAKI_DASHBOARD_API_KEY.
# Install meraki via 'pip install meraki' command
os.makedirs('./logs/', exist_ok=True)
dashboard = meraki.DashboardAPI(output_log=True, log_path="./logs/",
log_file_prefix=os.path.basename(__file__), print_console=False)
organizations = dashboard.organizations.getOrganizations()[0]['id']
print("[+] Organization ID: %s " % (organizations))
print("[+] Grabbing Network Device List")
devices = dashboard.organizations.getOrganizationDevicesAvailabilities(organizationId=organizations)
networkIDs = []
for a in devices:
if (a['status'] == 'online'):
netID = a['network']['id']
if netID not in networkIDs:
networkIDs.append(netID)
print("[+] Dumping Client Connections")
unique_client = {}
now = datetime.now()
timestampStr = now.strftime("%d-%m-%Y-%s")
with open('meraki-client-connections-%s.csv' % (timestampStr), 'w', newline='', encoding='utf-8') as f:
csv_header = ['timestamp', 'clientID', 'sourceIP', 'sourceMac',
'destinationIP', 'application', 'protocol', 'destinationPort']
writer = csv.writer(f)
writer.writerow(csv_header)
try:
for x in networkIDs:
available_clients = dashboard.networks.getNetworkClients(networkId=x, total_pages=9999, perPage=1000)
# print(available_clients)
for ac in available_clients:
try:
client_applications = dashboard.networks.getNetworkClientsApplicationUsage(networkId=x, clients=ac['mac'],ssidNumber=0, timespan=2592000)
for apps in client_applications:
try:
clientID = apps['clientId']
clientIP = apps['clientIp']
clientMac = apps['clientMac']
unique_client[clientID] = {}
print(clientIP, clientID, clientMac)
clientHistory = dashboard.networks.getNetworkClientTrafficHistory(networkId=x, clientId=clientID)
for ch in clientHistory:
if clientID in unique_client:
writer.writerow([ch['ts'], clientID, clientIP, clientMac,
ch['destination'], ch['application'], ch['protocol'], ch['port']])
except:
pass
except:
pass
except:
pass
finally:
pass
print("[+] Done. Happy hunting !")