Skip to content

Get Office with specific collection

Featured Replies

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

 

 

  • Author
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 .

  • Author

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 ...

:blink:
  • Author
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 ?

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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

Account

Navigation

Search

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.