Category Uncategorized

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: https://blogs.technet.microsoft.com/exchange/2013/04/18/troubleshooting-rapid-growth-in-databases-and-transaction-log-files-in-exchange-server-2007-and-2010/   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


https://w00tsec.blogspot.com/2015/11/arris-cable-modem-has-backdoor-in.html

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/Sharepoint01.domain.com […]

Avoiding PKI Mistakes


https://vimeo.com/nicconf/review/35053082/aaff51b192

IIS exploits in Windows Server and how you can fix them


This is a really good article from techtarget: http://searchwindowsserver.techtarget.com/tip/IIS-exploits-in-Windows-Server-and-how-you-can-fix-them   I believe it’s safe to say that a common goal of Windows server administrators is to have reasonably resilient systems. There’s a lot going on in the world of online security threats. The last thing you need is someone on the other side of the […]