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
(7)
849 times
Add to favorites
System Center
6/29/2018
E-mail Twitter del.icio.us Digg Facebook
Sign in to ask a question


  • 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).
      
      Cheers!
      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