Report on static 'default group' only!

[Tomas]

As the title says, I’m trying to create a report for assets which are part of certain static groups and exclude other groups.

We have multiple (16) different static groups to help us organize our Assets in Lansweeper.
If I want to run a report for assets included in one of those Groups I can just add the criteria in the report which works well.

But the other way around not so much.

i.e.
lets say I have the following groups:

Default Group
TestGroup-AT
TestGroup-UK
TestGroup-US
TestGroup-BR
TestGroup-CN
OtherGroup1
OtherGroup2

How can I exclude all Assets that a Part of any of the TestGroups.
If I add the criteria
NOT LIKE ‘%TestGroup%’
I still get all the assets in the report since every asset is part of “Default Group”

I tried counting the static groups like it was suggested in another Post and only show Assets with 1 group assigned. But this isn’t working since many assets belong to multible goups. i.e. OtherGoups1 -2

Any pointer would be greatly appreciated since I really need to be able to distinguish the groups in my Reports.

[RCorbeil · Accepted solution]

It would help to see the query you're working with, but off the top of my head, I'd probably start by trying something like

WHERE
  Not Exists (Select
                tblAssetGroupLink.AssetID
              From
                tblAssetGroupLink
                Inner Join tblAssetGroups On tblAssetGroups.AssetGroupID = tblAssetGroupLink.AssetGroupID
              Where
                tblAssetGroupLink.AssetID = tblAssets.AssetID
                And tblAssetGroups.AssetGroup Like '%TestGroup%')

[Tomas]

RC62N wrote:
It would help to see the query you're working with, but off the top of my head, I'd probably start by trying something like

WHERE
  Not Exists (Select
                tblAssetGroupLink.AssetID
              From
                tblAssetGroupLink
                Inner Join tblAssetGroups On tblAssetGroups.AssetGroupID = tblAssetGroupLink.AssetGroupID
              Where
                tblAssetGroupLink.AssetID = tblAssets.AssetID
                And tblAssetGroups.AssetGroup Like '%TestGroup%')

This seems to be the solution already. I was still getting false positives at first, but it seems that it was due to lack of Asset maintenance.