How can I migrate the dependency to new Orion?

Question

Any way available to migrate the dependency using sdk ?

mrdrewhood · Answer

Two of the comments (towards the bottom) from this post show that you can use powershell and the SDK to create them from a csv

https://thwack.solarwinds.com/product-forums/network-performance-monitor-npm/i/feature-requests/dependencies-extremely-inefficient?CommentId=65232885-cca5-46da-8436-dd7a763a6806

aLTeReGo · Answer

Dependencies are tied to the unique IDs of entities for that specific instance. If you were to somehow export them from one instance into another, the dependencies would be mapped to different entities.

My recommendation would be to create a report containing all dependency information and use that as a guide when recreating those dependencies on your new instance. This can be done fairly easily using the following SWQL Query

SELECT d.Name, p.DisplayName as ParentName, p.StatusLED AS ParentStatus, c.DisplayName AS ChildName, c.StatusLED AS ChildStatus

FROM Orion.Dependencies d

JOIN System.ManagedEntity p ON p.Uri = d.ParentUri

JOIN System.ManagedEntity c ON c.Uri = d.ChildUri