04-09-2021 05:12 AM
Hi,
My customer needs a daily client detail report in JSON format. So I went to DNAC, configured the report, scheduled it, and configured a webhook notification for the report. Every time the report runs, my webhook receiver gets notified with status updates (In Queue -> In Progress -> Success). So after being notified about a successful report run, I want my software to go and fetch the report from DNAC and send it to my customer, right? But how? There does not seem to be an API call for fetching a report, and the webhook notification only includes a URL to the GUI report download page, no REST API endpoint or file location.
So, I thought instead of using a webhook notification, I configure the DNAC report with the email attachment delivery option. But as it turns out, that option is only available for PDF reports.
As an alternative approach I could go and try to create a similar client detail report myself using data I read from the intent API. To get client detail data I can use the /dna/intent/api/v1/client-detail endpoint, but it can only get data from a particular client identified by MAC address, not from all clients. So that means making separate API calls for each and every client in my network. Besides the obvious performance and scaling issues in this approach, the next question that arises is: how do I even obtain a list of all client mac addresses in my network?
What is the best way to go about this? Do I overlook a more straightforward approach?
Solved! Go to Solution.
04-09-2021 08:02 AM
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
API -- REPORTS: CLIENT REPORT - CLIENT DETAIL_JSON_FORMAT
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
+
Goals:
Use the REST API to Get the Results of a Client DETAIL Report
* Get the list of Reports
* Get the Results from an existing Report
REPORTS -- Get List of Reports
------------------------------
GET
{{PROTOCOL}}://{{DNAC.IP.ADDRESS}}/api/dnacaap/v1/daas/core/data-set
REPORTS -- GET Report Results using {{reportId}} & {{executionId}}
------------------------------------------------------------------
{{PROTOCOL}}://{{DNAC.IP.ADDRESS}}/api/dnacaap/v1/daas/core/content/data-set/{{reportId}}/{{executionId}}
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
For Example:
------------
REPORTS -- Get List of Reports
-------------------------------
GET
{{PROTOCOL}}://{{DNAC.IP.ADDRESS}}/api/dnacaap/v1/daas/core/data-set
RESPONSE: (abbreviated output)
{
"version": "1.0",
"response": [
{
"name": "Client Report - Client Detail_JSON_FORMAT",
"dataCategory": "Client",
.
.
"view": {
"name": "Client Detail",
"description": "This client report view provides detailed information about the list of clients that are seen in the network",
.
.
"executionId": "318a739b-19a0-4486-861c-725770f934c3",
.
.
"reportId": "8e214baf-e3c8-4eb5-b433-9a89d165d71e",
.
.
}
REPORTS -- GET Report Results using {{reportId}} & {{executionId}}
------------------------------------------------------------------
GET
{{PROTOCOL}}://{{DNAC.IP.ADDRESS}}/api/dnacaap/v1/daas/core/content/data-set/{{reportId}}/{{executionId}}
From the GET LIST
-----------------
"name": "Client Report - Client Detail_JSON_FORMAT",
"reportId": "8e214baf-e3c8-4eb5-b433-9a89d165d71e",
"executionId": "318a739b-19a0-4486-861c-725770f934c3",
GET
{{PROTOCOL}}://{{DNAC.IP.ADDRESS}}/api/dnacaap/v1/daas/core/content/data-set/8e214baf-e3c8-4eb5-b433-9a89d165d71e/318a739b-19a0-4486-861c-725770f934c3
RESPONSE:
{"client_details": [{"hostName":"--","username":"blue1","macAddress":"F8:66:F2:23:01:FC","ipv4":"172.16.11.109","ipv6":"--","deviceType":"Wired","connectionStatus":"Connected","averageHealthScore_min":"1","averageHealthScore_max":"10","averageHealthScore_median":"10","usage_sum":"250.09","connectedDeviceName":"V1-FIAB1.dna.local","frequency":"--","rssi_median":"--","snr_median":"--","site":"Global/North America/North Carolina - Research Triangle Park/RTP 10 - STILLWATER","lastUpdated":"09 Apr, 02:00:00 PM","apGroup":"--","ssid":"--","vlan":"1021","vnid":"--","onboardingEventTime":"--","assocDoneTimestamp":"--","authDoneTimestamp":"--","aaaServerIp":"--","dhcpDoneTimestamp":"--","maxDhcpDuration_max":"--","dhcpServerIp":"--","linkSpeed":"1000.0","txRate_min":"0.0","txRate_max":"3214.47","txRate_avg":"1849.04","rxRate_min":"0.0","rxRate_max":"3672.53","rxRate_avg":"2403.31","txBytes_sum":"108.96","rxBytes_sum":"141.14","dataRate_median":"--","dot11Protocol":"--"},{"hostName":"V1-JUMPBOX1","username":"green1","macAddress":"50:3E:AA:4E:B4:EB","ipv4":"172.16.113.207","ipv6":"fe80::242c:c4dc:40e9:e18e","deviceType":"Wireless","connectionStatus":"Connected","averageHealthScore_min":"7","averageHealthScore_max":"10","averageHealthScore_median":"10","usage_sum":"379.23","connectedDeviceName":"AP00D7.8FA7.1774","frequency":"5.0","rssi_median":"-48.0","snr_median":"45.0","site":"Global/North America/North Carolina - Research Triangle Park/RTP 10 - STILLWATER/Floor 3","lastUpdated":"09 Apr, 02:00:00 PM","apGroup":"Floor3_TYPICAL_d02ec","ssid":"Wolverine","vlan":"0","vnid":"8190","onboardingEventTime":"09 Apr, 01:53:00 PM","assocDoneTimestamp":"06 Apr, 05:51:48 PM","authDoneTimestamp":"09 Apr, 01:53:00 PM","aaaServerIp":"192.168.111.85","dhcpDoneTimestamp":"--","maxDhcpDuration_max":"--","dhcpServerIp":"--","linkSpeed":"--","txRate_min":"0.0","txRate_max":"21505.96","txRate_avg":"11254.4","rxRate_min":"0.0","rxRate_max":"19312.27","rxRate_avg":"10100.07","txBytes_sum":"199.76","rxBytes_sum":"179.47","dataRate_median":"72.0","dot11Protocol":"802.11ac"},{"hostName":"AP1800s.SENSOR.43C0","username":"sensor1","macAddress":"0C:75:BD:0D:64:11","ipv4":"172.16.113.206","ipv6":"fe80::e75:bdff:fe0d:6411","deviceType":"Wireless","connectionStatus":"Connected","averageHealthScore_min":"4","averageHealthScore_max":"10","averageHealthScore_median":"10","usage_sum":"605.52","connectedDeviceName":"APCC16.7EDE.7C08","frequency":"5.0","rssi_median":"-40.0","snr_median":"49.0","site":"Global/North America/North Carolina - Research Triangle Park/RTP 10 - STILLWATER/Floor 3","lastUpdated":"09 Apr, 02:00:00 PM","apGroup":"Floor3_TYPICAL_d02ec","ssid":"Wolverine","vlan":"8190","vnid":"8190","onboardingEventTime":"09 Apr, 01:54:19 PM","assocDoneTimestamp":"09 Apr, 01:54:15 PM","authDoneTimestamp":"09 Apr, 01:54:16 PM","aaaServerIp":"192.168.111.85","dhcpDoneTimestamp":"09 Apr, 01:54:19 PM","maxDhcpDuration_max":"3101","dhcpServerIp":"192.168.111.87","linkSpeed":"--","txRate_min":"0.0","txRate_max":"7914.67","txRate_avg":"1610.03","rxRate_min":"0.0","rxRate_max":"144646.4","rxRate_avg":"34514.86","txBytes_sum":"27.42","rxBytes_sum":"578.1","dataRate_median":"130.0","dot11Protocol":"802.11ac"},{"hostName":"AP1800s.SENSOR.4770","username":"sensor2","macAddress":"68:CA:E4:77:82:51","ipv4":"172.16.114.206","ipv6":"fe80::6aca:e4ff:fe77:8251","deviceType":"Wireless","connectionStatus":"Connected","averageHealthScore_min":"1","averageHealthScore_max":"10","averageHealthScore_median":"10","usage_sum":"601.18","connectedDeviceName":"AP00D7.8FA7.1774","frequency":"5.0","rssi_median":"-42.0","snr_median":"47.5","site":"Global/North America/North Carolina - Research Triangle Park/RTP 10 - STILLWATER/Floor 3","lastUpdated":"09 Apr, 02:00:00 PM","apGroup":"Floor3_TYPICAL_d02ec","ssid":"Cyclops","vlan":"0","vnid":"8193","onboardingEventTime":"09 Apr, 01:55:28 PM","assocDoneTimestamp":"09 Apr, 01:55:27 PM","authDoneTimestamp":"09 Apr, 01:55:28 PM","aaaServerIp":"192.168.111.85","dhcpDoneTimestamp":"09 Apr, 01:40:17 PM","maxDhcpDuration_max":"3456","dhcpServerIp":"192.168.111.87","linkSpeed":"--","txRate_min":"0.0","txRate_max":"7584.27","txRate_avg":"1231.77","rxRate_min":"0.0","rxRate_max":"147635.47","rxRate_avg":"25849.76","txBytes_sum":"27.74","rxBytes_sum":"573.44","dataRate_median":"173.0","dot11Protocol":"802.11ac"},{"hostName":"--","username":"red1","macAddress":"64:F6:9D:79:95:EC","ipv4":"172.16.12.109","ipv6":"--","deviceType":"Wired","connectionStatus":"Connected","averageHealthScore_min":"10","averageHealthScore_max":"10","averageHealthScore_median":"10","usage_sum":"519.55","connectedDeviceName":"V1-FIAB1.dna.local","frequency":"--","rssi_median":"--","snr_median":"--","site":"Global/North America/North Carolina - Research Triangle Park/RTP 10 - STILLWATER","lastUpdated":"09 Apr, 02:00:00 PM","apGroup":"--","ssid":"--","vlan":"1028","vnid":"--","onboardingEventTime":"--","assocDoneTimestamp":"--","authDoneTimestamp":"--","aaaServerIp":"--","dhcpDoneTimestamp":"--","maxDhcpDuration_max":"--","dhcpServerIp":"--","linkSpeed":"1000.0","txRate_min":"0.0","txRate_max":"6293.98","txRate_avg":"4141.15","rxRate_min":"0.0","rxRate_max":"6822.45","rxRate_avg":"4614.43","txBytes_sum":"245.95","rxBytes_sum":"273.6","dataRate_median":"--","dot11Protocol":"--"},{"hostName":"V1-JUMPBOX2","username":"black1","macAddress":"50:3E:AA:4F:00:4D","ipv4":"172.16.114.208","ipv6":"--","deviceType":"Wireless","connectionStatus":"Connected","averageHealthScore_min":"10","averageHealthScore_max":"10","averageHealthScore_median":"10","usage_sum":"320.92","connectedDeviceName":"APCC16.7EDE.7C08","frequency":"5.0","rssi_median":"-50.0","snr_median":"39.75","site":"Global/North America/North Carolina - Research Triangle Park/RTP 10 - STILLWATER/Floor 3","lastUpdated":"09 Apr, 02:00:00 PM","apGroup":"Floor3_TYPICAL_d02ec","ssid":"Cyclops","vlan":"0","vnid":"8193","onboardingEventTime":"09 Apr, 01:34:28 PM","assocDoneTimestamp":"06 Apr, 06:02:11 PM","authDoneTimestamp":"09 Apr, 01:34:28 PM","aaaServerIp":"192.168.111.85","dhcpDoneTimestamp":"06 Apr, 06:02:16 PM","maxDhcpDuration_max":"1359","dhcpServerIp":"192.168.111.87","linkSpeed":"--","txRate_min":"0.0","txRate_max":"18615.38","txRate_avg":"13843.64","rxRate_min":"0.0","rxRate_max":"18008.89","rxRate_avg":"13542.88","txBytes_sum":"162.2","rxBytes_sum":"158.72","dataRate_median":"72.0","dot11Protocol":"802.11ac"},{"hostName":"--","username":"--","macAddress":"52:54:DD:BB:59:AF","ipv4":"172.16.11.108","ipv6":"fe80::5054:ddff:febb:59af","deviceType":"Wired","connectionStatus":"Connected","averageHealthScore_min":"10","averageHealthScore_max":"10","averageHealthScore_median":"10","usage_sum":"12.66","connectedDeviceName":"V1-FIAB1.dna.local","frequency":"--","rssi_median":"--","snr_median":"--","site":"Global/North America/North Carolina - Research Triangle Park/RTP 10 - STILLWATER","lastUpdated":"09 Apr, 02:00:00 PM","apGroup":"--","ssid":"--","vlan":"1021","vnid":"--","onboardingEventTime":"--","assocDoneTimestamp":"--","authDoneTimestamp":"--","aaaServerIp":"--","dhcpDoneTimestamp":"--","maxDhcpDuration_max":"--","dhcpServerIp":"--","linkSpeed":"1000.0","txRate_min":"0.0","txRate_max":"99.57","txRate_avg":"90.45","rxRate_min":"0.0","rxRate_max":"1270.51","rxRate_avg":"1212.53","txBytes_sum":"0.88","rxBytes_sum":"11.78","dataRate_median":"--","dot11Protocol":"--"},{"hostName":"V1-CLIENT1","username":"blue1","macAddress":"00:E0:4C:29:67:7D","ipv4":"172.16.111.209","ipv6":"--","deviceType":"Wireless","connectionStatus":"Connected","averageHealthScore_min":"1","averageHealthScore_max":"10","averageHealthScore_median":"10","usage_sum":"215.28","connectedDeviceName":"APCC16.7EDE.7C08","frequency":"5.0","rssi_median":"-41.0","snr_median":"49.0","site":"Global/North America/North Carolina - Research Triangle Park/RTP 10 - STILLWATER/Floor 3","lastUpdated":"09 Apr, 02:00:00 PM","apGroup":"Floor3_TYPICAL_d02ec","ssid":"Wolverine","vlan":"0","vnid":"8189","onboardingEventTime":"09 Apr, 01:40:05 PM","assocDoneTimestamp":"06 Apr, 05:43:41 PM","authDoneTimestamp":"09 Apr, 01:40:05 PM","aaaServerIp":"192.168.111.85","dhcpDoneTimestamp":"06 Apr, 05:43:43 PM","maxDhcpDuration_max":"2044","dhcpServerIp":"192.168.111.87","linkSpeed":"--","txRate_min":"0.0","txRate_max":"12525.16","txRate_avg":"7618.92","rxRate_min":"0.0","rxRate_max":"11512.62","rxRate_avg":"7077.52","txBytes_sum":"111.59","rxBytes_sum":"103.7","dataRate_median":"87.0","dot11Protocol":"802.11ac"},{"hostName":"--","username":"64-F6-9D-37-97-1E","macAddress":"64:F6:9D:37:97:1E","ipv4":"169.254.107.106","ipv6":"--","deviceType":"Wired","connectionStatus":"Connected","averageHealthScore_min":"1","averageHealthScore_max":"1","averageHealthScore_median":"1","usage_sum":"51.6","connectedDeviceName":"V1-FIAB1.dna.local","frequency":"--","rssi_median":"--","snr_median":"--","site":"Global/North America/North Carolina - Research Triangle Park/RTP 10 - STILLWATER","lastUpdated":"09 Apr, 02:00:00 PM","apGroup":"--","ssid":"--","vlan":"1","vnid":"--","onboardingEventTime":"--","assocDoneTimestamp":"--","authDoneTimestamp":"--","aaaServerIp":"--","dhcpDoneTimestamp":"--","maxDhcpDuration_max":"--","dhcpServerIp":"--","linkSpeed":"1000.0","txRate_min":"0.0","txRate_max":"691.56","txRate_avg":"92.33","rxRate_min":"0.0","rxRate_max":"1824.21","rxRate_avg":"783.98","txBytes_sum":"5.44","rxBytes_sum":"46.16","dataRate_median":"--","dot11Protocol":"--"}],"filters": [{"name":"Location","displayName":"Location","values":[]},{"name":"DeviceType","displayName":"Device Type","values":[""]},{"name":"SSID","displayName":"SSID","values":[]},{"name":"Band","displayName":"Band","values":[]},{"name":"startTime","displayName":"Start Time","values":["2021-04-02 14:44:51.189 PM UTC"]},{"name":"endTime","displayName":"End Time","values":["2021-04-09 14:44:51.189 PM UTC"]}]}
{
"client_details": [
{
"aaaServerIp": "--",
"apGroup": "--",
"assocDoneTimestamp": "--",
"authDoneTimestamp": "--",
"averageHealthScore_max": "10",
"averageHealthScore_median": "10",
"averageHealthScore_min": "1",
"connectedDeviceName": "V1-FIAB1.dna.local",
"connectionStatus": "Connected",
"dataRate_median": "--",
"deviceType": "Wired",
"dhcpDoneTimestamp": "--",
"dhcpServerIp": "--",
"dot11Protocol": "--",
"frequency": "--",
"hostName": "--",
"ipv4": "172.16.11.109",
"ipv6": "--",
"lastUpdated": "09 Apr, 02:00:00 PM",
"linkSpeed": "1000.0",
"macAddress": "F8:66:F2:23:01:FC",
"maxDhcpDuration_max": "--",
"onboardingEventTime": "--",
"rssi_median": "--",
"rxBytes_sum": "141.14",
"rxRate_avg": "2403.31",
"rxRate_max": "3672.53",
"rxRate_min": "0.0",
"site": "Global/North America/North Carolina - Research Triangle Park/RTP 10 - STILLWATER",
"snr_median": "--",
"ssid": "--",
"txBytes_sum": "108.96",
"txRate_avg": "1849.04",
"txRate_max": "3214.47",
"txRate_min": "0.0",
"usage_sum": "250.09",
"username": "blue1",
"vlan": "1021",
"vnid": "--"
},
{
"aaaServerIp": "192.168.111.85",
"apGroup": "Floor3_TYPICAL_d02ec",
"assocDoneTimestamp": "06 Apr, 05:51:48 PM",
"authDoneTimestamp": "09 Apr, 01:53:00 PM",
"averageHealthScore_max": "10",
"averageHealthScore_median": "10",
"averageHealthScore_min": "7",
"connectedDeviceName": "AP00D7.8FA7.1774",
"connectionStatus": "Connected",
"dataRate_median": "72.0",
"deviceType": "Wireless",
"dhcpDoneTimestamp": "--",
"dhcpServerIp": "--",
"dot11Protocol": "802.11ac",
"frequency": "5.0",
"hostName": "V1-JUMPBOX1",
"ipv4": "172.16.113.207",
"ipv6": "fe80::242c:c4dc:40e9:e18e",
"lastUpdated": "09 Apr, 02:00:00 PM",
"linkSpeed": "--",
"macAddress": "50:3E:AA:4E:B4:EB",
"maxDhcpDuration_max": "--",
"onboardingEventTime": "09 Apr, 01:53:00 PM",
"rssi_median": "-48.0",
"rxBytes_sum": "179.47",
"rxRate_avg": "10100.07",
"rxRate_max": "19312.27",
"rxRate_min": "0.0",
"site": "Global/North America/North Carolina - Research Triangle Park/RTP 10 - STILLWATER/Floor 3",
"snr_median": "45.0",
"ssid": "Wolverine",
"txBytes_sum": "199.76",
"txRate_avg": "11254.4",
"txRate_max": "21505.96",
"txRate_min": "0.0",
"usage_sum": "379.23",
"username": "green1",
"vlan": "0",
"vnid": "8190"
},
{
"aaaServerIp": "192.168.111.85",
"apGroup": "Floor3_TYPICAL_d02ec",
"assocDoneTimestamp": "09 Apr, 01:54:15 PM",
"authDoneTimestamp": "09 Apr, 01:54:16 PM",
"averageHealthScore_max": "10",
"averageHealthScore_median": "10",
"averageHealthScore_min": "4",
"connectedDeviceName": "APCC16.7EDE.7C08",
"connectionStatus": "Connected",
"dataRate_median": "130.0",
"deviceType": "Wireless",
"dhcpDoneTimestamp": "09 Apr, 01:54:19 PM",
"dhcpServerIp": "192.168.111.87",
"dot11Protocol": "802.11ac",
"frequency": "5.0",
"hostName": "AP1800s.SENSOR.43C0",
"ipv4": "172.16.113.206",
"ipv6": "fe80::e75:bdff:fe0d:6411",
"lastUpdated": "09 Apr, 02:00:00 PM",
"linkSpeed": "--",
"macAddress": "0C:75:BD:0D:64:11",
"maxDhcpDuration_max": "3101",
"onboardingEventTime": "09 Apr, 01:54:19 PM",
"rssi_median": "-40.0",
"rxBytes_sum": "578.1",
"rxRate_avg": "34514.86",
"rxRate_max": "144646.4",
"rxRate_min": "0.0",
"site": "Global/North America/North Carolina - Research Triangle Park/RTP 10 - STILLWATER/Floor 3",
"snr_median": "49.0",
"ssid": "Wolverine",
"txBytes_sum": "27.42",
"txRate_avg": "1610.03",
"txRate_max": "7914.67",
"txRate_min": "0.0",
"usage_sum": "605.52",
"username": "sensor1",
"vlan": "8190",
"vnid": "8190"
},
{
"aaaServerIp": "192.168.111.85",
"apGroup": "Floor3_TYPICAL_d02ec",
"assocDoneTimestamp": "09 Apr, 01:55:27 PM",
"authDoneTimestamp": "09 Apr, 01:55:28 PM",
"averageHealthScore_max": "10",
"averageHealthScore_median": "10",
"averageHealthScore_min": "1",
"connectedDeviceName": "AP00D7.8FA7.1774",
"connectionStatus": "Connected",
"dataRate_median": "173.0",
"deviceType": "Wireless",
"dhcpDoneTimestamp": "09 Apr, 01:40:17 PM",
"dhcpServerIp": "192.168.111.87",
"dot11Protocol": "802.11ac",
"frequency": "5.0",
"hostName": "AP1800s.SENSOR.4770",
"ipv4": "172.16.114.206",
"ipv6": "fe80::6aca:e4ff:fe77:8251",
"lastUpdated": "09 Apr, 02:00:00 PM",
"linkSpeed": "--",
"macAddress": "68:CA:E4:77:82:51",
"maxDhcpDuration_max": "3456",
"onboardingEventTime": "09 Apr, 01:55:28 PM",
"rssi_median": "-42.0",
"rxBytes_sum": "573.44",
"rxRate_avg": "25849.76",
"rxRate_max": "147635.47",
"rxRate_min": "0.0",
"site": "Global/North America/North Carolina - Research Triangle Park/RTP 10 - STILLWATER/Floor 3",
"snr_median": "47.5",
"ssid": "Cyclops",
"txBytes_sum": "27.74",
"txRate_avg": "1231.77",
"txRate_max": "7584.27",
"txRate_min": "0.0",
"usage_sum": "601.18",
"username": "sensor2",
"vlan": "0",
"vnid": "8193"
},
{
"aaaServerIp": "--",
"apGroup": "--",
"assocDoneTimestamp": "--",
"authDoneTimestamp": "--",
"averageHealthScore_max": "10",
"averageHealthScore_median": "10",
"averageHealthScore_min": "10",
"connectedDeviceName": "V1-FIAB1.dna.local",
"connectionStatus": "Connected",
"dataRate_median": "--",
"deviceType": "Wired",
"dhcpDoneTimestamp": "--",
"dhcpServerIp": "--",
"dot11Protocol": "--",
"frequency": "--",
"hostName": "--",
"ipv4": "172.16.12.109",
"ipv6": "--",
"lastUpdated": "09 Apr, 02:00:00 PM",
"linkSpeed": "1000.0",
"macAddress": "64:F6:9D:79:95:EC",
"maxDhcpDuration_max": "--",
"onboardingEventTime": "--",
"rssi_median": "--",
"rxBytes_sum": "273.6",
"rxRate_avg": "4614.43",
"rxRate_max": "6822.45",
"rxRate_min": "0.0",
"site": "Global/North America/North Carolina - Research Triangle Park/RTP 10 - STILLWATER",
"snr_median": "--",
"ssid": "--",
"txBytes_sum": "245.95",
"txRate_avg": "4141.15",
"txRate_max": "6293.98",
"txRate_min": "0.0",
"usage_sum": "519.55",
"username": "red1",
"vlan": "1028",
"vnid": "--"
},
{
"aaaServerIp": "192.168.111.85",
"apGroup": "Floor3_TYPICAL_d02ec",
"assocDoneTimestamp": "06 Apr, 06:02:11 PM",
"authDoneTimestamp": "09 Apr, 01:34:28 PM",
"averageHealthScore_max": "10",
"averageHealthScore_median": "10",
"averageHealthScore_min": "10",
"connectedDeviceName": "APCC16.7EDE.7C08",
"connectionStatus": "Connected",
"dataRate_median": "72.0",
"deviceType": "Wireless",
"dhcpDoneTimestamp": "06 Apr, 06:02:16 PM",
"dhcpServerIp": "192.168.111.87",
"dot11Protocol": "802.11ac",
"frequency": "5.0",
"hostName": "V1-JUMPBOX2",
"ipv4": "172.16.114.208",
"ipv6": "--",
"lastUpdated": "09 Apr, 02:00:00 PM",
"linkSpeed": "--",
"macAddress": "50:3E:AA:4F:00:4D",
"maxDhcpDuration_max": "1359",
"onboardingEventTime": "09 Apr, 01:34:28 PM",
"rssi_median": "-50.0",
"rxBytes_sum": "158.72",
"rxRate_avg": "13542.88",
"rxRate_max": "18008.89",
"rxRate_min": "0.0",
"site": "Global/North America/North Carolina - Research Triangle Park/RTP 10 - STILLWATER/Floor 3",
"snr_median": "39.75",
"ssid": "Cyclops",
"txBytes_sum": "162.2",
"txRate_avg": "13843.64",
"txRate_max": "18615.38",
"txRate_min": "0.0",
"usage_sum": "320.92",
"username": "black1",
"vlan": "0",
"vnid": "8193"
},
{
"aaaServerIp": "--",
"apGroup": "--",
"assocDoneTimestamp": "--",
"authDoneTimestamp": "--",
"averageHealthScore_max": "10",
"averageHealthScore_median": "10",
"averageHealthScore_min": "10",
"connectedDeviceName": "V1-FIAB1.dna.local",
"connectionStatus": "Connected",
"dataRate_median": "--",
"deviceType": "Wired",
"dhcpDoneTimestamp": "--",
"dhcpServerIp": "--",
"dot11Protocol": "--",
"frequency": "--",
"hostName": "--",
"ipv4": "172.16.11.108",
"ipv6": "fe80::5054:ddff:febb:59af",
"lastUpdated": "09 Apr, 02:00:00 PM",
"linkSpeed": "1000.0",
"macAddress": "52:54:DD:BB:59:AF",
"maxDhcpDuration_max": "--",
"onboardingEventTime": "--",
"rssi_median": "--",
"rxBytes_sum": "11.78",
"rxRate_avg": "1212.53",
"rxRate_max": "1270.51",
"rxRate_min": "0.0",
"site": "Global/North America/North Carolina - Research Triangle Park/RTP 10 - STILLWATER",
"snr_median": "--",
"ssid": "--",
"txBytes_sum": "0.88",
"txRate_avg": "90.45",
"txRate_max": "99.57",
"txRate_min": "0.0",
"usage_sum": "12.66",
"username": "--",
"vlan": "1021",
"vnid": "--"
},
{
"aaaServerIp": "192.168.111.85",
"apGroup": "Floor3_TYPICAL_d02ec",
"assocDoneTimestamp": "06 Apr, 05:43:41 PM",
"authDoneTimestamp": "09 Apr, 01:40:05 PM",
"averageHealthScore_max": "10",
"averageHealthScore_median": "10",
"averageHealthScore_min": "1",
"connectedDeviceName": "APCC16.7EDE.7C08",
"connectionStatus": "Connected",
"dataRate_median": "87.0",
"deviceType": "Wireless",
"dhcpDoneTimestamp": "06 Apr, 05:43:43 PM",
"dhcpServerIp": "192.168.111.87",
"dot11Protocol": "802.11ac",
"frequency": "5.0",
"hostName": "V1-CLIENT1",
"ipv4": "172.16.111.209",
"ipv6": "--",
"lastUpdated": "09 Apr, 02:00:00 PM",
"linkSpeed": "--",
"macAddress": "00:E0:4C:29:67:7D",
"maxDhcpDuration_max": "2044",
"onboardingEventTime": "09 Apr, 01:40:05 PM",
"rssi_median": "-41.0",
"rxBytes_sum": "103.7",
"rxRate_avg": "7077.52",
"rxRate_max": "11512.62",
"rxRate_min": "0.0",
"site": "Global/North America/North Carolina - Research Triangle Park/RTP 10 - STILLWATER/Floor 3",
"snr_median": "49.0",
"ssid": "Wolverine",
"txBytes_sum": "111.59",
"txRate_avg": "7618.92",
"txRate_max": "12525.16",
"txRate_min": "0.0",
"usage_sum": "215.28",
"username": "blue1",
"vlan": "0",
"vnid": "8189"
},
{
"aaaServerIp": "--",
"apGroup": "--",
"assocDoneTimestamp": "--",
"authDoneTimestamp": "--",
"averageHealthScore_max": "1",
"averageHealthScore_median": "1",
"averageHealthScore_min": "1",
"connectedDeviceName": "V1-FIAB1.dna.local",
"connectionStatus": "Connected",
"dataRate_median": "--",
"deviceType": "Wired",
"dhcpDoneTimestamp": "--",
"dhcpServerIp": "--",
"dot11Protocol": "--",
"frequency": "--",
"hostName": "--",
"ipv4": "169.254.107.106",
"ipv6": "--",
"lastUpdated": "09 Apr, 02:00:00 PM",
"linkSpeed": "1000.0",
"macAddress": "64:F6:9D:37:97:1E",
"maxDhcpDuration_max": "--",
"onboardingEventTime": "--",
"rssi_median": "--",
"rxBytes_sum": "46.16",
"rxRate_avg": "783.98",
"rxRate_max": "1824.21",
"rxRate_min": "0.0",
"site": "Global/North America/North Carolina - Research Triangle Park/RTP 10 - STILLWATER",
"snr_median": "--",
"ssid": "--",
"txBytes_sum": "5.44",
"txRate_avg": "92.33",
"txRate_max": "691.56",
"txRate_min": "0.0",
"usage_sum": "51.6",
"username": "64-F6-9D-37-97-1E",
"vlan": "1",
"vnid": "--"
}
],
"filters": [
{
"displayName": "Location",
"name": "Location",
"values": []
},
{
"displayName": "Device Type",
"name": "DeviceType",
"values": [
""
]
},
{
"displayName": "SSID",
"name": "SSID",
"values": []
},
{
"displayName": "Band",
"name": "Band",
"values": []
},
{
"displayName": "Start Time",
"name": "startTime",
"values": [
"2021-04-02 14:44:51.189 PM UTC"
]
},
{
"displayName": "End Time",
"name": "endTime",
"values": [
"2021-04-09 14:44:51.189 PM UTC"
]
}
]
}
04-09-2021 08:02 AM
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
API -- REPORTS: CLIENT REPORT - CLIENT DETAIL_JSON_FORMAT
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
+
Goals:
Use the REST API to Get the Results of a Client DETAIL Report
* Get the list of Reports
* Get the Results from an existing Report
REPORTS -- Get List of Reports
------------------------------
GET
{{PROTOCOL}}://{{DNAC.IP.ADDRESS}}/api/dnacaap/v1/daas/core/data-set
REPORTS -- GET Report Results using {{reportId}} & {{executionId}}
------------------------------------------------------------------
{{PROTOCOL}}://{{DNAC.IP.ADDRESS}}/api/dnacaap/v1/daas/core/content/data-set/{{reportId}}/{{executionId}}
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
For Example:
------------
REPORTS -- Get List of Reports
-------------------------------
GET
{{PROTOCOL}}://{{DNAC.IP.ADDRESS}}/api/dnacaap/v1/daas/core/data-set
RESPONSE: (abbreviated output)
{
"version": "1.0",
"response": [
{
"name": "Client Report - Client Detail_JSON_FORMAT",
"dataCategory": "Client",
.
.
"view": {
"name": "Client Detail",
"description": "This client report view provides detailed information about the list of clients that are seen in the network",
.
.
"executionId": "318a739b-19a0-4486-861c-725770f934c3",
.
.
"reportId": "8e214baf-e3c8-4eb5-b433-9a89d165d71e",
.
.
}
REPORTS -- GET Report Results using {{reportId}} & {{executionId}}
------------------------------------------------------------------
GET
{{PROTOCOL}}://{{DNAC.IP.ADDRESS}}/api/dnacaap/v1/daas/core/content/data-set/{{reportId}}/{{executionId}}
From the GET LIST
-----------------
"name": "Client Report - Client Detail_JSON_FORMAT",
"reportId": "8e214baf-e3c8-4eb5-b433-9a89d165d71e",
"executionId": "318a739b-19a0-4486-861c-725770f934c3",
GET
{{PROTOCOL}}://{{DNAC.IP.ADDRESS}}/api/dnacaap/v1/daas/core/content/data-set/8e214baf-e3c8-4eb5-b433-9a89d165d71e/318a739b-19a0-4486-861c-725770f934c3
RESPONSE:
{"client_details": [{"hostName":"--","username":"blue1","macAddress":"F8:66:F2:23:01:FC","ipv4":"172.16.11.109","ipv6":"--","deviceType":"Wired","connectionStatus":"Connected","averageHealthScore_min":"1","averageHealthScore_max":"10","averageHealthScore_median":"10","usage_sum":"250.09","connectedDeviceName":"V1-FIAB1.dna.local","frequency":"--","rssi_median":"--","snr_median":"--","site":"Global/North America/North Carolina - Research Triangle Park/RTP 10 - STILLWATER","lastUpdated":"09 Apr, 02:00:00 PM","apGroup":"--","ssid":"--","vlan":"1021","vnid":"--","onboardingEventTime":"--","assocDoneTimestamp":"--","authDoneTimestamp":"--","aaaServerIp":"--","dhcpDoneTimestamp":"--","maxDhcpDuration_max":"--","dhcpServerIp":"--","linkSpeed":"1000.0","txRate_min":"0.0","txRate_max":"3214.47","txRate_avg":"1849.04","rxRate_min":"0.0","rxRate_max":"3672.53","rxRate_avg":"2403.31","txBytes_sum":"108.96","rxBytes_sum":"141.14","dataRate_median":"--","dot11Protocol":"--"},{"hostName":"V1-JUMPBOX1","username":"green1","macAddress":"50:3E:AA:4E:B4:EB","ipv4":"172.16.113.207","ipv6":"fe80::242c:c4dc:40e9:e18e","deviceType":"Wireless","connectionStatus":"Connected","averageHealthScore_min":"7","averageHealthScore_max":"10","averageHealthScore_median":"10","usage_sum":"379.23","connectedDeviceName":"AP00D7.8FA7.1774","frequency":"5.0","rssi_median":"-48.0","snr_median":"45.0","site":"Global/North America/North Carolina - Research Triangle Park/RTP 10 - STILLWATER/Floor 3","lastUpdated":"09 Apr, 02:00:00 PM","apGroup":"Floor3_TYPICAL_d02ec","ssid":"Wolverine","vlan":"0","vnid":"8190","onboardingEventTime":"09 Apr, 01:53:00 PM","assocDoneTimestamp":"06 Apr, 05:51:48 PM","authDoneTimestamp":"09 Apr, 01:53:00 PM","aaaServerIp":"192.168.111.85","dhcpDoneTimestamp":"--","maxDhcpDuration_max":"--","dhcpServerIp":"--","linkSpeed":"--","txRate_min":"0.0","txRate_max":"21505.96","txRate_avg":"11254.4","rxRate_min":"0.0","rxRate_max":"19312.27","rxRate_avg":"10100.07","txBytes_sum":"199.76","rxBytes_sum":"179.47","dataRate_median":"72.0","dot11Protocol":"802.11ac"},{"hostName":"AP1800s.SENSOR.43C0","username":"sensor1","macAddress":"0C:75:BD:0D:64:11","ipv4":"172.16.113.206","ipv6":"fe80::e75:bdff:fe0d:6411","deviceType":"Wireless","connectionStatus":"Connected","averageHealthScore_min":"4","averageHealthScore_max":"10","averageHealthScore_median":"10","usage_sum":"605.52","connectedDeviceName":"APCC16.7EDE.7C08","frequency":"5.0","rssi_median":"-40.0","snr_median":"49.0","site":"Global/North America/North Carolina - Research Triangle Park/RTP 10 - STILLWATER/Floor 3","lastUpdated":"09 Apr, 02:00:00 PM","apGroup":"Floor3_TYPICAL_d02ec","ssid":"Wolverine","vlan":"8190","vnid":"8190","onboardingEventTime":"09 Apr, 01:54:19 PM","assocDoneTimestamp":"09 Apr, 01:54:15 PM","authDoneTimestamp":"09 Apr, 01:54:16 PM","aaaServerIp":"192.168.111.85","dhcpDoneTimestamp":"09 Apr, 01:54:19 PM","maxDhcpDuration_max":"3101","dhcpServerIp":"192.168.111.87","linkSpeed":"--","txRate_min":"0.0","txRate_max":"7914.67","txRate_avg":"1610.03","rxRate_min":"0.0","rxRate_max":"144646.4","rxRate_avg":"34514.86","txBytes_sum":"27.42","rxBytes_sum":"578.1","dataRate_median":"130.0","dot11Protocol":"802.11ac"},{"hostName":"AP1800s.SENSOR.4770","username":"sensor2","macAddress":"68:CA:E4:77:82:51","ipv4":"172.16.114.206","ipv6":"fe80::6aca:e4ff:fe77:8251","deviceType":"Wireless","connectionStatus":"Connected","averageHealthScore_min":"1","averageHealthScore_max":"10","averageHealthScore_median":"10","usage_sum":"601.18","connectedDeviceName":"AP00D7.8FA7.1774","frequency":"5.0","rssi_median":"-42.0","snr_median":"47.5","site":"Global/North America/North Carolina - Research Triangle Park/RTP 10 - STILLWATER/Floor 3","lastUpdated":"09 Apr, 02:00:00 PM","apGroup":"Floor3_TYPICAL_d02ec","ssid":"Cyclops","vlan":"0","vnid":"8193","onboardingEventTime":"09 Apr, 01:55:28 PM","assocDoneTimestamp":"09 Apr, 01:55:27 PM","authDoneTimestamp":"09 Apr, 01:55:28 PM","aaaServerIp":"192.168.111.85","dhcpDoneTimestamp":"09 Apr, 01:40:17 PM","maxDhcpDuration_max":"3456","dhcpServerIp":"192.168.111.87","linkSpeed":"--","txRate_min":"0.0","txRate_max":"7584.27","txRate_avg":"1231.77","rxRate_min":"0.0","rxRate_max":"147635.47","rxRate_avg":"25849.76","txBytes_sum":"27.74","rxBytes_sum":"573.44","dataRate_median":"173.0","dot11Protocol":"802.11ac"},{"hostName":"--","username":"red1","macAddress":"64:F6:9D:79:95:EC","ipv4":"172.16.12.109","ipv6":"--","deviceType":"Wired","connectionStatus":"Connected","averageHealthScore_min":"10","averageHealthScore_max":"10","averageHealthScore_median":"10","usage_sum":"519.55","connectedDeviceName":"V1-FIAB1.dna.local","frequency":"--","rssi_median":"--","snr_median":"--","site":"Global/North America/North Carolina - Research Triangle Park/RTP 10 - STILLWATER","lastUpdated":"09 Apr, 02:00:00 PM","apGroup":"--","ssid":"--","vlan":"1028","vnid":"--","onboardingEventTime":"--","assocDoneTimestamp":"--","authDoneTimestamp":"--","aaaServerIp":"--","dhcpDoneTimestamp":"--","maxDhcpDuration_max":"--","dhcpServerIp":"--","linkSpeed":"1000.0","txRate_min":"0.0","txRate_max":"6293.98","txRate_avg":"4141.15","rxRate_min":"0.0","rxRate_max":"6822.45","rxRate_avg":"4614.43","txBytes_sum":"245.95","rxBytes_sum":"273.6","dataRate_median":"--","dot11Protocol":"--"},{"hostName":"V1-JUMPBOX2","username":"black1","macAddress":"50:3E:AA:4F:00:4D","ipv4":"172.16.114.208","ipv6":"--","deviceType":"Wireless","connectionStatus":"Connected","averageHealthScore_min":"10","averageHealthScore_max":"10","averageHealthScore_median":"10","usage_sum":"320.92","connectedDeviceName":"APCC16.7EDE.7C08","frequency":"5.0","rssi_median":"-50.0","snr_median":"39.75","site":"Global/North America/North Carolina - Research Triangle Park/RTP 10 - STILLWATER/Floor 3","lastUpdated":"09 Apr, 02:00:00 PM","apGroup":"Floor3_TYPICAL_d02ec","ssid":"Cyclops","vlan":"0","vnid":"8193","onboardingEventTime":"09 Apr, 01:34:28 PM","assocDoneTimestamp":"06 Apr, 06:02:11 PM","authDoneTimestamp":"09 Apr, 01:34:28 PM","aaaServerIp":"192.168.111.85","dhcpDoneTimestamp":"06 Apr, 06:02:16 PM","maxDhcpDuration_max":"1359","dhcpServerIp":"192.168.111.87","linkSpeed":"--","txRate_min":"0.0","txRate_max":"18615.38","txRate_avg":"13843.64","rxRate_min":"0.0","rxRate_max":"18008.89","rxRate_avg":"13542.88","txBytes_sum":"162.2","rxBytes_sum":"158.72","dataRate_median":"72.0","dot11Protocol":"802.11ac"},{"hostName":"--","username":"--","macAddress":"52:54:DD:BB:59:AF","ipv4":"172.16.11.108","ipv6":"fe80::5054:ddff:febb:59af","deviceType":"Wired","connectionStatus":"Connected","averageHealthScore_min":"10","averageHealthScore_max":"10","averageHealthScore_median":"10","usage_sum":"12.66","connectedDeviceName":"V1-FIAB1.dna.local","frequency":"--","rssi_median":"--","snr_median":"--","site":"Global/North America/North Carolina - Research Triangle Park/RTP 10 - STILLWATER","lastUpdated":"09 Apr, 02:00:00 PM","apGroup":"--","ssid":"--","vlan":"1021","vnid":"--","onboardingEventTime":"--","assocDoneTimestamp":"--","authDoneTimestamp":"--","aaaServerIp":"--","dhcpDoneTimestamp":"--","maxDhcpDuration_max":"--","dhcpServerIp":"--","linkSpeed":"1000.0","txRate_min":"0.0","txRate_max":"99.57","txRate_avg":"90.45","rxRate_min":"0.0","rxRate_max":"1270.51","rxRate_avg":"1212.53","txBytes_sum":"0.88","rxBytes_sum":"11.78","dataRate_median":"--","dot11Protocol":"--"},{"hostName":"V1-CLIENT1","username":"blue1","macAddress":"00:E0:4C:29:67:7D","ipv4":"172.16.111.209","ipv6":"--","deviceType":"Wireless","connectionStatus":"Connected","averageHealthScore_min":"1","averageHealthScore_max":"10","averageHealthScore_median":"10","usage_sum":"215.28","connectedDeviceName":"APCC16.7EDE.7C08","frequency":"5.0","rssi_median":"-41.0","snr_median":"49.0","site":"Global/North America/North Carolina - Research Triangle Park/RTP 10 - STILLWATER/Floor 3","lastUpdated":"09 Apr, 02:00:00 PM","apGroup":"Floor3_TYPICAL_d02ec","ssid":"Wolverine","vlan":"0","vnid":"8189","onboardingEventTime":"09 Apr, 01:40:05 PM","assocDoneTimestamp":"06 Apr, 05:43:41 PM","authDoneTimestamp":"09 Apr, 01:40:05 PM","aaaServerIp":"192.168.111.85","dhcpDoneTimestamp":"06 Apr, 05:43:43 PM","maxDhcpDuration_max":"2044","dhcpServerIp":"192.168.111.87","linkSpeed":"--","txRate_min":"0.0","txRate_max":"12525.16","txRate_avg":"7618.92","rxRate_min":"0.0","rxRate_max":"11512.62","rxRate_avg":"7077.52","txBytes_sum":"111.59","rxBytes_sum":"103.7","dataRate_median":"87.0","dot11Protocol":"802.11ac"},{"hostName":"--","username":"64-F6-9D-37-97-1E","macAddress":"64:F6:9D:37:97:1E","ipv4":"169.254.107.106","ipv6":"--","deviceType":"Wired","connectionStatus":"Connected","averageHealthScore_min":"1","averageHealthScore_max":"1","averageHealthScore_median":"1","usage_sum":"51.6","connectedDeviceName":"V1-FIAB1.dna.local","frequency":"--","rssi_median":"--","snr_median":"--","site":"Global/North America/North Carolina - Research Triangle Park/RTP 10 - STILLWATER","lastUpdated":"09 Apr, 02:00:00 PM","apGroup":"--","ssid":"--","vlan":"1","vnid":"--","onboardingEventTime":"--","assocDoneTimestamp":"--","authDoneTimestamp":"--","aaaServerIp":"--","dhcpDoneTimestamp":"--","maxDhcpDuration_max":"--","dhcpServerIp":"--","linkSpeed":"1000.0","txRate_min":"0.0","txRate_max":"691.56","txRate_avg":"92.33","rxRate_min":"0.0","rxRate_max":"1824.21","rxRate_avg":"783.98","txBytes_sum":"5.44","rxBytes_sum":"46.16","dataRate_median":"--","dot11Protocol":"--"}],"filters": [{"name":"Location","displayName":"Location","values":[]},{"name":"DeviceType","displayName":"Device Type","values":[""]},{"name":"SSID","displayName":"SSID","values":[]},{"name":"Band","displayName":"Band","values":[]},{"name":"startTime","displayName":"Start Time","values":["2021-04-02 14:44:51.189 PM UTC"]},{"name":"endTime","displayName":"End Time","values":["2021-04-09 14:44:51.189 PM UTC"]}]}
{
"client_details": [
{
"aaaServerIp": "--",
"apGroup": "--",
"assocDoneTimestamp": "--",
"authDoneTimestamp": "--",
"averageHealthScore_max": "10",
"averageHealthScore_median": "10",
"averageHealthScore_min": "1",
"connectedDeviceName": "V1-FIAB1.dna.local",
"connectionStatus": "Connected",
"dataRate_median": "--",
"deviceType": "Wired",
"dhcpDoneTimestamp": "--",
"dhcpServerIp": "--",
"dot11Protocol": "--",
"frequency": "--",
"hostName": "--",
"ipv4": "172.16.11.109",
"ipv6": "--",
"lastUpdated": "09 Apr, 02:00:00 PM",
"linkSpeed": "1000.0",
"macAddress": "F8:66:F2:23:01:FC",
"maxDhcpDuration_max": "--",
"onboardingEventTime": "--",
"rssi_median": "--",
"rxBytes_sum": "141.14",
"rxRate_avg": "2403.31",
"rxRate_max": "3672.53",
"rxRate_min": "0.0",
"site": "Global/North America/North Carolina - Research Triangle Park/RTP 10 - STILLWATER",
"snr_median": "--",
"ssid": "--",
"txBytes_sum": "108.96",
"txRate_avg": "1849.04",
"txRate_max": "3214.47",
"txRate_min": "0.0",
"usage_sum": "250.09",
"username": "blue1",
"vlan": "1021",
"vnid": "--"
},
{
"aaaServerIp": "192.168.111.85",
"apGroup": "Floor3_TYPICAL_d02ec",
"assocDoneTimestamp": "06 Apr, 05:51:48 PM",
"authDoneTimestamp": "09 Apr, 01:53:00 PM",
"averageHealthScore_max": "10",
"averageHealthScore_median": "10",
"averageHealthScore_min": "7",
"connectedDeviceName": "AP00D7.8FA7.1774",
"connectionStatus": "Connected",
"dataRate_median": "72.0",
"deviceType": "Wireless",
"dhcpDoneTimestamp": "--",
"dhcpServerIp": "--",
"dot11Protocol": "802.11ac",
"frequency": "5.0",
"hostName": "V1-JUMPBOX1",
"ipv4": "172.16.113.207",
"ipv6": "fe80::242c:c4dc:40e9:e18e",
"lastUpdated": "09 Apr, 02:00:00 PM",
"linkSpeed": "--",
"macAddress": "50:3E:AA:4E:B4:EB",
"maxDhcpDuration_max": "--",
"onboardingEventTime": "09 Apr, 01:53:00 PM",
"rssi_median": "-48.0",
"rxBytes_sum": "179.47",
"rxRate_avg": "10100.07",
"rxRate_max": "19312.27",
"rxRate_min": "0.0",
"site": "Global/North America/North Carolina - Research Triangle Park/RTP 10 - STILLWATER/Floor 3",
"snr_median": "45.0",
"ssid": "Wolverine",
"txBytes_sum": "199.76",
"txRate_avg": "11254.4",
"txRate_max": "21505.96",
"txRate_min": "0.0",
"usage_sum": "379.23",
"username": "green1",
"vlan": "0",
"vnid": "8190"
},
{
"aaaServerIp": "192.168.111.85",
"apGroup": "Floor3_TYPICAL_d02ec",
"assocDoneTimestamp": "09 Apr, 01:54:15 PM",
"authDoneTimestamp": "09 Apr, 01:54:16 PM",
"averageHealthScore_max": "10",
"averageHealthScore_median": "10",
"averageHealthScore_min": "4",
"connectedDeviceName": "APCC16.7EDE.7C08",
"connectionStatus": "Connected",
"dataRate_median": "130.0",
"deviceType": "Wireless",
"dhcpDoneTimestamp": "09 Apr, 01:54:19 PM",
"dhcpServerIp": "192.168.111.87",
"dot11Protocol": "802.11ac",
"frequency": "5.0",
"hostName": "AP1800s.SENSOR.43C0",
"ipv4": "172.16.113.206",
"ipv6": "fe80::e75:bdff:fe0d:6411",
"lastUpdated": "09 Apr, 02:00:00 PM",
"linkSpeed": "--",
"macAddress": "0C:75:BD:0D:64:11",
"maxDhcpDuration_max": "3101",
"onboardingEventTime": "09 Apr, 01:54:19 PM",
"rssi_median": "-40.0",
"rxBytes_sum": "578.1",
"rxRate_avg": "34514.86",
"rxRate_max": "144646.4",
"rxRate_min": "0.0",
"site": "Global/North America/North Carolina - Research Triangle Park/RTP 10 - STILLWATER/Floor 3",
"snr_median": "49.0",
"ssid": "Wolverine",
"txBytes_sum": "27.42",
"txRate_avg": "1610.03",
"txRate_max": "7914.67",
"txRate_min": "0.0",
"usage_sum": "605.52",
"username": "sensor1",
"vlan": "8190",
"vnid": "8190"
},
{
"aaaServerIp": "192.168.111.85",
"apGroup": "Floor3_TYPICAL_d02ec",
"assocDoneTimestamp": "09 Apr, 01:55:27 PM",
"authDoneTimestamp": "09 Apr, 01:55:28 PM",
"averageHealthScore_max": "10",
"averageHealthScore_median": "10",
"averageHealthScore_min": "1",
"connectedDeviceName": "AP00D7.8FA7.1774",
"connectionStatus": "Connected",
"dataRate_median": "173.0",
"deviceType": "Wireless",
"dhcpDoneTimestamp": "09 Apr, 01:40:17 PM",
"dhcpServerIp": "192.168.111.87",
"dot11Protocol": "802.11ac",
"frequency": "5.0",
"hostName": "AP1800s.SENSOR.4770",
"ipv4": "172.16.114.206",
"ipv6": "fe80::6aca:e4ff:fe77:8251",
"lastUpdated": "09 Apr, 02:00:00 PM",
"linkSpeed": "--",
"macAddress": "68:CA:E4:77:82:51",
"maxDhcpDuration_max": "3456",
"onboardingEventTime": "09 Apr, 01:55:28 PM",
"rssi_median": "-42.0",
"rxBytes_sum": "573.44",
"rxRate_avg": "25849.76",
"rxRate_max": "147635.47",
"rxRate_min": "0.0",
"site": "Global/North America/North Carolina - Research Triangle Park/RTP 10 - STILLWATER/Floor 3",
"snr_median": "47.5",
"ssid": "Cyclops",
"txBytes_sum": "27.74",
"txRate_avg": "1231.77",
"txRate_max": "7584.27",
"txRate_min": "0.0",
"usage_sum": "601.18",
"username": "sensor2",
"vlan": "0",
"vnid": "8193"
},
{
"aaaServerIp": "--",
"apGroup": "--",
"assocDoneTimestamp": "--",
"authDoneTimestamp": "--",
"averageHealthScore_max": "10",
"averageHealthScore_median": "10",
"averageHealthScore_min": "10",
"connectedDeviceName": "V1-FIAB1.dna.local",
"connectionStatus": "Connected",
"dataRate_median": "--",
"deviceType": "Wired",
"dhcpDoneTimestamp": "--",
"dhcpServerIp": "--",
"dot11Protocol": "--",
"frequency": "--",
"hostName": "--",
"ipv4": "172.16.12.109",
"ipv6": "--",
"lastUpdated": "09 Apr, 02:00:00 PM",
"linkSpeed": "1000.0",
"macAddress": "64:F6:9D:79:95:EC",
"maxDhcpDuration_max": "--",
"onboardingEventTime": "--",
"rssi_median": "--",
"rxBytes_sum": "273.6",
"rxRate_avg": "4614.43",
"rxRate_max": "6822.45",
"rxRate_min": "0.0",
"site": "Global/North America/North Carolina - Research Triangle Park/RTP 10 - STILLWATER",
"snr_median": "--",
"ssid": "--",
"txBytes_sum": "245.95",
"txRate_avg": "4141.15",
"txRate_max": "6293.98",
"txRate_min": "0.0",
"usage_sum": "519.55",
"username": "red1",
"vlan": "1028",
"vnid": "--"
},
{
"aaaServerIp": "192.168.111.85",
"apGroup": "Floor3_TYPICAL_d02ec",
"assocDoneTimestamp": "06 Apr, 06:02:11 PM",
"authDoneTimestamp": "09 Apr, 01:34:28 PM",
"averageHealthScore_max": "10",
"averageHealthScore_median": "10",
"averageHealthScore_min": "10",
"connectedDeviceName": "APCC16.7EDE.7C08",
"connectionStatus": "Connected",
"dataRate_median": "72.0",
"deviceType": "Wireless",
"dhcpDoneTimestamp": "06 Apr, 06:02:16 PM",
"dhcpServerIp": "192.168.111.87",
"dot11Protocol": "802.11ac",
"frequency": "5.0",
"hostName": "V1-JUMPBOX2",
"ipv4": "172.16.114.208",
"ipv6": "--",
"lastUpdated": "09 Apr, 02:00:00 PM",
"linkSpeed": "--",
"macAddress": "50:3E:AA:4F:00:4D",
"maxDhcpDuration_max": "1359",
"onboardingEventTime": "09 Apr, 01:34:28 PM",
"rssi_median": "-50.0",
"rxBytes_sum": "158.72",
"rxRate_avg": "13542.88",
"rxRate_max": "18008.89",
"rxRate_min": "0.0",
"site": "Global/North America/North Carolina - Research Triangle Park/RTP 10 - STILLWATER/Floor 3",
"snr_median": "39.75",
"ssid": "Cyclops",
"txBytes_sum": "162.2",
"txRate_avg": "13843.64",
"txRate_max": "18615.38",
"txRate_min": "0.0",
"usage_sum": "320.92",
"username": "black1",
"vlan": "0",
"vnid": "8193"
},
{
"aaaServerIp": "--",
"apGroup": "--",
"assocDoneTimestamp": "--",
"authDoneTimestamp": "--",
"averageHealthScore_max": "10",
"averageHealthScore_median": "10",
"averageHealthScore_min": "10",
"connectedDeviceName": "V1-FIAB1.dna.local",
"connectionStatus": "Connected",
"dataRate_median": "--",
"deviceType": "Wired",
"dhcpDoneTimestamp": "--",
"dhcpServerIp": "--",
"dot11Protocol": "--",
"frequency": "--",
"hostName": "--",
"ipv4": "172.16.11.108",
"ipv6": "fe80::5054:ddff:febb:59af",
"lastUpdated": "09 Apr, 02:00:00 PM",
"linkSpeed": "1000.0",
"macAddress": "52:54:DD:BB:59:AF",
"maxDhcpDuration_max": "--",
"onboardingEventTime": "--",
"rssi_median": "--",
"rxBytes_sum": "11.78",
"rxRate_avg": "1212.53",
"rxRate_max": "1270.51",
"rxRate_min": "0.0",
"site": "Global/North America/North Carolina - Research Triangle Park/RTP 10 - STILLWATER",
"snr_median": "--",
"ssid": "--",
"txBytes_sum": "0.88",
"txRate_avg": "90.45",
"txRate_max": "99.57",
"txRate_min": "0.0",
"usage_sum": "12.66",
"username": "--",
"vlan": "1021",
"vnid": "--"
},
{
"aaaServerIp": "192.168.111.85",
"apGroup": "Floor3_TYPICAL_d02ec",
"assocDoneTimestamp": "06 Apr, 05:43:41 PM",
"authDoneTimestamp": "09 Apr, 01:40:05 PM",
"averageHealthScore_max": "10",
"averageHealthScore_median": "10",
"averageHealthScore_min": "1",
"connectedDeviceName": "APCC16.7EDE.7C08",
"connectionStatus": "Connected",
"dataRate_median": "87.0",
"deviceType": "Wireless",
"dhcpDoneTimestamp": "06 Apr, 05:43:43 PM",
"dhcpServerIp": "192.168.111.87",
"dot11Protocol": "802.11ac",
"frequency": "5.0",
"hostName": "V1-CLIENT1",
"ipv4": "172.16.111.209",
"ipv6": "--",
"lastUpdated": "09 Apr, 02:00:00 PM",
"linkSpeed": "--",
"macAddress": "00:E0:4C:29:67:7D",
"maxDhcpDuration_max": "2044",
"onboardingEventTime": "09 Apr, 01:40:05 PM",
"rssi_median": "-41.0",
"rxBytes_sum": "103.7",
"rxRate_avg": "7077.52",
"rxRate_max": "11512.62",
"rxRate_min": "0.0",
"site": "Global/North America/North Carolina - Research Triangle Park/RTP 10 - STILLWATER/Floor 3",
"snr_median": "49.0",
"ssid": "Wolverine",
"txBytes_sum": "111.59",
"txRate_avg": "7618.92",
"txRate_max": "12525.16",
"txRate_min": "0.0",
"usage_sum": "215.28",
"username": "blue1",
"vlan": "0",
"vnid": "8189"
},
{
"aaaServerIp": "--",
"apGroup": "--",
"assocDoneTimestamp": "--",
"authDoneTimestamp": "--",
"averageHealthScore_max": "1",
"averageHealthScore_median": "1",
"averageHealthScore_min": "1",
"connectedDeviceName": "V1-FIAB1.dna.local",
"connectionStatus": "Connected",
"dataRate_median": "--",
"deviceType": "Wired",
"dhcpDoneTimestamp": "--",
"dhcpServerIp": "--",
"dot11Protocol": "--",
"frequency": "--",
"hostName": "--",
"ipv4": "169.254.107.106",
"ipv6": "--",
"lastUpdated": "09 Apr, 02:00:00 PM",
"linkSpeed": "1000.0",
"macAddress": "64:F6:9D:37:97:1E",
"maxDhcpDuration_max": "--",
"onboardingEventTime": "--",
"rssi_median": "--",
"rxBytes_sum": "46.16",
"rxRate_avg": "783.98",
"rxRate_max": "1824.21",
"rxRate_min": "0.0",
"site": "Global/North America/North Carolina - Research Triangle Park/RTP 10 - STILLWATER",
"snr_median": "--",
"ssid": "--",
"txBytes_sum": "5.44",
"txRate_avg": "92.33",
"txRate_max": "691.56",
"txRate_min": "0.0",
"usage_sum": "51.6",
"username": "64-F6-9D-37-97-1E",
"vlan": "1",
"vnid": "--"
}
],
"filters": [
{
"displayName": "Location",
"name": "Location",
"values": []
},
{
"displayName": "Device Type",
"name": "DeviceType",
"values": [
""
]
},
{
"displayName": "SSID",
"name": "SSID",
"values": []
},
{
"displayName": "Band",
"name": "Band",
"values": []
},
{
"displayName": "Start Time",
"name": "startTime",
"values": [
"2021-04-02 14:44:51.189 PM UTC"
]
},
{
"displayName": "End Time",
"name": "endTime",
"values": [
"2021-04-09 14:44:51.189 PM UTC"
]
}
]
}
04-09-2021 08:20 AM
Brilliant!! Thank you very much! This is exactly what I was looking for!
04-09-2021 08:29 AM
@Tomas de Leon,
Is there any public documentation on the APIs you mentioned here? Or is this Cisco internal? Just wondering for future reference.
04-09-2021 09:55 AM
Intent API
Cisco DNA Center Platform v. 1.2.10
https://pubhub.devnetcloud.com/media/dna-center-api-1210/docs/swagger_dnacp_1210.html#%21/
CIsco DNA Center Platform v. 1.3.0.x
https://developer.cisco.com/docs/dna-center/api/1-3-0-x/
Cisco DNA Center Platform v. 1.3.1.x
https://developer.cisco.com/docs/dna-center/api/1-3-1-x/
Cisco DNA Center Platform v. 1.3.3.x
https://developer.cisco.com/docs/dna-center/#%21cisco-dna-1-3-3-x-api-overview
Cisco DNA Center Platform v. 2.1.2.x
https://developer.cisco.com/docs/dna-center/#%21cisco-dna-2-1-2-x-api-overview
SDK (Python)
https://developer.cisco.com/docs/dna-center/#%21python-sdk-getting-started
Cisco DNA Center Multivendor SDK
https://developer.cisco.com/docs/dna-center/#%21multivendor-sdk-overview/overview
Cisco EN Programmability
https://github.com/cisco-en-programmability
04-10-2021 07:59 AM
Which of those should describe the DNACaaP Api?
04-10-2021 11:01 AM
Unfortunately, not all of the APIs are documented or exposed. But they are adding more and more to the documentation.
The way to discover undocumented APIs is to use your browsers Developer tools and from there you can decipher the API calls and the necessary parameters.
I hope this helps
T.
04-11-2021 05:14 AM
Definitely helpful! Thanks Tomas!
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide