→ Celebrate SysAdmin Day 2024 with Lansweeper Enter our Giveaway here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Garfunko
Engaged Sweeper
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?
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
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.

View solution in original post

1 REPLY 1
Hemoco
Lansweeper Alumni
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.