Cisco Date of Manufacturing Chart

Find All Cisco Devices and Their Date of Manufacturing

This report pulls the date of manufacturing from the serial number and provides an overview of all switches with their manufacturing date in a chart. Find out how old your network equipment is and which devices might be first in line for a replacement. Alternatively, you can use the Cisco Date of Manufacturing report if you want the standard version of this report. You can use this report in the dashboard chart report widget to display get the chart displayed below.

Cisco Date of Manufacturing chart

Cisco Date of Manufacturing Chart Query

Select Top 1000000 DatePart(yyyy, DateAdd(DAY, 7 *
  SubString(tblAssetCustom.Serialnumber, 6, 2) - 7, DateAdd(YEAR, 96 +
  SubString(tblAssetCustom.Serialnumber, 4, 2), 0))) As ManYear,
  Count(tblAssets.AssetID) As Total
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%' And tsysAssetTypes.AssetType = 6
Group By DatePart(yyyy, DateAdd(DAY, 7 * SubString(tblAssetCustom.Serialnumber,
  6, 2) - 7, DateAdd(YEAR, 96 + SubString(tblAssetCustom.Serialnumber,
  4, 2), 0)))
Order By ManYear

Run This Report in 3 Easy Steps

Download-Install-Lansweeper

1. Download & Install Lansweeper

Save-and-Run-the-Report

3. Run the Report

Download Lansweeper to Run this Report

Harness the Power of Reporting