Jump to content


Pelegit

Get Office with specific collection

Recommended Posts

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

 

 

Share this post


Link to post
Share on other sites

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 .

Share this post


Link to post
Share on other sites

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:

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...


×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.