Elencare i servizi di tutti i server della farm in SharePoint 2010 con powershell / Sgart.it

Questo script PowerShell permette di elencare i servizi di tutti i server di una farm SharePoint 2010

$dt = (Get-Date -format yyyyMMdd); GET-SPServer 
 | foreach {Get-SPServiceInstance -Server $_.Name 
 | select TypeName, Status 
 | SORT TypeName 
 | Export-Csv "$($_.Name)_$dt.csv" -notype }

crea una serie di file file di nome NomeServer_yyyyMMdd.csv con un contenuto simile al seguente

"TypeName","Status"
"Access Database Service","Online"
"Application Registry Service","Online"
"Business Data Connectivity Service","Online"
"Central Administration","Disabled"
"Claims to Windows Token Service","Online"
"Document Conversions Launcher Service","Disabled"
"Document Conversions Load Balancer Service","Disabled"
"Excel Calculation Services","Online"
"Lotus Notes Connector","Disabled"
"Managed Metadata Web Service","Online"
"Microsoft SharePoint Foundation Incoming E-Mail","Disabled"
"Microsoft SharePoint Foundation Sandboxed Code Service","Disabled"
"Microsoft SharePoint Foundation Subscription Settings Service","Online"
"Microsoft SharePoint Foundation Web Application","Disabled"
"Microsoft SharePoint Foundation Workflow Timer Service","Disabled"
"PerformancePoint Service","Online"
"PowerPoint Service","Online"
"Project Application Service","Online"
"Search Query and Site Settings Service","Online"
"Secure Store Service","Disabled"
"SharePoint Foundation Search","Disabled"
"SharePoint Server Search","Online"
"User Profile Service","Disabled"
"User Profile Synchronization Service","Disabled"
"Visio Graphics Service","Online"
"Web Analytics Data Processing Service","Online"
"Web Analytics Web Service","Online"
"Word Automation Services","Online"
"Word Viewing Service","Online"

utile per essere importato in Excel.