Can anyone help me tailor this report to show only users that have logged on in a specific IP range?
SELECT CONVERT(date, logontime) AS Date, count (distinct assetid)as [distinct assets]
from tblCPlogoninfo
group by CONVERT(date, logontime)
order by Date desc
Or is there a better way to show devices that were online per day in the same IP range..
Thanks
