manam.pervez1 Posted November 27, 2013 Report post Posted November 27, 2013 Hello , How Can I get a report on which servers have System Center 2012 End Point Protection installed? or if we missing any of them? Please advice, Asap Thank you Quote Share this post Link to post Share on other sites More sharing options...
Hexa Posted December 2, 2013 Report post Posted December 2, 2013 Hello, Create a "all servers collection" --> 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 where SMS_R_System.OperatingSystemNameandVersion like "Microsoft Windows NT%Server%" Open the collection, right click on the column titles and add "endpoint protection enabled" That's it Quote Share this post Link to post Share on other sites More sharing options...
manam.pervez1 Posted December 3, 2013 Report post Posted December 3, 2013 Hello Hexa, Thank you for your help, but i am not expert on SCCM yet. please Try to Put some more Description about above post. Thank you Quote Share this post Link to post Share on other sites More sharing options...
Hexa Posted December 4, 2013 Report post Posted December 4, 2013 Simply create a new collection and use the query above to get a list of all servers ... --> http://technet.microsoft.com/en-us/library/gg712295.aspx and for the second step --> http://deployos.com/blog/2012/07/17/add-additional-columns-to-see-more-information-about-data-in-sccm-2012 Quote Share this post Link to post Share on other sites More sharing options...