A simple query to cm_computer_system and cm_snmp_interface would do the trick if it is discovered by the discovery_agent
select cs.name,si.if_name,si.if_alias,si.if_descr from cm_snmp_interface si, cm_computer_system cs WHERE cs.cs_id = si.cs_id
If not discovered, then the probe solution is one way to go.