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 

Leave a Reply

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