Forum Discussion

Matt_Whitney's avatar
Matt_Whitney
Icon for Expert rankExpert
24 days ago

Aggregate Reporting by instance or property

I would like to request an enhancement to resource metric trend reporting. Could either be a new type of report or a new option on the existing resource metric trends report type.

We have a use case where we need to report on what specific process is using the most CPU across a large group of servers. The best way to do this would be to sum up the CPU usage across all processes on all servers, then list the process name and their total CPU consumption over a defined time period.

To meet that use case we currently have to run a regular resource metric trends report and then do some processing on the data in Excel to group by instance name and sum up the totals.

My feature request is to allow us to report this way natively within LM. To allow us to report on metrics and group/aggregate the data by instance name or even a property name.

1 Reply

  • Matt_Whitney's avatar
    Matt_Whitney
    Icon for Expert rankExpert
    24 days ago

    Below are 2 examples where this type of reporting would be useful.

    1. Instance-based
      • There is a datasource that monitors CPU usage by process and the instance name is the name of the Windows process. We need to report on what process name has the highest CPU consumption among a large group of servers. We should be able to do this by running a report and selecting an option to group by instance name
    2. Property-based
      • The Network Interface datasource monitors port throughput. Would be useful to report on the throughput and group by the location property to see which locations have the highest throughput. We should be able to do this by running a report and selecting an option to group by the location property.
      • Also would be helpful to give us the option to filter on instance description so we can specify which instances get included in the aggregate calculation.