Notification

Icon
Error

How to see additional info columns on Asset Groups

Posted: Thursday, May 16, 2019 3:37:31 PM(UTC)
SW David

SW David

Member Original PosterPosts: 1
0
Like
This issue has been solved! Click here to view the solution
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!
Susan.A
#1Susan.A Member Administration Posts: 1,536  
posted: 6/3/2019 7:38:49 AM(UTC)
As we received a similar question via email recently, I'm pasting the reply we sent via email below, as reference for everyone.
Quote:
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:

Code:
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 = '[h]groupA[/h]'
Order By tblAssets.AssetName
virtualnik8
#2virtualnik8 Member Posts: 2  
posted: 9/21/2020 7:40:41 PM(UTC)
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!

Active Discussions

Lansweeper Computer Aging Report with Year and Month using Purchase Date
by  wyl sg   Go to last post Go to first unread
Last post: Yesterday at 5:19:32 AM(UTC)
Report Center Default Browser and Version
by  RC62N  
Go to last post Go to first unread
Last post: 11/26/2020 8:00:54 PM(UTC)
Lansweeper Trying to make a custom report that sorts assets by state
by  mzipperer   Go to last post Go to first unread
Last post: 11/25/2020 5:36:52 PM(UTC)
Lansweeper Report - All Assets with Specfic Default Gateway
by  RC62N  
Go to last post Go to first unread
Last post: 11/25/2020 4:18:08 PM(UTC)
Report Center Windows update report
by  ToeJoe   Go to last post Go to first unread
Last post: 11/24/2020 3:39:00 PM(UTC)
Lansweeper Report - assets
by  Andy.S  
Go to last post Go to first unread
Last post: 11/23/2020 2:42:01 PM(UTC)
Lansweeper Run Report on PCs from a list
by  RC62N   Go to last post Go to first unread
Last post: 11/16/2020 4:23:12 PM(UTC)