Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials

where can i add location query

SELECT TOP 10 n.NodeName AS Node, n.Status as nStatus, n.CPULoad, n.DetailsUrl AS [_Linkfor_Node], '/Orion/images/SubViewIcons/Network_02.png' AS [_Iconfor_Node], i.InterfaceName AS Interface, i.DetailsUrl, i.Status as iStatus, i.DetailsUrl AS [_Linkfor_Interface], '/Orion/images/SubViewIcons/Routing.png' AS [_Iconfor_Interface], i.InPercentUtil AS RECEIVE, i.OutPercentUtil AS TRANSMIT FROM Orion.NPM.Interfaces as i LEFT JOIN Orion.Nodes as n ON n.NodeID=i.NodeID ORDER BY i.InPercentUtil DESCENDING

where i have to add this query on above n.CustomProperties.Locations AS CustomProperties_Locations
FROM Orion.Nodes

Find more posts tagged with

Accepted answers

All comments

bobmarley

Try this, make sure you substitute YOURCUSTOMPROPERTYNAME with Locations (or whatever the CP name is) in your query.

SELECT TOP 10
 n.NodeName AS Node, n.Status as nStatus,
 n.CPULoad, n.DetailsUrl AS [_Linkfor_Node],
 '/Orion/images/SubViewIcons/Network_02.png' AS [_Iconfor_Node],
 i.InterfaceName AS Interface, i.DetailsUrl, i.Status as iStatus,
 i.DetailsUrl AS [_Linkfor_Interface],
 '/Orion/images/SubViewIcons/Routing.png' AS [_Iconfor_Interface],
 i.InPercentUtil AS RECEIVE, i.OutPercentUtil AS TRANSMIT,
 YOURCUSTOMPROPERTYNAME

FROM Orion.NPM.Interfaces as i 
LEFT JOIN Orion.Nodes as n ON n.NodeID=i.NodeID
LEFT JOIN Orion.NodesCustomProperties nd on I.NodeID = nd.NodeID

ORDER BY i.InPercentUtil DESCENDING

sadiqsul

bro when i run valid query it is fine but when i click show records getting error

bobmarley

Did you join the table? LEFT JOIN Orion.NodesCustomProperties nd on I.NodeID = nd.NodeID

Also have you tried without the AS CustomProperties_Locations, that is what the error is reporting on

sadiqsul

SELECT TOP 10
n.NodeName AS Node, n.Status as nStatus,
n.CPULoad, n.DetailsUrl AS [_Linkfor_Node],
'/Orion/images/SubViewIcons/Network_02.png' AS [_Iconfor_Node],
i.InterfaceName AS Interface, i.DetailsUrl, i.Status as iStatus,
i.DetailsUrl AS [_Linkfor_Interface],
'/Orion/images/SubViewIcons/Routing.png' AS [_Iconfor_Interface],
i.InPercentUtil AS RECEIVE, i.OutPercentUtil AS TRANSMIT,
n.CustomProperties.Locations AS CustomProperties_Locations

FROM Orion.NPM.Interfaces as i
LEFT JOIN Orion.Nodes as n ON n.NodeID=i.NodeID
LEFT JOIN Orion.NodesCustomProperties nd on I.NodeID = nd.NodeID

ORDER BY i.InPercentUtil DESCENDING

bro i am trying like this but query is valid but not showing record

edwinhoekman

Maybe you can lose the Joins and make full uses of the Navigation Properties. Can you try the following query:

SELECT TOP 10
      [Interface].Node.NodeName AS Node
    , [Interface].Node.Status as nStatus
    , [Interface].Node.CPULoad
    , [Interface].Node.DetailsUrl AS [_Linkfor_Node]
    , '/Orion/images/SubViewIcons/Network_02.png' AS [_Iconfor_Node]
    , [Interface].InterfaceName AS Interface
    , [Interface].DetailsUrl AS [_Linkfor_Interface]
    , [Interface].Status as iStatus
    , '/Orion/images/SubViewIcons/Routing.png' AS [_Iconfor_Interface]
    , [Interface].InPercentUtil AS RECEIVE
    , [Interface].OutPercentUtil AS TRANSMIT
    , [Interface].Node.CustomProperties.Locations AS [CustomProperties_Location]

FROM Orion.NPM.Interfaces (nolock=true) as [Interface]

ORDER BY [Interface].InPercentUtil DESCENDING

sadiqsul

thank you so much . you saved my life . it is working perfectly