PENDINGSCCM - Custom Report Help

[ktntech]

Hello,

Would anyone be able to advise how I could create a custom report in SCCM to pull the following information

Machine Name
Make
Model
O/S & Version (21H2)

I'm new to trying to create custom reports so any help would be greatly appreciate.

Thank you in advance for your time and help

Kurt

[EdGonz]

I have something that can help you, here's the SQL script:
SELECT distinct
CS.name0 as "Computer Name",
CS.domain0 as "Domain",
CS.UserName0 as "User",
BIOS.SerialNumber0 as "Bios serial",
SE.SerialNumber0 as "Service Tag",
CS.Manufacturer0 as "Manufacturer",
CS.Model0 as "model",
OS.Caption0 as "OS",
RAA.SMS_Assigned_Sites0 as "Site",
RAM.TotalPhysicalMemory0 as "Total Memory",
SUM(ISNULL(LDisk.Size0,'0')) as "Hardrive Size",
SUM(ISNULL(LDisk.FreeSpace0,'0')) AS "Free Space",
CPU.Name0 as "CPU Model"
FROM
v_GS_COMPUTER_SYSTEM CS right join v_GS_PC_BIOS BIOS on BIOS.ResourceID = CS.ResourceID
right join v_GS_SYSTEM SYS on SYS.ResourceID = CS.ResourceID
right join v_GS_OPERATING_SYSTEM OS on OS.ResourceID = CS.ResourceID
right join v_RA_System_SMSAssignedSites RAA on RAA.ResourceID = CS.ResourceID
right join V_GS_X86_PC_MEMORY RAM on RAM.ResourceID = CS.ResourceID
right join v_GS_Logical_Disk LDisk on LDisk.ResourceID = CS.ResourceID
right join v_GS_Processor CPU on CPU.ResourceID = CS.ResourceID
right join v_GS_SYSTEM_ENCLOSURE SE on SE.ResourceID = CS.ResourceID
WHERE
LDisk。DriveType0 = 3
GROUP BY
CS.Name0,
CS.domain0,
CS.Username0,
BIOS.SerialNumber0,
SE.SerialNumber0,
CS.Manufacturer0,
CS.Model0,
OS.Caption0,
RAA.SMS_Assigned_Sites0,
RAM.TotalPhysicalMemory0,
CPU.Name0

You'll have to have get report builder installed on your site server and just create a new report using the script above.

[Garth]

Hello,

Would anyone be able to advise how I could create a custom report in SCCM to pull the following information

Machine Name
Make
Model
O/S & Version (21H2)

I'm new to trying to create custom reports so any help would be greatly appreciate.

Thank you in advance for your time and help

Kurt

What do you have for a query now? What is not working with it?

[ktntech]

Hello,

I don't have anything at the moment, this is very much my first use of creating a custom SCCM report.

I've installed report builder and created a new report. I've then attempted to add a new data set but unsure which source to select.

Apologies, very new to this.