My question is about pulling the media type in a report, ie: RJ-45 or SFP. Does anyone know if there is a SWQL query that will yield information this for an interface?
You could poll the snmp OID for these: https://www.iana.org/assignments/ianamau-mib/ianamau-mib
IANAifJackType ::= TEXTUAL-CONVENTION STATUS current DESCRIPTION "Common enumeration values for repeater and interface MAU jack types. This data type is used as the syntax of the ifJackType and rpJackType objects in the (updated) definition of MAU-MIB's ifJackTable and rpJackTable respectively. Possible values are: other(1) - undefined or unknown rj45(2) - RJ45 rj45S(3) - RJ45 shielded db9(4) - DB9 bnc(5) - BNC fAUI(6) - AUI female mAUI(7) - AUI male fiberSC(8) - SC fiber fiberMIC(9) - MIC fiber fiberST(10) - ST fiber telco(11) - Telco mtrj(12) - MT-RJ fiber hssdc(13) - fiber channel style-2 fiberLC(14) - LC fiber cx4(15) - IB4X for 10GBASE-CX4 sfpPlusDA(16) - SFP+ Direct Attach for 10GE
Unfortunately, it looks like the devices don't support the OID in my case but this would work otherwise.
