Assets and the static asset groups they belong to

[Susan_A]

The report below lists your assets and the static asset groups they belong to. You can filter the AssetGroup column within the report results to list assets in a specific group. Static asset groups are configured in the Static Asset Groups section of the following Lansweeper webpage: Configuration\Website Management\Asset Groups.

The report will only list assets that meet all of the following criteria:

• The asset's state is set to "active".
  
• The asset belongs to at least one static asset group. (All assets should belong to the built-in Default Group, which cannot be edited.)

Select Top 1000000 tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Domain,
  tsysAssetTypes.AssetTypename As AssetType,
  tblAssets.Username,
  tblAssets.Userdomain,
  tblAssets.IPAddress,
  tblAssetCustom.Manufacturer,
  tblAssetCustom.Model,
  tblAssetCustom.Serialnumber,
  tblAssets.Firstseen,
  tblAssets.Lastseen,
  tblAssets.Lasttried,
  tblAssetGroups.AssetGroup
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