→ The Lansweeper Customer Excellence Awards 2024 - Submit Your Project Now! Learn More & Enter Here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
swdavidw
Engaged Sweeper
Hi All,

I have been sorting my inventory and assets into groups. One of the issues I am seeing though is that the columns for my asset groups are very minimal. For example I don't see info like RAM, Processor, Warranty, custom, etc. Whereas I would see this info on my full asset listing.

Is there a way to edit these views?

Thanks!
1 ACCEPTED SOLUTION
Susan_A
Lansweeper Alumni
As we received a similar question via email recently, I'm pasting the reply we sent via email below, as reference for everyone.
Our product management and development teams decide what columns to list in a view based on a multitude of factors, e.g. relevance. The Assets menu is kind of a master view of assets, which is why it lists so many fields. Other views don't generally list that many fields.

Automatically generated pages like the asset group pages you're referring to cannot be customized. This feature has been requested by other customers as well and is on our customer wish list, but we do not have an estimated release date for it at this time. To list specific information you're after, you'll need to build a custom report. We've included a sample report below that lists all of the columns from the Assets menu, but for assets in a specific static asset group. We also added Windows processor and RAM to the report, which aren't actually listed on the Assets page. You'll need to replace what we've highlighted with the name of the static group you want to report on, leaving the single quotes in place. Keep in mind that this approach only works for static groups. If you have a dynamic group, you cannot filter it by name and you'll need to write the group filters into the query instead.

Instructions for adding the below report to your Lansweeper installation can be found here: https://www.lansweeper.com/Forum/yaf_postst9882_How-to-run-a-report.aspx

If you are interested in building or modifying reports, we do recommend:

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename As AssetType,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.Domain,
Coalesce(tsysOS.OSname, tblLinuxSystem.OSRelease, tblMacOSInfo.SystemVersion)
As OS,
tblAssetCustom.Model,
tblAssetCustom.Manufacturer,
tblAssets.IPAddress,
tsysIPLocations.IPLocation,
tblAssets.Mac As MACAddress,
tblADComputers.OU,
tblState.Statename As State,
tblAssets.Firstseen,
tblAssets.Lastseen,
tblAssets.Lasttried,
tblAssets.Description,
tblAssetCustom.PurchaseDate,
tblAssetCustom.Warrantydate,
tblAssets.FQDN,
tblAssetCustom.DNSName,
tblAssetCustom.LastPatched,
tblAssetCustom.LastFullbackup,
tblAssetCustom.LastFullimage,
tblAssetCustom.Location,
tblAssetCustom.Building,
tblAssetCustom.Department,
tblAssetCustom.Branchoffice,
tblAssetCustom.BarCode,
tblAssetCustom.Contact,
tblAssetCustom.Serialnumber,
tblAssetCustom.OrderNumber,
tblAssets.Memory,
tblAssets.NrProcessors,
tblAssets.Processor,
tblAssetCustom.Custom1,
tblAssetCustom.Custom2,
tblAssetCustom.Custom3,
tblAssetCustom.Custom4,
tblAssetCustom.Custom5,
tblAssetCustom.Custom6,
tblAssetCustom.Custom7,
tblAssetCustom.Custom8,
tblAssetCustom.Custom9,
tblAssetCustom.Custom10,
tblAssetCustom.Custom11,
tblAssetCustom.Custom12,
tblAssetCustom.Custom13,
tblAssetCustom.Custom14,
tblAssetCustom.Custom15,
tblAssetCustom.Custom16,
tblAssetCustom.Custom17,
tblAssetCustom.Custom18,
tblAssetCustom.Custom19,
tblAssetCustom.Custom20,
Case tblAssetCustom.PreventCleanup
When 0 Then 'No'
When 1 Then 'Yes'
End As PreventCleanup,
tblAssets.Scanserver,
tblAssetGroups.AssetGroup
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tsysIPLocations On tsysIPLocations.LocationID =
tblAssets.LocationID
Left Join tblADComputers On tblAssets.AssetID = tblADComputers.AssetID
Inner Join tblState On tblState.State = tblAssetCustom.State
Left Join tblLinuxSystem On tblAssets.AssetID = tblLinuxSystem.AssetID
Left Join tsysOS On tblAssets.OScode = tsysOS.OScode
Left Join tblMacOSInfo On tblAssets.AssetID = tblMacOSInfo.AssetID
Inner Join tblAssetGroupLink On tblAssets.AssetID = tblAssetGroupLink.AssetID
Inner Join tblAssetGroups On tblAssetGroups.AssetGroupID =
tblAssetGroupLink.AssetGroupID
Where tblAssetGroups.AssetGroup = 'groupA'
Order By tblAssets.AssetName

View solution in original post

2 REPLIES 2
virtualnik8
Engaged Sweeper
Hi, great report, thank you!

Could you incorporate the inclusion of the version of "Microsoft Office" into the line-items of this report?

Is it doable to include a column to print the Asset Group that this asset is in?

Thanks!
Susan_A
Lansweeper Alumni
As we received a similar question via email recently, I'm pasting the reply we sent via email below, as reference for everyone.
Our product management and development teams decide what columns to list in a view based on a multitude of factors, e.g. relevance. The Assets menu is kind of a master view of assets, which is why it lists so many fields. Other views don't generally list that many fields.

Automatically generated pages like the asset group pages you're referring to cannot be customized. This feature has been requested by other customers as well and is on our customer wish list, but we do not have an estimated release date for it at this time. To list specific information you're after, you'll need to build a custom report. We've included a sample report below that lists all of the columns from the Assets menu, but for assets in a specific static asset group. We also added Windows processor and RAM to the report, which aren't actually listed on the Assets page. You'll need to replace what we've highlighted with the name of the static group you want to report on, leaving the single quotes in place. Keep in mind that this approach only works for static groups. If you have a dynamic group, you cannot filter it by name and you'll need to write the group filters into the query instead.

Instructions for adding the below report to your Lansweeper installation can be found here: https://www.lansweeper.com/Forum/yaf_postst9882_How-to-run-a-report.aspx

If you are interested in building or modifying reports, we do recommend:

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename As AssetType,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.Domain,
Coalesce(tsysOS.OSname, tblLinuxSystem.OSRelease, tblMacOSInfo.SystemVersion)
As OS,
tblAssetCustom.Model,
tblAssetCustom.Manufacturer,
tblAssets.IPAddress,
tsysIPLocations.IPLocation,
tblAssets.Mac As MACAddress,
tblADComputers.OU,
tblState.Statename As State,
tblAssets.Firstseen,
tblAssets.Lastseen,
tblAssets.Lasttried,
tblAssets.Description,
tblAssetCustom.PurchaseDate,
tblAssetCustom.Warrantydate,
tblAssets.FQDN,
tblAssetCustom.DNSName,
tblAssetCustom.LastPatched,
tblAssetCustom.LastFullbackup,
tblAssetCustom.LastFullimage,
tblAssetCustom.Location,
tblAssetCustom.Building,
tblAssetCustom.Department,
tblAssetCustom.Branchoffice,
tblAssetCustom.BarCode,
tblAssetCustom.Contact,
tblAssetCustom.Serialnumber,
tblAssetCustom.OrderNumber,
tblAssets.Memory,
tblAssets.NrProcessors,
tblAssets.Processor,
tblAssetCustom.Custom1,
tblAssetCustom.Custom2,
tblAssetCustom.Custom3,
tblAssetCustom.Custom4,
tblAssetCustom.Custom5,
tblAssetCustom.Custom6,
tblAssetCustom.Custom7,
tblAssetCustom.Custom8,
tblAssetCustom.Custom9,
tblAssetCustom.Custom10,
tblAssetCustom.Custom11,
tblAssetCustom.Custom12,
tblAssetCustom.Custom13,
tblAssetCustom.Custom14,
tblAssetCustom.Custom15,
tblAssetCustom.Custom16,
tblAssetCustom.Custom17,
tblAssetCustom.Custom18,
tblAssetCustom.Custom19,
tblAssetCustom.Custom20,
Case tblAssetCustom.PreventCleanup
When 0 Then 'No'
When 1 Then 'Yes'
End As PreventCleanup,
tblAssets.Scanserver,
tblAssetGroups.AssetGroup
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tsysIPLocations On tsysIPLocations.LocationID =
tblAssets.LocationID
Left Join tblADComputers On tblAssets.AssetID = tblADComputers.AssetID
Inner Join tblState On tblState.State = tblAssetCustom.State
Left Join tblLinuxSystem On tblAssets.AssetID = tblLinuxSystem.AssetID
Left Join tsysOS On tblAssets.OScode = tsysOS.OScode
Left Join tblMacOSInfo On tblAssets.AssetID = tblMacOSInfo.AssetID
Inner Join tblAssetGroupLink On tblAssets.AssetID = tblAssetGroupLink.AssetID
Inner Join tblAssetGroups On tblAssetGroups.AssetGroupID =
tblAssetGroupLink.AssetGroupID
Where tblAssetGroups.AssetGroup = 'groupA'
Order By tblAssets.AssetName