I'm becoming more and more the structural resource for SW, and we are pulling VPN stats for a SLT report and we'd like to pull data from the SW DB to a format that our Tableau developers can import into a report. From us, they want Peak VPN usage for the previous day.
We are also in the process of stabilizing one of our SW instance, as we're a pretty large company, and monitor 120,000+ elements per instance, and have had some issues scaling, and the CLI polling of ASA's is not working well, and it appears is taxing our DB for some queries.
I've built UnDP for VPN data, and get, per Cisco ASA, VPN active remote access users for four ASA's in a multiple UnDP poller chart, and then a second chart is set to Sum the total. I want to get out that sum total via API, if possible into what the tableau developer needs.
any hints would be appreciated.
Any