‎08-08-2013 05:33 PM
Solved! Go to Solution.
‎08-09-2013 06:57 PM
Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.IPAddress,
tsysOS.OSname,
tblAssets.SP,
tblOperatingsystem.Caption As FullOSName,
tblLanguages.Language As OSlanguage,
tblAssets.Firstseen,
tblAssets.Lastseen,
tblSoftwareUni.softwareName,
tblSoftware.softwareVersion,
tblSoftwareUni.SoftwarePublisher
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblOperatingsystem
On tblAssets.AssetID = tblOperatingsystem.AssetID
Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Inner Join tblLanguages On tblLanguages.LanguageCode =
tblOperatingsystem.OSLanguage
Where tblAssets.IPAddress Like '172.16.%' And (tblSoftwareUni.softwareName Like
'%office%' Or tblSoftwareUni.softwareName Like '%acrobat%' Or
tblSoftwareUni.softwareName Like '%microsoft%project%' Or
tblSoftwareUni.softwareName Like '%visio%') And tblAssetCustom.State = 1
Order By tblAssets.Domain,
tblAssets.AssetName
‎08-09-2013 06:57 PM
Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.IPAddress,
tsysOS.OSname,
tblAssets.SP,
tblOperatingsystem.Caption As FullOSName,
tblLanguages.Language As OSlanguage,
tblAssets.Firstseen,
tblAssets.Lastseen,
tblSoftwareUni.softwareName,
tblSoftware.softwareVersion,
tblSoftwareUni.SoftwarePublisher
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblOperatingsystem
On tblAssets.AssetID = tblOperatingsystem.AssetID
Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Inner Join tblLanguages On tblLanguages.LanguageCode =
tblOperatingsystem.OSLanguage
Where tblAssets.IPAddress Like '172.16.%' And (tblSoftwareUni.softwareName Like
'%office%' Or tblSoftwareUni.softwareName Like '%acrobat%' Or
tblSoftwareUni.softwareName Like '%microsoft%project%' Or
tblSoftwareUni.softwareName Like '%visio%') And tblAssetCustom.State = 1
Order By tblAssets.Domain,
tblAssets.AssetName
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now