Author Archives: penguyen

SCCM – Creating Device Collection using OU

Query: 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.SystemOUName = “DOMAIN.LOCAL/OU1” If you have sub-OUs, and would like to exclude those sub-OUs from your query, you can add the following: and SMS_R_System.ResourceID Not In (Select ResourceID from SMS_R_System Where SystemOUName like  “DOMAIN.LOCAL/OU1/SUB-OU-1-TO-EXCLUDE” or SystemOUName like “DOMAIN.LOCAL/OU1/SUB-OU-2-TO-EXCLUDE”) So the entire Query would look something like: […]

SCCM: Logs to check when troubleshooting software updates.

Server Side Software Update Logs: SUPsetup.log – Installation of SUP Site Role. WCM.log, WSUSCtrl.log – Configuration of WSUS Server/SUP. WSyncMgr.log – SMS/WSUS Updates Synchronization Issues. Objreplmgr.log – Policy Issues for Update Assignments/CI Version Info policies. RuleEngine.log – Auto Deployment Rules. Client Side Software Update Logs: UpdatesDeployment.log – Deployments, SDK, UX. UpdatesHandler.log – Updates, Download. ScanAgent.log […]

Troubleshooting Rapid Growth in Databases and Transaction Log Files in Exchange Server 2007 and 2010

I found this blog from the technet site. Just copied and pasted here in case the blog won’t be available for future use. Link to original blog is below:   A few years back, a very detailed blog post was released on Troubleshooting Exchange 2007 Store Log/Database growth issues. We wanted to revisit this […]

Arris Cable Modem has backdoor in backdoor

Solarwinds AppInsight: Unable to create wsMan listener (Error code: 16024).

I was trying to get AppInsight IIS working on my SharePoint boxes. The automatic configuration option through SAM threw up this error: Unable to create wsMan listener (Error code: 16024). Upon checking the SPN on the SharePoint server I found that the http option were missing: setspn -L Sharepoint01 Registered ServicePrincipalNames for CN=Sharepoint01,OU=Sharepoint 2010,OU=Serv ers,DC=domain,DC=com: CmRcService/Sharepoint01 CmRcService/ […]

Avoiding PKI Mistakes

get-wmiobject returns object not found

If you run get-wmiobject and it returns an error that says Object not found. Here’s how to fix it:   For Server 2003: rundll32 wbemupgd, RepairWMISetup For Server 2008: winmgmt /verifyrepository If this doesn’t work, try renaming or deleting the repository: First, you need to stop the WIN Management service net stop winmgmt Then, rename […]