尝试在没有故障转移列表的情况下获取dhcp，但它很混乱
尝试在没有故障转移列表的情况下获取dhcp，但它很混乱
提问于 2020-03-26 09:53:48
‘我尝试导出一个没有故障转移的DHCP服务器列表，但它全部在一行中输出(A1)所有的标题都是coma后的coma。对不起，我是新来的powershell。’
$CSVFile = "C:\Dhcp_report_$CurrentDate.csv"$machines = Get-DhcpServerInDC
"DHCPServer,SecondaryDHCPServer,ScopeName,ScopeID,Subnetmask,Startrange,Endrange" |out-file -
FilePath $CSVFile -append
foreach ($machine in $machines)
{
$DHCPName = $machine.dnsname
if ($DHCPName -notin @("server01.company.corp","server02.company.corp")){
$AllScopes = Get-DhcpServerv4Scope -ComputerName $DHCPName
foreach ($scope in $AllScopes)
{
$ScopeName = $scope.Name
$ScopeId = $scope.ScopeId
$failoverscope = Get-dhcpserverv4failover -ComputerName $DHCPName -ScopeId $ScopeId -ErrorAction SilentlyContinue
if ($failoverscope) {
$SecDHCP = ($failoverscope.SecondaryServerName)
}
else {
$SecDHCP = "no failover"
}
$Subnetmask = $scope.subnetmask
$Startrange = $scope.startrange
$Endrange = $scope.endrange
$OutInfo = ($DHCPName).Replace(".company.corp","") + "," + ($SecDHCP).Replace(".company.corp","") +
"," +$ScopeName + "," + $ScopeId+ "," + $Subnetmask + "," + $Startrange + "," + $Endrange
Write-Host $OutInfo
Add-Content -Value $OutInfo -Path $CSVFile
}
}
}回答 1
Stack Overflow用户
发布于 2020-03-26 10:25:23
有一个用于将数据导出到csv的cmdlet Export-Csv：
$CSVFile = "C:\Dhcp_report_$CurrentDate.csv"
$machines = Get-DhcpServerInDC
"DHCPServer,SecondaryDHCPServer,ScopeName,ScopeID,Subnetmask,Startrange,Endrange"
foreach ($machine in $machines)
{
$DHCPName = $machine.dnsname
if ($DHCPName -notin @("server01.company.corp","server02.company.corp")){
$AllScopes = Get-DhcpServerv4Scope -ComputerName $DHCPName
foreach ($scope in $AllScopes)
{
$ScopeName = $scope.Name
$ScopeId = $scope.ScopeId
$failoverscope = Get-dhcpserverv4failover -ComputerName $DHCPName -ScopeId $ScopeId -ErrorAction SilentlyContinue
if ($failoverscope) {
$SecDHCP = ($failoverscope.SecondaryServerName)
}
else {
$SecDHCP = "no failover"
}
$Subnetmask = $scope.subnetmask
$Startrange = $scope.startrange
$Endrange = $scope.endrange
[pscustomobject]@{
DHCPServer = ($DHCPName).Replace(".company.corp","")
SecondaryDHCPServer = ($SecDHCP).Replace(".company.corp","")
ScopeName = $ScopeName
ScopeID = $ScopeId
SubnetMask = $Subnetmask
StartRange = $Startrange
EndRange = $Endrange
}
} | Export-Csv $Csv -NoTypeInformation
}
} 在这里，我在psobject中排列数据并将其导出到csv。
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/60864630
复制相关文章
![[译]PG复制和自动故障转移--1](https://ask.qcloudimg.com/http-save/yehe-4783313/2a604811d905b20e875a8e009201fb06.png)
相似问题
故障转移没有启动
表语法很混乱
CSS a:悬停很混乱
命令没有在Python - Real basics中定义，但是很混乱！
正在尝试获取APi，但它没有显示数据
添加站长 进交流群
领取专属 10元无门槛券
AI混元助手 在线答疑
关注 腾讯云开发者公众号
洞察 腾讯核心技术
剖析业界实践案例
腾讯云开发者
