...
- User might be interested to automatically receive a report reports about the daily plan.
- The report reports includes the same information as available from the JOC Cockpit Daily Plan view.
- The report is reports are provided as an Excel file similar to what is available for export from the JOC Cockpit Daily Plan view.
- The report can be scheduled on a daily basis or more frequently to provide ongoing information about completed tasks and outstanding tasks.
...
Report Daily Plan from a job
The PowerShell CLI is can used by jobs to create reports. Two modules are applied for this purpose:
- the JobScheduler PowerShell Module
- a reporting PowerShell Module. This example make use of ImportExcel that can be used to create Excel reports on Windows and Linux.
The Get-JobSchedulerDailyPlan cmdlet is used to retrieve daily plan data and to forward them to the ImportExcel module within a job. Two flavors of the job are available for Windows and Linux. The difference is not about the handling of cmdlets or parameters but due to the fact that PowerShell is invoked differently on Windows and Linux. For Windows environments usually a PowerShell is available with the OS, for Linux the job has to call pwsh to invoke the PowerShell.
Please consider that below jobs are examples that have to be adjusted for your environment.
Windows Version
Download: report_daily_plan_windows.job.xml
...