Problem with Asset Filtering on Field

[Dominik Hebestreit]

Hello

I have a question I am currently setting up our asset management.

I now need the following field for various reasons ->

Location Devices:

All devices from the location where the USer is located should be displayed here.

Example: Person A has the location New York.
If person A presses the field, all devices in the New York location should be listed.

I currently have two schemes

1) AD Azure (from a plugin) with the object types Users Locations

2) IT Asset Management with several object types.
Here there is an attribute ‘User’ which is of the type ‘Users’.

Does anyone have an idea how I can realise this? 

[Alex Koxaras _Relational_]

Hi @Dominik Hebestreit and welcome to the community,

In my case the following AQL did the job:

objectType in objectTypeAndChildren(Infrastructure) and object having outboundReferences(objectType = Location and object having inR(objectType = Employee and "Jira User" = currentReporter()))

Keep in mind that my config was the following:

• I have an abstract object type called Infrastructure
  • Below infrastructure I have the children object types such as laptops, monitors, mobile phones etc (all IT things that can be assigned to users)
  • These children have an object attribute of Location
• Location is an objecttype with just the name
• I have another object type called Employee.
  • Within the Employee object type I have an object attribute of Location
  • I have another attribute of type User called "Jira User"

Now based on your setup you might want to adjust the above AQL. On my instance and based on my config it works as expected.

Let me know if you have got this!

[Dominik Hebestreit]

Hey @Alex Koxaras _Relational_ 

You are a legend!!!

This looks very good!!

[Alex Koxaras _Relational_]

Nice to know that @Dominik Hebestreit!

If that solved your problem, kindly accept my answer in order to help others in the community with similar questions.

Cheers!