SCCM SQL Query - Systems Vulnerable to WannaCrypt Ransomware Malware

SCCM SQL query to show systems that may be vulnerable to the WannaCrypt ransomware virus.

665 times
Add to favorites
System Center
E-mail Twitter Digg Facebook
Sign in to ask a question

  • Nobody ?
    2 Posts | Last post May 11, 2018
    • ???
    • I apologize about replying so late, but Microsoft has not figured out a way to send notifications when someone asks a question here. 
      Anyway, I do not speak French, but I was able to translate what you asked using Google. 
      If you are getting an error that states that the v_r_system view does not exist, then you need to ensure that you are running the script on the SCCM database. 
  • Erreur
    2 Posts | Last post June 02, 2017
    • Bonjour, 
      En lançant la requête, j'ai cette erreur :
      Msg 208, Niveau 16, État 1, Ligne 8
      Nom d'objet 'v_R_System' non valide.
      Merci par avance.
    • Je suis en SQL 2014 et SCCM 1606