I'd like to run a report on all monitored Windows Server nodes telling me which versions of .Net are installed. Can anyone please help me figure out how to arrange this? Thank you.
This custom query should do the job assuming all your servers are having their asset inventories collected:
SELECT n.caption, s.name, s.version, s.installdate
from Orion.AssetInventory.Software s
join orion.nodes n on n.nodeid=s.nodeid
where s.name like '%.net%'
How do you get it to only show Windows servers?
and n.vendor = 'Windows'