SCCM-Export TS to Excel

Both PowerShell scripts in the archive allow you to export your SCCM task squence to Excel. The first one is run through the command line (CMTSExportToExcel -Siteserver "YOURSITESERVER" -Sitecode "YOURSITECODE" -TSName "TASKSEQUENCENAME")

5 Star
1,230 times
Add to favorites
System Center
E-mail Twitter Digg Facebook
Sign in to ask a question

  • Problem! Variable, Child TS
    1 Posts | Last post September 05, 2019
    • - The variable is not correct, here they are simply written one after the other!
      - If further steps are called via the "Run Task Sequence" step, these are not specified.
  • Is it possible to also get conditions?
    1 Posts | Last post June 20, 2019
    • This script works very well. Only thing it says is conditions is YES but nothing on what the actual condition is. I was trying to find a way to export this information when I found your script. keep up the good work!
  • Execution fails
    1 Posts | Last post June 17, 2019
    • Not sure if I am doing something wrong, but it keeps throwing below error in PS:
      You cannot call a method on a null-valued expression.
      At C:\temp\Export_TS_ToExcel\CM-ExportTStoExcel_1.1\CMTSExportToExcelGUI.ps1:376 char:3
      +         $TSsheet.columns.Item('H').EntireColumn.Columnwidth = 100
      +         ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
          + CategoryInfo          : InvalidOperation: (:) [], RuntimeException
          + FullyQualifiedErrorId : InvokeMethodOnNull
  • You're very good
    1 Posts | Last post March 15, 2019
    • Thank you gregory for this unbelievable script, just found it yesterday but works like a charm.
       Thank you so much from Portugal!
  • Thanks
    1 Posts | Last post October 26, 2018
    • Thanks this is so useful for our Change control documentation  Top Work
  • Very Nice script
    1 Posts | Last post October 12, 2018
    • If your Task Sequence has multiple steps with the existance of variable in column "H", the variable are summed up. Therefore I've succesfully added a line to clear the variable $var for column "H". When putting the line "Clear-Variable var" in line 342, the variable in column "H" are not summed up anymore.
      When you have added a description in a Groupname, the description is added in the first step in the group instead of adding the description in the group itselfs. My powershell knowledge is not that good to fix that, so any help will be welcome.
  • Nice Work, but possible suggestion
    3 Posts | Last post June 29, 2018
    • Very nice work.
      One suggestion - It might be nice to also note if a step was disabled in the task sequence.
    • Hi Shane,
      Thank You for the feeback and the suggestion. I'll see to implement this ASAP :)
      Gregory B
    • Hi Shane,
      Added a column for set/group enabled (yes/No).
      Gregory B
  • Optimization
    1 Posts | Last post June 28, 2018
    • I would Suggest to Add/Replace this step:
      instead of condition i would add the action because you see the CommandLine Text ...
      Line 233.....
      if ($item.action -ne $null)
      			$TSSheet.Cells.Item($row, "E") = "Yes"
      			$TSSheet.Cells.Item($row, "E").Interior.ColorIndex = 6
      			foreach ($Action in $item.action)
      					$var = $Action
      			$TSSheet.Cells.Item($row, "G") = $var
  • Worked like a charm!!
    2 Posts | Last post June 04, 2018
    • Damn, you're good.
    • Thank you for the feedback :). Gregory B
  • Good Job
    2 Posts | Last post May 29, 2018
    • Nice Work!!! thank you for sharing. Rg
    • Thank you for the feedback :). Gregory B