A few days ago I began receiving errors when running reports in the ConfigMgr console and the web portal. The DefaultValue expression for the report parameter UserTokenSIDs contains an error: “The trust relationship between this workstation and the primary domain
ConfigMgr Database Maintenance – 2020 edition
Steve Thompson, ConfigMgr MVP and SQL MVP, has a nice write up on using Ola’s Maintenance Solution with ConfigMgr. It’s good stuff. Matthew Teegarden has a follow-up article with more info and some alterations. There’s only one problem… both are
ConfigMgr Status Filter Rule with alternate credentials
A recent customer wanted an automated SSRS Report Email Subscription anytime a new deployment was created. I’d been pondering how do accomplish that for some time, but finally got a catalyst and a bit of time. I found a PowerShell
SSRS Error 401.3 Access is denied
So, you’ve been denied! It’s OK. It happens to the best of us. Server Error in ‘/Reports’ Application. Access is denied. Description: An error occurred while accessing the resources required to serve this request. You might not have permission to
ConfigMgr Reporting Services Point with complex SQL
In a new ConfigMgr 2012 R2 SP1 environment the Reporting Services point was proving a bit challenging to install. After setting all of the required permission it was finally happy. Required Permissions On the SQL Server Reporting Services server, an
SCCM Inventory of IPAddress SkipAsSource
< div class=”ExternalClass56053B2187DC429B993BBB746BA0DCAD”> A customer of mine was looking for a way to verify that servers with multiple IP Addresses (mostly web severs) were configured to use a specific IP for all default communications. SkipAsSource is a Boolean flag which
A Collection of ConfigMgr 2012 Collection Queries
Tommy Gunn started a great post on this same topic at SystemCenterCentral. I’m adding my own here. *note: these are WQL queries for ConfigMgr/SCCM collections, but all will translate to T-SQL queries for reporting. Computers which are joined to a
ReportServerService logs not deleted
I was performing some initial discovery on a SCCM primary site server and noticed a lack of disk space. Using WinDirStat.exe I started digging deeper and discovered almost 100gb of ReportServerService_<timestamp>.log files. These are associated with the SQL Server Reporting