Add custom column to SCCM console using SCCM Console Builder

Editing SCCM console views are quit limited, there is no way to add column to collection that doesn’t exist in the list available classes:

In order to add custom column (in this example, an IP Address column) we need to create a new custom node using Console Builder tool.

Console Builder will edit the console and it doesn’t have any Save or Back options, so before editing the console using the Console Builder make sure to backup ConsoleRoot folder under the following path:
C:Program Files (x86)Microsoft Configuration ManagerAdminConsoleXmlStorageConsoleRoot

Close any open SCCM console and run the tool from the following path in any computer with SCCM 2012 console:
C:Program Files (x86)Microsoft Configuration ManagerAdminConsolebin

Go to File OpenConnectedConsole

Once connected, SCCM console nodes will appear on the bottom left corner:

Pressing the relevant node (in this case Assets and Compliance) will reveal all available options above:

Right click any place under the root and click New:

Name the new node:

Under General tab Change the Instance Name to what ever make sense, and add Search Folder ID so search option will be available.
Last, add a Display name:

Under Resource assembly detail, add the following values,
Assembly: AdminUI.UIResources.dll

Under View tab, add new view with the following values and configure it,
Assembly: AdminUI.ConsoleView.dll
Type: Microsoft.ConfigurationManagement.AdminConsole.ConsoleView.ViewDescription

Under Property display items, change Class Name (in this case SMS_R_System), add the desired Class Properties and Misc Settings:

Under Images tab, add the following values to images,
Assembly: AdminUI.UIResources.dll
On resource Name, browse and choose the relevant icon to show for this node

Under Queries tab, right click Root and add the following new query:
SELECT *  FROM  SMS_R_System WHERE SMS_R_System.IPAddresses like ‘%’
Change the Query Language to WQL and mark the Enable use of COUNT (*)

Close Console Builder, open SCCM console and browse to the new node you just created:

17 Reviews for Add custom column to SCCM console using SCCM Console Builder

    I really liked your tutorial, it worked great! I'm wondering how to add 'Description' from Active Directory. I'm already collecting it during AD Discovery, I just can't figure out how to add it as a column to an SCCM node.

    User description is a custom active directory object attribute you add to user discovery.
    From my research, there is no way to add those custom attributes with console builder.
    My suggestion is to create a query (under monitoring node) with the following query statement: select * from SMS_R_User where SMS_R_User.description like "%"
    From the result of that query you can see among other many options, user description (called User Resource.description).

    Great tutorial just wondering is there a way to use this to show in a collection the status of a deployment that is deployed to that collection? For example a column showing success/in progress/error from the deployment applied to the collection for the PC's in there

    Not sure its possible, and if so, its quit complicated (because of different values for each deployment).
    My personal opinion is to use report for getting that kind of information.
    You can use build-in report: Management 4 – Deployment that target a collection

    Hi Idan,
    Great tutorial indeed, i didn't know this was possible. I really wanted to get security group info for servers into console.
    I have a question though. I did not necessarily needed a node which basically gives me results for all resources.
    I was looking to populate Security groups as an option to pick from available columns. Currently that option is available only for "Security Groups" node i created. How do i make this available for a collection column picker? Any insights on this?

    It is not possible to add column to the default view.
    In order to add your own custom column, you have to create custom node.

    Glad it was helpful for you.

    Excellent! Your blog actually was more helpful than all the MS PDFs. LOL. Os.

    Excellent! Very easy to follow, nice work.

    Thx a lot. And some info if you want Right click menu you must add instances into the Queries > Root section
    You can copy this instances from other tabs.

    Just wanted to say thanks, I inherited an SCCM platform and have not read about this trick before.

    Many thanks!

    Idan, great tutorial. I was wondering if you could help me be able to add a custom column to the list under device collection, so I can easily see lastuserloggedin. Right now I have to right click and check out primary users. Any help would be great. Thanks.

    No option to do that.
    You have to create new node and add your desire columns.

    So, it is not possible to add a custom column to existing Collections? I would like to add SMS_R_SYSTEM.LastLogonUserName as a column option for all of my Collections. That is not possible?

Leave a Reply

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