PowerShell.com
Library » Script Library » SQL Server » Get-MSSQL-ServerAttrib-Csv

Get-MSSQL-ServerAttrib-Csv

Previous | Next | View all files | View Slideshow
posted by Richard Giles
10-06-2008
Downloads: 496
File size: 2.4kB
Views: 1,265
Embed
Get-MSSQL-ServerAttrib-Csv
  1. ## ===================================================================== 
  2. ## Title       : Get-MSSQL-ServerAttrib-Csv 
  3. ## Description : Connect to SQL Server and output server attributes to CSV 
  4. ## Author      : Idera 
  5. ## Date        : 9/1/2008 
  6. ## Input       : -serverInstance <server\instance> 
  7. ##                   -tempDir <output path> 
  8. ##                   -verbose  
  9. ##                   -debug     
  10. ## Output      : CSV file with server attributes 
  11. ## Usage            : PS> . Get-MSSQL-ServerAttrib-Csv -serverInstance MyServer  
  12. ##                             -tempDir C:\TEMP\ -v -d 
  13. ## Notes            :  
  14. ## Tag            : SQL Server, Attributes, CSV 
  15. ## Change log  : 
  16. ## ===================================================================== 
  17.  
  18. param 
  19. ( 
  20.     [string]$serverInstance = "(local)", 
  21.       [string]$tempDir = "C:\TEMP\", 
  22.     [switch]$verbose, 
  23.     [switch]$debug 
  24. ) 
  25.  
  26. function main() 
  27. { 
  28.     if ($verbose) {$VerbosePreference = "Continue"} 
  29.     if ($debug) {$DebugPreference = "Continue"} 
  30.     Get-MSSQL-ServerAttrib-Csv $serverInstance $tempDir 
  31. } 
  32.  
  33. function Get-MSSQL-ServerAttrib-Csv($serverInstance, $tempDir) 
  34. { 
  35.     trap [Exception]  
  36.     { 
  37.         write-error $("TRAPPED: " + $_.Exception.Message); 
  38.         continue; 
  39.     } 
  40.  
  41.     # Create fully qualified output filename 
  42.     $outputFile = $tempDir + "SQLServerAttributes.csv" 
  43.     Write-Debug "Output directory: $outputFile" 
  44.      
  45.     # Validate path to temp directory 
  46.     if (-not (Test-Path -path $tempDir))  
  47.     { 
  48.         Write-Host Unable to validate path to temp directory: $tempDir 
  49.         break 
  50.     } 
  51.      
  52.     # Load SMO assemblies 
  53.     [void][System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.Smo") 
  54.     [void][System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.SqlEnum") 
  55.     [void][System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.SmoEnum") 
  56.     [void][System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.ConnectionInfo") 
  57.      
  58.     # Create a Server object for default instance 
  59.     Write-Debug "Connecting to server: $ServerInstance"  
  60.     $NamedInstance = New-Object ('Microsoft.SqlServer.Management.Smo.Server') ($serverInstance) 
  61.  
  62.     # Get server attributes with EnumServerAttributes() method and output to CSV 
  63.     #   and overwrite existing file 
  64.     Write-Debug "Outputing $outputFile..." 
  65.     $NamedInstance.EnumServerAttributes() | Export-Csv -path $outputFile 
  66.      
  67.     # Cleanup 
  68.     # TIP: variables will go out of scope when the function ends 
  69.     #      this is a why to specifically dispose them 
  70.     remove-variable NamedInstance  
  71.     remove-variable TempDir 
  72.     remove-variable OutputFile 
  73. } 
  74.  
  75. main 
Filed under: , ,

Connect to SQL Server and output server attributes to CSV.

Concentrated Tech NSoftware Dell Compellent Sponsored by Idera and Concentrated Tech and NSoftware and Dell Compellent
Copyright 2011 PowerShell.com. All rights reserved.