SOLVED

Query using Computer list from Parameter

Occasional Contributor

Hello,

I have an issue with some code for a Workbook. I would like to run a Query in a Workbook and filter this on a list of computers that would be retrieved in a preceding parameter.

 

This parameter has the variable name {SuperComputerListPackageCode}.

 

I can successfully run the {SuperComputerListPackageCode} query:

 

1.jpg

 

Its result is:

["Computer1.mydomain.com", "Computer2.mydomain.com", "Computer3.mydomain.com", "Computer4.mydomain.com", "Computer5.mydomain.com"]

 

My stake is the following. In a subsequent request, I run the code:

 

Perf
| where Computer in ({SuperComputerListPackageCode})
| distinct Computer

 

and the result gives me an error.

 

2.jpg

2 Replies
best response confirmed by SebasL (Occasional Contributor)
Solution
Change "text" parameter Type to "multi-value"
Wow. Ok. It worked the first time.

A big thank you!