we have a kind of work plan for every employee in an excel sheet. That sheet contains data such as who is on holiday, who is in homeoffice etc. As of right now i've always made a Screenshot of the current week and embedded it on our prtg map. But we thought we could somehow automate this process, because when someone makes a change we have to manually change the screenshot in the prtg webroot directory.
We did think of something like this:
- Create a powershell script that exports the current data out of that sheet and outputs the data as xml - Build a html table as we need it in the PRTG map and insert the xml outputs from the powershell script
Is something like that possible or is there an easier solution?