Skip to main content

Computer Datasheet

This customizable data sheet is used to display various computer data.

ComputerDatesheetW10.png

The structure is divided into different sections, each containing an image, a heading and a table (consisting of any number of records). Behind each table is an SQL query that can be customized. In addition, sections can also be removed or new ones added.

In addition, different configurations for different computer types can be stored. The configuration file ComputerDataSheet_TypeMapping.xml is used for this purpose. More information can be found in the following section on configuration or Computer Datasheet Editor.

Configuration - Plug-inintegration

The following configuration refers to the image example.

  • Assembly: ComputerDatasheetPlugin
  • Name: COMPUTER_DATASHEET (is translated)
  • Icon: chart_pie2.png
  • SelectedComputer: Single
Configuration - Global
  • DataTableFromComputerNameQuery: SQL query to get the resource ID based on a computer name. Exactly one value should be returned here.
  • DataTableFromComputerIDQuery: SQL query to get the computer name based on a resource ID. Exactly one value should be returned here.
  • LastHWScanQuery: SQL query to determine the last hardware invention.

  • PrimaryKey: Replacement parameter for the resource ID.

  • ExpandLoadedData: If enabled: Automatically expand all sections after the plugin is loaded.

  • CheckLastHWScan: If enabled: No display of data if no hardware inventory has been performed yet.

Four additional configuration files exist in the standard installation. Depending on the requirements, further configurations can be added here. To edit these configuration files use the Computer Datasheet Editor.

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

{Installation path}\Web\SCCMManager\Resources\Configuration\ComputerDataSheet_Data.xml

{Installation path}\Web\SCCMManager\Resources\Configuration\ComputerDataSheet_DesktopData.xml

{Installation path}\Web\SCCMManager\Resources\Configuration\ComputerDataSheet_ServerData.xml