CISCO switch and IOS version in report

[JohnLewis]

Is there a way to get the IOS version number for switches and routers in reports?

Current report running is:

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssetCustom.Model,
tblAssetCustom.Serialnumber,
DateAdd(DAY, 7 * SubString(tblAssetCustom.Serialnumber, 6, 2) - 7,
DateAdd(YEAR, 96 + SubString(tblAssetCustom.Serialnumber, 4, 2),
0)) 'Date of Manufacture',
tblAssets.Lastseen,
tblAssets.Lasttried
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Where tblAssetCustom.Serialnumber <> '' And tblAssetCustom.State = 1 And
tblAssetCustom.Manufacturer Like '%cisco%'

[Jeremy_D · Accepted solution]

We received and answered this question via email as well. Below is a copy of the response we sent via email.

There's no specific database field that stores the Cisco IOS version. If the version number is included in the device description though, which may be the case, you could create a report that lists the descriptions. We've included a sample report for Cisco devices below. Instructions for adding this report to your Lansweeper installation can be found here.

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tsysAssetTypes.AssetTypename,
  tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAssets.IPAddress,
  tblAssets.Mac,
  tblAssets.Description,
  tblAssetCustom.PurchaseDate,
  tblAssetCustom.Warrantydate,
  tblAssetCustom.Location,
  tblAssetCustom.Manufacturer,
  tblAssetCustom.Model,
  tblAssetCustom.Contact,
  tblAssetCustom.Serialnumber,
  tblAssets.Firstseen,
  tblAssets.Lastseen,
  tblAssets.Lasttried
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Where tblAssetCustom.Manufacturer Like '%cisco%' And tblAssetCustom.State = 1
Order By tblAssets.IPNumeric,
  tblAssets.AssetName