StackQL for querying Azure VM's which are in stopped/running state #522
Description
Hi,
Requesting help with SQL to fetch all Azure VM's in running or stopped status,
Tried the below from Azure cloudshell but didnt work,
stackql >>SELECT vm_id, name, FROM azure.compute.virtualmachines WHERE power_state = 'stopped';
Service.GetResource() failure
stackql >>SELECT vm_id, name, FROM azure.compute.virtualmachines WHERE power_state = 'running';
Service.GetResource() failure