cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Export DMI Report through DB query

raffaele_talari
Inactive

Hi,

is it possible, and in case how, to export a DMI report through a DB Query?
The customer needs to export daily a report (Time-User-Operation) with a 5 minutes timing.

Thank you,
Raffaele

9 REPLIES 9

Carl_Morphet
Dynatrace Mentor
Dynatrace Mentor

Hello Raffaele,

If I understand your requirements, this could be achieved through a scheduled report delivery (if you're CAS is connected to an SMTP server), build and save a custom DMI report which contains the data required then schedule it for delivery via email

Hi Carl,

thanks for your answer.

What I was really looking for is if it's possible to export the DMI Report with a direct SQL Query, without using the scheduled report delivery..

Thanks, Raffaele

saanjeith_varat
Inactive

Hey Raffele,

I believe the closest to what you want to achieve, is via a REST call to the CAS server.

Cheers,

Sanj

alex_napier
Inactive

Hi Raffaele,

I think the response to this will be no because the development team need to maintain the flexibility to change the schema between versions. There is a REST interface you can use to access the data and I've also done this with direct http calls that export data in CSV format but that's not a supported method.

REST documentation is here

regards,

Alex.

sandrine-extern
Advisor

Hello Carl,

This is not the most practical way if you want to inject some information directly to another application.

For instance, our customer would like to unify his monitoring tools dashboards into one unique dashboard that will show consolidated information coming from network, application performance, synthetic monitoring, java monitoring, hardware monitoring...

In this case, using a DB query is a lot easier than sending e-mails 😉

Regards,

Sandrine


Hey Sandrine,


To Sebastian's point, the CAS has an in-house caching engine to load particular data more quickly. Have you tried using the REST interface to pull data from DC RUM so you can export it to your single pane of glass solution? If not, I'd give it a shot and also check this out 🙂


Regards

chris_v
Dynatrace Pro
Dynatrace Pro

As covered already, direct access to the DB is not supported.

There's broadly 3 supported options

  1. REST API interface
  2. Scheduled email report
  3. Scheduled task export

1 and 2 have been covered already, 3 is probably what I see most commonly used when the export is destined for another system, rather than end user consumption.

I detailed option 3 here: https://answers.dynatrace.com/answers/135994/view....

Hello,

I would like to let you know that DC RUM 12.4 offers another way to access reports.

You only need to define a report (or a set of reports) that will be executed every at processing interval (default: 5 min) and their data will be stored on disk in CSV/zdata-like format. There is a simple REST API which enables to access those files from external systems, such as BSM or Splunk.

For the demo purposes we created as Splunk app which consumes data generated by DCRUM using this new API. You can play around with this app at https://apm.gdn.demo.dynatrace.com:8000/ (guest/guest). You can also download the app from https://community.dynatrace.com/community/display/PUBDCRUM/Splunk+plugin+for+DC+RUM

I would not recommend direct access though DB queries. The schema is pretty complex, plus you don't leverage DC RUM in-memory caching mechanism which in most cases speeds up report data acquisition time tremendously.

Regards,

Sebastian

@Sebastian Kruk, thanks for sharing! Much appreciated!