cancel
Showing results forĀ 
ShowĀ Ā onlyĀ  | Search instead forĀ 
Did you mean:Ā 
MC
Engaged Sweeper II

hi all,
i have have a query to list the pc and that specify a certain sowftware is not installed
can you plaese help//
NEWBIE  HERE------
 is used the custom field to state that its not installed..


 

Select Distinct Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Username,
tblAssetCustom.Custom1 As [MetaTrader 5]


case
when tblSoftwareUni.softwareName not like 'MetaTrader 5'
then  tblAssetCustom.Custom1 = 'not installed'
else 
end


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.IPAddress Like '192.168.70.%' And tblAssetCustom.State = 1
Order By tblAssets.AssetName



2 REPLIES 2
brandon_jones
Champion Sweeper III

You can try this report. The only thing that you will need to edit is the name of the software. In the report below replace 'Google Chrome' with the name of the software you are wanting to Query. For example if you want all the computers that don't have Microsoft Teams installed, you enter in 'Microsoft Teams'.

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 '%Google Chrome%') And
  tblAssetCustom.State = 1
Order By tblAssets.Domain,
  tblAssets.AssetName
ErikT
Lansweeper Tech Support
Lansweeper Tech Support

@MC next to the built-in reports, Lansweeper has an online report library you can use. 

This report might be the one you are looking for. 

missing software audit