SLA report based on device uptime during "Last calendar Month"?
Hello! My challenge is how to calculate proper SLA time (in minutes) during the last calendar month. Currently the Threshold must be set manually. The problem is that manymonths have different amount of minutes so single value might notgive 100% correct result. Having dynamic thresholds would be much better option. Thank you!9Views0likes1CommentUsing PropertySources for Reporting
PropertySources are one of the recent additions to LogicModules, they were introduced in v.83 (https://www.logicmonitor.com/release-notes/v-83-scriptable-properties-dashboards-report-two-factor-authentication/). They are a very powerful feature and you can use them for many other purposes other than just showing a Cisco Serial Number which is a common use case for this feature. I am going to focus this post on using PropertySources to improve a Device Inventory Report. For example, you have hundreds or thousands of SNMP devices being monitored and you want to know if any of the devices are having an issue collecting data through SNMP. It is not a viable solution to go through the device one by one and check if LogicMonitor collects data from them. Fortunately, there is an easy way on how to get this information using Device Inventory Report and PropertySources. The idea is to create a property source that can add a host property to a device if SNMP is not working, then we can create a device inventory report to show this property. Here is a sample of PropertySource that go through all SNMP devices and adds a host property called auto.snmp.working=no if SNMP is not working on a device. // import the logicmonitor snmp helper class import com.santaba.agent.groovyapi.snmp.Snmp; // getthesnmp host from the device properties def host = hostProps.get('system.hostname'); // retrieve the value for the specified OID try { oid_value = Snmp.get(host, ".1.3.6.1.2.1.1.1.0"); println "snmp.working=yes" } catch (Exception ex) { println "snmp.working=no"; } return (0); Then we can easily create a Device Inventory Reports and add this specific host property.Here is how the report looks like Another use case would be to build a device inventory report that shows a piece of basic information,such as the number of CPU cores or system memory of a Windows server. Some information such assystem.totalmemory is available by default, so we should be able to pull this information directly from the devices. To get a number of CPU cores on a Windows server,here is a sample property source that pulls that information. You can easily add other information such as total memory or even processor type and so on. // This script counts the total number of processor cores across all processors on a device import com.santaba.agent.groovyapi.win32.WMI; def hostname = hostProps.get("system.hostname"); try { def wmiResponse = WMI.queryAll(hostname, "select NUMBEROFCORES from Win32_Processor"); def totalcores = 0; wmiResponse.each { corecount -> totalcores += (corecount.get('NUMBEROFCORES')).toInteger(); } println "Windows_CPUcorecount=" + totalcores; } // Catch any exceptions that may have occurred catch (Exception e) { //print exception out and return non- zero println e; return 1; } //Exit by returning zero return 0; Here is a sample of Device Inventory report with the PropertySources added. This is just of one of the things that you can do using PropertySources. You can also use PropertySources as applies to fieldin Datasourcesor even Alert Rules.5Views0likes0CommentsReports - Device Inventory - Why define a datasource?
Scenario -- I have a device group with a mix of AWS EC2 with Local Collector, EC2 withonly the cloud collector, RDS instances, and Load Balancers. I went and created a deviceinventory report to grab some info about EC2 tags. It asks for a datasource, so I've tried a few--"Ping", "HostStatus", "AWS_EC2". No matter which I select, the resulting report has all devices--EC2, ELBs, RDS--regardless of the datasource selection. So obviously the datasource selection in this report type doesn't mean what I think it means. So what is this option used for?3Views0likes1CommentExecutive summary report for Usage
currently i don't see any template where i can get detailed usage report of customer (i.e. Group) with details of CPU, Memory, Disk, Network in single report. there is an option we can do with device metric trends but we have enter all Data points which is going to be a huge task when we are talking about multiple groups who's with huge amount of servers. There has to be templates around to get execute summary (Management, CIO reports)with details of monitoringsystem and few for utilization like this.. etc..3Views0likes1CommentReports UI - Users with View access SHOULD NOT see reports generated by other users
I love the Reports UI but my users who have only View access to Reports or any given Report Group SHOULD NOT be able to see the reports generated by other users. The previously generated reports are great, but they are hosted in S3 and don't check against the user roles we have assigned to our users. We have a common set of reports that all of our clients use and when they run them on-demand in the old UI, that's all they get--that particular run. Client ABC can now see a version of a report that was run by Client XYZ by clicking on a link. Not good. Making all runs of a report available for all users with access to those reports creates a management headache.2Views1like1CommentBetter UI for Report Filters
We waste a lot of productive time trying to figure out GLOB expressions, or supporting our non-programmer users with GLOB expressions. It would be super awesome if you could simply give us something based onthe device tree navigator control from the Role definition editor view, so users canuse that to select resource groups to include in a report. We prefer to give our users self service abilities, but GLOBs mean users have to come to engineering when they need to filter information from a report.1View0likes0CommentsCombined Reports
I want to be able to send customers a monthly report that is a combination of several other reports. So we need a way to multi select reports to create a combined report that will send a single email with a single report that contains the contents of the selected reports. For example I have SLA reports setup for CPU, Memory, and DiskUsage and I have a report that shows a list of all alerts of level Error and above. These are fourseparate reports. I would like to be able to combine all of these into a single report that gets emailed to the customer. Any ideas how this could be done? Gary1View0likes4CommentsEnhanced Reports with Graphs and Alert Trending
As we have implemented LogicMonitor we have worked to stabilize and tune alerts as well as to remediate real problems identified by alerts. To track this progress we wanted to graph the alerts overtime. We sort the alerts into several categories such as severity, group, device. To do this we have to create a detailed report, pull the data into Excel and create pivot tables and pivot charts. Create alert trend charts in LogicMonitor reports, directly, would be a valuable tool for teams working to drive down the alert counts. Attached is a simple graph we have created multiple times in Excel as an example. We have others. Thanks. Todd Kelley1View0likes4Comments