Start a new topic

Query for getting Teacher Website and Meeting data

As an administrator, is there a way that I can do a query to get the Teachers info they input for Teacher Website and Meeting?  Having the ability to pull that up quickly to  see who is missing either their Teacher Website or Meeting info would be great.  


3 people have this question
1 Comment

Figured out it's stored in the MSS table for MST based sites, so a query to see by teacher and period is:


LIST MSS MST TCH CRS TCH.TE MST.PD MSS.SE CRS.CO MSS.SV BY TCH.TE MST.PD IF MSS.NM = "OnlineMeeting_URL" 


For elementary based sites it's stored in the gradebook options table, GBO but I have not been able to link it back to the teacher table. GBO does have an ID field that is the gradebook number, but it's not cooperating with any queries using GBK. 


LIST GBO IF GBO.OPN = "Website_URL"

Login to post a comment