# Identify assets with more than one parent

**URL:** https://community.alloyapp.io/t/identify-assets-with-more-than-one-parent/692
**Category:** Reports
**Created:** [5 January 2024 09:54 UTC](https://community.alloyapp.io/t/identify-assets-with-more-than-one-parent/692 "2024-01-05T09:54:55Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![CHallam](https://avatars.discourse-cdn.com/v4/letter/c/d78d45/32.png) [@CHallam](https://community.alloyapp.io/u/CHallam)
#### Post date: [5 January 2024 09:54 UTC](https://community.alloyapp.io/t/identify-assets-with-more-than-one-parent/692/1 "2024-01-05T09:54:55Z")

</div>

We have an issue where our staff have accidentally added the same asset to multiple parents. Is there an AQS report which can show me for instance “All lamps with more than one lantern as parent”.

---

<div class="post-metadata">

### Author: ![cmcnicholas](https://dub1.discourse-cdn.com/flex013/user_avatar/community.alloyapp.io/cmcnicholas/32/21_2.png) [@cmcnicholas](https://community.alloyapp.io/u/cmcnicholas)
#### Post date: [10 January 2024 14:01 UTC](https://community.alloyapp.io/t/identify-assets-with-more-than-one-parent/692/2 "2024-01-10T14:01:16Z")

</div>

Hi @CHallam you probably want to flip it around and say `ALL lanterns WHERE COUNT(root.lamps) > 1`

An example AQS query which shows all Jobs that have more than 1 Job work item is as follows.

```auto
{
  "type": "Join",
  "properties": {
    "attributes": [
      "attributes_itemsTitle",
      "attributes_itemsSubtitle"
    ],
    "collectionCode": [
      "Live"
    ],
    "dodiCode": "designInterfaces_jobs"
  },
  "children": [
    {
      "type": "GreaterThan",
      "children": [
        {
          "type": "Count",
          "properties": {
            "groupBy": "attributes_jobsJobWorkItems"
          }
        },
        {
          "type": "Number",
          "properties": {
            "value": [
              1
            ]
          }
        }
      ]
    }
  ]
}

```

---

<div class="post-metadata">

### Author: ![CHallam](https://avatars.discourse-cdn.com/v4/letter/c/d78d45/32.png) [@CHallam](https://community.alloyapp.io/u/CHallam)
#### Post date: [10 January 2024 14:52 UTC](https://community.alloyapp.io/t/identify-assets-with-more-than-one-parent/692/3 "2024-01-10T14:52:21Z")

</div>

That is extremely helpful!

Can it work the other way round i.e. an asset with multiple parents - one of our users has added a lamp to 26 lanterns.