Cisco date of manufacture
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(Serialnu...