Reporting assistance (software inventory)

[Guillaume_ccfd]

Hello,

Following a major migration to O365, we need to check the versions of the Office suite installed on the workstations. I've seen that this information is available under "Software Inventory" on my workstations, however, I'm not sure how to query this variable (I'm looking for an equivalent to "Microsoft Office P" or "Microsoft Office S" (standard/pro)). The goal is to list my workstations and see which version is installed in a second column.

Do you have any suggestions or ideas?

Thank you very much!

[fck_mly]

Good morning,

Since the time of the post, the solution may have been found, but you never know:

Code: Select all

select hosts.computer_name,hostsoftwares.name,hostsoftwares.version,description
from hosts,hostsoftwares
where hostsoftwares.name ilike 'Microsoft 365 Apps%%' and hosts.uuid=hostsoftwares.host_id
order by hosts.computer_name ASC