i have created a custom property (main_location) and how can i add that custom property on below query
Select A.Resources, A.Resources_Name , A.IP_Address , A.Nodes
From(
select 'Interfaces' as Resources, I.InterfaceName as Resources_Name , N.IP_Address as IP_Address, N.Caption as Nodes
From NodesData N Join Interfaces I On I.NodeID = N.NodeID
Union
select 'Volumes' as Resources , V.VolumeDescription as Resources_Name , N.IP_Address as IP_Address, N.Caption as Nodes
From NodesData N Join Volumes V On V.NodeID = N.NodeID
) A
Order By A.Nodes