List of computers from an AD User Security Group

by Garth 23. March 2012 13:11

Use this query to get a list of PCs by user’s security group. For full details see the forum post: http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/5180b626-b6c7-4639-a8ff-b2276f1c4cad

select 



  CS.Name0,



  CS.UserName0



from 



  dbo.v_R_User U



  join dbo.v_RA_User_UserGroupName UGN on U.ResourceID = UGN.ResourceID



  join dbo.v_GS_COMPUTER_SYSTEM CS on CS.UserName0 = U.Unique_User_Name0



Where



  UGN.User_Group_Name0 = 'GARTEK\Domain Users'

Tags:

ConfigMgr | SMS | SSRS | System Center Configuration Manager | System Management Server | vNext

E-mail | Kick it! | DZone it! | del.icio.us
Permalink | Comments (0) | Post RSSRSS comment feed
Comments are closed

Powered by BlogEngine.NET 1.6.0.0


Enhansoft specializes in providing software solutions, custom reports, and consulting services for retrieving your IT asset inventory. 

This is done within the system management area focusing on Microsoft System Center Configuration Manager (SCCM) by extending its asset information and reporting capabilities.

Our software solutions found in the Enhanced Asset Management Suite – EAM: Warranty Information Reporting - WIR, Monitor Information Reporting - MIR & Enhanced Web Reporting - EWR, will quickly and accurately report on your:

  • PC (laptop, notebook, desktop & server) warranties
  • PC monitor information
  • Enable you to use over 100 different SQL Server Reporting Services (SSRS) ranging from hardware, software and dashboard categories, to keep track of and effectively display even more detailed information about your IT assets.

Enhansoft aims to make tracking the life cycle of each IT asset on the network as easy and efficient as possible.

Be more efficient.   Be more accurate.  Enhansoft.

 

Tag cloud