Visualizing what we talked about on the phone with Grafana

Well, in this post we will see something as always different and that we can simply add to our Grafana installation, and it is nothing more than exploiting the usage data of our phone calls. I've been using it for a long time and I wanted to share it in case you're interested, I was curious how much I talked on my mobile phone, with whom, what they called me and I called, See it by schedules, people… with nougat!

Visualizing IP addresses on a world map with Grafana

Well, This document is something particular, since it had a series of public IP addresses in a MySQL table, that I would like to visualize it in Grafana. Basically I'm talking about the visits to the blog 🙂 I have a WordPress and I don't have the database in my possession since it's on an external hosting… I leave you the steps I followed to achieve it, I hope it can be useful for other ideas.

Exploiting our Citrix farm with Grafana

Good, I leave you a post where we see how we can exploit the information stored by Citrix in its databases. As I imagine you know, Citrix stores in a database the records of what happens on our Citrix farm, but that is true, as much as you pay, as much as you get, that is, which depends on the Edition we have, Citrix will store information in those databases for 1 week, or 1 month or 1 year. Here we will see how to make our own panels with Grafana and without date limits!

Monitoring MySQL database queries using Centreon

Another marvel of monitoring with Centreon, is that it allows us to make queries to any type of database, in this post we will see how to query a MySQL database, We can launch any type of query that helps us to know the state or value that interests us, then we will be able to know that there are no blockages or that 'something’ He has not stopped writing on his table…

Monitoring a specific date

In this article we will see something different and that we can give it the use we need, and it is nothing more than being able to monitor a day or a specific date and let us know as the day approaches. An ideal and practical example, Well, to have centralized when the licenses or maintenance of each software/hardware that we have acquired expire, For example; or, My birthday, the 12 and congratulate 😉 me

Monitoring the status of our Xiaomi Mi Vacuum robot vacuum cleaner in Grafana

If we have the wonderful and all-powerful Xiaomi robot vacuum cleaner and you want to visualize its data in a Grafana dashboard, This is your post! In it we will see how to connect to the vacuum cleaner, how we can ask you questions and obtain all kinds of interesting data, and then store it in a MySQL database that we will attack with Grafana to visualize and process these metrics.