I have DPA 12.1.698 installed using MySQL 5.7.9 (hey, it's free - don't judge ). I want to run queries directly against the DPA repository to yield the same results as Perfstack would. Longer story but I am unable to leverage Perfstack reports due to PS being a bit inflexible in a few areas. Aside from that, when I export a Perfstack report to CSV, I get something like the example below. What would a MySQL query look like against the DPA repository? I assume for other metrics it will be as simple as changing the metric name I'm looking for?
Entity | Metric | Date/Time | Value |
SOMESERVER (DPASERVER) | O/S Memory Utilization (%) | 4/30/2019 | 86 |
SOMESERVER (DPASERVER) | O/S Memory Utilization (%) | 5/1/2019 | 86 |
SOMESERVER (DPASERVER) | O/S Memory Utilization (%) | 5/2/2019 | 87 |
SOMESERVER (DPASERVER) | O/S Memory Utilization (%) | 5/3/2019 | 87 |
SOMESERVER (DPASERVER) | O/S Memory Utilization (%) | 5/4/2019 | 89 |
SOMESERVER (DPASERVER) | O/S Memory Utilization (%) | 5/5/2019 | 86 |
SOMESERVER (DPASERVER) | O/S Memory Utilization (%) | 5/6/2019 | 69 |
SOMESERVER (DPASERVER) | O/S Memory Utilization (%) | 5/7/2019 | 47 |
SOMESERVER (DPASERVER) | O/S Memory Utilization (%) | 5/8/2019 | 53 |
SOMESERVER (DPASERVER) | O/S Memory Utilization (%) | 5/9/2019 | 60 |
SOMESERVER (DPASERVER) | O/S Memory Utilization (%) | 5/10/2019 | 65 |
SOMESERVER (DPASERVER) | O/S Memory Utilization (%) | 5/11/2019 | 91 |
SOMESERVER (DPASERVER) | O/S Memory Utilization (%) | 5/12/2019 | 91 |
SOMESERVER (DPASERVER) | O/S Memory Utilization (%) | 5/13/2019 | 91 |
SOMESERVER (DPASERVER) | O/S Memory Utilization (%) | 5/14/2019 | 90 |
SOMESERVER (DPASERVER) | O/S Memory Utilization (%) | 5/16/2019 | 88 |
SOMESERVER (DPASERVER) | O/S Memory Utilization (%) | 5/17/2019 | 88 |
SOMESERVER (DPASERVER) | O/S Memory Utilization (%) | 5/18/2019 | 91 |
SOMESERVER (DPASERVER) | O/S Memory Utilization (%) | 5/19/2019 | 91 |
SOMESERVER (DPASERVER) | O/S Memory Utilization (%) | 5/20/2019 | 91 |
SOMESERVER (DPASERVER) | O/S Memory Utilization (%) | 5/21/2019 | 91 |
SOMESERVER (DPASERVER) | O/S Memory Utilization (%) | 5/22/2019 | 89 |
SOMESERVER (DPASERVER) | O/S Memory Utilization (%) | 5/23/2019 | 85 |
SOMESERVER (DPASERVER) | O/S Memory Utilization (%) | 5/24/2019 | 86 |
SOMESERVER (DPASERVER) | O/S Memory Utilization (%) | 5/25/2019 | 90 |
SOMESERVER (DPASERVER) | O/S Memory Utilization (%) | 5/28/2019 | 57 |
SOMESERVER (DPASERVER) | O/S Memory Utilization (%) | 5/29/2019 | 63 |
SOMESERVER (DPASERVER) | O/S Memory Utilization (%) | 5/30/2019 | 67 |
SOMESERVER (DPASERVER) | O/S Memory Utilization (%) | 5/31/2019 | 71 |