Scripts/FoxSites/Get-FoxSitesInformation.ps1
|
function Get-FoxSitesInformation { <# .SYNOPSIS CREATE A TABLE WITH INFORMATION ABOUT FOX SITES. .PARAMETER SecuredCredentials IF NOT SUPPLIED, ASKSF OR CREDENTIALS IF SUPPLIED, USE THAT SUPPLIED CREDENTIALS .PARAMETER Servers IF NOT SUPPLIED, CHECK FOR FILE "IISServers.csv" IN DOCUMNETS FOLDER THAT INCLUDES SERVER NAMES IF IISServers.csv IS NOT FOUND, ASKS FOR SERVERS AND SAVE TO IISServers.csv FILE AT CHOSEN Location IF SUPPLIED USE THAT SUPPLIED SERVERS. .PARAMETER OutputType HTML: CREATED HTML FILE WITH TABLE CSV: CREATED CSV FILE AT CHOSEN Location. EXCEL: CREATE XLSX FILE AT CHOSEN Location QUICKREVIEW: OUTPUT RESULTS TO CONSOLE .EXAMPLE Get-FoxSitesInformation -OutputType HTML #> param ( [securestring]$SecuredCredentials, [Parameter(ValueFromPipeline)]$Servers, [Parameter(Mandatory)][ValidateSet('Console', 'QuickReview','HTML', 'Excel','CSV')]$OutputType ) if (!($Servers)) { $ServersPath=[Environment]::GetFolderPath('MyDocuments') $ServersPath=$ServersPath+ '\IISServers.csv' if(Test-Path -Path $ServersPath){ $Servers=import-CSV -Path $ServersPath | Select-Object -Unique -ExpandProperty 'Servers' } Else{ Write-host "Notice: This is a one-time Operation`n" -ForegroundColor Yellow 'Servers' | Out-File -FilePath $ServersPath $Servers=(Read-Host -Prompt 'Enter your IIS Server names - Seperated by Commas (,)').Split(',') Add-Content -Value $Servers -Path $ServersPath }} if (!($SecuredCredentials)) { $cred=(Get-Credential) } $SQLQuery='select value as [FoxVersion],UserDataSourcesNew.ServerName as [LDSServer],UserDataSourcesNew.Port as [LDSPort] from SystemConfiguration left join UserDataSourcesNew on UserDataSourcesNew.UsersContainerDistinguishedName=''CN=Fox,CN=OuTree,DC=Fox,DC=Bks'' where SystemConfiguration.property=''version''' $SitesInfo=Invoke-Command -ComputerName $Servers -Credential $cred -ScriptBlock{ ##Remote Start Here Import-Module -Name WebAdministration $SitesInfo=@() $HostName=$env:computername $Sites=Get-ChildItem -Path IIS:\Sites | Where-Object -Property Name -NE 'Default Web Site'|Where-Object -Property Name -NotLike "*OPT*" foreach($Site in $Sites){ $SiteName=($Site|Select-Object -ExpandProperty Name) IF(Test-Path -Path HKLM:\SOFTWARE\BKS\Fox\$Site){ $Registry="HKLM:\SOFTWARE\BKS\Fox\$SiteName"} Else{ $Registry="HKLM:\SOFTWARE\WOW6432Node\BKS\Fox\$SiteName"} if ($null -ne (Get-ItemProperty -Path $Registry -Name Location -ErrorAction SilentlyContinue).Location){ $SQLInstance=Get-ItemProperty -Path $Registry | Select-Object -ExpandProperty SQL_Server $DataBase=Get-ItemProperty -Path $Registry | Select-Object -ExpandProperty Sql_DataBase $InstallLocation=Get-ItemProperty -Path $Registry | Select-Object -ExpandProperty Location Switch(Get-ItemProperty -Path $Registry | Select-Object -ExpandProperty SqlAuthenticationType){ 1{$SQLAuthType='SQL'} 2{$SQLAuthType='WINDOWS'} } $SQLInstanceCheck=$SQLInstance.Split('\')[0] if (($SQLInstanceCheck) -eq $HostName) { $SQLResult=Invoke-Sqlcmd -ServerInstance $SQLInstance -Database $DataBase -Query $Using:SQLQuery } else { $SQLResult=Invoke-Command -ComputerName $SQLInstanceCheck -ArgumentList $SQLInstance,$Database,$Using:SQLQuery -Credential $Using:cred -ScriptBlock{ [CmdletBinding()] param($SQLInstance,$Database,$SQLQuery) Invoke-Sqlcmd -ServerInstance $SQLInstance -Database $DataBase -Query $SQLQuery } } $LDSServer=$SQLResult | Select-Object -ExpandProperty LDSServer if ('127.0.0.1' -or $HostName){ $LDSServer=$HostName} $LDSPort=$SQLResult| Select-Object -ExpandProperty LDSPort $Version=$SQLResult| Select-Object -ExpandProperty FoxVersion $item = New-Object -TypeName PSObject Add-Member -InputObject $Item -type NoteProperty -Name 'IIS Server' -Value $HostName.ToUpper() Add-Member -InputObject $Item -type NoteProperty -Name 'Fox Site' -Value $SiteName.ToUpper() Add-Member -InputObject $Item -type NoteProperty -Name 'Site Status' -Value ($Site|Select-Object -ExpandProperty State).ToUpper() Add-Member -InputObject $Item -type NoteProperty -Name 'Fox Version' -Value $Version Add-Member -InputObject $Item -type NoteProperty -Name 'Install Location' -Value $InstallLocation.ToUpper() Add-Member -InputObject $Item -type NoteProperty -Name 'SQL Server' -Value $SQLInstance.ToUpper() Add-Member -InputObject $Item -type NoteProperty -Name 'Fox DataBase' -Value $DataBase.ToUpper() Add-Member -InputObject $Item -type NoteProperty -Name 'SQL Authentication Type' -Value $SQLAuthType Add-Member -InputObject $Item -type NoteProperty -Name 'LDS Server' -Value $LDSServer.ToUpper() Add-Member -InputObject $Item -type NoteProperty -Name 'LDS Port' -Value $LDSPort $SitesInfo+=$Item } } $SitesInfo ##Remote ENDs Here } Switch($OutputType){ 'Console'{$SitesInfo |Select-Object -ExcludeProperty 'PSComputerName','RunspaceId' | Format-Table -AutoSize -Force} 'HTML'{ $Temp=[Environment]::GetFolderPath('MyDocuments') $Temp=$Temp + '\FoxSitesInformation.HTML' $SitesInfo | Out-HtmlView -FilePath $Temp -DisablePaging -ExcludeProperty 'PSComputerName','RunspaceId','PSShowComputerName' -FixedHeader -AutoSize -SearchHighlight -OrderMulti -ResponsivePriorityOrder ('IIS Server') -DefaultSortOrder Ascending -Title 'Fox Sites Information' -Filtering -PreventShowHTML $HTMLContent=Get-Content -Path $Temp $HTMLContent=$HTMLContent -replace '<head>','<head> <!-- DisableCaching --> <meta http-equiv="cache-control" content="no-cache, must-revalidate, post-check=0, pre-check=0" /> <meta http-equiv="cache-control" content="max-age=0" /> <meta http-equiv="expires" content="0" /> <meta http-equiv="expires" content="Tue, 01 Jan 1980 1:00:00 GMT" /> <meta http-equiv="pragma" content="no-cache" /> <!-- End OF DisableCaching --> ' $date=Get-Date -Format "dddd dd/MM/yyyy HH:mm" $replace='<!-- End OF DisableCaching -->' + ' Updated at: ' + $date $HTMLContent=$HTMLContent -replace '<!-- End OF DisableCaching -->',$replace | Out-File -FilePath $temp -Force Invoke-Item -Path $temp } 'CSV'{ Add-Type -AssemblyName System.Windows.Forms $browser = New-Object -TypeName System.Windows.Forms.FolderBrowserDialog $null = $browser.ShowDialog() $Path=$browser.SelectedPath if($Path){ if(Test-Path -Path "$Path\FoxSitesInformation.csv"){Remove-Item -Path "$Path\FoxSitesInformation.csv" -Force} $SitesInfo |Select-Object -ExcludeProperty 'PSComputerName','RunspaceId','PSShowComputerName' | Out-File -FilePath "$Path\FoxSitesInformation.csv"} Else {Write-Host -Object 'No File Selected. Oborting.' -ForegroundColor Red} exit} 'Excel'{ Import-Module -Name ImportExcel Add-Type -AssemblyName System.Windows.Forms $browser = New-Object -TypeName System.Windows.Forms.FolderBrowserDialog $null = $browser.ShowDialog() $Path=$browser.SelectedPath if($Path){ if(Test-Path -Path "$Path\FoxSitesInformation.xlsx"){Remove-Item -Path "$Path\FoxSitesInformation.xlsx" -Force} $SitesInfo |Select-Object -ExcludeProperty 'PSComputerName','RunspaceId','PSShowComputerName' | Export-Excel -Path "$Path\FoxSitesInformation.xlsx" -Title 'Your Fox Sites Information' -WorksheetName (Get-Date -Format 'dd/MM/yyyy') -TitleBold -AutoSize -FreezeTopRowFirstColumn -TableName SitesInformation -Show} Else {Write-Host -Object 'No File Selected. Oborting.' -ForegroundColor Red} exit} 'QuickReview'{$SitesInfo |Select-Object -ExcludeProperty 'PSComputerName','RunspaceId','PSShowComputerName' | Out-GridView -Title 'Your Fox IIS Sites Information'} } } |