Hi @Poonam_Dogra ,
Following are my suggestions for your queries:
1. How should we retarget pending broadlogs as per best practice- We are planning to get these pending records from broadlog and then retarget them-- Please let me know if there could be a better approach for this?
First, there is already a retry mechanism in the Adobe campaign (link) so you may review this property in your deliveries and may add/increase the retry period for pending deliveries. Also, check the "validity_period" in the Submit_SM setting of your SMPP external account to make sure there is some short limit set to SMS retires. (link)
Second, if you want to re-target the 'Pending' broadLogs' recipients daily for Sms delivery, you can create a retry workflow that fetches the 'Pending' status logs for that particular SMS delivery (table to use: nms:broadLogRcp) and then target them again.
2. How to get the logs of these pending broadlog status sharing the reason of them being in pending status?
Tabel will be nms:broadLogsRcp and the reason for the 'Pending' should be explained in the incoming SR's that you can find in the nms:inSMS table
3. How to make sure those were not delivered at all? or if only the broadlog status of these ids were not changed but the sms was sent?
First, make sure that there is no syncing issue with the incoming SR's for the Submit SMs of your SMS deliveries. For this refer to my old answer here
Br,
Shubham