I am trying to create a report to show all of the preventive maintenance and when they are scheduled. The sworkorder table gives me the Title and description. However I cannot find when it is scheduled and who it is assigned to. Many of these have not get generated workorders because they are annual and have not come due yet.

 

Does anyone have a query to get all the information associated for Preventive maintenance?