This question is likely going to take someone with extreme patience to answer...
I am basically trying to do the following:
Now here comes the tricky part for me. Our SQL server machines were imported using the DPA association wizard so my NPM is aware they exist. If I run the following query:
SELECT DISTINCT(NodeID) FROM orion.dbo.DPA_DatabaseInstanceData --take the values it returns and then run SELECT * FROM dbo.NodeData WHERE NodeID IN (--results of query 1) --yes i know i could do that in a single query just exploring the db :)
I get node information. I can also join the volume table on node id and get information there as well.
I cannot seem to add the properties from multiple objects (node & volume & custom property) to the sql server "group" I am creating. If someone can show me how to do it, I would like to be able to do it both through the GUI and the SQL database (more important). I think this one time walk through will help me better grasp the relationships in the Orion database, and what happens to things when you connect tools together.
As always any and all help is appreciated. Thanks in advance to whoever takes time out of their day to explain this to me.