1 Reply Latest reply on Apr 5, 2018 12:37 PM by ctlswadmin

    SQL events.netobjecttype description

    imcguinness

      Hi,

      I'm creating a few SQL reports and i am currently looking at the Events table.

      In there is a column named NetObjectType with values like N, HWHT, SMSA etc.

      I would like to join the events to a table that has the definitions of all of these codes but i am yet to find the correct one.

      Also the database hasn't got any Constraints to point me in the correct direction.

      I have worked out that N is for Nodes but i don't want to go through them all manually and create my own table.

      Any help is greatly appreciated.

       

      Ian