There was a question in forum list about how to get count of clients by its status (active,obsolete etc). I…
Browsing: Collections
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…
Have seen lot of questions on how to get list of computers that do not have xxxxxx .This xxxx could…
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…
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…
Computers that are running on virtual(Virtual PC or VMware etc) will have an entry in win32_computersystem with attribute model in…
If your boss ask to get list of laptops which are managed by SMS or SCCM.what do you do and…
If your boss ask to get list of laptops which are managed by SMS or SCCM.what do you do and…