https://docs.microsoft.com/en-us/previous-versions/windows/desktop/sppwmi/softwarelicensingproduct

WQL : Select LicenseStatus From SoftwareLicensingProduct where ProductkeyID IS NOT NULL and Name like "Windows%"

What can return with this query

At ALL Agent v. 4.* versions all looks correct.
But at Agent2 5.0.10 WMI looks not fully working.

Not tested for Windows Agent\Agent2 5.2 or Agent 5.0.10

Direct request with WMIExplorer works fine.

But from test via Agent2 5.0.10 i always got "Empty result"

Item test

Expected result

Unexpected result

Hello,

Same thing for me :

2022/06/28 09:25:23.028253 plugin WindowsPerfMon: executing collector task
2022/06/28 09:25:23.479229 connection established using TLSv1.3 TLS_CHACHA20_POLY1305_SHA256
2022/06/28 09:25:23.479736 received passive check request: 'wmi.get[root\cimv2,"Select LicenseStatus From SoftwareLicensingProduct where ProductkeyID IS NOT NULL and Name like 'Windows%'"]' from 'x.x.x.x'
2022/06/28 09:25:23.479736 [1] processing update request (1 requests)
2022/06/28 09:25:23.479736 [1] adding new request for key: 'wmi.get[root\cimv2,"Select LicenseStatus From SoftwareLicensingProduct where ProductkeyID IS NOT NULL and Name like 'Windows%'"]'
2022/06/28 09:25:23.479736 [1] created direct exporter task for plugin 'Wmi' itemid:0 key 'wmi.get[root\cimv2,"Select LicenseStatus From SoftwareLicensingProduct where ProductkeyID IS NOT NULL and Name like 'Windows%'"]'
2022/06/28 09:25:23.479736 executing direct exporter task for key 'wmi.get[root\cimv2,"Select LicenseStatus From SoftwareLicensingProduct where ProductkeyID IS NOT NULL and Name like 'Windows%'"]'
2022/06/28 09:25:23.608464 failed to execute direct exporter task for key 'wmi.get[root\cimv2,"Select LicenseStatus From SoftwareLicensingProduct where ProductkeyID IS NOT NULL and Name like 'Windows%'"]' error: 'Empty WMI search result.'

2022/06/28 09:25:23.609048 sending passive check response: ZBX_NOTSUPPORTED: 'Empty WMI search result.' to 'x.x.x.x'

So I got a fail check at https://git.zabbix.com/projects/ZBX/repos/zabbix/browse/src/go/internal/agent/scheduler/task.go#296

wmi.get[root\cimv2,select status from Win32_DiskDrive where Name like '%PHYSICALDRIVE0%'] -> Work
wmi.get[root\cimv2,select LicenseStatus from SoftwareLicensingProduct where ProductkeyID IS NOT NULL and Name like '%Windows%'] -> Empty
wmi.get[root\cimv2,select LicenseStatus from SoftwareLicensingProduct where Name like '%Windows%'] -> Empty
wmi.get[root\cimv2,select LicenseStatus from SoftwareLicensingProduct where ProductkeyID IS NOT NULL] -> Empty
.\zabbix_agent2.exe -t wmi.getall["root\cimv2,select * from SoftwareLicensingProduct"]
wmi.getall[root\cimv2,select * from SoftwareLicensingProduct][m|ZBX_NOTSUPPORTED] [Timeout occurred while gathering data.]

and Get-WmiObject -Query "Select LicenseStatus From SoftwareLicensingProduct where ProductkeyID IS NOT NULL and Name like 'Windows%'" returns data.

Maybe related to https://support.zabbix.com/browse/ZBX-18643 ?

Another tests :

With getall, works

wmi.getall[root\cimv2,Select LicenseStatus From SoftwareLicensingProduct where Name like "Windows%" and ProductkeyID IS NOT NULL][s|[{"LicenseStatus":1}]]

With the uint32 LicenseStatus , not works

wmi.get[root\cimv2,Select LicenseStatus From SoftwareLicensingProduct where Name like "Windows%" and ProductkeyID IS NOT NULL][m|ZBX_NOTSUPPORTED] [Empty WMI search result.]

 with string Description, works

wmi.get[root\cimv2,Select Description From SoftwareLicensingProduct where Name like "Windows%" and ProductkeyID IS NOT NULL][s|Windows(R) Operating System, VOLUME_MAK channel]

with another uint32... not works

wmi.get[root\cimv2,Select LicenseStatusReason From SoftwareLicensingProduct where Name like "Windows%" and ProductkeyID IS NOT NULL][m|ZBX_NOTSUPPORTED] [Empty WMI search result.] 

But, works with GracePeriodRemaining a another uint32..

wmi.get[root\cimv2,Select GracePeriodRemaining From SoftwareLicensingProduct where Name like "Windows%" and ProductkeyID IS NOT NULL][s|0]

All tests before with zabbix_agent2 Win64 (Zabbix) 6.2.8

With non-go version, works :

wmi.get[root\cimv2,Select LicenseStatus From SoftwareLicensingProduct where Name like "Windows%" and ProductkeyID IS NOT NULL] [u|1]

Hello,

Can you provide a correction for the future v7, please? We have this bug for 2 years.