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

Get-MSSQL-ServerAttrib-Html

Previous | Next | View all files | View Slideshow
posted by Richard Giles
10-06-2008
Downloads: 484
File size: 2.5kB
Views: 1,382
Embed
Get-MSSQL-ServerAttrib-Html
  1. ## ===================================================================== 
  2. ## Title       : Get-MSSQL-ServerAttrib-Html 
  3. ## Description : Connect to SQL Server and output server attributes to HTML 
  4. ## Author      : Idera 
  5. ## Date        : 9/1/2008 
  6. ## Input       : -serverInstance <server\instance> 
  7. ##                   -tempDir <file path> 
  8. ##                   -verbose  
  9. ##                   -debug     
  10. ## Output      :  
  11. ## Usage            : PS> . Get-MSSQL-ServerAttrib-Html -serverInstance MyServer  
  12. ##                             -tempDir C:\TEMP\ -v -d 
  13. ## Notes            : 
  14. ## Tag            : SQL Server, Attributes, HTML 
  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-Html $serverInstance $tempDir 
  31. } 
  32.  
  33. function Get-MSSQL-ServerAttrib-Html($serverInstance, $tempDir) 
  34. { 
  35.     $outputFile = $tempDir + "SQLServerAttributes.html" 
  36.     Write-Debug "Output directory: $outputFile" 
  37.      
  38.     # Validate path to temp directory 
  39.     if (-not (Test-Path -path $tempDir))  
  40.     { 
  41.         Write-Host Unable to validate path to temp directory: $tempDir 
  42.         break 
  43.     } 
  44.      
  45.     # Load-SMO assemblies 
  46.     [void][System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.Smo") 
  47.     [void][System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.SqlEnum") 
  48.     [void][System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.SmoEnum")  
  49.     [void][System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.ConnectionInfo")  
  50.      
  51.     # Create a Server object for default instance 
  52.     Write-Debug "Connecting to server: $ServerInstance"  
  53.     $namedInstance = New-Object ('Microsoft.SqlServer.Management.Smo.Server') ($serverInstance) 
  54.  
  55.     # Get server attributes and convert attribute info to HTML 
  56.     # Save to file and overwrite the file if it exists 
  57.      
  58.     Write-Debug "Saving $outputFile..." 
  59.     # TIP: using PowerShell convert an output stream to formatted HTML 
  60.     $namedInstance.EnumServerAttributes() | ` 
  61.         convertto-html -property attribute_name, attribute_value ` 
  62.         -title "Server Attributes" -body '<font face="Verdana">' ` 
  63.         | foreach {$_ -replace "<th>", "<th align=left>"} ` 
  64.         | Out-File $outputFile 
  65.      
  66.     # TIP: Open new browser window and display ServerAttributes.html 
  67.     #      requires confirmation 
  68.     invoke-item $outputFile -confirm 
  69.  
  70.     # Cleanup 
  71.     remove-variable namedInstance  
  72.     remove-variable tempDir 
  73.     remove-variable outputFile 
  74. } 
  75.  
  76. main 
Filed under: , , ,

Connect to SQL Server and output server attributes to HTML

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