SELECT GS.Name0 as 'PC Name', GSS.DisplayName0 as 'Service', GSS.StartMode0 as 'Startup', GSS.State0 as 'State' FROM v_GS_SERVICE GSS, v_GS_COMPUTER_SYSTEM GS Where GSS.StartMode0 = 'Auto' and GSS.State0 != 'Running' and GSS.ResourceID = GS.ResourceID ORDER BY GS.Name0, GSS.DisplayName0 Thanks to jones for original post.
Author: Eswar Koneti
when deplying image on to bare metal PC,sometimes it may require to get multiple partitions like C,D,E ect depends on the organization requirement.(Going down the route of making multiple partitions is like having multiple wives/girlfriends/lovers… it’s all fun and games for a while but ends with disaster). Here are simple steps that make simpler. 1.On your task sequence,get in to Preinstall->New computer only->formate and partition disk ,on the right pane click on star burst and select 2 volumes (with specific size for each partitions) and made both as primary .(in this case,u will get 2 partitions like C,E). if you need more partitions do as…
Thre are many methods which you can achive this task but i like this way in doing for prompting the computer name in MDT SCCM when deploying an image would be using the below simple VB script.It deals with known and unknown computers. set env = CreateObject("Microsoft.SMS.TSEnvironment") 'Set the OSDComputerName variable to the detected name assuming this is a known computer env("OSDComputerName") = env("_SMSTSMachineName") 'If the detected name contains "MININT" then this is an unknown computer so ask for a name If InStr(1,env("OSDComputerName"),"MININT",1) then Name = inputbox("Rename Computer" ,"Please enter the new Computer name below:",env("OSDComputerName"),400,0) env("OSDComputerName") = Name…
Failure of Task sequence during the PXE is very common and sometimes it is very difficult to know why is it failing until you get the smsts logs .There could be various reasons why the Task sequence is failing.If you try to look at the reports,you may not get exact reason for the failure .There are couple of solutions to get the smsts*. logs incase of task sequence failure .Some of them are given here. 1) you can add task sequence action to copy the logs to share location using cmd as given in http://eskonr.com/tag/copy-the-smsts-log-files-to-a-sharesccm-server-if-task-sequence-fails-in-deploying-os/ 2)Manually getting the logs using…
There are no questions to read for the interview if you really worked on the any technology practically unless and until to see how the questions can be framed/asked in interview. I would like to put some not all questions on SCCM 2007 since it is Huge and many questions can be framed if you gone through the SCCM Guide on TechNet . This post will keep updated on Day to Day basic with Newly Faqs. Systems Management Server 2003 Technical Frequently Asked Questions : Planning and Deployment Site Systems Clients Discovery Inventory Software Metering Software Distribution and Packaging Remote…
I has an issue with the distribution or removal packages from retired / orphaned DP where the packages are distributed to DP but the distribution point are really not on the network (retired ).Because of this, I see the red alerts on the system status with below error. Possible cause: The distribution point might not be accessible to SMS Distribution Manager running on the site server. Solution: If users are currently accessing the package files on the distribution point, disconnect the users first. you can see the below information from your site system status error messages. Package ID : IND0011B…
Having issues with hardware inventory in running on the machines ,there are several tools that does this job like Right click tools ,SMS collection commander from Zander and can use batch script given below. 1.Cretea a folder called Temp in C drive. 2.Crete a new notepad file ,add list of computers that you want to kick the hinv on and save it as Computerlist.txt in c:\Temp folder. 3.Open a notepad and paste the below code and save it as filename.bat . @echo off REM It kickoffs the hinv on to the list of machines provided WMIC /node:@c:\temp\Computerlist.txt /namespace:\\root\ccm path sms_client CALL…
If you are looking for a collection to query all the machines only from a particular OU not the SUB OU .Let say ,I have Top OU called Workstations\comp(120 systems) in eskon.net domain and in turn it has 3 sub OU's OU1(10 systems),OU2(20 systems),OU3(49 systems). Here is the simple query to get machines only from TOP OU called workstations. 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 = "eskon.net/workstations/comp" /*find all machines in that OU (but also finds machines in subOUs */ AND sms_r_system.resourceID NOT IN (SELECT resourceID FROM sms_r_system where systemouname LIKE "eskon.net/workstations/comp/%") /*remove…