Page History

...

• Instead of the plain old tabular visualization in report files, users can add a more lively visual design to their Excel® reports by using the Import Excel Module.
• Reports start as usual with data in rows and columns, however, with the choice of colors, Pivot Tables, and Charts a design is available that suggests better visualization and better decision making.

Use Cases

The PowerShell CLICommand Line Interface 2.0 - Introduction is used by jobs to create better designed reports. Two modules are applied for this purpose:

• the JobScheduler the JS7 - PowerShell Module
• a reporting PowerShell Module. This example makes use of the ImportExcel PowerShell Module that can be used to create Excel® reports and to add Pivot Tables and Pivot Charts to reports. The module can be operated for Windows and Linux computers and does not require prior installation of Microsoft Excel®.

...

• The below screenshot contains the output of the  Get-JSTaskHistory cmdlet stored in the Excel report sheet. Users can change the colors of text and background of cells according to their choice. The below example presents the status of jobs with different colors using the -ConditionalText parameter of the ImportExcel module.

Image RemovedImage Added

Sample Charts:

• There is a sample Pivot Chart created with the parameter -ChartType ColumnClustered3D. This chart type is used in this example to display the number of jobs per state (successful, incomplete, failed, planned) of jobs. 

Image RemovedImage Added

Sample Pivot Table:

• The sample Pivot Table displays the RowHeaderCaption as "By JobScheduler ID, Job, Status". You can adjust the style of the table by use of the parameter -PivotTableStyle. Users can expand and collapse the Pivot Table.

Image RemovedImage Added