Find a list of machines without installed software (With hardware)
This query works great to find computers with a software that is NOT installed.
WHERE Guid NOT IN (SELECT inst._ResourceGuid
FROM vRM_Software_Component_Item sci
JOIN Inv_InstalledSoftware inst
ON inst._SoftwareComponentGuid = sci.Guid
AND inst.InstallFlag = 1
WHERE LOWER(sci.Name) LIKE '%enterprise%vault%')
I am trying to figure out how to add data from vHWComputerSystem like Model and also user information from vuser.
Is it possible? Thanks in advance!