Not able to fetch Custom Attributes from Solarwinds Graphconnector

Ayush Mittal
Giga Contributor

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.

4 REPLIES 4

Swapna Abburi
Mega Sage
Mega Sage

@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

@Swapna Abburi 

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

Thanks in advance 🙂

@Ayush Mittal 

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

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