cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
5 REPLIES 5
Esben_D
Lansweeper Employee
Lansweeper Employee

All of the vulnerability reports are things I create to help all the customers and serve as an example of what you could do. So its more inspiration rather than a service (hence why its free).

The version @Mister_Nobody posted is a great example that compares all your assets to the highest version detected in your environment. So if you install the latest version on one device, that report should work great.


The alternative would be to use the old report you find and update it with the latest driver numbers stated in the NVIDIA security center.

Mister_Nobody
Honored Sweeper II

Universal report:

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.oscode,
  tblVideoController.caption,
  tblVideoController.driverversion As Version,
  b.LatestVersion As [Highest Version Detected],
  tblVideoController.Lastchanged,
  tblAssets.Lastseen
From tblAssets
  Inner Join tblVideoController On
      tblAssets.AssetID = tblVideoController.AssetID
  Inner Join (Select __.caption,
      __.Major,
      __.Minor,
      __.Build,
      __.Revision,
      LatestVersion = __.driverversion
    From (Select *,
          r = Row_Number() Over (Partition By _.Caption Order By _.Major Desc,
          _.Minor Desc, _.Build Desc, _.Revision Desc)
        From (Select Distinct tblVideoController.caption,
              Major = Convert(int,ParseName(tblVideoController.driverversion,
              4)),
              Minor = Convert(int,ParseName(tblVideoController.driverversion,
              3)),
              Build = Convert(int,ParseName(tblVideoController.driverversion,
              2)),
              Revision = Convert(int,ParseName(tblVideoController.driverversion,
              1)),
              tblVideoController.driverversion
            From tblVideoController
            Where tblVideoController.adapterram > 0 And
              IsNumeric(Replace(tblVideoController.driverversion, '.',
              '')) = 1) _) __
    Where __.r = 1) b On tblVideoController.driverversion <> b.LatestVersion And
      tblVideoController.Caption = b.caption
Mister_Nobody
Honored Sweeper II

You can change filter by youself.

@Mister_Nobody 
Of course I could do.
But why I should do that?
I expect Lansweeper to provide up-to-date versions of such reports on a regular basis.

Mister_Nobody
Honored Sweeper II

IMHO:
You are asking a question in the community, not an official request for support via https://www.lansweeper.com/contact-support/.
Accordingly, you can make a contribution to the community.