Skip to main content

Product Match Rule Editor

plugin_software_rule_editor_thumb_600_0.png

Using the “Product Match Rule Editor” plugin, any software inventory data can be aggregated into custom products using a set of rules.

Plugin configuration
Name Description Default value
LookupAutoCompleteDatabase Specifies the database on which the “LookupAutoCompleteQuery” SQL query is to be executed. SCCMManager
LookupAutoCompleteQuery The SQL query retrieves information from the database that can be used for autocomplete
Click to view 
SELECT
        [ArpManufacturer] AS 'RuleManufacturer' ,
        [ArpProduct]      AS 'RuleProduct'      ,
        [RelManufacturer] AS 'Manufacturer'     ,
        [RelProduct]      AS 'Product'          ,
        [RelLanguage]     AS 'Language'
FROM
        MatchLookup
MigrationSourceDatabase Specifies the database on which the “MigrationSourceQuery” SQL query is to be executed. SCCMManager

MigrationSourceQuery

 SQL query to retrieve the clients that can be selected for migration.
Click to view 
SELECT DISTINCT
        [DisplayName0] ,
        [Version0    ] ,
        [Publisher0  ]
FROM
        [DBO].[v_Add_Remove_Programs]

UnmatchedSoftwareQuery

 The SQL query identifies which software is “unmatched.”
Click to view 
SELECT DISTINCT
        inv.Publisher0   AS Manufacturer ,
        inv.DisplayName0 AS Name         ,
        inv.Version0     AS Version
FROM
        MatchProductResult MATCH
RIGHT JOIN
        [DBO].[v_Add_Remove_Programs] inv
ON
        ISNULL(inv.DisplayName0, '') = ISNULL(MATCH.ProductName, '')
AND     ISNULL(inv.Version0,'')      = ISNULL(MATCH.ProductVersion, '')
AND     ISNULL(inv.Publisher0,'')    = ISNULL(MATCH.ProductManufacturer, '')
LEFT JOIN
        MatchProduct product
ON
        product._Id = MATCH.MatchProductId
WHERE
        MATCH.MatchProductId IS NULL
ORDER BY
        inv.Publisher0,
        inv.DisplayName0
Default Plugin Integration
  • Assembly: MatchProdutRuleEditorPlugin
  • Name: MATCH_PRODUCT_RULE_EDITOR (gets translated)
  • Icon: box_software.png
  • SelectedComputer: None
Back to top