• State Suggested Answer
  • Replies 5 replies
  • Answers 1 answer
  • Subscribers 46 subscribers
  • Views 882 views
  • Users 0 members are here
Options
Related

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

  • 0

    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
  • 0 in reply to bobmarley

    [Nodes].ResponseTimeHistory    should have the rest
  • 0 in reply to bobmarley

    Hi Bob

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

    enlightenment
  • 0 in reply to ahmad.fauzi 

    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)

SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 200,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.

SolarWinds Customer Success Center Certification SolarWinds Lab Link Customer Portal
About THWACK SolarWinds Blog Federal & Government Edit Settings Free Tools & Trials
Legal Documents Terms of Use Privacy California Privacy Rights Security Information
©2021 SolarWinds Worldwide, LLC. All Rights Reserved.