PENDING Create custom configuration manager report

[MeniAdam]

Hi

I want create SCCM report to get this data from Special collection:
1. Computer name
2. Computer Model
3. Computer serial number
4. Primary User

I have used SQL view to build this query:

SELECT        dbo.v_GS_COMPUTER_SYSTEM.Manufacturer0, dbo.v_GS_COMPUTER_SYSTEM.Model0, dbo.v_GS_COMPUTER_SYSTEM.Name0, dbo.v_GS_COMPUTER_SYSTEM.UserName0, dbo.v_GS_PC_BIOS.SerialNumber0,
                         dbo.v_Collections.CollectionName
FROM            dbo.v_GS_COMPUTER_SYSTEM CROSS JOIN
                         dbo.v_GS_PC_BIOS CROSS JOIN
                         dbo.v_Collections

I can not seem to create a parameter for the collection.
I have tried use this guide without success : https://prajwaldesai.com/how-to-add-collection-parameter-in-sccm-report/.

please help
thank you

 

[Garth]

There are a few things that needed to be update. first Never use Cross joins.

SELECT       
    CS.Manufacturer0,
    CS.Model0,
    CS.Name0,
    CS.UserName0,
    BIOS.SerialNumber0
FROM
    dbo.v_R_System_Valid RV
    Inner join dbo.v_GS_COMPUTER_SYSTEM CS on RV.ResourceID = CS.ResourceID
    Inner JOIN dbo.v_GS_PC_BIOS BIOS on RV.ResourceID = BIOS.ResourceID
    Inner join dbo.v_FullCollectionMembership FCM on RV.ResourceID = FCM.ResourceID
    inner join dbo.v_Collection Coll on Coll.CollectionID = FCM.CollectionID
Where
    Coll.Name = 'All systems'

 

[MeniAdam]

thanks Garth

how add parameter to choose the collection?

 

[Garth]

This blog will help you. https://www.enhansoft.com/blog/adding-a-prompt-value-to-the-title-of-a-sccm-report