Data Access

[drwho17]

Has anybody constructed post to get data out of air control? I want to integrate some of it's info into our standard OSS system for technicians to troubleshoot wireless clients.

[sldnkarm]

Do you mean what is stored in the database?

Take a look at the database tables DEVICE and DEVICE_ATTR_VALUE.

Example:

SELECT * FROM DEVICE_ATTR_VALUE WHERE DEVICE_ID = '245'

182343 2010-01-05 16:04:26.52 0 0 0 2 245
182344 2010-01-05 16:04:26.52 625168 625168 625168 3 245
182345 2010-01-05 16:04:26.52 13034 13034 13034 4 245
182346 2010-01-05 16:04:26.52 0 0 0 5 245
182347 2010-01-05 16:04:26.52 2663 2663 2663 6 245
182348 2010-01-05 16:04:26.52 2412 2412 7 245
182349 2010-01-05 16:04:26.52 810 810 8 245
182350 2010-01-05 16:04:26.52 -35 -35 9 245
182351 2010-01-05 16:04:26.52 0 0 0 10 245
182352 2010-01-05 16:04:26.52 140 140 140 11 245
182353 2010-01-05 16:04:26.52 3150 3150 12 245
182354 2010-01-05 16:04:26.52 1 1 13 245
182355 2010-01-05 16:04:26.52 620329 620329 620329 14 245
182356 2010-01-05 16:04:26.52 0 0 0 15 245
182357 2010-01-05 16:04:26.52 0.0.0.0 16 245
182358 2010-01-05 16:04:26.52 0 0 0 17 245
182359 2010-01-05 16:04:26.52 11.0 11.0 18 245
182360 2010-01-05 16:04:26.52 2520 2520 2520 19 245
182361 2010-01-05 16:04:26.52 0 0 0 20 245
182362 2010-01-05 16:04:26.52 46 46 21 245
182363 2010-01-05 16:04:26.52 11.0 11.0 22 245
182364 2010-01-05 16:04:26.52 2553 2553 2553 23 245
182365 2010-01-05 16:04:26.52 611495 611495 611495 24 245
182366 2010-01-05 16:04:26.52 0 0 0 25 245
182367 2010-01-05 16:04:26.52 24 24 26 245
182368 2010-01-05 16:04:26.52 0 0 0 27 245
182369 2010-01-05 16:04:26.52 0 0 0 28 245
182370 2010-01-05 16:04:26.52 -98 -98 29 245
182371 2010-01-05 16:04:26.52 0 0 0 30 245
182372 2010-01-05 16:04:26.52 0.0.0.0 31 245
182373 2010-01-05 16:04:26.52 00:80:48:63:69:FC 32 245

[UBNT-Thomas]

Any data integration solution that we offer in the future will not be at the SQL level but through a published API. The database schema won't be public and may change at any time.

[drwho17]

Any data integration solution that we offer in the future will not be at the SQL level but through a published API. The database schema won't be public and may change at any time.
Thomas that is what I'm looking for, a published API. Any ideas how long before that's on the roadmap? I really don't want our tier1 techs having to login to yet another system, I'd rather just integrate the info required into our current OSS.

[UBNT-Thomas]

What data are you looking to get out of the API? List of all devices with current stats?