Forum Discussion

David_Bond's avatar
David_Bond
Icon for Professor rankProfessor
2 months ago

LogicMonitor Datamart (Free / Open Source)

We have created a free (as in beer), open source LogicMonitor Datamart.

It creates a Postgres or SQL Server LogicMonitor Datamart for all common LogicMonitor data types, meaning you can now just use SQL to query all your LogicMonitor data.  There are certain limitations around time series data.

If you are a .NET developer, check out the nuget here: LogicMonitor.Datamart and the source code on Github .

We use this as the basis of our flagship Reporting system for our larger MSP customers.

The codebase is mature, and up-to-date to LogicMonitor v211.  We don't have a simple deployment wrapper yet, but we want to get community feedback, so we mature the deployment process, some (free) assistance will be provided to set this up for the first five takers.

DM me if you are interested.  First come first served.

If you are not ready to deploy, but generally interested in the concept, please provide feature requests or ask questions in reply to this post.

  • Following on from this post, we will shortly be publishing Docker images and Helm charts.  Standby!

  • By popular demand, the Docker image is now live!  Full documentation, including links to the support forum can be found here:

    https://www.panoramicdata.com/open-source/logicmonitor-datamart/ 

    A quick-start video should follow later this week!  Lots of feedback please - we want to make this useful for every power LogicMonitor user.  Would a UI be useful?  Example SQL statements?  Please let us know!

     

  • Update: Short video "advert" now live on Linked In!

    https://www.linkedin.com/posts/davidbond_set-up-your-free-logicmonitor-datamart-today-activity-7259230845515755520-OcJW/

  • Definitely interested in keeping track of this project.  I don't specifically have a use for it yet, but sounds like an awesome starting point for some cool solutions.