Not able to fetch Custom Attributes from Solarwinds Graphconnector

[Ayush Mittal]

I am integrating Solarwinds to ServiceNow (CMDB), using Flow Action to fetch Custom Attributes and use them in the script.

I am using nodes for this - example code - Nodes.CustomProperties.AttributeName

Kindly help me out if here if there is anything wrong with the above way of fetching the attribute value.

[Swapna Abburi]

@Ayush Mittal 

I think you should use two tables and do a JOIN in SQL Query.

Orion.Nodes

Orion.NodesCustomProperties

Please let me know if you are trying to fetch Custom properties from "SG-SolarWinds Hardware Data Stream" Flow action, I should be able to give the SQL Query that I have written recently to fetch attributes from NodesCustomProperties table by joining two tables.

Thanks,

Swapna

[Ayush Mittal]

@Swapna Abburi 

Yes, please share that would be of great help if you could share.

Thanks in advance 🙂

[Swapna Abburi]

@Ayush Mittal 

Please find the query files attached. Replace attribute1 and attribute2 values with actual names from SolarWinds custom properties.

[Munesh2]

Will this work for SG-SolarWinds Network Adaptee Data Stream" Flow action? If not, what would the query for that