Scripts/FoxSites/Get-FoxSitesInformation.ps1
|
function Get-FoxSitesInformation { param ( [securestring]$SecuredCredentials, [Parameter(ValueFromPipeline)]$Servers, [Parameter(Mandatory)][ValidateSet('Console', 'QuickReview','HTML', 'Excel','CSV')]$OutputType ) $WrinRMStatus=Get-Service -Name WinRM |Select-Object -ExpandProperty Status if($WrinRMStatus -eq 'Stopped'){ Start-Service -Name WinRM } 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 Site 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''' Get-Service -Name WinRM | start-service $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 '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 'IIS Server' -Value $HostName.ToUpper() 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'{$SitesInfo |Select-Object -ExcludeProperty 'PSComputerName','RunspaceId','PSShowComputerName' | Out-GridHtml} '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\IISSitesInformation.csv"){Remove-Item -Path "$Path\IISSitesInformation.csv" -Force} $SitesInfo |Select-Object -ExcludeProperty 'PSComputerName','RunspaceId','PSShowComputerName' | Out-File -FilePath "$Path\IISSitesInformation.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\IISSitesInformation.xlsx"){Remove-Item -Path "$Path\IISSitesInformation.xlsx" -Force} $SitesInfo |Select-Object -ExcludeProperty 'PSComputerName','RunspaceId','PSShowComputerName' | Export-Excel -Path "$Path\IISSitesInformation.xlsx" -Title 'Your Fox IIS 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'} } if($WrinRMStatus -eq 'Stopped'){ Stop-service -Name WinRM } } |