Compiling ICCID numbers

I have been tasked with identifying all of our companies active SIM cards. Currently I can log into each modem that we have in and run the AT command to pull the ICCID. however this process it quite tedious considering that we have hundreds of modems deployed. I am looking for a way to either be able to include the info as a column in the device export data or be able to automate the task of logging into each modem executing the command and recording the results in a spreadsheet.

It is better to report the modem information to the cloud as far as possible. I will feed back your requirements.

I don’t understand what you meant by that.