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

Leave a Reply

Your email address will not be published. Required fields are marked *