Automated creation of service requests
We have a procedurally generated power BI report that contains a list of vulnerabilities(out of date software ect) per machine.
For our analysts we create tickets 1 per vulnerabilities so if 100 machines have out of date (adobe) for example it will create 100 tickets to patch them(we try to automate using sccm ect)
My question: Is there a way(preferably using power BI) but if not then exporting a report to excel and then using PowerShell(or I see a beta web-hooks available) to generate tickets from a list?
IE take this +100 other entries(The powershell script would take the info from an excel sheet in the same folder):
The result would be:
Thank you all for any help! Hoping automated ticket generation is a popular request or there is way to do so in power BI !