Extract files from SCSM WI and upload to SharePoint Online


As part of authorizing access to a system, the initial request document had to be extracted from a SR and uploaded to SharePoint Online.

By uploading to SharePoint, the customer kept track of all changes made to the request document and also had a long term storage of all requests.

I ended up creating a Orchestrator runbook, that was initiated during the execution of the Service Request:

The activities in the runbook are as follows:

1. Load the SR that has started the runbook

2. Extract all attachments to a temporary fileshare, in a folder named as the SR ID.

The script to extract attachments from a WI, is more a less a raw copy of the work Patrick has blogged about: http://blogs.litware.se/?p=1369 

3. Run a powershell script to upload the specific folder and files to a site in SharePoint Online.

4. Update the SR with the URL of where the attachments are stored.

You can download the runbook here.

Extract Attachments.zip

Comments (6)
  1. Anonymous says:

    I’ve just published a blog post on how to extract attachments from WIs and upload them to SharePoint

  2. polo says:

    http://www.burberryfactorys.com/
    http://www.shophandbagsonline.com/
    http://www.official-coachoutlet.com/
    http://www.barbour-factory.com/
    http://www.burberry-outlet2014.com/
    http://www.gucci-factory.com/
    http://www.marcjacobsonsale.com/
    http://www.mcmworldwide.ca/
    http://www.guccishoes-uk.com/
    http://www.kate-spades.com/
    http://www.louisvuittonas.com/
    http://www.lv-guccishoesfactory.com/
    http://www.official-mkoutlets.com/
    http://www.official-pradaoutlet.com/
    http://www.michael-korsusa.net/
    http://www.north-facesoutlet.com/
    http://www.moncler-clearance.com/
    http://www.north-faceclearance.com/
    http://www.clothes-mall.com/
    http://www.polo-outlets.com/
    http://www.ralphlauren.so/
    http://www.ralphlaurentshirts.com/
    http://www.ferragamos.in.net/
    http://www.longchampsoutlet.com/
    http://www.abercrombiee.com/
    http://www.barbour-jacketsoutlet.com/
    http://www.michael–korsonline.com/
    http://www.thenorthface.so/
    http://www.cheapuggsbootsr.com/
    http://www.beatsbydreoutlet.net/
    http://www.tommyhilfiger.in.net/
    http://www.ralphslauren.co.uk/
    http://www.michaelkors.so/
    http://www.oakleyssunglassoutlet.com/
    http://www.warm-boots.com/
    http://www.tory-burches.com/
    http://www.woolrich-clearance.com/
    http://www.tommy-hilfigeroutlet.com/
    http://www.uggboots-factory.com/
    http://www.official-northfaceoutlet.com/
    http://www.nike-jordanshoes.com/
    http://www.monsterbeatsbydres.net/
    http://www.canada-gooser.com/
    http://www.bestcustomsonline.com/
    http://coach.mischristmas.com/
    http://www.coach-blackfriday2014.com/
    http://www.coachccoachoutlet.com/
    http://www.coach-clearance.com/
    http://www.coach-factories.net/
    http://www.coach-factorysoutlet.com/
    http://www.coachlosangeles.com/
    http://www.coachoutletstates.com/
    http://www.coach-pursesoutlets.com/
    http://www.hermes-outletonline.com/
    http://www.misblackfriday.com/
    http://www.mischristmas.com/
    http://www.mmoncler-outlet.com/
    http://www.newoutletonlinemall.com/
    http://www.ralphlaurenepolo.com/
    http://www.zxcoachoutlet.com/
    http://www.misblackfriday.com/uggsale.html
    http://www.mischristmas.com/uggboots.html
    http://www.newoutletonlinemall.com/coachoutlet.html
    http://www.zxcoachoutlet.com/coachoutletonline.html
    http://michaelkorsoutlet.mischristmas.com/
    http://mcmbackpack.mischristmas.com/
    http://monsterbeats.mischristmas.com/
    http://northfaceoutlet.mischristmas.com/
    http://mk.misblackfriday.com/
    http://coachoutlet.misblackfriday.com/
    http://coachfactory.misblackfriday.com/
    http://uggaustralia.misblackfriday.com/
    http://coachpurses.misblackfriday.com/
    http://coachusa.misblackfriday.com/
    http://coach.misblackfriday.com/
    http://michaelkorss.misblackfriday.com/
    http://michaelkors.misblackfriday.com/
    http://airmax.misblackfriday.com/
    http://michael-kors.misblackfriday.com/

    https://twitter.com/CoachOutlet2014
    https://www.facebook.com/coachoutletstoreonline
    https://www.facebook.com/ralphlaurenoutletonline

  3. jacob marker says:

    ready to retreat to college or maybe it began it to work andunfortunate create schizophrenia and in the end couldn’t return to work so this aconsiderable inability connected with schizophrenia and must have.

    http://bestanti-agingvitamins.com/

  4. Inn VNix Ginner says:

    Thanks for this!

Comments are closed.

Skip to main content