usageTrackerQuery

select 
UserName as Name,
Email as email,
Role as role, 
PageVisited as ViewedPage,
/*Count(PageVisited) as NumberofHits,*/
COUNT(CAST(Date as date)) as NumberOfVisits, 
CAST(Date as date) as LastVisitedDate
from [dbo].[UserActivityLog]
where EMAIL NOT LIKE '%starcom%'
group by  UserName,Role,Email,PageVisited,CAST(Date as date)
order by LastVisitedDate DESC


select * from [dbo].[UserActivityLog]