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 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
SQL Reporting with custom pagination and Excel named worksheets
< div class=”ExternalClass16EB91745BFA419384C0E3307E72D388″> With some guidance from Microsoft TechNet, Edward at StackOverflow.com, and Adam at RedThree, I managed to enhance the Compliance 5 – Computers in a Collection report by separating each computer onto its own page. When exported to
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