If your boss ask to get list of laptops which are managed by SMS or SCCM.what do you do and how do you get that. Right click on computer and go to resource explorer to identify the computer is Laptop or Desktop ? You can identify if the computer is Laptop or Desktop based on…
SCCM Collection to Determine what Version of BITS(BackGround Intelligence Transfer Protocol) on Computers

How to Identify the computers which has What version of BITS(Background intelligence Transfer service) installed onto it. Background Intelligent Transfer Service (BITS) transfers files (downloads or uploads) between a client and server and provides progress information related to the transfers. You can also download files from a peer and it is Needed in Asynchronously transfer…

Create a New report and paste the below query with prompt asking for computer name: select a.name0 ,b.SerialNumber0,c.model0  from v_R_System a,v_GS_PC_BIOS b,v_GS_COMPUTER_SYSTEM c where a.ResourceID=b.ResourceID and a.ResourceID=c.ResourceID AND a.name0=@hostname Prompt for computer name @hostname: select name0 from v_GS_computer_system Below is the collection which will prompt for computer name which should be created under component management--->queries…
Collections for Windows 7 and Server 2008 OS

By default in SCCM,you do not have separate collections for Windows 7 or server 2008 OS as like you have in Windows XP and server 2003.You can create a query based collection using the following method/ query. collection for windows 7: Right click on collections and say new collection ,go to query based collection and…

There might be the scenario where you will be looking for computers which doesnt have particular application installed on.Create a new collection and copy the below  simple WQL query which list you all computers there by you can advertise the application package onto it. select SMS_G_System_SYSTEM.Name from  SMS_R_System inner join SMS_G_System_SYSTEM on SMS_G_System_SYSTEM.ResourceID = SMS_R_System.ResourceId where SMS_G_System_SYSTEM.Name…

2 weeks back,working on patching issues in SMS 2003 which are having some trouble.there are lot of systems which failed the patches due to windows update agent doesnt exisit on the machines(identified the cause because of this) more information look here .It is bit hard to find the systems by looking at resource explorer and finding if…

In my last post http://eskonr.com/2010/01/sccm-report-for-applications-installled-on-computers-with-without/ showed how to create sccm report to list computers with different versions of application installed on computers. This is to list the computers in collection rather report. Create a collection and edit the query ,paste the following into it. select *  from  SMS_R_System inner join SMS_G_System_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceId = SMS_R_System.ResourceId where…