Microsoft

System Center Configuration Manager Feedback

Suggestion box powered by UserVoice

How can we improve Configuration Manager?

Bug & Solution // Error The SELECT permission was denied on the object 'v_WindowsServicingStates'

Windows Server 2016
SCCM just upgraded to SCCM CB 1806

When i run the Report "Lifecycle 01A - Computers with a specific software product" and i select "Windows 10, version 1703" it throws an error:
Error The SELECT permission was denied on the object 'v_WindowsServicingStates'
It Works fine if I for example select "Windows 8.1"

I could reproduce it both environments - Test and Live.

Solution:
smsschm_users had no rights on the view 'v_WindowsServicingStates' for select
set it manually, then it works

13 votes
Vote
Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
You have left! (?) (thinking…)
PatrickDo shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

2 comments

Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
Submitting...

Feedback and Knowledge Base