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?
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.