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
Share
Related questions
Getting this error on multiple machines,
Not able to patch few machines
Feature updates 1803/2004/20H2 to 21H2/22H2 is not happening through SCCM for windows 10 Pro (OEM) but SCCM showing compliant while its not
The exception unknown software exception (0xe0434352) occurred in the Application at location 0x000000007721C732
Best practice deploy application
Leave an answer
Sorry, you do not have permission to answer to this question .
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/