1 Reply Latest reply on Sep 5, 2017 11:07 AM by mesverrum

    Orion.Nodes.NodeID Type

    tyteen4a03

      What exactly is the type of Orion.Nodes.NodeID? It says System.GUID but when I query the table in SWQL Studio it gives me an integer, then when I try to query NCM with the integer it tells me it cannot convert Int32 to GUID (or character string to uniqueidentifier, when I wrap the number up in a string)

        • Re: Orion.Nodes.NodeID Type
          mesverrum

          NCM tables have a different nodeid format than they do in the rest of the product (NCM useds to be a standalone product and some of the tables still reflect this)

           

          To find the translation from the integer nodeid to the guid I believe the table you will need is cirrus.nodes where they have the GUId as nodeid and integer as corenodeid or something along those lines.