1 Reply Latest reply on Mar 11, 2015 5:59 PM by bluefunelemental

    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?

        • Re: Enumerating on IP Address Reports
          bluefunelemental

          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.