Filtering data source by AQL where Hostname is some string

[Declan Morgan]

Hi,

I am trying to filter my assets at the time of import by using AQL in the 'Edit object type mapping' section of the mapping.

My goal is to filter by selector 'HOST' from my import file to select only assets that follow a naming convection. For example, I want to select only devices with the string "SAMGRALT" that is contained in the attribute 'Hostname' from that data source. See Below.

I have also tried:

objecttype.Hostname startswith "SAMGRALT"

I have had no luck in correctly selecting the assets. Is there any further documentation about AQL other than this.

Any help would be greatly appreciated.

Thanks

[Simen Vågsæter]

Hi Declan,

Did you ever manage to solve this? I have a similar problem where we are running Asset Discovery scan on servers, laptops etc. in same import. I want to split the import so laptops get in the laptop objectType, servers to objectType etc.

Hardware assets
-> Laptops
-> Servers
-> Phones