HI All,
I have created a script the List down the advanced settings configured on the number of Hosts in the VC. Below are the vaules i need to find out form the ESXi hosts.
QFullSampleSize = 32
QFullThreshold = 4
IOPS = 1
disable ATS hearbeat
EnableNaviReg = 0
ReqCallThreshold = 30
Below is the script i created
$VC = read-host "Please enter vCenter Name"
connect-viserver $VC
$esxHosts = Get-VMHost | Sort Name
$esxcli = Get-EsxCli -VMHost $esxHosts
foreach($esx in $esxHosts)
{
Get-AdvancedSetting -Entity $esx -Name Disk.QFullSampleSize | Select Entity,Name,Value | Export-CSV -NoTypeInformation -Append -path c:\scripts\ADSettings.csv
Get-AdvancedSetting -Entity $esx -Name Disk.QFullThreshold| Select Entity,Name,Value | Export-CSV -NoTypeInformation -Append -path c:\scripts\ADSettings.csv
Get-AdvancedSetting -Entity $esx -Name Disk.EnableNaviReg| Select Entity,Name,Value | Export-CSV -NoTypeInformation -Append -path c:\scripts\ADSettings.csv
Get-AdvancedSetting -Entity $esx -Name Disk.ReqCallThreshold| Select Entity,Name,Value | Export-CSV -NoTypeInformation -Append -path c:\scripts\ADSettings.csv
Get-AdvancedSetting -Entity $esx -Name VMFS3.UseATSForHBOnVMFS5 | Select Entity,Name,Value | Export-CSV -NoTypeInformation -Append -path c:\scripts\ADSettings.csv
$esxcli.storage.nmp.satp.rule.list()| select PSPOptions, @{Name="ESXihost" ; Expression = {$esxHosts}}
#}
Write-Host
Write-Host "Done. Check the c:\scripts\ADSettings.csv file now." -ForegroundColor Green
For the above Get-AdvancedSetting i am getting the correct output in Excel but not able to get the correct output for $esxcli.storage.nmp.satp.rule.list() in EXcel along with the above values.
I ran the below command separately with 2 methods but i am not getting one liner command.
METHOD 1:
PS C:\Windows\system32> $esxcli.storage.nmp.satp.rule.list()| select PSPOptions, @{Name="ESXihost" ; Expression = {$esxHosts}}
OUTPUT:-
PSPOptions ESXihost
---------- --------
Host Name
Host Name
Host Name
Host Name
Host Name
Host Name
Host Name
Host Name
Host Name
Host Name
iops=1 Host Name
Host Name
Host Name
Host Name
Host Name
Host Name
Host Name
Host Name
Host Name
METHOD 2:
PS C:\Windows\system32> $esxcli.storage.nmp.satp.rule.list()| where {$_.PSPOptions -eq "iops=1"}
OUTPUT:-
ClaimOptions :
DefaultPSP : VMW_PSP_RR
Description :
Device :
Driver :
Model : XtremApp
Name : VMW_SATP_DEFAULT_AA
Options :
PSPOptions : iops=1
RuleGroup : system
Transport :
Vendor : XtremIO
Whereas I wanted an output in the below manner:
| Entity | Name | Value |
| Host Name | Disk.QFullSampleSize | 32 |
| Host Name | Disk.QFullThreshold | 4 |
| Host Name | Disk.EnableNaviReg | 0 |
| Host Name | Disk.ReqCallThreshold | 30 |
| Host Name | VMFS3.UseATSForHBOnVMFS5 | 0 |
| Host Name | PSPOptions | IOPS=1 |
Can someone help me please.
