You can try to start with a stored procedure and pull data from both user and SiteLog tables.
Here is an example:
CREATE PROCEDURE [dbo].[usp_SiteVisitCount_test]
@userId int=null,
@UserName nvarchar(50)=null,
@startDateTime datetime,
@endDateTime datetime=null
AS
BEGIN
SET NOCOUNT ON;
SELECT SiteLog.UserId, SiteLog.DateTime,
Users.Username, Users.FirstName, Users.LastName,
COUNT(SiteLog.DateTime) OVER(Partition by SiteLog.UserId)
FROM SiteLog INNER JOIN
Users ON SiteLog.UserId = Users.UserID
WHERE
--Pass a userID or UserName
(Users.UserId = @userid OR Users.Username =@UserName) AND
--Define a time period
(SiteLog.DateTime BETWEEN @startDateTime AND ISNULL(@endDateTime,getdate()))
END