Report Showing NIC & Driver Version

[jaycii]

Hi,

I’m currently trying to build a report that will show me all computers with an “Intel Dual Band Wireless – AC 7265” NIC.

Out of these computers I need to see which ones need their Wireless Driver updated.

Can I please get assistance with creating a custom report that shows computers with
Intel Dual Band Wireless – AC 7265 wireless adapter with the driver version at 18.44 & below.

[Esben_D]

Windows driver scanning has now been added: https://www.lansweeper.com/updates/introducing-lansweepers-2022-spring-launch-aymon/#h-windows-driver-scanning

[fjca]

jaycii wrote:
Hi,

I’m currently trying to build a report that will show me all computers with an “Intel Dual Band Wireless – AC 7265” NIC.

Out of these computers I need to see which ones need their Wireless Driver updated.

Can I please get assistance with creating a custom report that shows computers with
Intel Dual Band Wireless – AC 7265 wireless adapter with the driver version at 18.44 & below.

Hello,

I needed to do a similar thing (comparing driver versions), and ended up doing a version scan of the specific driver file.
Im my case the machines are Dell Optiplex 380, and the network driver itself is the file c:\windows\system32\drivers\k57nd60a.sys. So, the first thing to do is go to "Scanning" tab, "File And Registry Scanning", and add the driver file for your card under File Scanning. This gets run daily, so do a full rescan of the machines, so LS picks up the correct info.

For the report itself, I copied this one from the forums, it has more information them I needed, but I was on a hurry and didn't trimmed it down.

Options for you to change according to your environment are the tblFileVersions.FilePathfull, you can see that I search for k57 (yes, I'm lazy) and I also limit the query to Dell Optiples 380 machines. You may also limit the driver version with tblFileVersions.FileVersion.

Select Top 1000000 tsysOS.Image As icon,
  tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.IPAddress,
  SubQuery1.PatchSearched,
  Case SubQuery1.Found When 1 Then 'Yes' Else 'No' End As FileFound,
  SubQuery1.FileVersion As [Driver Version],
  SubQuery1.Filesize,
  SubQuery1.CreationDate,
  SubQuery1.LastAccessed,
  SubQuery1.LastModified,
  SubQuery1.Lastchanged,
  TsysLastscan.Lasttime As LastFileScan,
  tblAssetCustom.Model,
  tblBIOS.SMBIOSBIOSVersion,
  tblAssets.Lastseen,
  Case
    When TsysLastscan.Lasttime < GetDate() -
    1 Then
    'Last file scan more than 24 hours ago! Scanned file information may not be up-to-date. Try rescanning this machine.' End As Comment
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
  Inner Join TsysLastscan On tblAssets.AssetID = TsysLastscan.AssetID
  Inner Join TsysWaittime On TsysWaittime.CFGCode = TsysLastscan.CFGcode
  Left Join (Select Top 1000000 tblFileVersions.AssetID,
    tblFileVersions.FilePathfull As PatchSearched,
    tblFileVersions.Found,
    tblFileVersions.FileVersion,
    tblFileVersions.CompanyName,
    tblFileVersions.Filesize,
    tblFileVersions.Lastchanged,
    tblFileVersions.CreationDate,
    tblFileVersions.LastAccessed,
    tblFileVersions.LastModified
  From tblFileVersions
  Where tblFileVersions.FilePathfull Like '%k57%') SubQuery1
    On SubQuery1.AssetID = tblAssets.AssetID
  Inner Join tblBIOS On tblAssets.AssetID = tblBIOS.AssetID
Where tblAssetCustom.Model Like '%optiplex 380%' And tblAssetCustom.State = 1
  And TsysWaittime.CFGname = 'files'
Order By tblAssets.AssetName

[MikeMc]

I did a quick look through Lansweeper and it does not look like driver versions are scanned. You do have other potential options within Lansweeper.

• When you install Intel drivers the package usually installs other software. You can perhaps check this software version against your other machines and see if there is a pattern.
  
• If it exists, you can try scanning a common registry value for the driver version and run a report based off those results.

Another option would be using Powershell to query the values remotely:

Get-WmiObject Win32_PnPSignedDriver -computer <ComputerName> | Where { $_.DeviceName -eq "Intel Dual Band Wireless – AC 7265" } | select devicename, driverversion