I am trying to run following query -

DECLARE @IP NVARCHAR(15);

SET @IP = (SELECT EVENTDATA().value('(/EVENT_INSTANCE/ClientHost)[1]', 'NVARCHAR(15)'));

Select @IP

It is returning Null. Am I doing something wrong ?