Using Update Statement in SQL when using joins

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 example: Suppose we have 2 tables that … Continue reading Using Update Statement in SQL when using joins

Mapped drives disappear after logoff or reboot

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 soon as i logged off the runbook … Continue reading Mapped drives disappear after logoff or reboot

System Center Orchestrator runbook for removing SCCM records

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 database : $error.clear() powershell{ cd "D:\Program Files\Microsoft … Continue reading System Center Orchestrator runbook for removing SCCM records

SQL query for SCCM to pull out Hostname, Ip Address , OU location and Operating system

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 requirement was for servers , but if … Continue reading SQL query for SCCM to pull out Hostname, Ip Address , OU location and Operating system

Update Rollup 1 for Microsoft System Center 2016 Orchestrator is now available

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 improvements to Orchestrator and  recommendation is  that … Continue reading Update Rollup 1 for Microsoft System Center 2016 Orchestrator is now available

SCCM report to show disk utilization for all endpoints

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 get through SCCM reports . This report … Continue reading SCCM report to show disk utilization for all endpoints