356add2e49
Migration 075: Cisco Nexus 9300 SE1 (7 models) — poster-image + support CDN Migration 076: QuantaMesh (3), QNAP QSW-M5216-1T, Sophos CS210-48FP (5 models) Migration 077: Barracuda F900, Peplink SD Switch 24-Port, Westermo Lynx 5612 (3 models) Coverage: 428 → 443 images (63.8% → 66.0%)
83 lines
4.6 KiB
SQL
83 lines
4.6 KiB
SQL
-- Migration 075 — Cisco Nexus 9300 SE1 Cloud-Scale Switches
|
||
--
|
||
-- All 6 URLs verified HTTP 200 (2026-04-21).
|
||
--
|
||
-- Sources:
|
||
-- N9324C-SE1U + N9348Y2C6D-SE1U:
|
||
-- cisco.com/content/dam/cisco-cdc/site/images/poster-image/
|
||
-- Official Cisco CDC poster-image CDN (these are case-sensitive — 9348y2C6d).
|
||
-- N9336C-SE1 + N9364E-SG2-Q + N9396T12C-SE1 + N9396Y12C-SE1:
|
||
-- cisco.com/c/dam/assets/support/product-images/model/
|
||
-- Official Cisco Support CDN (model-specific product images, lowercase slugs).
|
||
--
|
||
-- N9364E-SG2-O:
|
||
-- SG2-O (QSFP-DD uplinks) and SG2-Q (QSFP28 uplinks) share the same
|
||
-- 64-slot chassis physical form factor. SG2-O image returns 404 on all
|
||
-- known Cisco DAM paths; SG2-Q image (124KB, confirmed 200 OK) used.
|
||
--
|
||
-- Product page for all models: Nexus 9000 Series (SE1 subpage).
|
||
--
|
||
-- Skipped (line cards / no standalone chassis photo):
|
||
-- N9300v: virtual switch, no physical chassis image.
|
||
-- All NC55-*, NC57-*, C9600-LC-*, A9K-*, A99-*, ASR-9000V-* etc.
|
||
-- remain skipped (line cards or module-only SKUs).
|
||
|
||
-- ── Cisco Nexus 9300 SE1 Series ──────────────────────────────────────────────
|
||
|
||
-- N9324C-SE1U — 24×400G QSFP-DD cloud-scale campus spine switch
|
||
UPDATE switches
|
||
SET image_url = 'https://www.cisco.com/content/dam/cisco-cdc/site/images/poster-image/model-9324c-se1u.jpg',
|
||
product_page_url = COALESCE(product_page_url, 'https://www.cisco.com/c/en/us/products/switches/nexus-9000-series-switches/index.html'),
|
||
assets_scraped_at = NOW()
|
||
WHERE model = 'N9324C-SE1U'
|
||
AND vendor_id = (SELECT id FROM vendors WHERE slug = 'cisco');
|
||
|
||
-- N9336C-SE1 — 36×400G QSFP-DD cloud-scale ToR/spine switch
|
||
UPDATE switches
|
||
SET image_url = 'https://www.cisco.com/c/dam/assets/support/product-images/model/switches-nexus-9336c-se1-switch-model.jpg',
|
||
product_page_url = COALESCE(product_page_url, 'https://www.cisco.com/c/en/us/products/switches/nexus-9000-series-switches/index.html'),
|
||
assets_scraped_at = NOW()
|
||
WHERE model = 'N9336C-SE1'
|
||
AND vendor_id = (SELECT id FROM vendors WHERE slug = 'cisco');
|
||
|
||
-- N9348Y2C6D-SE1U — 48×25G SFP28 + 2×100G + 6×400G cloud-scale switch
|
||
UPDATE switches
|
||
SET image_url = 'https://www.cisco.com/content/dam/cisco-cdc/site/images/poster-image/model-9348y2C6d-se1u.jpg',
|
||
product_page_url = COALESCE(product_page_url, 'https://www.cisco.com/c/en/us/products/switches/nexus-9000-series-switches/index.html'),
|
||
assets_scraped_at = NOW()
|
||
WHERE model = 'N9348Y2C6D-SE1U'
|
||
AND vendor_id = (SELECT id FROM vendors WHERE slug = 'cisco');
|
||
|
||
-- N9364E-SG2-O — 64-slot 400G QSFP-DD AI/hyperscale spine switch
|
||
-- Image: SG2-Q photo used (same chassis, SG2-O-specific image unavailable on Cisco DAM)
|
||
UPDATE switches
|
||
SET image_url = 'https://www.cisco.com/c/dam/assets/support/product-images/model/switches-nexus-9364e-sg2-q-switch-model.jpg',
|
||
product_page_url = COALESCE(product_page_url, 'https://www.cisco.com/c/en/us/products/switches/nexus-9000-series-switches/index.html'),
|
||
assets_scraped_at = NOW()
|
||
WHERE model = 'N9364E-SG2-O'
|
||
AND vendor_id = (SELECT id FROM vendors WHERE slug = 'cisco');
|
||
|
||
-- N9364E-SG2-Q — 64-slot 400G QSFP28 AI/hyperscale spine switch
|
||
UPDATE switches
|
||
SET image_url = 'https://www.cisco.com/c/dam/assets/support/product-images/model/switches-nexus-9364e-sg2-q-switch-model.jpg',
|
||
product_page_url = COALESCE(product_page_url, 'https://www.cisco.com/c/en/us/products/switches/nexus-9000-series-switches/index.html'),
|
||
assets_scraped_at = NOW()
|
||
WHERE model = 'N9364E-SG2-Q'
|
||
AND vendor_id = (SELECT id FROM vendors WHERE slug = 'cisco');
|
||
|
||
-- N9396T12C-SE1 — 96×10G BASE-T + 12×100G cloud-scale access switch
|
||
UPDATE switches
|
||
SET image_url = 'https://www.cisco.com/c/dam/assets/support/product-images/model/switches-nexus-9396t12c-se1-switch-model.jpg',
|
||
product_page_url = COALESCE(product_page_url, 'https://www.cisco.com/c/en/us/products/switches/nexus-9000-series-switches/index.html'),
|
||
assets_scraped_at = NOW()
|
||
WHERE model = 'N9396T12C-SE1'
|
||
AND vendor_id = (SELECT id FROM vendors WHERE slug = 'cisco');
|
||
|
||
-- N9396Y12C-SE1 — 96×25G SFP28 + 12×100G cloud-scale access switch
|
||
UPDATE switches
|
||
SET image_url = 'https://www.cisco.com/c/dam/assets/support/product-images/model/switches-nexus-9396y12c-se1-switch-model.jpg',
|
||
product_page_url = COALESCE(product_page_url, 'https://www.cisco.com/c/en/us/products/switches/nexus-9000-series-switches/index.html'),
|
||
assets_scraped_at = NOW()
|
||
WHERE model = 'N9396Y12C-SE1'
|
||
AND vendor_id = (SELECT id FROM vendors WHERE slug = 'cisco');
|