Service duplicating assets/credentials

Hello any idea why it double assets in Service?

I guess because it shows both assets, and any credentials linked with them. In addition, it shows credentials, and any assets linked with them.

There's probably a way we can de-duplicate this.

yes there is a way with a group by clause, Ill take a peek by next week