We are still not running AD... 
Any advice on how I can search on a username for last x logons? I used to hack the code that searched users, but can't really do that with the new version since it only has 1 search box for everything.
This SQL will do what I want, but not sure the best way to pass the username:
select TOP 40 C.Computer, L.Username, L.logontime, L.Ipaddress from tblCPlogoninfo L join tblcomputers C on L.computername = C.computername
where L.Username like 'cr%'
order by L.logontime desc
One thought I had.... create a report listing unique username, and create a link from there to call a stored procedure. But, not sure how to create a link in a report to pass the parameter.
Any advice on how I can search on a username for last x logons? I used to hack the code that searched users, but can't really do that with the new version since it only has 1 search box for everything.
This SQL will do what I want, but not sure the best way to pass the username:
select TOP 40 C.Computer, L.Username, L.logontime, L.Ipaddress from tblCPlogoninfo L join tblcomputers C on L.computername = C.computername
where L.Username like 'cr%'
order by L.logontime desc
One thought I had.... create a report listing unique username, and create a link from there to call a stored procedure. But, not sure how to create a link in a report to pass the parameter.
