Extract SQL Profiler result in Excel file

There is no direct option to extract the SQL profile result in Excel or CSV file. We need to use fn_trace_gettable()  in SQL server.

Let’s see step by step how to extract SQL profiler result in excel file.

Open SQL server and profiler.

Read more about SQL Profiler here:

https://bageshkumarbagi-msbi.blogspot.com/2017/07/sql-server-profiler.html

Here I am running below SQL query.

  

See it in profiler.

  

Now we need to save this result in .trc file

   

I saved this with name abc.trc file.

Now open the query window and run the below query

  

Now we can save the query result in excel or csv file.

select  * from fn_trace_gettable('D:\abc.trc',default)

   

Here I am saving it in csv format.

   

We can add the filer on the function to retrieve the profiler result for the particular user.

select TextData,ApplicationName,LoginName,StartTime,EndTime,   ServerName,NTDomainName,NTUserName from fn_trace_gettable('D:\abc.trc',default)   where NTUserName='Bagesh'