3 weeks ago - last edited 3 weeks ago
Hello everyone!
I am kinda new to Lansweeper reporting and would like to ask you for an assistance, please!
Can you give me a hand regarding creating a report that only lists the specific software installed (like 300 specific software - Adobe Acrobat Reader; 7-Zip; VLC Media Player; etc). The report should include the software name, versions, users and their machine hostnames as well.
I have found in a post (Specific Software Installed Audit - Lansweeper ) how to create similar report, but only for one software....How can I add more than one software in this report, as I have to create similar report, but for around 300 more software included?
Thank you in advance!
Regards,
Pavlin
Solved! Go to Solution.
3 weeks ago
Using the link you provided as the starting point, you would add the extra software names using the OR criteria.
Here I've added only two software names you've listed.
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetUnique,
tblAssets.Domain,
tblAssets.Username,
tblADusers.Displayname As [User],
tblSoftwareUni.softwareName As software,
tblSoftware.softwareVersion As version,
tblSoftwareUni.SoftwarePublisher As publisher,
tsysOS.Image As icon
From tblSoftware
Inner Join tblAssets On tblSoftware.AssetID = tblAssets.AssetID
Inner Join tblSoftwareUni On tblSoftware.softID = tblSoftwareUni.SoftID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Left Join tblADusers On tblADusers.Username = tblAssets.Username And
tblADusers.Userdomain = tblAssets.Userdomain
Where (tblSoftwareUni.softwareName Like '%adobe acrobat reader%') Or
(tblSoftwareUni.softwareName Like '%7-zip%' And tblAssetCustom.State = 1)
Order By tblAssets.AssetName,
software,
version
Line 17 wraps the first software package to line 18 using the OR function. It states that if the results find "adobe acrobat reader" OR "7-zip" then show it on the report.
Here's the editor table view of the report.
I'm not sure if there will be a limit on the number of OR statements you can have, so this may not be the best way to report on 300 software titles. But it is a simple way to start understanding the reporting lingo.
You might be better off to run a report for all software titles (no filtering), export to excel and from there filter out what you don't want.
Good luck.
2 weeks ago
Thank you very much for the useful information! It helped me a lot and gave me better understanding of reporting and adding more than one statements!
Regards,
Pavlin
2 weeks ago
You're welcome.
I'm just adding to what I've learned from others to keep the community vibrant and active.
3 weeks ago
Using the link you provided as the starting point, you would add the extra software names using the OR criteria.
Here I've added only two software names you've listed.
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetUnique,
tblAssets.Domain,
tblAssets.Username,
tblADusers.Displayname As [User],
tblSoftwareUni.softwareName As software,
tblSoftware.softwareVersion As version,
tblSoftwareUni.SoftwarePublisher As publisher,
tsysOS.Image As icon
From tblSoftware
Inner Join tblAssets On tblSoftware.AssetID = tblAssets.AssetID
Inner Join tblSoftwareUni On tblSoftware.softID = tblSoftwareUni.SoftID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Left Join tblADusers On tblADusers.Username = tblAssets.Username And
tblADusers.Userdomain = tblAssets.Userdomain
Where (tblSoftwareUni.softwareName Like '%adobe acrobat reader%') Or
(tblSoftwareUni.softwareName Like '%7-zip%' And tblAssetCustom.State = 1)
Order By tblAssets.AssetName,
software,
version
Line 17 wraps the first software package to line 18 using the OR function. It states that if the results find "adobe acrobat reader" OR "7-zip" then show it on the report.
Here's the editor table view of the report.
I'm not sure if there will be a limit on the number of OR statements you can have, so this may not be the best way to report on 300 software titles. But it is a simple way to start understanding the reporting lingo.
You might be better off to run a report for all software titles (no filtering), export to excel and from there filter out what you don't want.
Good luck.
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now