Lansweeper cannot detect a software's language settings. For the rest of the information you are after, use the report below.
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
To use the specified report, do the following:
• Browse to the Dashboard\Reports\Report Builder section of the web console.
• Paste the SQL code we provided at the bottom of the page.
• Left-click somewhere in the upper section of the page so the code applies.
• Give the report a Title and hit the Save & Run button to save it.
• The report will now also be listed under Dashboard\Reports\All Reports.