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
How to change pre-req which is in use for more than 10 applications in MECM
How to change pre-req which is in use for more than 10 applications in MECM
What’s the difference between Dell Command Update and Dell Command
I have two SCCM DP’s is it possible to have 2 PXE responder, one on each DP.
Move the SCCM console -primary site- to anocher new
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/