K2 SMO to DB mapping

SELECT distinct so.[SmartObjectGUID]
      ,so.[DisplayName_XML]
      --,so.[SmartObjectXML]
      --,so.[SystemName]
      ,so.SmartObjectXML.value('(//serviceinstance/@name)[1]','nvarchar(MAX)') ServiceInstanceName
      ,so.SmartObjectXML.value('(//serviceinstance/objects/object/@name)[1]','nvarchar(MAX)') ServInstObjectName
      ,sx.ServiceObjectXML.value('(/object/metadata/display/displayname)[1]','nvarchar(MAX)') SqlName
      ,sx.ServiceObjectXML.value('(/object/@type)[1]','nvarchar(MAX)') SqlTypeName
      --,sx.ServiceObjectXML
  FROM [K2].[SmartBroker].[SmartObject] so
  left outer join [SmartBroker].[ServiceObject] sx on sx.SystemName = so.SmartObjectXML.value('(//serviceinstance/objects/object/@name)[1]','nvarchar(MAX)')
  and sx.SystemName is not null
  where
  so.SmartObjectXML.value('(//serviceinstance/@name)[1]','nvarchar(MAX)') = 'TestDataDb'