Windows computers that do not have a specific software installed

[Susan_A]

The report below lists Windows computers that are missing a specific software. Replace YourSoftware with the name of the software as listed in Add/Remove Programs (Programs and Features), e.g. Adobe Reader.

The report will only list assets that meet all of the following criteria:

• The asset is a Windows computer.
  
• The computer's state is set to "active".
  
• The computer has been successfully scanned at least once.
  
• The computer does not have the specified software installed.

Select Top 1000000 tsysOS.Image As icon,
  tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Domain,
  tblAssets.Username,
  tblAssets.Userdomain,
  tblAssets.IPAddress,
  tblAssets.Firstseen,
  tblAssets.Lastseen,
  tblAssets.Lasttried
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Where tblAssets.AssetID Not In (Select Top 1000000 tblSoftware.AssetID
  From tblSoftware Inner Join tblSoftwareUni On tblSoftwareUni.SoftID =
      tblSoftware.softID
  Where tblSoftwareUni.softwareName Like '%YourSoftware%') And
  tblAssetCustom.State = 1
Order By tblAssets.Domain,
  tblAssets.AssetName

[aplechaty]

This report is almost exactly what I am looking for. How would I make it only report on Windows 10 systems, so it doesn't pick up servers and other devices as well? Thanks in advance.

[MoonDogg]

aplechaty wrote:
This report is almost exactly what I am looking for. How would I make it only report on Windows 10 systems, so it doesn't pick up servers and other devices as well? Thanks in advance.

Select Top 1000000 tsysOS.Image As icon,
  tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Domain,
  tblAssets.Username,
  tblAssets.Userdomain,
  tblAssets.IPAddress,
  tblAssets.Firstseen,
  tblAssets.Lastseen,
  tblAssets.Lasttried,
  tsysOS.OSname
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Where tblAssets.AssetID Not In (Select Top 1000000 tblSoftware.AssetID
      From tblSoftware Inner Join tblSoftwareUni On tblSoftwareUni.SoftID =
          tblSoftware.softID
      Where tblSoftwareUni.softwareName Like '%Software not installed%') And
  tsysOS.OSname Like '%Win 10%' And tblAssetCustom.State = 1
Order By tblAssets.Domain,
  tblAssets.AssetName

[MoonDogg]

Perfect Thanks!

[ifm]

I made a version of this that only includes computers with the name of your choice, I'm gonna use it for computer rooms that should have the software installed.
We have a lot of different rooms, to add more just add additional rows of:

Or tblAssets.AssetName Like '%COMPUTERNAME%'

before the )

Select Top 1000000 tsysOS.Image As icon,
  tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Domain,
  tblAssets.Username,
  tblAssets.Userdomain,
  tblAssets.IPAddress,
  tblAssets.Firstseen,
  tblAssets.Lastseen,
  tblAssets.Lasttried
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Where tblAssets.AssetID Not In (Select Top 1000000 tblSoftware.AssetID
  From tblSoftware Inner Join tblSoftwareUni On tblSoftwareUni.SoftID =
      tblSoftware.softID
  Where tblSoftwareUni.softwareName Like '%Name of Software%') And
  (tblAssets.AssetName Like '%COMPUTERNAME1%' Or tblAssets.AssetName Like '%COMPUTERNAME2%')
  And tblAssetCustom.State = 1 And tblAssetCustom.State = 1
Order By tblAssets.Domain,
  tblAssets.AssetName

[James_W_]

Works perfect for me, Thank you!

[Bruce_B]

I've added a modified version of the report below where you can specify which software isn't installed and which is installed.

Select Top 1000000 tsysOS.Image As icon,
  tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Domain,
  tblAssets.Username,
  tblAssets.Userdomain,
  tblAssets.IPAddress,
  tblAssets.Firstseen,
  tblAssets.Lastseen,
  tblAssets.Lasttried
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
  Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
  Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
Where tblAssets.AssetID Not In (Select Top 1000000 tblSoftware.AssetID
  From tblSoftware Inner Join tblSoftwareUni On tblSoftwareUni.SoftID =
      tblSoftware.softID
  Where tblSoftwareUni.softwareName Like '%Software not installed%') And
  tblSoftwareUni.softwareName Like '%Software installed%' And
  tblAssetCustom.State = 1
Order By tblAssets.Domain,
  tblAssets.AssetName

[AMADEO_MARTI_CA]

Thank you very much!!

[MD2Tech]

Is it possible to include another software name that IS installed? Something like this software is installed but missing the other software?

Not sure if that makes any sense... sorry.

[James_W_]

MD2Tech wrote:
Is it possible to include another software name that IS installed? Something like this software is installed but missing the other software?

Not sure if that makes any sense... sorry.

I am trying to do this also. I need a report for computers with Office 2010 and without a program called Phish Alert. Cant get it to work