This website uses Cookies. By clicking Accept, you agree to the storing of cookies on your device to enhance your community and translation experience. Read our Privacy Policy.
Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Who rated this post

nsinghvirk
L4 Transporter

‎08-23-2024 09:57 AM

Hello @tualantin 

 

Thanks for reaching out on LiveCommunity!

Please try using below query.

dataset = host_inventory
| arrayexpand applications
| alter vendor = json_extract(applications,"$.key_name")
| filter (vendor not in (null, """"""))
| fields applications , vendor

 

Please click Accept as Solution to acknowledge that the answer to your question has been provided.

View solution in original post

(1)
Who rated this post
LEGAL NOTICES
RESOURCES
Khoros awards 2022
Copyright 2007 - 2024 - Palo Alto Networks