Can an Application custom property and a node custom property have the same name?
As far as I understand YES you can have the same name, I guess they would still work as Target Table's are different
If what Im saying is incorrect please do let me know.
yes they definitely can be the same...completely separate tables. If you do behind the scenes SQL queries rather than SWQL or gui report writer it can get a little hairy, but definitely doable.
Correct and Correct, you will need a clever JOIN statement to pull a report and Match those values!
Actually the join should be fairly simple. Just give each database name an alias, can't remember what database the custom properties are in APM. Something like
SELECT A.NodeID AS APMNode, N.NodeID AS CoreNodeID
FROM Nodes N JOIN APM_HardwareInfo A ON (A.NodeID = N.NodeID)
Should give you an idea of what you'd need to do if two are identical...