Skip to content

sample-vm-analytics

Pipeline: sample-vm-analytics

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
## 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"

Playground

Try this in RDA Playground


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