cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
d_i_saunders
Engaged Sweeper III
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
0 REPLIES 0