How to Add Blank Columns to a report.

For full details please see:

http://www.myitforum.com/forums/SCCM-Report-question-m238232.aspx

SELECT DISTINCT

CS.Name0 as ‘PC’,

” as ‘Blank column1′,

BIOS.SerialNumber0 as ‘SN #’,

CS.Manufacturer0 as ‘Manufacturer’,

CS.Model0 as ‘Model’,

” as ‘Blank column2′,

OS.Caption0 as ‘OS’,

OS.CSDVersion0 as ‘Service Pack’,

SCUM.TopConsoleUser0 as ‘Top User’,

R.User_Name0 AS ‘Last Logged (Heartbeat)’,

CS.UserName0 AS ‘Last Logged (HW Inv.)’,

BIOS.ReleaseDate0 as ‘Bios Date’,

NAC.IPAddress0 as ‘IP’,

NAC.DefaultIPGateway0 as ‘Gateway’,

” as ‘Blank column3′,

Case SE.ChassisTypes0

when ’1′ then ‘Other’

when ’2′ then ‘Unknown’

when ’3′ then ‘Desktop’

when ’4′ then ‘Low Profile Desktop’

when ’5′ then ‘Pizza Box’

when ’6′ then ‘Mini Tower’

when ’7′ then ‘Tower’

when ’8′ then ‘Portable’

when ’9′ then ‘Laptop’

when ’10′ then ‘Notebook’

when ’11′ then ‘Hand Held’

when ’12′ then ‘Docking Station’

when ’13′ then ‘All in One’

when ’14′ then ‘Sub Notebook’

when ’15′ then ‘Space-Saving’

when ’16′ then ‘Lunch Box’

when ’17′ then ‘Main System Chassis’

when ’18′ then ‘Expansion Chassis’

when ’19′ then ‘SubChassis’

when ’20′ then ‘Bus Expansion Chassis’

when ’21′ then ‘Peripheral Chassis’

when ’22′ then ‘Storage Chassis’

when ’23′ then ‘Rack Mount Chassis’

when ’24′ then ‘Sealed-Case PC’

else ‘Undefinded’

end as ‘PC Type’

FROM

dbo.v_R_System R

INNER JOIN dbo.v_GS_PC_BIOS BIOS ON R.ResourceID = BIOS.ResourceID

INNER JOIN dbo.v_GS_COMPUTER_SYSTEM CS ON R.ResourceID = CS.ResourceID

INNER JOIN dbo.v_GS_NETWORK_ADAPTER_CONFIGUR NAC ON R.ResourceID = NAC.ResourceID

INNER JOIN dbo.v_GS_OPERATING_SYSTEM OS ON R.ResourceID = OS.ResourceID

LEFT OUTER JOIN dbo.v_GS_SYSTEM_CONSOLE_USAGE_MAXGROUP SCUM ON R.ResourceID = SCUM.ResourceID

INNER JOIN dbo.v_GS_SYSTEM S on R.ResourceID = S.ResourceID

INNER JOIN dbo.v_GS_SYSTEM_ENCLOSURE SE on R.ResourceID = SE.ResourceID

WHERE

NAC.IPEnabled0 = 1

AND NAC.DefaultIPGateway0 Is NOT NULL

AND S.SystemRole0 = ‘Workstation’

ORDER BY

BIOS.ReleaseDate0

email

Written by , Posted .