• 0
DanB

Is there a way to export data source to a template file; CSV?

Question

So we are in the final phases of rolling out LogicMonitor and now the daunting process of Alert Tuning has rolled upon us. In our old monitoring solution we has it very much tweaked and customized and overall all alerts were around ~400-600ish. 

In LogicMonitor we are currently at 13000+. We need to seriously tune up the Datasources and we need a way to show our SME's what each datasource is monitoring and what it alerts on, what thresholds, etc.. 

Is there a way to export the Datasource's Monitoring Template to a CSV file so that we can reference that and our SME's can then say turn off, adjust etc..

I see in the reports section there is a "Alert Threshold Report" but that lists out every single datapoint instance on a group/resource and we don't want that.
We need what the base DS template looks at and uses and applies to each matching resource.

 

 

Share this post


Link to post
Share on other sites

5 answers to this question

Recommended Posts

  • 0

Not sure I get why the report doesn't fit the bill. Feel free to expound on that.

In the meantime, to summarize your needs: for each DataSource that has instances, show each datapoint's name, description, and threshold (if there is a threshold). Is that right? I can probably spend some time mapping out which API calls you'd need to do for this.

As an incentive to me (i'm mostly joking, i'm already looking in postman at the api calls to do this) can i get a little quid pro quo? I need customer feedback on this.

Share this post


Link to post
Share on other sites
  • 0

Short answer is that you can export the XML definition of any DataSource by navigating to the DS under Settings>>DataSources. Under More, there's an Export function. 

image.png.c549ed3c788239ea949c7ef32244c0d1.png

Share this post


Link to post
Share on other sites
  • 0

Hey Stu,

So as an MSP, we get asked all the time from client(s) and new potential new clients what'sour monitoring template for each different technology.

We needed to create an excel sheet with each different Technology and then listed each UIM probe, what it collected and if it alerted what threshold it alerted at, the time it polled, samples etc.. 

Example Windows Base Template:

image.thumb.png.9aa1e33c99bb57b972522fa95b962396.png

We had an excel workbook with 30+ different technologies each on their own tab that were the mostly commonly in use and could share that with clients.

I saw that export option but that isn't going to help b/c that exports into XML. I need a csv format. I can't send an xml to client(s) and say go read that.  😛

Regarding your questions:

Not sure I get why the report doesn't fit the bill. Feel free to expound on that.

>> B/c that lists every single datapoint instance. I need just the general what would be picked up by the monitoring tool. (See pic above)

In the meantime, to summarize your needs: for each DataSource that has instances, show each datapoint's name, description, and threshold (if there is a threshold). Is that right? 

>> Yes this is correct. Exactly or as similar to what's listed in the pic above. 

As an incentive to me can i get a little quid pro quo?

>> I know many LM users get asked this all the time. I know we did and will and will need to re-create this with LM as our new tool.

 

Share this post


Link to post
Share on other sites
  • 0

What if you did this: start with the report in CSV format. Only include these columns in the report. Then just remove the duplicates from the report. I know it involves post-processing the output, but take a look and see if that gets you what you want. I ended up with 1440 thresholds, but I have a bunch of group, device, and instance level thresholds. You could exclude those as well just by filtering on the ThresholdType column. 

image.png.ef37836ba503bf171a6db161887e7d7a.png

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.