Single Sign-On Reports

The following is a list of reports that can be imported into sqlReports, version 4.3 or higher.  Clicking on the report name will take you to the page with the coding to import.  The screenshots were created from fictional data in a sample database provided by PowerSchool.  Reports with uploaded dates prior to 9/1/16 were originally uploaded to sqlreports4.com.

Admin Portal Reports

Report Name / Description Created By Uploaded

 free
Count of SSO Accounts per Student
Report shows a list of students at the current school and a count of the number of SSO guardian accounts tied to the student.  Filter on those with a 0 count to get a list of those without a SSO guardian account.  (screenshot)
  Matt Freund 1/22/16
  Inactive Students with SSO Accounts
Shows a list of guardians tied to inactive students.  Can be run at the current school or district wide.  (screenshot)
  Matt Freund 11/8/16
  Parent / Student Portal Login History
Login history from the parent and student portal for the date ranges entered by the admin.  Parent portal information is for SSO logins only.  (screenshot)
  Matt Freund 9/8/14
  SSO Accounts per Student
Report shows a list of students at the current school with SSO guardian accounts.  Results are grouped by student and provides basic information about each account.  (screenshot)
  Matt Freund 1/22/16
  SSO Accounts per Student - Columns
Same data as the SSO Accounts per Student report except the data is not grouped together and the report data is in separate columns to make it export friendly and easier to filter.  (screenshot)
  Matt Freund 1/22/16
  SSO Guardian Accounts
Report shows guardian accounts and the students at the current school grouped together with the account.  Can also be run at the district office.  (screenshot)
  Matt Freund 1/22/16

 


Charts - Admin

Report Name / Description Created By Uploaded

 
Parent Portal Logins by Student
Shows the number of logins within a date range by the student and any SSO account(s) tied to the student.  (screenshot)
  Matt Freund 8/23/14
  Parent Portal Statistics
Summary of parent and student logins based on a date range specified by the admin.  (screenshot)
  Matt Freund 8/23/14