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
Store

SolarWind Dependency Report - Unable to Limit to Customer

Hi All,

I have created a parent child dependency report with the below SWQL. The output is as expected but The output that it is showing is for all customer that we have in our infra and i want to restrict it to a particular customer. Can anyone help me how can i restrict it to show dependency report of particular customer using custom properties.

SELECT d.Name, p.DisplayName as ParentName, p.StatusLED AS ParentStatus, c.DisplayName AS ChildName, c.StatusLED AS ChildStatus

FROM Orion.Dependencies d

JOIN System.ManagedEntity p ON p.Uri = d.ParentUri

JOIN System.ManagedEntity c ON c.Uri = d.ChildUri

Find more posts tagged with

Accepted answers

All comments

mesverrum

assuming all your parent entities are nodes (common but not always true) you could do something like

SELECT d.Name, p.DisplayName as ParentName, p.StatusLED AS ParentStatus, c.DisplayName AS ChildName, c.StatusLED AS ChildStatus
FROM Orion.Dependencies d
JOIN System.ManagedEntity p ON p.Uri = d.ParentUri
JOIN System.ManagedEntity c ON c.Uri = d.ChildUri
JOIN Orion.Nodes n on n.Uri=p.Uri
WHERE n.customproperties. =

Vidyadip91

Thanks for your response. I have tried that but it is showing no activity to report on the output page.

SELECT d.Name, p.DisplayName as ParentName, p.StatusLED AS ParentStatus, c.DisplayName AS ChildName, c.StatusLED AS ChildStatus
FROM Orion.Dependencies d
JOIN System.ManagedEntity p ON p.Uri = d.ParentUri
JOIN System.ManagedEntity c ON c.Uri = d.ChildUri
JOIN Orion.Nodes n on n.Uri=p.Uri
WHERE n.customproperties.customer = 'xyz'