1st off, we are using Orion Platform, SRM, VNQM, NCM, NPM, NTA, VMAN, UDT, SAM: 2020.2.4
My customer has put in hundreds of Parent/Child relationships into SW and is asking me to create a report so he can see what he has put in and what still needs to be put in off his list.
I have been able to pull half the information, but I cannot get the other half.
What tables do I pull from to convert the ParentNetObjectID & ChildNetObjectID columns into the Node Caption/Name?
Columns needed: Parent (Name/Caption) & Child (Name/Caption)
Here is what I have so far:
select Name, ParentNetObjectID, ChildNetObjectID from Dependencies
Order by Name ASC
How do I connect the dots?