topic Re: Host List without Management Zone in Open Q&A

Host List without Management Zone

gbaudart — Tue, 23 Jan 2024 14:50:17 GMT

Hi Community,

I'd like to output a list of Hosts that are not in a ManagementZone.
The EntitySelector does not allow us to do this.

Do you have an idea?

Re: Host List with no Mz

AntonPineiro — Tue, 23 Jan 2024 09:45:24 GMT

Hi,

I would say using entities API:

Call entities API to get a full host list.
Call entity API per host ID in before query.

Second one is providing much more information than mz, but you can see if that host has a MZ or not:

Best regards

Re: Host List with no Mz

gbaudart — Wed, 24 Jan 2024 15:54:22 GMT

Isn't there an easier way to get the information?

Re: Host List with no Mz

PraWij — Wed, 24 Jan 2024 16:29:36 GMT

This may help, part of a dashboard - not my code, from a DT SME.

import { monitoredEntitiesClient } from '@dynatrace-sdk/client-classic-environment-v2'; export default async function() { // Check if that tile should be activated based on selected indicators and scope if($Indicators[0] === "All" || $Indicators.includes("hostGroupCoverage")) { let scope; if($Scope[0] === "Tenant") { scope = 'Tenant'; } else { let mzList = ""; for(let i=0; i<$Scope.length; i++) { mzList += i === 0 ? `"${$Scope[i]}"` : `,"${$Scope[i]}"`; } scope = mzList; } // Define entity selector based on the selected scope let entitySelector; if(scope === "Tenant") { entitySelector = 'type("HOST"),isMonitoringCandidate(false)'; } else { entitySelector = `type("HOST"),isMonitoringCandidate(false),mzName(${scope})`; } let config = { from: `now-1d`, entitySelector: entitySelector}; // Get all monitored hosts const monitoredHosts = await monitoredEntitiesClient.getEntities(config); // Define entity selector based on the selected scope if(scope === "Tenant") { entitySelector = 'type("HOST"),isMonitoringCandidate(false),fromRelationships.isInstanceOf(type("HOST_GROUP"))'; } else { entitySelector = `type("HOST"),isMonitoringCandidate(false),fromRelationships.isInstanceOf(type("HOST_GROUP")),mzName(${scope})`; } config = { from: `now-1d`, entitySelector: entitySelector}; // Get all monitored hosts that are assigned with a host group const hostsWithHostGroup = await monitoredEntitiesClient.getEntities(config); // Compute host group coverage const hostGroupCoverage = parseInt(hostsWithHostGroup.totalCount/monitoredHosts.totalCount*100); // Compute local score based on the host group coverage const score = hostGroupCoverage === 100 ? 1 : (hostGroupCoverage >= 80 ? 0.5 : 0); let result; switch(true) { case score === 1: result = `✅ ${hostGroupCoverage}%`; break; case score === 0.5: result = `💡 ${hostGroupCoverage}%`; break; case score === 0: result = `⚠️ ${hostGroupCoverage}%`; break; } // Return the emojied result return result; } else { return "N/A"; } }

Re: Host List with no Mz

AntonPineiro — Wed, 24 Jan 2024 17:14:08 GMT

Hi,

Maybe easier can be using Grail, if it is enabled in your tenant. I think you know more Grail than mine but something as that:

fetch dt.entity.host | expand managementZones | filter managementZones == ""

Best regards

Re: Host List with no Mz

gbaudart — Wed, 24 Jan 2024 19:51:55 GMT

hi @PraWij,

Thanks for this code.

OK, but what are the $Indicators and $Scope variables?

Re: Host List with no Mz

gbaudart — Wed, 24 Jan 2024 19:52:31 GMT

@AntonPineiro
This doesn't work. I'll try with the sdk

Re: Host List with no Mz

PraWij — Thu, 25 Jan 2024 17:22:32 GMT

In the full dashboard, scope also includes the mgmt zones.

Indicators example:

Re: Host List with no Mz

AntonPineiro — Sat, 27 Jan 2024 17:42:40 GMT

Hi,

You can try this one, looks like is working:

fetch dt.entity.host | fieldsAdd managementZones | filter isNull(managementZones)

Best regards

Re: Host List without Management Zone

MarwanC — Mon, 29 Jan 2024 12:11:35 GMT

This looks interesting,

fetch dt.entity.host
| fieldsAdd managementZones
| filter isNull(managementZones)

What do I need to add to search by a particular management zone? contains or equal? need the DQL.

Re: Host List without Management Zone

AntonPineiro — Mon, 29 Jan 2024 13:23:20 GMT

Hi,

Maybe more than one option but looks like this:

fetch dt.entity.host | fieldsAdd managementZones | filter matchesValue(managementZones, "XXXXXX")

Best regards

Re: Host List with no Mz

sujit_k_singh — Tue, 30 Jan 2024 06:05:41 GMT

@AntonPineiro This works for me. Thanks a lot.

Tijust

Re: Host List with no Mz

AntonPineiro — Tue, 30 Jan 2024 11:01:39 GMT

You are welcome!