Service Graph Connector for Azure - Need to populate the environment field

[ThenmozhiA]

Hi All we are using the service graph connector to pull the servers hosted in Azure. But the environment field is not populated, but the environment tag is available. Can you guide me on how to populate the environment from tags to server table. In the integrstionHub etl i tried to used a transform script, but im not able to find the input column containing the tags, but its in the payload. Or is there another way to do this? or how to map the tags to the environment field? 

[ThenmozhiA]

Yes i did try to add an attribute, but not able to extract the environment. The environment tags is under the column zones which is like a array not json. The zones attribute has a number when clicked it shows all the tags of the server. i tried a script operation with input as zones column but the script to extract dint work. Can u help on that?
Also under the transformer definition of the SG- Azure VMs, in robust transformation field mapping i can see the environment field, is ther a script to extract the enviornment value from Azuretags and map to cmdb?

[pratiksha5]

@ThenmozhiA  

Few question : Once the processing is done, are you able to see the environment tag on the vm? I mean is the key value populating? 

[ThenmozhiA]

Yes i can see the environment tag, but its under the azuretags attribute, conataining all the tags as key - value. Any script to extract from the Azuretags

[Pratiksha]

No, when VM are inserting in the virtual machine instance table, are you able to see the environment tag?

[ThenmozhiA]

Yes i can. under the tags related list of the vm instance table i can see all the tags including the environment.