Report for Assets with only Default Group

[Alulux]

Hi,
I would like to create a report that shows me which assets are only in the "Default Group" of the "Asset groups", so I can move them to the right one.

[Hemoco · Accepted solution]

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
Count(tblAssetGroupLink.AssetID) As NrOfGroups
From tblAssets
Inner Join tblAssetGroupLink On tblAssets.AssetID = tblAssetGroupLink.AssetID
Group By tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain
Having Count(tblAssetGroupLink.AssetID) = 1

[AnthelioHealth]

I too would like a report as described above.