Skip to content

software not installed report

Featured Replies

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.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

Account

Navigation

Search

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.