Forum Discussion

SebasL's avatar
SebasL
Copper Contributor
Mar 30, 2021

Query using Computer list from Parameter

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:

 

 

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.

 

    • SebasL's avatar
      SebasL
      Copper Contributor
      Wow. Ok. It worked the first time.

      A big thank you!

Resources