使用powershell格式化CSV文件输出
使用powershell格式化CSV文件输出
提问于 2019-05-20 01:23:42
我编写了以下代码，将证书详细信息存储在csv文件中。它可以工作，但在csv文件的每一行中，开头的符号@{和结尾的符号}在第一列中是written.also，其中包含标题，符号=也被写入。所以我不知道如何在没有这些符号的情况下填充我的csv文件
下面是我写的代码
$StartDate = Get-Date
$CertPath = 'Cert:\LocalMachine\'
$CertsDetail = Get-ChildItem -Path $CertPath -Recurse | Where-Object {$_.PsIsContainer -ne $true } | ForEach-Object {
$DaysLeft = (New-TimeSpan -Start $StartDate -End $_.NotAfter).Days
If ($DaysLeft -lt 30) {
$Under30 = $true
$Text = "The Certificate is but valid about to expire"
}
Else {
$Under30 = $false
}
If ($DaysLeft -lt 1) {
$Expired = $true
#$Not_Expired = $false
$Text = "The Certificate is expired"
}
Else {
$Expired = $false
#$Not_Expired = $true
$Text = "The Certificate is still valid and not going soon to expire"
}
[pscustomobject]@{Text=$Text;`
Subject = $_.Subject;`
ExpireDate = $_.NotAfter;`
DaysRemaining = $DaysLeft;`
Under30Days = $Under30;`
Expired = $Expired;`
#Not_Expired = $Not_Expired
}
}
$obj = [PSCustomObject] @{
'Example Header 1' = $null
'Example Header 2' = $null
'Example Header 3' = $null
'Example Header 4' = $null
'Example Header 5' = $null
'Example Header 6' = $null
$obj | Add-Content -Path 'C:\Users\hanna\Desktop\certificate.csv'
$CertsDetail | Add-Content -Path 'C:\Users\hanna\Desktop\certificate.csv'回答 1
Stack Overflow用户
回答已采纳
发布于 2019-05-20 01:39:13
尝试如下所示：
$StartDate = Get-Date
$CertPath = 'Cert:\LocalMachine\'
$CertsDetail = Get-ChildItem -Path $CertPath -Recurse |
Where-Object { $_.PsIsContainer -ne $true } | ForEach-Object {
$DaysLeft = (New-TimeSpan -Start $StartDate -End $_.NotAfter).Days
if ($DaysLeft -lt 1) {
$Under30 = $true
$Expired = $true
$Text = "The Certificate is expired"
}
elseif ($DaysLeft -lt 30) {
$Under30 = $true
$Expired = $false
$Text = "The Certificate is but valid about to expire"
}
else {
$Under30 = $false
$Expired = $false
$Text = "The Certificate is still valid and not going soon to expire"
}
[PSCustomObject]@{
Text = $Text
Subject = $_.Subject
ExpireDate = $_.NotAfter
DaysRemaining = $DaysLeft
Under30Days = $Under30
Expired = $Expired
}
}
$CertsDetail | Export-Csv -Path 'C:\Users\hanna\Desktop\certificate.csv'页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/56210279
复制相关文章
相似问题
腾讯云开发者
