query for getting hostname of machine on which a specific task running (taskmanager)

Solved140 viewsdashboard query
0
0 Comments

I have several Windows computers with a specific alarm template. What does a query in a dashboard have to look like so that I can see on which of these computers a specific task is running.
If I filter the list in the Task Manager, I find the right task list, but the computer host name is not listed anywhere. So I would have to somehow manage a join to get to the element in which this task list is located.

Peter Kindl Selected answer as best 2nd December 2024

1 Answer

0
16.68K 1 Comment

Hi Peter,

You can perform an inner join operation to get the element name corresponding to the monitored task. Below an example:

  • Data Source: Get parameters for elements where
  • Type: Protocol
  • Protocol Name: Microsoft Platform
  • Version: Production (or the version that the elements are currently using)
  • Parameters: Task Manager
  • Select: Parameters that will be displayed in the result of your query.
    Don't forget to include the column 'Element ID'. This column will be used for the Inner join operation.
  • Join operator
  • Type: Inner
  • Data Source: Get elements
  • Select: Columns 'Element ID' and 'Name'
  • Joint "Element ID"on "Element ID"

Below the result of the query:

Hope it helps.

Peter Kindl Posted new comment 2nd December 2024
Peter Kindl commented

Thank you so much!!!
Works like charm!!!!!