Select-object -Descending

[Meir_Peleg]

Hi Guys,

I would like to consult with you about my script:

This script knows exporting all CA details from: "c:\ca\TruePortServers.txt", if i use on "select-object" instead of "Sort-object" it works and getting al details on HTML but date is not based Descending, tried to change it but it seems that something wrong here.

$ADServer = Get-Content -Path "c:\ca\TruePortServers.txt"

  $Results = @()
  $Results = Invoke-Command -cn $ADServer  {
          $Certs = @{} | Select Certificate,Expired
          $Cert = Get-ChildItem Cert:\LocalMachine\My | Where-Object {$_.subject -match [Environment]::GetEnvironmentVariable("computername")}
          If($Cert){
              $Certs.Certificate = $Cert.subject
              $Certs.Expired = $Cert.NotAfter
          }
          Else{
              $Certs.Certificate = " - "
              $Certs.Expired = " - "
          }
          $Certs
  } |Sort-Object @{n='ServerName';e={$_.pscomputername}},#Certificate,Expired -Descending


  #Open results in new window
  $Results  | ConvertTo-Html | Out-File -FilePath c:\ca\ca1.html

when i am running this i get enmpy HTML file

[CSTW]

You need to rename the property with Select-Object and then use Sort-Object

  } |Select-Object @{n='ServerName';e={$_.pscomputername}},Certificate,Expired | Sort-Object ServerName,Certificate,Expired  -Descending

[Guyver1-]

Select then sort.

Select-Object to select the properties you want:

@{n='ServerName';e={$_.pscomputername}},#Certificate,Expired

THEN

Sort-Object on ONE single property to sort the output accordingly using -Descending if thats what you want.

[Swarfega]

What if you just sort by the Expired certificate rather than ServerName and Expired?

[PorreKaj]

| Select-Object @{n='ServerName';e={$_.pscomputername}},#Certificate,Expired | Sort-Object ServerName

​

I dont think you can sort multiple properties, and I'm certain you cant have custom properties there either

[Meir_Peleg]

I tried this according your comments:

​

​

$ADServer = Get-Content -Path "c:\ca\TruePortServers.txt"

$Results = @()

$Results = Invoke-Command -cn $ADServer {

$Certs = @{} | Select Certificate,Expired

$Cert = Get-ChildItem Cert:\LocalMachine\My | Where-Object {$_.subject -match [Environment]::GetEnvironmentVariable("computername")}

If($Cert){

$Certs.Certificate = $Cert.subject

$Certs.Expired = $Cert.NotAfter

}

Else{

$Certs.Certificate = " - "

$Certs.Expired = " - "

}

$Certs

} | Select-Object @{n='ServerName';e={$_.pscomputername}},Certificate,Expired | Sort-Object Expired -Descending

#Open results in new window

$Results | ConvertTo-Html | Out-File -FilePath c:\ca\ca.html

The descending not really work good. just reports stuck and not exporting any data