SCCM - Export your task sequence in Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-198138%22%20slang%3D%22en-US%22%3ESCCM%20-%20Export%20your%20task%20sequence%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-198138%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20everyone%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere%20is%20my%20script%20to%20automatically%20export%20you%20task%20sequences%20in%20Excel%3A%3C%2FP%3E%3CP%3EYou%20can%20download%20it%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fgallery.technet.microsoft.com%2FSCCM-Export-TS-vers-Excel-69b65e4c%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EHere%3C%2FA%3E.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F34972iFDA0BF544A460CAB%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22ExportTS4.jpg%22%20title%3D%22ExportTS4.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers%3C%2FP%3E%3CP%3EGregory%20B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-198138%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECM%20current%20branch%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPowerShell%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-393877%22%20slang%3D%22en-US%22%3ERe%3A%20SCCM%20-%20Export%20your%20task%20sequence%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-393877%22%20slang%3D%22en-US%22%3E%3CP%3EDear%20Gregory%2C%20thanks%20for%20this%20fantastic%20tool%20but%20...%20really...%20I%20don't%20now%20how%20to%20obtain%20informations%20on%20my%20lab%20infrastructure.%3C%2FP%3E%3CP%3EActually%20the%20configuration%20is%3A%3C%2FP%3E%3CP%3E-SCCM%20Primary%20Site%20Standalone%20CB%201810%20on%20Windows%202012R2%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eis%20there%20some%20prerequisites%3F%3C%2FP%3E%3CP%3ECan%20You%20help%20me%20to%20understand%20why%20the%20tools%20does%20not%20work%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDavide%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-266418%22%20slang%3D%22en-US%22%3ERe%3A%20SCCM%20-%20Export%20your%20task%20sequence%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-266418%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20scripts%20works%20fine.%20I%20want%20to%20import%20more%20information%20like%20options%20on%20the%20right%20side%20of%20a%20task.%3C%2FP%3E%3CP%3EEx%3A%20If%20a%20task%20says%20to%20install%20an%20application%20%2C%20on%20the%20right%20side%20we%20need%20to%20assign%20a%20package%20or%20an%20application.%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20help%20to%20add%20%22Properties%22%20and%20%22Options%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%2C%3C%2FP%3E%3CP%3ERam%3C%2FP%3E%3CBLOCKQUOTE%3E%3CHR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F11967%22%20target%3D%22_blank%22%3E%40Gregory%20Bouchu%3C%2FA%3E%26nbsp%3Bwrote%3A%3CBR%20%2F%3E%3CP%3EHi%20everyone%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere%20is%20my%20script%20to%20automatically%20export%20you%20task%20sequences%20in%20Excel%3A%3C%2FP%3E%3CP%3EYou%20can%20download%20it%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fgallery.technet.microsoft.com%2FSCCM-Export-TS-vers-Excel-69b65e4c%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EHere%3C%2FA%3E.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F34972iFDA0BF544A460CAB%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22ExportTS4.jpg%22%20title%3D%22ExportTS4.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers%3C%2FP%3E%3CP%3EGregory%20B%3C%2FP%3E%3CHR%20%2F%3E%3C%2FBLOCKQUOTE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2141962%22%20slang%3D%22en-US%22%3ERe%3A%20SCCM%20-%20Export%20your%20task%20sequence%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2141962%22%20slang%3D%22en-US%22%3E%3CP%3EHey%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F11967%22%20target%3D%22_blank%22%3E%40Gregory%20Bouchu%3C%2FA%3E%20this%20looks%20like%20exactly%20what%20I'm%20after%20however%20it%20seems%20the%20link%20is%20now%20dead%2C%20are%20you%20able%20to%20share%20a%20current%20link%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2157380%22%20slang%3D%22en-US%22%3ERe%3A%20SCCM%20-%20Export%20your%20task%20sequence%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2157380%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F969076%22%20target%3D%22_blank%22%3E%40TofuFace%3C%2FA%3E%26nbsp%3BYou%20can%20download%20most%20of%20the%20the%20old%20TechNet%20Gallery%20samples%20from%20the%20Internet%20Archive.%20Here%20is%20a%20link%20to%20the%20task%20sequence%20export%20to%20Excel%20scripts%3A%26nbsp%3B%3CBR%20%2F%3E%3CA%20href%3D%22http%3A%2F%2Fweb.archive.org%2Fweb%2F20200318074701%2Fhttps%3A%2F%2Fgallery.technet.microsoft.com%2FSCCM-Export-TS-vers-Excel-69b65e4c%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Ehttp%3A%2F%2Fweb.archive.org%2Fweb%2F20200318074701%2Fhttps%3A%2F%2Fgallery.technet.microsoft.com%2FSCCM-Export-TS-vers-Excel-69b65e4c%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%2F%20Johan%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Hi everyone,

 

Here is my script to automatically export you task sequences in Excel:

You can download it Here.

 

ExportTS4.jpg

 

Cheers

Gregory B

4 Replies

Hello,

 

This scripts works fine. I want to import more information like options on the right side of a task.

Ex: If a task says to install an application , on the right side we need to assign a package or an application. 

Please help to add "Properties" and "Options"

 

Regards,

Ram


@Gregory Bouchu wrote:

Hi everyone,

 

Here is my script to automatically export you task sequences in Excel:

You can download it Here.

 

ExportTS4.jpg

 

Cheers

Gregory B


 

Dear Gregory, thanks for this fantastic tool but ... really... I don't now how to obtain informations on my lab infrastructure.

Actually the configuration is:

-SCCM Primary Site Standalone CB 1810 on Windows 2012R2

 

is there some prerequisites?

Can You help me to understand why the tools does not work?

 

Thanks

 

Davide

Hey @Gregory Bouchu this looks like exactly what I'm after however it seems the link is now dead, are you able to share a current link?

@TofuFace You can download most of the the old TechNet Gallery samples from the Internet Archive. Here is a link to the task sequence export to Excel scripts: 
http://web.archive.org/web/20200318074701/https://gallery.technet.microsoft.com/SCCM-Export-TS-vers-... 

 

/ Johan