Community FAQ
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
mrdisco
Engaged Sweeper II
Good morning. I'm looking to run a report that lists all assets that I've assigned to a Group, but I don't want to see the Default Group because that duplicates each asset. Here's what I have so far:

Select Top 1000000 tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssetGroups.AssetGroup,
tsysAssetTypes.AssetTypename As AssetType,
tblAssets.Username,
tblAssets.IPAddress,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblAssetGroupLink On tblAssets.AssetID = tblAssetGroupLink.AssetID
Inner Join tblAssetGroups On tblAssetGroups.AssetGroupID =
tblAssetGroupLink.AssetGroupID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Where tblAssetCustom.State = 1
Order By tblAssets.IPNumeric,
tblAssets.AssetName,
tblAssetGroups.AssetGroup
0 REPLIES 0

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