• State Not Answered
  • Locked Locked
  • Replies 1 reply
  • Subscribers 15 subscribers
  • Views 152 views
  • Users 0 members are here
Options
Related
This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Enumerating on IP Address Reports

donpepe

Hi,

I am trying to do a report on IP status. The value returned on the report is a number. 2 represents available, 1 is used, 4 is reserved, etc... Is there anyway to transform those numbers into English?

  • 0

    I‌ have never found an IP status description field. 

    But we can do this in SWQL or sql as I do for several IP reports.

    Select IPAddress

    ,Case when status = 1 then 'Used' when status = 2 then 'Available' when status = 4 then 'Reserved' Else 'Status Unknown' end as [Status]

    ,

    from IPnode

    etc etc

    The above is from memory and I also forget which number is transient.

SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 195,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 Media Vault Link Accounts
About THWACK Blogs For Government Edit Settings Free Tools & Trials
Legal Documents Terms of Use Privacy California Privacy Rights Security Information
©2024 SolarWinds Worldwide, LLC. All Rights Reserved.