Query some values from a XML datatype result…
SELECT [datumtijd]
,(CAST(body AS XML).query('declare namespace ns1="http://totietoot.nl/example/person/1/0";
declare namespace soapenv="http://schemas.xmlsoap.org/soap/envelope/";
declare default element namespace "http://totietoot.nl";
//soapenv:Envelope/soapenv:Body/ns1:Members/ns1:Person/ns1:ID'
).value('.', 'nvarchar(100)')) AS ID
,(CAST(body AS XML).query('declare namespace ns1="http://totietoot.nl/example/person/1/0";
declare namespace soapenv="http://schemas.xmlsoap.org/soap/envelope/";
declare default element namespace "http://totietoot.nl";
//soapenv:Envelope/soapenv:Body/ns1:Members/ns1:Person/ns1:Name'
).value('.', 'nvarchar(100)')) AS Name
--,[body]
FROM [DATABASE].[dbo].[Logtable]
WHERE [kolom1] = 'waarde'
ORDER BY datumtijd DESC