Get OS Details on Virtual Machine Instance

[Pratiksha]

You have to write it on virtual machine instance pattern as extension. Also added xml for ease of use. 

library {
name = "GET OS"
id = "3d0730798386f1104e2ef355eeaad3cc"
description = "GET OS"

step {
name = "GET OS"

parse_var_to_var {
from_var_name = "rest_resp_instance"
to_var_names = table {
name = "instances"
col_names = "InstanceID", "os"
}

parsing_strategy = xml_parsing_strategy {
rootXpath = "/DescribeInstancesResponse"

fields {
field {
col_name = "InstanceID"
xpath = "/DescribeInstancesResponse/reservationSet/item/instancesSet/item/instanceId/text()"
delimiters = ""
position = 1
}

field {
col_name = "os"
xpath = "/DescribeInstancesResponse/reservationSet/item/instancesSet/item/platformDetails/text()"
delimiters = ""
position = 1
}

field {
col_name = "forEach"
for_each = "forEach"
delimiters = ""
position = 1
}
}
}

if_not_found_do = nop {}
}
}

step {
name = "Remove empty records"

filter {
src_table_name = "instances"
target_table_name = "instances"
condition = is_not_empty {
get_attr { "instances[].InstanceID" }
}
}
}

step {
name = "Set Value"

transform {
src_table_name = "instances"
target_table_name = "cmdb_ci_vm_instance"

operation {
set_field {
field_name = "u_os"
value = get_attr { "instances[].os" }
}

set_field {
field_name = "object_id"
value = get_attr { "instances[].InstanceID" }
}
}
}
}

step {
name = "Dependent relations"

relation_reference {
table1_name = "cmdb_ci_vm_instance"
table2_name = "cmdb_ci_aws_datacenter"
result_table_name = "vm_to_ldc_relation"
unmatched_lines = keep
relation_type = "Hosted on::Hosts"
ref_direction = parentToChild
ref_field_name = ""
}
}
}

Do mark it helpful 🙂

Regards,

Pratiksha Khandelwal