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…

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…

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…

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…

SMS/SCCM report with Asset Details information: I had a question from my boss to get list of computers that consists of computer name,model ,last boot up time and other important information.You can also customize it according to ur needs but…

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…

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…

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…

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…

Are you looking for getting a report for a given KB numbers or MSID(like MS10-087),you can add few more lines to the existing code as like below and change the ID1 to ID2 also add a prompt to it.The same…