20 lines
772 B
Plaintext
Executable File
20 lines
772 B
Plaintext
Executable File
select entPhysical.entPhysicalDescr as 'SFP Description',
|
|
entPhysical.entPhysicalVendorType as 'SFP Type',
|
|
entPhysical.entPhysicalSerialNum as 'SFP Serial',
|
|
entPhysical.entPhysicalName as 'Port Name',
|
|
ports.port_descr_descr as 'Port Description',
|
|
devices.hostname as 'Host',
|
|
ports.ifAdminStatus as 'Admin-Status',
|
|
ports.ifOperStatus as 'Oper-Status'
|
|
from entPhysical
|
|
join devices
|
|
on (entPhysical.device_id = devices.device_id)
|
|
join ports \
|
|
on (entPhysical.device_id = ports.device_id)
|
|
where ports.ifindex = entPhysical.ifindex
|
|
and entPhysical.entPhysicalDescr like '%SFP%'
|
|
and (entPhysical.entPhysicalVendorType like 'cevPort%'
|
|
or entPhysical.entPhysicalVendorType like 'cevSFP%')
|
|
;
|
|
|