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

solved 0
JV 7 months 2021-01-13T15:20:47+05:30 1 Answer 32 views Beginner 0

Answer ( 1 )

  2. Anoop C Nair
    1
    2021-01-13T15:49:21+05:30
    Reply

    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 a permission to answer to this question .