It is indeed possible to pull this information from the EventLog table. However, I do not know of a direct query to get to that information. The only items available for the EventLog are: AddEventLog, DeleteEventLog, GetEventLogByGUID, GetEventLogPendingNotif, GetEventLogPendingNotifConfig, PurgeEventLog, UpdateEventLogPendingNotif.
You would have to build your own module that includes a query to the EventLog table.
If you are using SQL Server 2005, this Stored Procedure would work. It will give you the last IP number and the date/time it occurred. You can also do this for SQL Server 2000, but the XML is done differently, I think.
CREATE PROCEDURE [dbo].[ModuleName_GetLastIpNumberForUser]
@UserName NVARCHAR(100),
@PortalId INT
AS
BEGIN
SET NOCOUNT ON;
DECLARE @Xml XML, @LogDate DATETIME;
SELECT TOP 1 @Xml = CAST(el.[LogProperties] AS XML), @LogDate = el.[LogCreateDate]
FROM [EventLog] el
WHERE (el.[LogUserName] = @UserName AND el.[LogPortalID] = @PortalId)
AND el.[LogTypeKey] = 'LOGIN_SUCCESS'
ORDER BY el.[LogCreateDate] DESC;
SELECT @Xml.value('(/LogProperties/LogProperty/PropertyValue)[1]', 'NVARCHAR(50)'), @LogDate;
END