Sep 26 2018
02:37 PM
- last edited on
Apr 07 2022
05:29 PM
by
TechCommunityAP
Sep 26 2018
02:37 PM
- last edited on
Apr 07 2022
05:29 PM
by
TechCommunityAP
It doesn't seem like saved queries with function aliases can be called from within another saved query with a function alias...
Save the following query with a function alias of "lastperf"
Perf | top 10 by TimeGenerated desc
open up a new query and type
lastperf
and you'll get the 10 most recent Perf rows.
Now, save this query with a function alias of "funcfunc"
lastperf | summarize count() by Computer
Now try this:
funcfunc
you'll get
'' operator: Failed to resolve table or column or scalar expression named 'lastperf'
if you change the body of funcfunc to call lastperf(), it will work if you run it, but then it will say:
Unknown function: 'lastperf'.
Oct 08 2018 08:07 AM
you're right. not intended. I'm reporting this behavior to engineering.
Jan 25 2019 11:51 AM
I'm running into a similar issue.
I've created a Computer Group called "WINDOWSNONPROD". I then created a 2nd computer group called "IISNONPROD" that has the following statement in it:
where Computer in (WINDOWSNONPROD)
When I reference the IISNONPROD group, I get the error: 'where' operator: Failed to resolve table or column or scalar expression named 'WINDOWSNONPROD'
Have you found out if it's simply not possible to call a function with another function?
Oct 20 2019 04:50 AM