How SQL Server detect program name in sys.dm_exec_sessions

Question

Hi,

 

Can somebody explain the how below mention query detect program_name eg: Microsoft SQL Server Management Studio,Microsoft SQL Server Management Studio - Query etc..

 

select login_name,program_name,host_name,nt_domain,nt_user_name from sys.dm_exec_sessions