Pelegit Posted June 22, 2015 Report post Posted June 22, 2015 Hi all , I would like to ask you question , i need to get from specific collection who office 2012 is installed , the issue is that if i try with "All inventory filed for a specific product " in the values i see 2 others program the office is doesn't appear there ... in additional i have checked on the specific computer under Hardware and software resource that the office appear on Hardware category Quote Share this post Link to post Share on other sites More sharing options...
GarthMJ Posted June 22, 2015 Report post Posted June 22, 2015 Why don't you use the report entitled. "Computers with specific software registered in Add Remove Programs" Quote Share this post Link to post Share on other sites More sharing options...
Pelegit Posted June 22, 2015 Report post Posted June 22, 2015 Yes you right i have found that , thank but i need another help , i need to get all users from specific group from Active Directory and the next step is run another query that can provide me where all user that member of group did login , can you help me with query to specific security group *** all Active Directory discovery's are working . Quote Share this post Link to post Share on other sites More sharing options...
GarthMJ Posted June 22, 2015 Report post Posted June 22, 2015 This is more of an AD question that and CM12 question. I would ask in a AD forum. Quote Share this post Link to post Share on other sites More sharing options...
Pelegit Posted June 22, 2015 Report post Posted June 22, 2015 Hi GarthMJ , My question is regarding combine of SCCM with Active Directory so it's really matter where i open the POST ?.. i have progressed with my task , but i need to create collection from specific security group from AD Someone can help me ... Quote Share this post Link to post Share on other sites More sharing options...
BeerBelly90 Posted June 22, 2015 Report post Posted June 22, 2015 https://blog.thesysadmins.co.uk/sccm-2012-creating-device-collections.html Quote Share this post Link to post Share on other sites More sharing options...
Pelegit Posted June 23, 2015 Report post Posted June 23, 2015 Hi beerBelly , First of all thank you about your respond , I want to explain you what i need: need to run query to User group i want get all computer name that user from group did login Possible ? Quote Share this post Link to post Share on other sites More sharing options...
BeerBelly90 Posted June 23, 2015 Report post Posted June 23, 2015 You will need to combine a few queries: https://sccmentor.wordpress.com/2013/06/26/creating-a-user-collection-based-on-ad-user-group/ https://configmonkey.wordpress.com/2015/04/29/sccm-2012-query-to-find-clients-a-user-last-logged-in-to/ Quote Share this post Link to post Share on other sites More sharing options...
BeerBelly90 Posted June 24, 2015 Report post Posted June 24, 2015 If you just need an sql report you can use something like this: select sys.User_Name0,sys.Name0 from v_ra_user_usergroupname UGN join v_r_user Users on Users.ResourceId = UGN.ResourceId join v_r_system sys on sys.User_Name0 = Users.User_Name0 where UGN.User_Group_Name0 = 'YourDomain\YourGroup' order by sys.User_Name0 Quote Share this post Link to post Share on other sites More sharing options...
