Problem requesting nVidia graphics card model

[fobrian]

Good morning,

I am posting this message because I am currently experiencing a problem listing the nVidia graphics card models of some of my client workstations on my network.

Indeed, for some positions, the information simply doesn't come through:



So, here is my current request, from which I have already carried out several tests, as you will see:

Code: Select all

select hosts.computer_name,hostsoftwares.name,hostsoftwares.version,wmi->'Win32_VideoController.1'->>'VideoProcessor' as "Modèle carte graphique",wmi->'Win32_VideoController'->>'Caption' as "Modèle carte graphique 1",wmi->'Win32_VideoController.1'->>'Name' as "Modèle carte graphique 2", wmi->'Win32_VideoController.0'->>'Caption' as "Caption 1",wmi->'Win32_VideoController.1'->>'Caption' as "Caption 2"
from hosts,hostsoftwares
where hostsoftwares.name ilike 'NVIDIA Pilote graphique%%' and hosts.uuid=hostsoftwares.host_id
order by hosts.computer_name ASC

If I manually check the fields queried in my query or if I manually perform a WMI query on one of the impacted workstations from a PowerShell prompt for example, I do get information back.

Have you ever encountered this problem in WAPT?

Thanks in advance.

Fred