topic Re: Create Custom Metric from missing log entries in Log Analytics

Create Custom Metric from missing log entries

detk72 — Thu, 20 Feb 2025 17:20:36 GMT

Hi,

I created a metric "cluster-availability" using Log Monitoring - Metric extraction (mointoring availability of a JDBC database by checking the log entries which are ingested by custom extension/SQL data source). In this way I get the value of availability which I can use in chart.

I want to create a metric that shows the unavailability which would concern the missing datapoints of metric "cluster-availability"

How can I do this?

Thank you very much for your help.

Re: Create Custom Metric from missing log entries

marco_irmer — Fri, 07 Mar 2025 23:42:30 GMT

What does your metric data look like during times of unavailability? Are you getting 'null' values or something else?

Re: Create Custom Metric from missing log entries

detk72 — Mon, 10 Mar 2025 08:41:50 GMT

Hi there,

Thanks for your reply. During times of unavailability it's lacking datapoints, since in this case datapoints are only created when the cluster is available. I could use the default(0,always)


db_cluster.avail:filter(eq("dt.entity.custom:my_db_cluster",CUSTOM_DEVICE-XXXX)):splitBy("dt.entity.custom:my_db_cluster"):default(0,always)

So I could set "0" for the missing datapoint.

Thanks for your support.

Re: Create Custom Metric from missing log entries

PacoPorro — Mon, 10 Mar 2025 11:50:10 GMT

You can use Missing data alert parameter.
https://docs.dynatrace.com/docs/shortlink/anomaly-detection-configuration#missing-data

Re: Create Custom Metric from missing log entries

detk72 — Mon, 10 Mar 2025 14:14:01 GMT

Hi,

Thanks for your reply. The anomaly detection/missing-data is in place. However additonally the requirement is to display the unavailbity within a chart oder dashboard.

Kind regards,