CrowdStrike Update Causes BSOD Issues Globally – Audit Available 🛡️ Learn more

TRY NOW

Cisco Date of Manufacturing Audit

Hardware Network Devices

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. 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 Chart report if you want a chart version of this report. Cisco Date of Manufacturing

Cisco Date of Manufacturing Query

SELECT TOP 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tsysAssetTypes.AssetTypename,
  tsysAssetTypes.AssetTypeIcon10 AS icon,
  tblAssets.IPAddress,
  Serialnumber,
  DATEADD(DAY,7*SUBSTRING(Serialnumber,6,2)-7,
  DATEADD(YEAR,96+SUBSTRING(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.State = 1 AND Manufacturer LIKE '%cisco%' AND Serialnumber <> ''

Show

Hide

NO CREDIT CARD REQUIRED

Ready to get started?
You’ll be up and running in no time.

Explore all our features, free for 14 days.