topic Re: Complex WQL queires in Extension 2.0? in Extensions

Complex WQL queries in Extension 2.0

tarjei — Fri, 15 Dec 2023 16:24:05 GMT

(Get-WmiObject -Query "select * from MSCluster_Resource where type='IP Address'" -namespace "root\mscluster").privateproperties

In Powershell I can quite easily do the following:

(Get-WmiObject -Query "select * from MSCluster_Resource where type='IP Address'" -namespace "root\mscluster").privateproperties

This will provide me with the expanded information from the privateproperties of the MSCluster_Resource type.

Is it possible to the same using WQL in Extension 2.0?

Re: Complex WQL queires in Extension 2.0?

ChadTurner — Thu, 03 Aug 2023 19:56:11 GMT

I dont think so as Dynatrace uses their own language - DQL

Re: Complex WQL queires in Extension 2.0?

Mike_L — Thu, 03 Aug 2023 20:15:43 GMT

DQL is something else than what is being used in the extension framework. WMI declarative extensions uses WQL.

Re: Complex WQL queires in Extension 2.0?

Mike_L — Thu, 03 Aug 2023 20:16:51 GMT

You cannot access additional attributes on the returned query, you’d have to make it all part of the query. Is there a reason that you cannot in this case?

Re: Complex WQL queires in Extension 2.0?

tarjei — Mon, 14 Aug 2023 08:34:38 GMT

Hi Mike!

As far as I have been able to figure out, there is no way of writing this as a WQL. And believe me I have tried.
If you have knowledge otherwise please do let me know.

Re: Complex WQL queires in Extension 2.0?

Mike_L — Tue, 15 Aug 2023 12:30:33 GMT

I didn't try but if it won't be returned like this I think you're stuck with Python in EF1, reaching out to our services team for Python in EF2, or setting up a task that feeds the result in through the OneAgent endpoints.

wmiNamespace: root\mscluster query: SELECT PrivateProperties FROM MSCluster_Resource WHERE type='IP Address'

Re: Complex WQL queires in Extension 2.0?

tarjei — Tue, 22 Aug 2023 12:41:11 GMT

Ok,

So basically we are stuck with waiting on DT to release python for ext2 in the wild?
We have basically 99% of the functionality, but not the remaining 1%