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
Hi Team, is there any script that can remove all versions of Ms Project from workstations
I have found one script for fetching office365 addin but for exporting the data to CSV is not working
Backup is not happening sccm database, getting error .ldf file is not readable , in short ldf and xml files are missing from backup while mdf file is there
What is the best way to restrict MECM clients to a specific server for all MECM needs?
SCCM: Recover Secondary Site to a different Hardware
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/