Category: System Center

System Center

SCCM Collection Query for all Workgroup Machines

Reading Time: < 1 minuteNothing too special about this post, just a query statement. Use this query in an SCCM collection and it will give you all WORKGROUP machines.   select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System where SMS_R_System.ResourceDomainORWorkgroup = “WORKGROUP”   There ya go! Hope I’ve made your day, at least a little bit easier.

Matt Hansen 
SQL System Center

No email option in SCOM 2012 report subscription

Reading Time: 2 minutesSo this is the issue — you’re going to subscribe to a report in SCOM and the only options are “Windows File Share” and “Null Delivery Provider”.   Well that’s a problem…we want these reports emailed. This error typically occurs when a SQL Migration is done, the reporting role is migrated, or on new installs. […]

Matt Hansen 
System Center Windows Windows Server

SCCM 2012 “Perform site maintenance or reset this site” Greyed Out / Unavailable

Reading Time: 2 minutesAs I went to upgrade an evaluation version of System Center Configuration Manager 2012 to a full version, I noticed unlike Operations Manager — you have to do this through the setup/install interface. Upon first search people were saying just run the setup again and choose “Perform site maintenance or reset the site”, though it […]

Matt Hansen