1 Reply Latest reply on Jul 13, 2018 10:45 AM by Jonathan.Schmidt

    Where is data for Journal.notes stored

    JGotze Apprentice

      Where is data for Journal.notes stored? I see the Notes# object but it doesn't have any fields that distinguish what each entry is associated with.  I want to query for Notes that are related to CMDB Types only.

        • 1. Re: Where is data for Journal.notes stored
          Jonathan.Schmidt SupportEmployee

          Hi JGotze,


          Journal Notes are stored in the SQL level in the Journal table.  There's a ParentLink Category field there you should be able to leverage to pull only those related to a certain type of parent object.


          I recognize your ID as one of our ISM customers.  I am moving this to the correct subspace.  Please note the IT Service Management (v6 and v7) (powered by HEAT) subspace is for the older ITSM product lines from years past (that some folks are still using).