Is there a transceiver only report available in Ciscoworks? I was trying to do this in the Custom Reports in LMS 3.2, RME but I didn't see a way how other than to generate a detailed device report.
If there isn't, are there plans to implement one in LMS 4.0?
No, this cannot be done yet. There is an enhancement open to get port serial numbers (e.g. for SFPs, GBICs, etc.). That bug ID is CSCsz48654. There is also another bug open to pull all RME DDR attributes into custom reports (CSCsj78780). RME 4.0 will have some of this, but serial numbers right now are not available.
Please support CSC Helps Haiti