Often you may need to analyze results from the SQL Server profiler to know blocking CPU time, Reads etc. By default the profiler shows you a set of columns in the grid. One of the columns is the ClientProcessId. This column gives information about the Id of the client that accesses the server.
If you want to know the name of the client, you can add that column in the grid using the following steps
Start SQL Server profiler > Navigate to File > Templates > Edit template
A new window will open. Click on "Events Selection" Tab. At the bottom, check the option labeled "Show all columns"
In the window, check Hostname checkbox in the Audit Login event as shown above and click the Save button. Now Restart the Profiler. It will start showing the client name too in the results.