Hi everyone, Let’s discuss the SQL update statement when using joins in SQL. Many of us try to make this complicated when we try to use update statement when dealing with two tables using joins. Please follow along for this short SQL lesson on UPDATE USING JOINS. For […]
Hi Guys , For those of you wanting to automate the decommission of servers or desktops or users you can use the following powershell script or runbook for disabling the AD account provided the service account has the rights to do disable the AD account and then move […]
Hi everyone, usually we see that mapped drives disappear after logoff or reboot. So below are the following 2 ways to prevent that from happening . I had an issue today where i was running the orchestrator and it had to connect to mapped drive but as i […]
Hi Everyone , Hope you are doing great! Today i am writing about an scenario which talks about automating SCCM record removal through Orchestrator . The runbook once created will look like the following : You can use the following Powershell script to remove the record from the […]
Hi everyone , A simple sql query that will get you the hostname , IP address , OU location and operating system details from your SCCM database . Select s.Netbios_Name0,ip.IP_Addresses0, s.Distinguished_Name0,s.operatingSystem0, s.Operating_System_Name_and0 from v_RA_System_IPAddresses AS IP inner join v_R_System AS S on ip.ResourceID=s.ResourceID where operatingSystem0 like ‘%Server%’; My […]
Voila ! Hi everyone , today i will cover how to go about installing 2016 Orchestrator step by step and also to let you know that the Microsoft System Center 2016 Orchestrator General Availability Update Rollup is now available. This update rollup package provides a collection of minor […]
Hi There , Yesterday i had a requirement to go through the disk space utilization for all the servers in our environment to keep a track before year end . Now remember we are not looking for a report that shows low disk space which you can readily […]
Hi Everyone , For those of you who are using SCUP to update java need to be careful for one very important scenario which might leave your client ( Servers in my case ) without any version of Java . We faced an issue last week when we […]
Deploying Office 2010 through SCCM 2012 SP1 R2: Hi All, I was going through the office installation today with some custom requirements where we want to deploy Office 2010 with the following components: Excel Word PowerPoint I will be deploying the Volume License edition of Microsoft Office 2010 […]
Hello Everyone , Today i will talk about an issue which is very common if you are dealing with patch management . Ever seen that you apply software updates to a system and after reboot when the system comes up we see the below given screen on the system […]
sukhdeepblogs