I just ran across a bug in SCCM 2012 SP1 that I thought I would post here in case someone else runs across it.  There is a posting on it in Connect and credit for solving it goes to Keith Thornley at Premier.  Apparently this was identified in one of the RCs, but didn't make it into the final release. 

If you try running the report "Software Distribution - Application Monitoring > Application deployments per asset" it will fail.  The error on the SRS server is:

An error occurred during client rendering.

An error has occurred during report processing.

Query execution failed for dataset 'DataSet1'.

The EXECUTE permission was denied on the object 'fnLShortNameToLCID', database 'CM_CAS', schema 'dbo'

To fix it you need to go into SQL Server Management Studio and go to

Databases / CM_XXX / Security / Roles / Database roles / smsschm_users

Open the properties for smsschm_users and select securables.  Unfortunately the fnLShortNameToLCID won't show up in the list.  You have to do a search for it with the following

• Select Specific objects
• Object types select 'Scalar function'
• For Object name type in fnLShortNameToLCID
• Press OK
• You should get another dialog box come up with the function listed.
• You can now scroll down to fnLShortNameToLCID and select 'Execute'

The report should now