Conversion failed when converting value to data type about sccm-zone.com HOT 6 CLOSED

I have a lot of reports, which one are you refering to?

from sccm-zone.com.

Oh sorry, it's the "CB Configuration Baseline Compliance by Configuration Item with Values" one.

However, a colleague and I found the issue, we believe. The ID's in the error correspond with 'AdminIDs' for Administrative users in SCCM. And the issue only happens to users who are members of multiple groups and/or specified explicitly in the administrative users section in the console.

In my case, my user account was explicitly defined as an admin AND I am a member of another group which is also defined as an admin in the console. The error is actually coming from the definition of 'UserSIDs'.

My user's UserTokenSIDs as it passes into 'dbo.fn_rbac_GetAdminIDsfromUserSIDs' results in two ID's coming back from the function. But instead of Microsoft listing them as 2 separate values, they concatenate them into one string joined with a comma.

Workaround:
Remove the duplicate Administrative User entry.

Fix?:
My colleague wrote some simple T-SQL to automatically split the string (if it needs to), and select the first ID in the newly created array. This is, more than likely, not ideal as it's not checking for the highest permissions levels.

from sccm-zone.com.

Hmm, I will look for a workaround, thanks for reporting this

from sccm-zone.com.

No problem, when I get into work, I will post the extra code that got it working.

from sccm-zone.com.

For now the simple workaround is to uncomment this line
--DECLARE @UserSIDs AS NVARCHAR(250) = 1;
If it does not work you might need to replace the value with 'Disabled'

NOTE: This will disable the report security!

from sccm-zone.com.

Implemented workaround, upgraded report template and other optimisations.
Released v4.0

from sccm-zone.com.