As an update to the queue monitor script, I have added a little tweak.
When the script has completed its run, it will now import the log file into Excel and create a chart displaying the message flow for the current log.
The Excel chart export seems to have a problem with the current folder. I tried using “.\” or even get-location and set location in variables, but it only works if I hard code the path.
This image can be used on a web page to display the queue information in more friendly and accessible format.Excel is set to overwrite the existing image and spreadsheet everytime the script runs.
An awesome source of Excel related information can be located at the Excel Cookbook. This information saved me a lot of time an effort while working with Excel.
Information regarding Excel chart types and styles can be found here.
The complete script with the Excel chart export section can be downloaded from here:
When the script has completed its run, it will now import the log file into Excel and create a chart displaying the message flow for the current log.
The Excel chart export seems to have a problem with the current folder. I tried using “.\” or even get-location and set location in variables, but it only works if I hard code the path.
This image can be used on a web page to display the queue information in more friendly and accessible format.Excel is set to overwrite the existing image and spreadsheet everytime the script runs.
An awesome source of Excel related information can be located at the Excel Cookbook. This information saved me a lot of time an effort while working with Excel.
Information regarding Excel chart types and styles can be found here.
The complete script with the Excel chart export section can be downloaded from here:
0 comments:
Post a Comment
Note: Only a member of this blog may post a comment.