→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Alulux
Engaged Sweeper III
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.
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
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

View solution in original post

2 REPLIES 2
Hemoco
Lansweeper Alumni
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
Engaged Sweeper
I too would like a report as described above.