Custom Computed Dictionary Creation - Assets

[Isaac Moore]

I'm trying to standardise my imported Intune device manufacturers in my asset system as some show HP and others Hewlett-Packard (I want both entries to merge and show under the name HP.

From what I understand this is what dictionaries are for but I can't find any way to create my own custom dictionary. The default dictionaries only deal with OS Version, Platform or InfrastructureType.

What am I missing?

[Connor · Accepted solution]

Hi @Isaac Moore I was just recently playing with this in my environment, and while a custom computed dictionary could be used for this, I found it easier to use a transform function.

1. On the Adapters page, select "All Jobs" and edit your Intune job.
2. Add a "Replace String" transform function, to replace Hewlett-Packard with HP in the Manufacturer column, and save the job.
3. Select "Recent Jobs".
4. Click "Transformation Request", select your Intune job, and click submit.
5. Beside the Intune job click the "View Transformed Data" button and you'll see all the HP devices now list HP as the manufacturer.

If you want to try using a custom computed dictionary instead, then this is the documentation you'll want to read. The steps essentially break down to:

1. Create a "Computed" attribute to be used with your custom computed dictionary.
2. Create a new computed dictionary, selecting manufacturer as the source attribute, optionally adding a secondary attribute, and select the attribute you created in step 1 as the destination attribute.
3. Add dictionary group(s) to your custom computed dictionary.
4. Add dictionary values to your dictionary group(s).

[Isaac Moore]

Hi @Connor that's super helpful thank you,

When I first looked at this during the closed beta, custom computed dictionaries either weren't a thing or I missed that section documentation. I'm sure I looked into it though!

I initially thought I had too many combinations to create transform for each string (would have taken ages!) but after doing a bit of a cull I think this will work in the short term.