SolarWinds THWACK
THWACK
  • Sign In
  • Search
  • Product Forums
    • Observability
      • SolarWinds Observability
      • Hybrid Cloud Observability
      • DevOps
    • The Orion Platform
      • Forum
      • Scalability Engines (HA, APE, AWS)
      • Enterprise Operations Console (EOC)
      • Orion SDK
      • Alert Lab
      • Report Lab
    • Network Management
      • Network Performance Monitor (NPM)
      • NetFlow Traffic Analyzer (NTA)
      • Network Configuration Manager (NCM)
      • IP Address Manager (IPAM)
      • User Device Tracker (UDT)
      • VoIP & Network Quality Manager (VNQM)
      • Log Analyzer
      • Engineer’s Toolset
      • Network Topology Mapper (NTM)
      • Kiwi CatTools
      • Kiwi Syslog Server
      • ipMonitor
    • Systems Management
      • Server & Application Monitor (SAM)
      • Virtualization Manager (VMAN)
      • Storage Resource Monitor (SRM)
      • Server Configuration Monitor (SCM)
      • SolarWinds Backup
      • Web Performance Monitor (WPM)
    • Database Management
      • Database Performance Analyzer (DPA)
      • SQL Sentry
      • Database Performance Monitor (DPM)
      • Database Mapper
      • Task Factory
    • Application Management
      • AppOptics
      • Loggly
      • Papertrail
      • Pingdom
      • DevOps
    • IT Security
      • Access Rights Manager (ARM)
      • Identity Monitor
      • Security Event Manager (SEM)
      • Patch Manager
      • Serv-U FTP & MFT
    • IT Service Management
      • SolarWinds Service Desk (SWSD)
      • Web Help Desk (WHD)
      • DameWare Remote Support (DRS)
      • DameWare Remote Everywhere (DRE)
      • DameWare Mini Remote Control (MRC)
  • Resources
    • THWACK Command Center
    • DevOps
    • What We're Working On
    • Blogs
      • Community Announcements
      • Product Blog
      • Monitoring Central
      • Geek Speak
      • The DevOps Blog
    • THWACK Tech Tips
    • Movies and Mainframes
    • Support
      • Success Center
      • Documentation
      • Submit a Support Ticket
      • Customer Portal
      • Renew Maintenance
    • Community Groups
      • New To THWACK
      • Federal & Government
      • User Experience
      • EMEA Group
      • Japan Group
  • Events, Missions, & Musings
    • Events
      • THWACK Livecast
      • THWACK Livecast Archive
      • SolarWinds Lab
      • SolarWinds Lab Archive
      • THWACKcamp 2022 On Demand
      • SolarWinds User Groups
      • SolarWinds Events Calendar
    • Missions & Contests
      • Monthly Mini-Mission: Running the IT Pro Gauntlet
      • THWACK 101
    • Musings
      • Water Cooler
      • Geek Tank
      • IT Tech Jobs/Careers
      • Monitoring for Managers
    •  
      •  
  • Content Exchange
    • The Orion Platform
      • Alerts
      • Custom HTML
      • Custom Queries
      • Modern Dashboards
      • Reports
      • Scripts
    • Network Performance Monitor
      • Device Pollers
      • Universal Device Pollers (UnDP)
    • Network Configuration Manager
      • Config Change Scripts
      • Device Templates
      • Firmware Upgrade Templates
      • Policy Documents
    • Server & Application Monitor
      • API Pollers
      • Application Monitor Templates
    • Server Configuration Monitor
      • Policies
      • Profiles
    • Database Performance Analyzer
      • Custom Alerts
      • Custom Metrics
      • Custom Queries
    • Web Help Desk
      • Style Sheets
  • Academy
    • Newsroom
    • Forums
      • Classroom Discussions
      • SolarWinds Certified Professional (SCP)
    • Training & Certification
  • Free Tools & Trials
  • Store
The Orion Platform
  • Content Exchange
  • More
The Orion Platform
Custom Queries ICMP Status Only vs. Paid Nodes for HCO Details | Older than v2023.2
  • Tags
  • More
  • Cancel
Options
  • View all
  • Previous
  • Next
  • View slideshow
  • More
  • Cancel
fileName

ICMP Status Only vs. Paid Nodes for HCO Details | Older than v2023.2

Hello and salutations,

Thank you for your consideration of our Hybrid Cloud Observability (HCO) product which is built on the SolarWinds Platform (formerly known as Orion). This new license model provides at lot of advantages over the heritage point products, and we group the various functionality of the various point products into a new product offering. Therefore, this document is to help determine the license tier you will be in by converting over your existing products into the new HCO offering.

Determining your version of the SolarWinds Platform (fka Orion):

Please open your SolarWinds Web console to look at the footer of the website, which would present the version you are currently on for our application. This referenced image provides you a visual guide:

If you are on version 2023.2 or newer, then please go to this SolarWinds Thwack article to gain access to a report that you can import into your reports to run. Here is the corresponding video to show you how to import/export a report within your web console --> link

If you are running an older version of the SolarWinds Platform, then the below section would be the appropriate way to gather the necessary information to be properly licensed in the new product offering. 

Possible Modifications to the SWQL Query:

Please remove the sections of color-coded text based on a product not being present in your environment.

  • Remove this line if SAM doesn’t exist
  • Remove this line is VMan doesn’t exist
  • Remove this line if NCM doesn’t exist

Query Colored-coded to highlight the sections for possible removal:

SELECT

t1.Total as [Total ICMP Nodes]

, t2.StatusO as [ICMP Status Only Nodes]

, t1.VMan as [ICMP VMan Nodes]

, t1.API as [ICMP API Nodes]

, t2.SAM as [ICMP SAM Nodes]

, t2.NCM as [ICMP NCM Nodes]

FROM

(SELECT

     count(DISTINCT OriN.NodeID) as [Total]

, sum(case when OriN.ObjectSubType='ICMP' AND OriN.ApiPollers.ID IS NOT NULL THEN 1 ELSE 0 end) as API

   , sum(case when OriN.ObjectSubType='ICMP' AND (OriN.Host.HostID IS NOT NULL OR OriN.VCenter.VCenterID IS NOT NULL) THEN 1 ELSE 0 end) as VMan

from Orion.Nodes OriN WHERE OriN.ObjectSubType='ICMP') as t1

join

(SELECT

      count(DISTINCT OriN.NodeID) as Total

    , sum(case when OriN.ApiPollers.ID IS NULL AND OriN.Applications.NodeID IS NULL AND OriN.Host.HostID IS NULL AND OriN.VCenter.VCenterID IS NULL AND OriN.NCMLicenseStatus.LicensedByNCM='No' then 1 else 0 end) as StatusO

    , count(distinct OriN.Applications.nodeid) as SAM

    , sum(case when OriN.NCMLicenseStatus.LicensedByNCM='Yes' then 1 else 0 end) as NCM

    from Orion.Nodes OriN WHERE OriN.Objectsubtype='ICMP') as t2 on t1.Total=t2.Total

SWQL Query to run within your environment:

Please go to https://<your SolarWinds Server Hostname>/Orion/Admin/swis.aspx to then apply your modified query to execute the query. The results should be shared with your Account Representative.

Referenced in this image:

Shout out to animelov in providing the SWQL Query to allow customers in getting precise and accurate information for licensing on Hybrid Cloud Observability (HCO). 

  • orion
  • license usage
  • icmp
  • HCO
  • license
mrburns
mrburns
  • 29 Jun 2023
  • 14 Downloads
  • Share
  • More
  • Cancel
Anonymous

SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 190,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 Accounts
About THWACK Blogs 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.