9 Replies Latest reply on Jul 9, 2019 11:49 AM by mandevil

    How to query DPA database to get same metrics as Perfstack through DPAIM

    tony.fountain@wtainc.com

      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?

       

      EntityMetricDate/TimeValue
      SOMESERVER (DPASERVER)O/S Memory Utilization (%)4/30/201986
      SOMESERVER (DPASERVER)O/S Memory Utilization (%)5/1/201986
      SOMESERVER (DPASERVER)O/S Memory Utilization (%)5/2/201987
      SOMESERVER (DPASERVER)O/S Memory Utilization (%)5/3/201987
      SOMESERVER (DPASERVER)O/S Memory Utilization (%)5/4/201989
      SOMESERVER (DPASERVER)O/S Memory Utilization (%)5/5/201986
      SOMESERVER (DPASERVER)O/S Memory Utilization (%)5/6/201969
      SOMESERVER (DPASERVER)O/S Memory Utilization (%)5/7/201947
      SOMESERVER (DPASERVER)O/S Memory Utilization (%)5/8/201953
      SOMESERVER (DPASERVER)O/S Memory Utilization (%)5/9/201960
      SOMESERVER (DPASERVER)O/S Memory Utilization (%)5/10/201965
      SOMESERVER (DPASERVER)O/S Memory Utilization (%)5/11/201991
      SOMESERVER (DPASERVER)O/S Memory Utilization (%)5/12/201991
      SOMESERVER (DPASERVER)O/S Memory Utilization (%)5/13/201991
      SOMESERVER (DPASERVER)O/S Memory Utilization (%)5/14/201990
      SOMESERVER (DPASERVER)O/S Memory Utilization (%)5/16/201988
      SOMESERVER (DPASERVER)O/S Memory Utilization (%)5/17/201988
      SOMESERVER (DPASERVER)O/S Memory Utilization (%)5/18/201991
      SOMESERVER (DPASERVER)O/S Memory Utilization (%)5/19/201991
      SOMESERVER (DPASERVER)O/S Memory Utilization (%)5/20/201991
      SOMESERVER (DPASERVER)O/S Memory Utilization (%)5/21/201991
      SOMESERVER (DPASERVER)O/S Memory Utilization (%)5/22/201989
      SOMESERVER (DPASERVER)O/S Memory Utilization (%)5/23/201985
      SOMESERVER (DPASERVER)O/S Memory Utilization (%)5/24/201986
      SOMESERVER (DPASERVER)O/S Memory Utilization (%)5/25/201990
      SOMESERVER (DPASERVER)O/S Memory Utilization (%)5/28/201957
      SOMESERVER (DPASERVER)O/S Memory Utilization (%)5/29/201963
      SOMESERVER (DPASERVER)O/S Memory Utilization (%)5/30/201967
      SOMESERVER (DPASERVER)O/S Memory Utilization (%)5/31/201971