Home› Advanced Request Offering

Automated creation of service requests

Ryan_KelleyRyan_Kelley Customer IT Monkey ✭
in Advanced Request Offering

Hello All!

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):

image.png


The result would be:

image.png

Thank you all for any help! Hoping automated ticket generation is a popular request or there is way to do so in power BI !

Answers

  • Brian_WiestBrian_Wiest Customer Super IT Monkey ✭✭✭✭✭

    What is the source of the Power BI report?

  • Ryan_KelleyRyan_Kelley Customer IT Monkey ✭

    The sources of the power BI report are service management and service manager (we used both depending on the objective)

  • Brian_WiestBrian_Wiest Customer Super IT Monkey ✭✭✭✭✭

    So then the source is a SQL database, use the same rules in for PowerBi and build a SCORCH runbook to create matching work items.

  • Ryan_KelleyRyan_Kelley Customer IT Monkey ✭

    I was thinking that but - apologies for not mentioning- Some of the sources are also being tied in from rapid7,ATP, CISA , ect - as we wanted a very comprehensive report.

    Hence the question on how to create tickets in scsm using the power bi report or failing that exporting what we want and then running a script to generate tickets

    Power BI -> export list to excel -> run script -> generate SRs for analysts - Unless Orchestration Console can do that?

  • Brian_WiestBrian_Wiest Customer Super IT Monkey ✭✭✭✭✭

    We also have outside systems that provide reporting that I cannot hit directly, aka receiving reporting with csv's. So to address that have power automate capturing the files and moving them into a custom SQL database. Then combining the OOB databases and these custom databases we run rules that create 100's of tickets each month of "issue assets"

    Since Power Automate can "Talk" with Power Bi you might be able to have Automate perform the export job as a flat file, copy to a local file share, then call SCORCH RestAPI to kick off a runbook to process that export file.

    HTH

  • Adam_DzyackyAdam_Dzyacky Product Owner Contributor Monkey ✭✭✭✭✭

    Historically my advice would have been any one of the following (obviously varies based on specific use case):

    • Export to a CSV, PowerShell loop through to create Work Items & and their relationships (semi-manual extracts, but fairly straightforward all in all)
    • Use the SCCM management pack for SCOM to Alert on failures to generate an SCSM Incident (somewhat technically involved, but possible)
    • Use the SCSM/SCCM Desired State Configuration Workflow within SCSM for SCCM items that fall out of their Baseline (may not apply to every scenario)
    • Integrate those systems with PowerShell and then report off of SCSM (ideal, but also technically involved)


    HOWEVER!

    Per our Innovate 2022 announcement yesterday - with the upcoming release of our Power Automate Connector for SMP, I can't see why you now couldn't potentially use Power Automate's Power BI connector to extract data and then drive the creation of Incidents/Service Requests entirely from Power Automate.

  • Ryan_KelleyRyan_Kelley Customer IT Monkey ✭

    Hello,

    I attended the Innovate 2022 announcement! :)

    I am very excited to use power automate -> however -> Is there an expected release date?

    Thank you for replying!

Sign In or Register to comment.