Been trying to come up with a custom report for software not installed on computers. I have setup a report that gives me the computers with the software installed but when I attempt to change it to the NOT IN subset it errors out. error is SYS.Netbios_Name0 cannot be bound.
We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.
Been trying to come up with a custom report for software not installed on computers. I have setup a report that gives me the computers with the software installed but when I attempt to change it to the NOT IN subset it errors out. error is SYS.Netbios_Name0 cannot be bound.
Select SYS.Netbios_Name0, SYS.User_Name0, SP.ProductName, SP.CompanyName, SP.ProductVersion
FROM v_GS_SoftwareProduct SP
where SYS.Netbios_Name0 not in (Select SYS.Netbios_Name0, SYS.User_Name0, SP.ProductName, SP.CompanyName, SP.ProductVersion
FROM v_GS_SoftwareProduct SP
JOIN v_R_System SYS on SP.ResourceID = SYS.ResourceID
WHERE SP.ProductName = 'Microsoft .NET Framework 2.0')
any help would be appreciated.
Share this post
Link to post
Share on other sites