Category: System Centre

SCCM reports show "The DefaultValue expression for the report parameter ‘UserTokenSIDS’ contains an error: The user name or password is incorrect. (rsRuntimeErrorInExpression)"

Had a rare fresh SCCM install recently with a client that has more of a security focus than many of our other clients. Had SCCM 2002 (current at time of writing), Server 2019, SQL 2017 and Reporting services 2017. Reporting services is using the default, "virtual service account", which, under the covers, is "NT Service\SQLReportingServices"…

Continue reading

SCCM – picking random clients for a collection

There are plenty of ways to randomly add systems to a collection in SCCM, a common query being something similar to select SMS_R_System.Name from SMS_R_System where SMS_R_System.SMSUniqueIdentifier like "%0" OR SMS_R_System.SMSUniqueIdentifier like "%1" In a recent instance, i needed to ensure that systems were randomly chosen for a product roll out across a 1500-ish servers…

Continue reading

SCCM antimalware client policies – do they merge ?

There seems to be a great deal of mis-information about this floating around the web.... despite articles like this that lay it out quite well. When you create an SCCM antimalware policy, the settings do merge. You do not have to create bucketloads of policies and apply/re-apply the same settings over and over and over…

Continue reading

Surface Pro X and Pro 7 – SCCM deployment

A few years back - an (ex) employee posted on the Adexis blog about the fun of Surface laptops and deployment in SCCM https://blog.adexis.com.au/2018/04/09/microsoft-surface-laptops-and-sccm-os-deployment/#comment-1478 Personally, i've deployed a lot of Surface Pro 3's and 4's.... but not so much after that.... until now. During the week i was called into a client to find out…

Continue reading

Deploying the new chromium based edge via SCCM

New Edge, Credge, Edgium or Credgium - no matter what you call it, the Edge browser based on chromium was released on Jan 15th 2020. To deploy the new versions using SCCM 1910 (or above) Add "Microsoft Edge" a product that is sync'ed in your software update point component properties Somewhat confusingly, the product is…

Continue reading

Microsoft Endpoint Manager – potentially SCCM's future

Microsoft Endpoint Manager - announced at Ignite - https://redmondmag.com/articles/2019/11/04/microsoft-endpoint-manager.aspx There's a lot of words in the announcement that don't mean much.... but it is an indication of how MS plan to move forward in this space. As it stands, the SCCM/Intune integration attempts have ranged from pretty bad to OK.... it will be interesting to…

Continue reading

SCCM 1906 release

SCCM 1906 released! - https://docs.microsoft.com/en-us/sccm/core/plan-design/changes/whats-new-in-version-1906 If you want it right now - you can opt-in via the fast ring script - https://go.microsoft.com/fwlink/?linkid=2099733 Another belting release from the SCCM team - while some releases have different focuses over time - generally releases have tended to have something which makes day-to-day admin life a bit easier for…

Continue reading