→ Celebrate SysAdmin Day 2024 with Lansweeper Enter our Giveaway here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Susan_A
Lansweeper Alumni
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
11 REPLIES 11
aplechaty
Engaged Sweeper II
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
Engaged Sweeper III
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
Engaged Sweeper III
Perfect Thanks!
ifm
Champion Sweeper
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_
Engaged Sweeper II
Works perfect for me, Thank you!
Bruce_B
Lansweeper Alumni
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
Engaged Sweeper II
Thank you very much!!
MD2Tech
Engaged Sweeper II
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_
Engaged Sweeper II
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