cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JohnLewis
Engaged Sweeper II
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%'
1 ACCEPTED SOLUTION
Jeremy_D
Champion Sweeper
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

View solution in original post

1 REPLY 1
Jeremy_D
Champion Sweeper
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