I need SQL query to get the machines list which are not patched SInce 2 months

Question

Hi All,

 

SQL Query to get machines list that are not patched since 2 months.

 

Regards,

JN

Answer ( 1 )

  1. I have better options to share ..CMPivot is the best option to get these details in real-time. Checkout the following options?

    https://www.anoopcnair.com/sccm-cmpivot-query-patches-installed-in-last-90-days-configmgr/
    https://www.anoopcnair.com/find-devices-missing-patches-using-configmgr-cmpivot-query-sccm/

    Karthick/Deepak shared another SQL query for patch reports

    https://www.anoopcnair.com/sccm-patch-status-sql-query-based-collection/

    Best answer

Leave an answer

Sorry, you do not have permission to answer to this question .