SCCM report for Computers Asset information including SN Number and model name

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 the basis information that gives from below report. This reports provides an asset manager’s summary…

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…

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…

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.…

I was searching for something to find the software update complaince to see if machines requires something to patch .as i couldnt find any such report from default reports ,so created one like below and gives me the compelet complaicne of software updates. SQL Statement select distinct    sys.Name0,    ui.BulletinID as BulletinID,    ui.ArticleID…