Skip to main content

Computer Datasheet

ComputerDatesheetW10.png

The “Computer Datasheet” plugin provides a customizable datasheet that can display various details about a selected computer.

The datasheet is divided into several sections. Each section consists of

  • an optional image,
  • a heading,
  • and a table containing any number of data records.

Each of these tables is based on a freely configurable SQL query that can be customized as needed. In addition, sections can be removed or new sections added to adapt the datasheet to individual requirements.

Furthermore, different configurations can be stored for various computer types. The file ComputerDataSheet_TypeMapping.xml is used for this purpose.
Further details can be found in the Configuration section or in the Computer Datasheet Editor.

Database configuration

Starting with SCCM Manager Server version 3.4, the Datasheet Editor supports the ability to save and edit datasheet configurations in the database. Instructions for this can be found here: Computer Datasheet Editor.

File configuration (obsolete)

The standard installation includes four additional configuration files. Additional configurations can be added here as needed. The included Computer Datasheet Editor tool is used to edit these configuration files.

Configuration files:

  • {Installation path}\Web\SCCMManager\Resources\Configuration\ComputerDataSheet_TypeMapping.xml

    This file specifies which data sheet is used for which device selection. This is controlled by an SQL query, whose return value enables the identification of the computer type.

    Additional data sheets for devices can be added at any time as needed, and existing ones can be customized to suit your specific requirements. Each data sheet consists of a name and an SQL query for the desired type mapping. Every SQL query includes the ResourceId placeholder, which corresponds to the selected computer in the program.


  • {Installation path}\Web\SCCMManager\Resources\Configuration\ComputerDataSheet_Data.xml
    This file contains a default configuration for easily creating additional data sheets.

  • {Installation path}\Web\SCCMManager\Resources\Configuration\ComputerDataSheet_DesktopData.xml
    Here you will find a preconfigured data sheet for displaying the required information about a desktop PC.

  • {Installation path}\Web\SCCMManager\Resources\Configuration\ComputerDataSheet_ServerData.xmlA preconfigured data sheet for displaying server data.
Plugin configuration
Configuration Description Default value
CheckLastHWScan If enabled: No data is displayed if a hardware inventory has not yet been performed. False
DataTableFromComputerIDQuery SQL query to determine the computer name based on a resource ID. This query should return exactly one value
Click to view

 

SELECT
        [Netbios_name0]
FROM
        [v_R_System]
WHERE
        [ResourceID]='{RESOURCEID}'
DataTableFromComputerNameQuery SQL query to determine the resource ID based on a computer name. This query should return exactly one value
Click to view

 

SELECT
        [ResourceID]
FROM
        [v_R_System]
WHERE
        [Netbios_name0]='{COMPUTERNAME}'
ExpandLoadedData If enabled: Automatically expand all sections after the plugin has loaded. False
LastHWScanQuery SQL query to determine the latest hardware inventory.
Click to view

 

SELECT
        [LastHWScan]
FROM
        [v_GS_WORKSTATION_STATUS]
WHERE
        [ResourceID]='{RESOURCEID}'
PrimaryKey Replacement parameter for the resource ID. {RESOURCEID}

Default Plugin Integration
  • Assembly: ComputerDatasheetPlugin
  • Name: COMPUTER_DATASHEET (to be translated)
  • Icon: chart_pie2.png
  • SelectedComputer: Single

Back to top