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
in progress
0
Configuration Manager
2 weeks
2021-01-13T15:20:47+05:30
2021-01-13T15:20:47+05:30 1 Answer
21 views
Beginner 0
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/