I was recently looking for a solution to add a device to SCCM Collection using the Task sequence. During the search, I…
Browsing: sccm collection
SCCM has multiple discovery methods help you discover devices on your network, devices and users from Active Directory, or users…
I was working on SCCM report for client health dashboard. During this report creation ,found that ,device appear twice with…
Collection to check if any of Primary or Secondary site not installed with SUP Role or any other Role?…
I was looking at client health percentage other day and found many systems were reported as not healthy though I…
Creating collection to get computers that starts and end with particular string is used mostly using % .If this percentile…
Full Details :http://social.technet.microsoft.com/Forums/en-US/configmgrgeneral/thread/7b4d3810-a262-4c63-8dd6-7cc906b85941 select sys.name0,sys.AD_Site_Name0,FCM.SiteCode,ARP.DisplayName0,ARP.Version0,ARP.InstallDate0 from V_R_system sys inner join v_Add_Remove_Programs ARP on arp.resourceID=sys.ResourceID inner join v_FullCollectionMembership FCM on…
Full Details http://social.technet.microsoft.com/Forums/en-US/configmgrgeneral/thread/7b4d3810-a262-4c63-8dd6-7cc906b85941 This collection is created using sub selected queries http://eskonr.com/2011/12/sccm-collection-sub-selected-quiries/ 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 …