transceiver-db/sql/066-juniper-images.sql
Rene Fichtmueller 4e927acf55 data: switch image coverage 065-072 — Cisco/Juniper/Arista/NVIDIA/Huawei/Nokia/Dell/Extreme/HPE/Ubiquiti/Supermicro/Celestica/Asterfusion/FS.com/Edgecore
Migrations 065-072: 72 verified image URLs across all 17 tier-1 vendors.
- 065: Cisco 8000/Catalyst/Nexus/NCS (14) — cisco.com/c/dam doc CDN
- 066: Juniper EX/MX/QFX (10) — juniper.net/content/dam image library
- 067: Arista remaining 7000-series (11) — arista.com QSG front-panel PNGs
- 068: NVIDIA Mellanox SN-series (5) — docscontent.nvidia.com dims4 CDN
- 069: Huawei CloudEngine/NE40E (5) + Nokia IXR-D3L/7750 SR-14s (2)
- 070: Dell PowerSwitch ON-series (5) + Extreme Networks 8720/X465 (2)
- 071: HPE Aruba CX 6300M/8100/8360 (3) + Ubiquiti USW (3) + Supermicro (2)
- 072: Celestica DS3000/4000/5000 (3) + Asterfusion CX-N (3) + FS.com (2) + Edgecore (2)

All URLs verified HTTP 200 (2026-04-21). 5 models skipped (no public image found):
Arista 7280R3A-48D5, 750-36Y; NVIDIA SN3750-SX; Nokia 7750 SR-1 (hotlink-protected), 7220 IXR-H4.
2026-04-21 11:34:38 +02:00

92 lines
5.6 KiB
SQL
Raw Permalink Blame History

This file contains ambiguous Unicode characters

This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.

-- Migration 066 — Juniper Networks: EX Series, MX Series, QFX Series
--
-- All 10 URLs verified HTTP 200 (2026-04-21).
-- Image CDN: juniper.net/content/dam/www/assets/images/us/en/image-library/[series]/[model]/
-- Official Juniper image library — stable, high-res front-panel photos.
-- ── EX Series ────────────────────────────────────────────────────────────────
-- EX4100-48P — 48×1G PoE+ + 4×10G SFP+ campus switch
UPDATE switches
SET image_url = 'https://www.juniper.net/content/dam/www/assets/images/us/en/image-library/ex-series/ex4100-48t-48p/ex4100-48p-front-high.jpg',
product_page_url = COALESCE(product_page_url, 'https://www.juniper.net/us/en/products/switches/ex-series/ex4100-ethernet-switch.html'),
assets_scraped_at = NOW()
WHERE model = 'EX4100-48P'
AND vendor_id = (SELECT id FROM vendors WHERE slug = 'juniper');
-- EX4400-48T — 48×1G campus switch with flexible uplinks
UPDATE switches
SET image_url = 'https://www.juniper.net/content/dam/www/assets/images/us/en/image-library/ex-series/ex4400/ex4400-48t-front-straight.jpg',
product_page_url = COALESCE(product_page_url, 'https://www.juniper.net/us/en/products/switches/ex-series/ex4400-ethernet-switch.html'),
assets_scraped_at = NOW()
WHERE model = 'EX4400-48T'
AND vendor_id = (SELECT id FROM vendors WHERE slug = 'juniper');
-- EX4650-48Y — 48×25G SFP28 + 4×100G QSFP28 data center switch
UPDATE switches
SET image_url = 'https://www.juniper.net/content/dam/www/assets/images/us/en/image-library/ex-series/ex4650-48y/ex4650-48y-front-high.jpg',
product_page_url = COALESCE(product_page_url, 'https://www.juniper.net/us/en/products/switches/ex-series/ex4650-ethernet-switch.html'),
assets_scraped_at = NOW()
WHERE model = 'EX4650-48Y'
AND vendor_id = (SELECT id FROM vendors WHERE slug = 'juniper');
-- ── MX Series ────────────────────────────────────────────────────────────────
-- MX10008 — 8-slot universal routing platform chassis
UPDATE switches
SET image_url = 'https://www.juniper.net/content/dam/www/assets/images/us/en/image-library/mx-series/mx10008/mx10008-front-high.jpg',
product_page_url = COALESCE(product_page_url, 'https://www.juniper.net/us/en/products/routers/mx-series/mx10008-universal-routing-platform.html'),
assets_scraped_at = NOW()
WHERE model = 'MX10008'
AND vendor_id = (SELECT id FROM vendors WHERE slug = 'juniper');
-- MX304 — compact 12×100G/24×40G universal edge router
UPDATE switches
SET image_url = 'https://www.juniper.net/content/dam/www/assets/images/us/en/image-library/mx-series/mx304/mx304-front-high.jpg',
product_page_url = COALESCE(product_page_url, 'https://www.juniper.net/us/en/products/routers/mx-series/mx304-universal-routing-platform.html'),
assets_scraped_at = NOW()
WHERE model = 'MX304'
AND vendor_id = (SELECT id FROM vendors WHERE slug = 'juniper');
-- ── QFX Series ───────────────────────────────────────────────────────────────
-- QFX10008 — 8-slot data center spine/core chassis
UPDATE switches
SET image_url = 'https://www.juniper.net/content/dam/www/assets/images/us/en/image-library/qfx-series/qfx10008/qfx10008-front-high.jpg',
product_page_url = COALESCE(product_page_url, 'https://www.juniper.net/us/en/products/switches/qfx-series/qfx10008-switch.html'),
assets_scraped_at = NOW()
WHERE model = 'QFX10008'
AND vendor_id = (SELECT id FROM vendors WHERE slug = 'juniper');
-- QFX5120-48Y — 48×25G + 8×100G leaf switch (Junos)
UPDATE switches
SET image_url = 'https://www.juniper.net/content/dam/www/assets/images/us/en/image-library/qfx-series/qfx5120-48y/qfx5120-48y-front-high.jpg',
product_page_url = COALESCE(product_page_url, 'https://www.juniper.net/us/en/products/switches/qfx-series/qfx5120-switch.html'),
assets_scraped_at = NOW()
WHERE model = 'QFX5120-48Y'
AND vendor_id = (SELECT id FROM vendors WHERE slug = 'juniper');
-- QFX5130-32CD — 32×400G QSFP-DD leaf/spine switch
UPDATE switches
SET image_url = 'https://www.juniper.net/content/dam/www/assets/images/us/en/image-library/qfx-series/qfx5130-32cd/qfx5130-32cd-front-high.jpg',
product_page_url = COALESCE(product_page_url, 'https://www.juniper.net/us/en/products/switches/qfx-series/qfx5130-switch.html'),
assets_scraped_at = NOW()
WHERE model = 'QFX5130-32CD'
AND vendor_id = (SELECT id FROM vendors WHERE slug = 'juniper');
-- QFX5220-32CD — 32×400G QSFP-DD spine switch (Trident 4)
UPDATE switches
SET image_url = 'https://www.juniper.net/content/dam/www/assets/images/us/en/image-library/qfx-series/qfx5220-32cd/qfx5220-32cd-front-high.jpg',
product_page_url = COALESCE(product_page_url, 'https://www.juniper.net/us/en/products/switches/qfx-series/qfx5220-switch.html'),
assets_scraped_at = NOW()
WHERE model = 'QFX5220-32CD'
AND vendor_id = (SELECT id FROM vendors WHERE slug = 'juniper');
-- QFX5700 — modular 6-slot data center switch
UPDATE switches
SET image_url = 'https://www.juniper.net/content/dam/www/assets/images/us/en/image-library/qfx-series/qfx5700/qfx5700-front-high.jpg',
product_page_url = COALESCE(product_page_url, 'https://www.juniper.net/us/en/products/switches/qfx-series/qfx5700-switch.html'),
assets_scraped_at = NOW()
WHERE model = 'QFX5700'
AND vendor_id = (SELECT id FROM vendors WHERE slug = 'juniper');