Identify assets with more than one parent

Reports
1

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”.

2

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.

{
  "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
            ]
          }
        }
      ]
    }
  ]
}
3

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.