Tags: Collections

Posted on November 23, 2012 by | 5 Comments | 8,926 Views
  Report provide count of computers from the collections. Full Details: http://social.technet.microsoft.com/Forums/en-US/configmgradminconsole/thread/f0cccbd7-7616-4d06-a3a6-31d4c583e2f0 SELECT v_Collection.Name ,v_Collection.Comment,v_Collection.CollectionID,COUNT(*) as [Members] FROM v_Collection,v_FullCollectionMembership where v_Collection.CollectionID=v_FullCollectionMembership.CollectionID group by v_Collection.Name ,v_Collection.Comment,v_Collection.CollectionID order by v_Collection.Name
Read more »
SCCM collection Subselected Queries

Posted on December 2, 2011 by | 2 Comments | 3,988 Views
Have seen lot of questions on how to get list of computers that do not have xxxxxx .This xxxx could be of anything like softwares,file names anything that do not have. In this post,I will go through step by step procedure how to make it simple. Step 1: To get list of computers that do…
Read more »

Posted on December 2, 2011 by | 0 Comments | 3,057 Views
Use Subselected query to get the results: select *  from  SMS_R_System where SMS_R_System.NetbiosName like "%rts%" and SMS_R_System.ResourceId not in (select SMS_R_System.ResourceID  from  SMS_R_System inner join SMS_G_System_SoftwareFile on SMS_G_System_SoftwareFile.ResourceId = SMS_R_System.ResourceId where SMS_G_System_SoftwareFile.FileName like "rtvscan.exe" AND SMS_R_System.Client = 1)  
Read more »

Posted on May 17, 2011 by | 2 Comments | 5,474 Views
Create New SCCM collection and paste the below query into it. 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 inner join SMS_G_System_OPERATING_SYSTEM on SMS_G_System_OPERATING_SYSTEM.ResourceID = SMS_R_System.ResourceId inner join SMS_G_System_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceId = SMS_R_System.ResourceId where SMS_G_System_OPERATING_SYSTEM.Caption like "Microsoft Windows 7%" and SMS_G_System_COMPUTER_SYSTEM.SystemType = "x64-based PC" Also need report :look at here http://myitforum.com/cs2/blogs/skissinger/archive/2009/06/23/32bit-vs-64bit-report.aspx
Read more »

Posted on April 4, 2011 by | 4 Comments | 14,174 Views
Computers that are running on virtual(Virtual PC or VMware etc) will have an entry in win32_computersystem with attribute model in WMI. You can create a collection to using table called SMS_G_System_COMPUTER_SYSTEM. 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 inner join SMS_G_System_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceId = SMS_R_System.ResourceId where SMS_G_System_COMPUTER_SYSTEM.Model like "%Virtual%" To list all physical computers ,create another collection…
Read more »

Posted on November 16, 2010 by | 8 Comments | 20,393 Views
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…
Read more »

Posted on November 16, 2010 by | 0 Comments | 418 Views
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…
Read more »