outgoing sms activity link to provider when using multiple providers?
From the db schema https://doc.symbiotic.coop/dev/civicrm/latest/schema/tables/civicrm_sms_provider.html

It looks like you might be after the sms_provider_id from the civicrm_mailing table, or sms_provider_id from the civicrm_action_schedule table.