Comments by brajunaresh (Top 5 by date)

hi Aathi,
thank u, but i need to pass the xml local path in the Query, then the data in the xml will inserted into the table.

SELECT @xmlData = BulkColumn
FROM OPENROWSET
(BULK 'D:\Process.xml',SINGLE_CLOB ) as a

SELECT UserID = a.value('(USERID/text())[1]','VARCHAR(100)'),
Machine_Name = a.value('(MAchineName/text())[1]','VARCHAR(100)'),
CurrentDate = a.value('(CurrentDate/text())[1]','VARCHAR(100)'),
DocumentTitle = a.value('(DocumentTitle/text())[1]','VARCHAR(100)')
from @xmlData.nodes('/Processes/Process') x(a)

Thank u i tried it and i got the processes which are running, now if i want kind events that i want to use to add the newly started processes to my processes list, mean the newly added processes are dynamically add to my processes list.

I have requirement to track each and every processing application window information in task bar, Mean window name/title and start time and exit time.

Hi Perumal,
thanks u, i did same thing to get the processes but if i opened more then one word or IE browsers, in the process list i am getting only one process. i need how to get the reamaing windows information.