SMSUG.ca

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

Garth Jones

Limiting a report to a Collection

For more details please see

http://www.windows-noob.com/forums/index.php?/topic/9766-sccm-report-on-collection/

 

 

SELECT DISTINCT
    CS.Name0, 
    R.User_Name0, 
    MAX(SOU.System_OU_Name0) AS Expr1,                      
    CS.Description0, 
    CS.Manufacturer0, 
    CS.Model0,
    BIOS.SerialNumber0
FROM  
    dbo.v_Collection Coll
    join dbo.v_FullCollectionMembership FCM on Coll.CollectionID = FCM.CollectionID and Coll.Name = 'All systems'
    join dbo.v_GS_COMPUTER_SYSTEM CS on FCM.ResourceID = CS.ResourceID
    INNER JOIN dbo.v_R_System R ON CS.ResourceID = R.ResourceID 
    INNER JOIN dbo.v_RA_System_SystemOUName SOU ON CS.ResourceID = SOU.ResourceID 
    INNER JOIN dbo.v_GS_PC_BIOS BIOS ON CS.ResourceID = BIOS.ResourceID
GROUP BY 
    CS.Name0, 
    R.User_Name0, 
    CS.Description0,
    CS.Manufacturer0, 
    CS.Model0, 
    BIOS.SerialNumber0

Comments

 

Limiting a report to a Collection | My CMS said:

Pingback from  Limiting a report to a Collection | My CMS

January 14, 2014 2:58 AM

This Blog

Syndication

News

Training

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