1,309
edits
Changes
→Valley Christian PowerQueries
These PowerQueries are in use at Valley Christian, they may not work "as is" for your school, and are provided as real-life examples.
* [[Media:Jss classes 1 a.zip|jss_classes_1_a.zip]] - JAMF Classes
* [[Media:ASM 1 0.zip|ASM_1_0.zip]] - Apple School Manager (Example of 6 queries in one plugin)
* [[Media:Hmh 1 0.zip|hmh_1_0.zip]] - HMH ThinkCentral (PowerQuery portion)
* <pre>
~(f.add;~(curyearid);1990)
~(decode;1;1;S;)
student_number
blank
first_name
middle_name
last_name
^(decode;^(grade_level);-1;PK;0;K;^(grade_level))
student_web_id
student_web_password
~(decode;1;1;MDR;)
~(decode;1;1;01429045;)
blank
~(decode;1;1;TC;)
</pre>
