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
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
Hi All,
SQL Query to get machines list that are not patched since 2 months.
Regards,
JN
Answer ( 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/