Community FAQ
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
triggert
Engaged Sweeper
Is it possible to change the default asset fields show when selecting an Asset group by name?
1 ACCEPTED SOLUTION
Daniel_B
Lansweeper Alumni
The displayed columns can't be changed on the Lansweeper web console.

However, you could build a custom report, which shows you the data you need for assets in a specific group.
The example report below will list you all assets with Model and MAC address which are in the Group "YourGroup"

Select Top 1000000 tblAssetGroups.AssetGroup As [Asset Group],
tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssetCustom.Model,
tblAssets.Mac,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssets.Lasttried
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblAssetGroupLink On tblAssets.AssetID = tblAssetGroupLink.AssetID
Inner Join tblAssetGroups On tblAssetGroups.AssetGroupID =
tblAssetGroupLink.AssetGroupID
Where tblAssetGroups.AssetGroup Like '%YourGroup%' And tblAssetCustom.State = 1
Order By [Asset Group],
tblAssets.AssetName

For instructions on how to run a report, please refer to the following note: http://www.lansweeper.com/Forum/yaf_postst9882_How-to-run-a-report.aspx

View solution in original post

1 REPLY 1
Daniel_B
Lansweeper Alumni
The displayed columns can't be changed on the Lansweeper web console.

However, you could build a custom report, which shows you the data you need for assets in a specific group.
The example report below will list you all assets with Model and MAC address which are in the Group "YourGroup"

Select Top 1000000 tblAssetGroups.AssetGroup As [Asset Group],
tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssetCustom.Model,
tblAssets.Mac,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssets.Lasttried
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblAssetGroupLink On tblAssets.AssetID = tblAssetGroupLink.AssetID
Inner Join tblAssetGroups On tblAssetGroups.AssetGroupID =
tblAssetGroupLink.AssetGroupID
Where tblAssetGroups.AssetGroup Like '%YourGroup%' And tblAssetCustom.State = 1
Order By [Asset Group],
tblAssets.AssetName

For instructions on how to run a report, please refer to the following note: http://www.lansweeper.com/Forum/yaf_postst9882_How-to-run-a-report.aspx

Archive

This board contains archived posts from the retired Lansweeper Forum and Insiders Community.

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now