→ 🚀What's New? Join Us for the Fall Product Launch! Register Now !
‎12-04-2014 11:55 AM
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
‎08-06-2020 02:25 PM
‎08-06-2020 02:51 PM
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
‎07-31-2020 11:13 PM
‎08-30-2017 07:37 PM
Or tblAssets.AssetName Like '%COMPUTERNAME%'
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
‎06-22-2017 03:46 PM
‎06-19-2017 10:06 AM
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
‎01-25-2017 03:43 PM
‎01-25-2017 12:22 AM
‎06-16-2017 06:38 PM
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.
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now