You can see the ALOGIN table for login events. 

You can see the AESPION table for more detail. 

The actual connection information stored for the current connections are stored in a series of tables that can be seen in the query below. For example, you could see the session ID for the folder "PROD" like the following: 

SELECT X3SM0.SESSIONID_0

FROM X3.ASYSSMDBASSO X3SM1

JOIN X3.ASYSSMINTERN X3SM0 ON X3SM1.SESSIONID_0 = X3SM0.SESSIONID_0

JOIN sys.dm_exec_connections VDS ON VDS.session_id = convert(INTEGER, X3SM1.DBIDENT1_0)

       AND VDS.connect_time = convert(DATETIME, X3SM1.DBIDENT2_0, 121)

WHERE X3SM0.FOLD_0 = 'PROD'

Great thank you, I will dig in

How can the device IP be added to the mix?