No, you can not get your CIF number through SMS. You can get your State Bank of India CIF number on the first page of your Bank Passbook.