2 Replies Latest reply on May 19, 2017 10:58 AM by slalani

    Report KB patches from Asset Inventory in NPM

    IanBaker

      Does anyone know hoe to get data from the Asset Inventory in NPM. I am tasked with providing a list of Windows KB patches to our Technicians. Unfortunately the Inventory report only shows other installed patches but none of the Windows Update patches. Is it possible to get this data out. I can see it on the Asset Inventory Tab?

        • Re: Report KB patches from Asset Inventory in NPM
          IanBaker

          Its Okay I have produced a report to give me this info now. Simple SQL query. Here it is if it is of any interest:

           

          SELECT ALL

                  [SolarWindsOrion].[dbo].[Nodes].[NodeID]

                , [SolarWindsOrion].[dbo].[Nodes].[Caption]

                ,[SolarWindsOrion].[dbo].[AssetInventory_OSUpdates].[Name]

                ,[SolarWindsOrion].[dbo].[AssetInventory_OSUpdates].[Type]

            FROM [SolarWindsOrion].[dbo].[Nodes], [SolarWindsOrion].[dbo].[AssetInventory_OSUpdates]

          Where [SolarWindsOrion].[dbo].[AssetInventory_OSUpdates].[NodeID] =  [SolarWindsOrion].[dbo].[Nodes].[NodeID]

          1 of 1 people found this helpful