ML
    • Recent
    • Categories
    • Tags
    • Popular
    • Users
    • Groups
    • Register
    • Login

    SQL: Query SUSDB for MS17-010

    IT Discussion
    3
    4
    673
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • GreyG
      Grey
      last edited by

      Has anyone made a query to peer in the SUSDB for the presence of a specific update being applied? I was hoping someone else has this so I can copy their work. 😄

      1 Reply Last reply Reply Quote 0
      • D
        Delete
        last edited by

        Rather than query the SQL backend use Powershell!

        1 Reply Last reply Reply Quote 0
        • GreyG
          Grey
          last edited by

          I found an article on technet that pointed me to the right table. For reference, it's vComputerTarget. If you are using Excel, like me, then you can make the sql connection to that table in the sudb and get the meaningful material. Finding the technet article took a bit of searching. If anyone else needs it, here you go.

          https://msdn.microsoft.com/en-us/library/windows/desktop/bb410149(v=vs.85).aspx

          1 Reply Last reply Reply Quote 0
          • momurdaM
            momurda
            last edited by momurda

            Cant you just use the wsus console to view this information? It will tell you how many computers and which computers need/have a specific update applied.
            I suppose you could take that page, find the query it uses and copy it.
            Or just use the console.

            1 Reply Last reply Reply Quote 1
            • 1 / 1
            • First post
              Last post