PSCB - Custom Reports (System Admin)

View PSCB Plugin Directory

Version 1.2

Description

This bundle is a collection of System Administration reports. It includes six reports.

    Admin User List
    CPM File/Folder Report
    CPM Plugin Information
    Security By Group
    User Login Count
    User Login Report

Acknowledgements

PSCB Development Team
Rob Staats
Manjit Basra
Michael Moore

PowerData Solutions Contributors
Jason Treadwell
Brent Johnson
Brian Andle

Version Info
1.0 (2018-10-06)
- Initial Release

1.1 (2019-03-24)
- Added Admin User List report.

1.2 (2020-04-12)
- Sql coding updated for all reports.
- Added auto generated drop-down menu options to the column filters in all reports.
- A ~[cust.insertion_point:pscb.sysadmin] was added to the System Admin Reports menu (PSCB_sysadmin.html). This provides users with a method to add links for their own custom system admin reports to the System Admin menu.

Powerschool Compatible Versions
12.x, 19.x

Additional Plugin Requirement

The following PSCB plugins should be installed prior to the installation of this reports bundle.

PSCB - Base Resources
PSCB - Custom Reports (_Home Page)

Installation

Install in System > System Settings > Plugin Management Configuration
Do not unzip the plugin. Install the entire zip file. Be sure to enable the plugin once it's installed.
If you are updating, you can now click on the Plugin name and then use the Update button, and then browse to the new file and click Submit and it will then load the update and then ask you to enable it.

Instructions

Select a school and go to the Powerschool start page.
Click on the PSCB Custom Reports link on the left navigation menu.
Click on the System Admin link to access the System Admin Reports menu.

Report Type: 
Web Based Report
Plugin: 
Y
CPM Import Friendly: 
Y

Comments

Hello - Quick question regarding the Admin User List in PSCB - Custom Reports (System Admin). We have several users that have "District" under "School".
We have figured out that this is the school that the user must have been created but does not mean that the user has access to District. Can you tell me what field it is pulling that data from?

Your assumption is correct, the user was entered at the district level. Access to the District Level is then determine by security group permissions and roles.

--
Rob Staats
PSCB Development

Thanks Rob.
Are you able to tell me what field that data is pulling from?

Teacher Table

Field Name: SchoolID - Indicates the staff member Home School
Field: CanChangeSchool - Lists schools the staff member can access.

--
Rob Staats
PSCB Development

I am sorry, perhaps I am not asking the right question.
The field that populates the school where the account was created is what is in the school column in the Admin User List Report. This is the field that I am interested in learning. Neither of the fields above pull that data.

The Field: Schoolid is the number associated with the school where account was created. Example: 200

The report than queries the Schools table to translate the schoolID and display the corresponding school name in the School column.. Example: Riverside School.

The schoolid and the school name are stored in two different table.

--
Rob Staats
PSCB Development

I am seeing the same issue with "District" appearing as the school for users not at the district. I have looked at my users and they all have the 4 digit code for our high school in their SchoolID and HomeSchoolID fields. Yet, on the user report, they are listed as District.

Thanks for bringing this issue to our attention. We will investigate the cause and update the report as needed.

--
Rob Staats
PSCB Development

This report seems a little off? It is pulling schools that the user doesn't have and not pulling the school assigned for others. I am filtering any group, any role, and any school.

Sue - Please send your contact info to pscb.development@gmail.com. I would like to schedule a Zoom session to review this issue.

--
Rob Staats
PSCB Development

Subscribe to Comments for "PSCB - Custom Reports (System Admin)"