the view v_CertificateStatus is empty

Duchemin, Dominique 2,006 Reputation points
2021-02-24T00:28:35.687+00:00

Hello,

I am in version MEM CM 2010 + KB4594177.
I was trying the report "Asset with certificates nearing expiry" and I noticed the views v_CertificateStatus and v_CertificateHistory are empty.
Any setting to enable and use these tables?

Thanks,
Dom

Microsoft Configuration Manager
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Amandayou-MSFT 11,051 Reputation points
    2021-02-24T08:21:58.343+00:00

    Hi @Duchemin, Dominique ,

    I query the views v_CertificateStatus and v_CertificateHistory, they are empty too.

    Asset with certificates nearing expiry, is it expiring user certificates? If so, we could use SCCM CI Baseline to check it, here is the link to refer to:
    https://blog.thomasmarcussen.com/using-sccm-ci-baseline-to-check-for-expiring-user-certificates/
    Note: This is non-official Microsoft article just for your reference.

    If not, in order to avoid misunderstanding, could we verify the details of problem?


    If the response is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    1 person found this answer helpful.
    0 comments No comments

  2. Duchemin, Dominique 2,006 Reputation points
    2021-02-24T21:42:07.797+00:00

    Hello,

    Why the views "views v_CertificateStatus and v_CertificateHistory" are empty?
    Also I am looking for Computer Certificate expiring, not User Certificate!!

    $certchk = Get-ChildItem -Path Cert:\LocalMachine\My |

    Where-Object {$.EnhancedKeyUsageList.FriendlyName -eq "Server Authentication" -and $.Issuer -notlike "CN=MS-Organization-P2P-Access*"} |
    Select-Object -Property PSComputerName, Subject, @{n='ExpireInDays';e={($.notafter – (Get-Date)).Days}} |
    Where-Object {$
    .ExpireInDays -lt 90}
    If (!($certchk)) {$Compliance="Compliant"}
    Else {$Compliance="Non-Compliant"}
    $Compliance

    Blockquote

    Thanks,
    Dom