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.