Filtering data source by AQL where Hostname is some string

Declan Morgan
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
October 24, 2022

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.

hostName.png

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

1 answer

0 votes
Simen Vågsæter
Contributor
October 13, 2023

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

Bill Teale
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
January 30, 2024

Hi Simen,

I have exactly your scenario - wanting to split results of Asset Discovery into Laptops, Servers, Phones, etc.

Did you have any luck with this?

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events