As per Insight SCCM integration - Used SQL statements, we use 3 SQL queries to populate the Application object type.
In the last query, we get the normalized value of an application publisher and version, which could be different from the publisher and version value from the first 2 queries. This results in duplicated objects to be created.
For example, the first 2 queries would return the result of Publisher0 and Version0 as follows.
The third query would return the result of Publisher0 and Version0 as follows.
Disclaimer: The queries are returning results correctly as per the queries used, but it's causing duplicated objects to be created as the normalized columns are used in the third query, which is different than the other 2 queries
Imported data is not normalized
Imported data is normalized as we can see that the third query (below) uses the normalized columns (NormalizedName, NormalizedPublisher and NormalizedVersion)
- Change the last query to map the non-normalized values of application name, publisher and application version, and have additional data for the normalized values.
- Example query
- Allow SQL queries to be modified in the app
Currently there is no known workaround for this behavior. A workaround will be added here when available