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? 

[Pratiksha]

ETL won’t be helpful in this case, as both objects are unrelated. Instead, you can achieve the desired outcome using a script.

The logic would be as follows:
If the environment field is empty, check the key-value table for the corresponding CI and look for the specific tag. If the tag exists, you can then update the environment field in the server table accordingly.

Let me know if you need help drafting the script.

Regards,

Pratiksha

[ThenmozhiA]

Hi Pratiksha, I can see the environment tags in the payload so i thought of extracting and mapping to the environment field thru ETL. But in my CMDB, some of the server records have already environment populated. I just want the environment field populated for all the server records. Though some have environment field, but i dont see the environment field mapping in IntegrationHub ETL. So where should the script be used? I also checked the key value table, i can see the tags field is empty.

[ThenmozhiA]

Just to add, i able to see the tags in IntefrationHubetl, under the attribute - Zones, when clicked it will show all the key (global-env) and  value (pr, dr) for that particular server. How to extract this value?

[Pratiksha]

On etl on top left side you will see option to add attribute.