04-19-2024
12:04 AM
- last edited on
05-22-2024
09:19 AM
by
Riley
When I go into Software, Windows Software and filter the list based on the "Software" column I get back a list of all matching software names with a line for each matching name variation, along with a count of each.
Is there an easy way to move from this display to a list of ALL assets that have any matching version installed?
For example, filter on "Crystal Reports". In my environment this returns 24 different version, from "Crystal Reports 2016 SP3" to "Crystal Reports 2020 SP4 Update".
I can click on each individual line and get the details of the hosts installed, then export that to Excel. Repeat for each of the other 23 lines, one at a time. But I'd love to do the full export of all 24 entries and their underlying hosts in ONE click.
Do I have to write a specific report for this?
Solved! Go to Solution.
05-07-2024 06:16 PM
It sounds like a report would be the best option. Try this as a starting point.
Select Top 1000000 tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblSoftwareUni.softwareName,
tblSoftware.softwareVersion,
tblSoftwareUni.SoftwarePublisher
From tblAssets
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes tsysAssetTypes1 On tsysAssetTypes1.AssetType =
tblAssets.Assettype
Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
Where tblAssetCustom.State = 1
Filter on the software and version columns and then you can export to Excel as needed.
Built-in example:
Report generated example:
Good luck.
05-07-2024 06:16 PM
It sounds like a report would be the best option. Try this as a starting point.
Select Top 1000000 tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblSoftwareUni.softwareName,
tblSoftware.softwareVersion,
tblSoftwareUni.SoftwarePublisher
From tblAssets
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes tsysAssetTypes1 On tsysAssetTypes1.AssetType =
tblAssets.Assettype
Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
Where tblAssetCustom.State = 1
Filter on the software and version columns and then you can export to Excel as needed.
Built-in example:
Report generated example:
Good luck.
05-07-2024 10:10 PM
Excellent, thanks very much this will help a lot!
I also provided more information to Support as they indicated they don't have a 'normalizer' for SAP Crystal configuration yet.
04-22-2024 11:25 AM
This can be done by going to the software tab and checking the Preview normalized software information. Here, you can customize the view.
Custom views (lansweeper.com)
Or click on a Software you want the list for.
On the next page, you can select Assets in the left-hand column to get a list of all the assets regardless of version.
04-22-2024 09:16 PM
I'm using Lansweeper Classic (on-premise) and I don't see similar functionality.
Even in Lansweeper Cloud for my specific use-case (Crystal Reports) the "normalized software" checkbox doesn't make much difference in showing all versions in one place. This may be due to how SAP names the software installation with the version right in the name? See examples with that checkbox on and off.
Another example is 7-Zip, which DOES normalize as expected -- see those examples too.
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now