using SQL stored procedures How to get the list of .rar files from e:\Tempbackup directories from the different remote desktop windows server and delete the .rar files which contains the current month and date

Concept: Every month i need to find the list of .rar files from the E:/TempBackup directory from the different environments (remote desktop servers) and i need to delete the current month .rar files alone from the respective (E:/TempBackup) directory. below is example files structure inside the E:/TempBackup.
example:
zDROP_2014_08_31_Backups.rar zDROP_2014_09_31_Backups.rar zDROP_2014_10_31_Backups.rar from the above list i need to delete the zDROP_2014_08_31_Backups.rar(current month) file alone and also logs should be capture for this deletion.
key words for this are zDROP and Current month and date.
i need a stored procedure for this concept. could you please help on this.