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

swql report avaiability node

ahmad.fauzi

Hi all

Need advice and references for report availability queries with filtering

show node name, ip address, availability, customproperties with coverage last month

Find more posts tagged with

Accepted answers

All comments

bobmarley

The best place to start is in the Orion.Nodes table

SELECT NodeID, ObjectSubType, IPAddress, IPAddressType, DynamicIP, Caption, NodeDescription, Description, DNS, SysName, Vendor, SysObjectID, Location, Contact, VendorIcon, Icon, Status, PolledStatus, StatusLED, StatusDescription, NodeStatusRootCause, NodeStatusRootCauseWithLinks, CustomStatus, IOSImage, IOSVersion, GroupStatus, StatusIcon, LastBoot, SystemUpTime, ResponseTime, PercentLoss, AvgResponseTime, MinResponseTime, MaxResponseTime, CPUCount, CPULoad, MemoryUsed, LoadAverage1, LoadAverage5, LoadAverage15, MemoryAvailable, PercentMemoryUsed, PercentMemoryAvailable, LastSync, LastSystemUpTimePollUtc, MachineType, IsServer, Severity, UiSeverity, ChildStatus, Allow64BitCounters, AgentPort, TotalMemory, CMTS, CustomPollerLastStatisticsPoll, CustomPollerLastStatisticsPollSuccess, SNMPVersion, PollInterval, EngineID, RediscoveryInterval, NextPoll, NextRediscovery, StatCollection, External, Community, RWCommunity, IP, IP_Address, IPAddressGUID, NodeName, BlockUntil, BufferNoMemThisHour, BufferNoMemToday, BufferSmMissThisHour, BufferSmMissToday, BufferMdMissThisHour, BufferMdMissToday, BufferBgMissThisHour, BufferBgMissToday, BufferLgMissThisHour, BufferLgMissToday, BufferHgMissThisHour, BufferHgMissToday, OrionIdPrefix, OrionIdColumn, SkippedPollingCycles, MinutesSinceLastSync, EntityType, DetailsUrl, DisplayName, Category, IsOrionServer, ModernIcon, UnManaged, UnManageFrom, UnManageUntil, Image, AncestorDisplayNames, AncestorDetailsUrls, StatusIconHint, InstanceType, Uri, InstanceSiteId

FROM Orion.Nodes

bobmarley

[Nodes].ResponseTimeHistory should have the rest

ahmad.fauzi

Hi Bob

Thanks for you answer, but it seems still got error message need more

enlightenment

bobmarley

SELECT TOP 100
    N.Caption AS [NodeName]
    ,AVG(N.ResponseTimeHistory.Availability) AS [Availability], n.CustomProperties._Group
FROM Orion.Nodes as N
WHERE
    N.ResponseTimeHistory.DateTime>ADDDAY(-7,GETUTCDATE())
GROUP BY N.Caption, n.CustomProperties.YOURCUSTOMPROPERTYNAMEHERE
ORDER BY AVG(N.ResponseTimeHistory.Availability)