Login Report V 2.1

Submitted by jtreadwell on Sat, 08/16/2008 - 10:21am

Oracle Version: New report that allows you to search for logins by student, parent, teacher, admin, sub, maintenance or all of the above. You can leave the search fairly open or even drill down to a specific IP address. Check out the readme file for more options.

V 1.0 (12/21/2007) - Initial Release
V 1.1 (01/12/2008) - small bug fixes
V 1.2 (02/06/2008) - Added ability to use the calendar popup with the report
V 1.2.1 (02/07/2008) - Fixed error with IE
V 1.2.2 (02/29/2008) - Fixed error with IE
V 2.0 (07/29/2008) - Converted to Oracle
V 2.1 (08/16/2008) - Fixed rounding error in the IP addresses

0
Your rating: None

Comments

User Login Report

by sbenson - 06/08/2010 - 12:17pm

Getting a Log Out Reason of 170 on this report.  Can you tell me what this refers to?

re: User Login Report

by jtreadwell - 06/08/2010 - 10:31pm

170 is one of the codes we have not been able to figure out yet. Most of the codes came straight from PowerSchool documentation. Some were deduced by forcing the error to come back again and again. But that one has not been one we can reliably reproduce for 1 specific reason so we haven't been able to decode it. So because we don't know we let it show the raw code. If someone reliably decodes this we'll update the report with the correct definition. There are a couple of codes that'll come out that way, but 170 is the one I've seen the most. It's frustrating not knowing what causes it but we'll figure it out one day.

Jason

Okay, I think I figured some

by jlfiller - 01/25/2010 - 12:29pm

Okay, I think I figured some of this out. If you have an image server (even if it's on the same server) you have to copy the calendar scripts to psimage directory.

There is a scripts folder under your psimage and you have to copy the whole calendar folder (under scripts in the customization) to the scripts folder under psimage.

Also, it doesn't work with Internet Explorer, but it does work on Firefox.

Joy Filler (fillerj@wilton.k12.ct.us)
Wilton Public Schools, Wilton, CT

Calendar not working.

by Pam Kissel - 03/18/2010 - 10:54am

Did you ever figure out how to get the calendar to work with Explorer?
Pam

Still can't get calendar to work for User Login

by jlfiller - 01/25/2010 - 11:43am

still not able to either enter or select a calendar date on the user login report? Anybody figure this one out? Tried Internet Explorer and Firefox, just can't enter anything into this field. Also re-applied the Calendar pop-up customization, no difference.

Joy Filler (fillerj@wilton.k12.ct.us)
Wilton Public Schools, Wilton, CT

Calendar issues

by Karina - 03/19/2009 - 11:25am

Can't get the calendar to work either. Hoping this report will tell us who is attempting to logon (and is getting locked out with IP address restrictions) Thank you! Karina Gallie

Wrong IP Address.

by joegee27 - 03/05/2009 - 3:12pm

I have the same problem with the IP addresses Running the report, my IP address of 192.168.101.40 is being reported as 191.167.100.40. So the first three octets are 1 too low.

Re: Wrong IP Address.

by danberms - 03/19/2009 - 3:18pm

In the following SQL code, you can change the "+ 255 END" to "+ 256 END" in the 6 instances on UserloginReport.html

Dan

FLOOR(CASE WHEN IPAddr > 0 THEN IPAddr/16777216 ELSE IPAddr/16777216 + 255 END) IP1,
FLOOR(CASE WHEN IPAddr > 0 THEN MOD(IPAddr, 16777216)/65536 ELSE MOD(IPAddr, 16777216)/65536 + 255 END) IP2,
FLOOR(CASE WHEN IPAddr > 0 THEN MOD(MOD(IPAddr, 16777216),65536)/256 ELSE MOD(MOD(IPAddr, 16777216),65536)/256 + 255 END) IP3,
FLOOR(CASE WHEN IPAddr > 0 THEN MOD(MOD(MOD(IPAddr, 16777216),65536),256) ELSE MOD(MOD(MOD(IPAddr, 16777216),65536),256) + 256 END) IP4,

...

AND FLOOR(CASE WHEN IPAddr > 0 THEN IPAddr/16777216 ELSE IPAddr/16777216 + 255 END) LIKE CASE WHEN to_char('~[gpv:ip1]') is null THEN '%' ELSE to_char('~[gpv:ip1]') END
AND FLOOR(CASE WHEN IPAddr > 0 THEN MOD(IPAddr, 16777216)/65536 ELSE MOD(IPAddr, 16777216)/65536 + 255 END) LIKE CASE WHEN to_char('~[gpv:ip2]') is null THEN '%' ELSE to_char('~[gpv:ip2]') END
AND FLOOR(CASE WHEN IPAddr > 0 THEN MOD(MOD(IPAddr, 16777216),65536)/256 ELSE MOD(MOD(IPAddr, 16777216),65536)/256 + 255 END) LIKE CASE WHEN to_char('~[gpv:ip3]') is null THEN '%' ELSE to_char('~[gpv:ip3]') END
AND FLOOR(CASE WHEN IPAddr > 0 THEN MOD(MOD(MOD(IPAddr, 16777216),65536),256) ELSE MOD(MOD(MOD(IPAddr, 16777216),65536),256) + 256 END) LIKE CASE WHEN to_char('~[gpv:ip4]') is null THEN '%' ELSE to_char('~[gpv:ip4]') END

calendar doesn't work

by jlfiller - 02/18/2009 - 10:36am

The calendar doesn't work for me either. Can't click on the calendar or change the date. I know it worked previously. I recently installed the Grade Verification 3.0.0.2 customization. The calendar works on other parts of PowerSchool, but not on this report.

Joy Filler (fillerj@wilton.k12.ct.us)
Wilton Public Schools, Wilton, CT

wrong IP

by jlfiller - 01/13/2009 - 4:59pm

I am having a problem displaying the IP also. My own IP is 172.20.0.253

It's being displayed as 172.19.-1.253

Joy Filler (fillerj@wilton.k12.ct.us)
Wilton Public Schools, Wilton, CT

Login Report V2.1

by ilovecats - 11/11/2008 - 10:23am

Before we updated to Version 5.2.0.9 this report worked great. We could change the start date to the first day of school and get anything we wanted. Now since the update we can only see one date and that would be today's date. We can not change the start date or the end date. The calendar does not show up. All we get is a box that is outlined in red and no calendar picture.

re: Login Report V2.1

by jtreadwell - 11/12/2008 - 1:16am

Please try the Fix tlist_sql error from 5.2.0.9 I uploaded just a few minutes ago. It should give you the ability to check a box to make all this work.

Jason Treadwell
Custom Solutions Specialist
jason@powerdatasolutions.org
www.powerdatasolutions.org

Rounding an issue for the first three subnets

by danberms - 10/20/2008 - 9:06am

Running the report, my IP address of 172.19.215.100 is being reported as 171.18.214.100. So the first three octets are 1 too low. My IP is stored as a negative number.
Looking at the SQL, I believe the +255 should be +256 for all three?

login report

by tschan - 10/14/2008 - 1:44pm

Terry L. Schanbacher
Technology Director
Regional School District 6
Litchfield, CT

I cannot seem to make the calendar work on the login report. I cannot change the date or click on the calendar to change the dates. ?
The calendar works in other parts of Power
school.

Syndicate content Syndicate content