SMSUG.ca

...your virtual communITy
Welcome to SMSUG.ca Sign in | Join | Help
in Search

Garth Jones

Count of PCs by OU

Please see post http://social.technet.microsoft.com/Forums/systemcenter/en-US/aea60e7b-a88b-48d8-8cc3-8675097abe62/trying-to-do-a-report-of-sup-failures-by-ou?forum=configmgrinventory for full details

SELECT
    Max(SOU.System_OU_Name0),
    COUNT(*) AS 'COUNT'
FROM 
    dbo.v_RA_System_SystemOUName SOU 
    JOIN dbo.v_R_System SYS ON SYS.ResourceID = SOU.ResourceID

/*WHERE SYS.Netbios_Name0 IN ( 'PHO-PVR63186',
'WCO-PVP11579',
'PAL-PVI82336',
'LOM-PVI46044',
'LOM-PVI49102',
'LOM-PVR46148',
'PUG-PVI92643',
'RED-PVI54875',
'REN-PVR27553',
'WLA-PVR125834')*/
Group by 
    SOU.System_OU_Name0
ORDER BY
    SOU.System_OU_Name0

Comments

 

Count of PCs by OU | My CMS said:

Pingback from  Count of PCs by OU | My CMS

March 19, 2014 2:31 PM
 

Thin brick pavers floor said:

Count of PCs by OU - Garth Jones

November 21, 2014 12:06 PM

This Blog

Syndication

News

Training

Powered by Community Server (Non-Commercial Edition), by Telligent Systems