Skip to content

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

Artifact Type Artifact Name Access
dataset sample-aws-vms read


Bots used in this Pipeline

@c:new-block @dm:recall @dm:groupby @dm:save *dm:filter @dm:selectcolumns @dm:eval @dm:to_type