1 Reply Latest reply on Jul 29, 2016 9:18 AM by cwinning

    Batching Bulletin to get Qnumbers

    troyfred Rookie

      Hello all,

       

           I am fairly new to Shavlik but I understand that the scans use the Qnumbers to search for patches being applied to the target. I am creating a patch group that scans for the last 2 years of Microsoft patches that have been isolated on a list. The problem is that all of the patches are the  Bulletin ID and so far the only way I have found to get the corresponding Q number is one at a time in the patches area. Is there a way of using a text file with the Bulletin numbers to get a batched list of Qnumbers? Any help would be a life saver and time saver. Thanks

       

      Troy

        • 1. Re: Batching Bulletin to get Qnumbers
          cwinning CommunityTeam

          Hello,

           

          We definitely don't have anything from the GUI, PowerShell script or SQL script for this.

           

          You may be able to use SQL and our Report Views to accomplish this.  The basics would be to open a text file in SQL and then query for the patches.  The caveat is your going to need to know SQL to get this accomplished.

           

          SELECT [Id]

                ,[Bulletin]

                ,[QNumber]

                ,[BulletinTitle]

                ,[VendorSeverityId]

                ,[IsCustomPatch]

                ,[PatchTypeId]

                ,[ReleasedOn]

            FROM [Reporting].[Patch]

            WHERE

                [Bulletin] = 'From Text File'

           

          Report Views Guide

           

          Thanks,

          Charles