Active Discovery Script "SPLIT"?

The following works for me:

> $Issuer = "CN=UCLA Health AD Certificate Authority-CA1, DC=ad, DC=medctr, DC=ucla, DC=edu"
> (($Issuer -split ",") |? {$_ -like "CN=*"}) -replace "CN="
UCLA Health AD Certificate Authority-CA1

It works for me in the Collector Attribute Script but does not work in the Active Discovery Script...

Quote

| Select-Object { `
  $_.Thumbprint + "##" `
  + $_.Issuer + "##" `
+ $_.Subject + $_.Issuer + "##" `
+ "##" `
+ "cert.issuer=" + $_.Issuer `
+ "&cert.friendlyname=" + $_.FriendlyName `
+ "&cert.serialnumber=" + $_.SerialNumber `
+ "&cert.thumbprint=" + $_.Thumbprint `
+ "&cert.issuerby=" + {(($_.Issuer -split ",") |? {$_ -like "CN=*"}) -replace "CN="} `
+ "&cert.days=" + {($_.NotAfter - [datetime]::Today).Days} `

It works for me in the Collector Attribute Script but does not work in the Active Discovery Script...

I don't get the field split available in my report or in the device info...

I tried also the days to expire and I have the same issue as well...

After waiting an hour the auto.cert.days finally appears...

the field is in but the value if incorrect...

but still missing the auto.cert.idssuerby...

If you're making changes to the DS, you need to manually kick off discovery on the device to see the results right away (within a couple minutes).

Btw, adding auto.cert.days as a property is an alternative way of getting the data into a report (a resource inventory report).

3 minutes ago, Stuart Weenig said:

If you're making changes to the DS, you need to manually kick off discovery on the device to see the results right away (within a couple minutes).

Btw, adding auto.cert.days as a property is an alternative way of getting the data into a report (a resource inventory report).

For the auto.cert.days appears in the info but the calculation by "{($_.NotAfter - [datetime]::Today).Days}" remains as text not change as value !!!!

For the auto.cert.issuerby still not appearing in the info and as it was in before the "days" it might be an issue with the name ... uppercase/lowercase... syntax!!!

Find out for the Days there was too many {} ...

This should be the last script:

##--------------- Discovery ------------------##
$pshost = Get-Host              # Get the PowerShell Host.
$pswindow = $pshost.UI.RawUI    # Get the PowerShell Host's UI.

$newsize = $pswindow.BufferSize # Get the UI's current Buffer Size.
$newsize.width = 800            # Set the new buffer's width to 800 columns.
$pswindow.buffersize = $newsize # Set the new Buffer Size as active.

$newsize = $pswindow.windowsize # Get the UI's current Window Size.
$newsize.width = 800            # Set the new Window Width to 800 columns.
$pswindow.windowsize = $newsize # Set the new Window Size as active.

$readOnly     = [System.Security.Cryptography.X509Certificates.OpenFlags]"ReadOnly"
$localMachine = [System.Security.Cryptography.X509Certificates.StoreLocation]"LocalMachine"
$store        = new-object System.Security.Cryptography.X509Certificates.X509Store( "\\##SYSTEM.SYSNAME##\my", $localMachine )

$store.Open( $readOnly )

$store.Certificates `
| Select-Object { `
  $_.Thumbprint + "##" `
  + $_.Issuer + "##" `
+ $_.Subject + $_.Issuer + $_.NotAfter + "##" `
+ "##" `
+ "cert.issuer=" + $_.Issuer `
+ "&cert.friendlyname=" + $_.FriendlyName `
+ "&cert.serialnumber=" + $_.SerialNumber `
+ "&cert.thumbprint=" + $_.Thumbprint `
+ "&cert.days=" + ($_.NotAfter - [datetime]::Today).Days `
+ "&cert.issuerby=" + (($_.Issuer -split ",") |? {$_ -like "CN=*"}) -replace "CN=" `
} `
| Format-Table -HideTableHeaders

----=================================================================================================----

Thanks,

Dom

Checking the report now

Everything i listed properly in the test Active Discovery but the report does not show anything anymore !!!

Checking ...

Thanks,

Dom