Software list with installed language and location based off IP subnet?

[Garfunko]

Hi,

First time posting here!

I would like help on the following please:

a list of computers from IP range 172.16.X.X with the following software installed

OS version and language
Office version and language
Acrobat reader version and language
MS Project, acrobat standard, Ms visio and language

To run this report, do I simply copy and past the info into a new report?

[Hemoco · Accepted solution]

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.