sample-vm-analytics
Pipeline: sample-vm-analytics
| ## Find distribution of VM types
@c:new-block
name="InstanceType Distribution"
--> @dm:recall
name="sample-aws-vms"
--> @dm:groupby
columns="InstanceType"
--> @dm:save
name="temp-data"
## Find Number of Stopped VMs
--> @c:new-block
name="Find Number of Stopped VMs"
--> @dm:recall
name="sample-aws-vms"
--> *dm:filter
State_Name = 'stopped'
--> @dm:groupby
columns="State_Name" & agg="count"
--> @dm:selectcolumns
include="InstanceId"
--> @dm:save
name="temp-data"
## Find total number of CPU Cores used across all running VMs
--> @c:new-block
name="Find Total Number of CPU Cores for 'running' VMs"
--> @dm:recall
name="sample-aws-vms"
--> *dm:filter
State_Name = 'running'
--> @dm:selectcolumns
include="CpuOptions_CoreCount"
--> @dm:eval
dummy="'dummy'"
--> @dm:to_type
columns="CpuOptions_CoreCount" & type="int"
--> @dm:groupby
columns="dummy" & agg="sum"
--> @dm:save
name="temp-data"
|
Artifacts used in this Pipeline
Bots used in this Pipeline
@c:new-block @dm:recall @dm:groupby @dm:save *dm:filter @dm:selectcolumns @dm:eval @dm:to_type