Filter on populated CI's using the SGC for Intune (or Defender)

JvS001
Tera Contributor

When I enable the SGC for Intune and my CMDB is populated with Computer accounts, there seems to be no possibility to filter the incoming accounts. So it will populate all the Computer accounts as CI's that our found in Intune. What is a way to filter this.

 

For example: 

- I have setup the SGC for Intune. It will populate teh Computers from Intune into the CMDB

- I only want the computers where the name start with "W11-" to be populated using this SGC

 

Preferably I also want this filter to be active before I do the first run (so I do not need to remove CI's after the first population of CI's

 

Who can help pointing me in the right direction? Do I need to use the Integrationhub ETL? Or the Transform  maps? And if so, please explain how to do that

3 REPLIES 3

Andrew_TND
Mega Sage
Mega Sage

Hi @JvS001 I had a right pain with this during its implementation because there was personal and business machines which were recorded. I fixed this using a combination of insert business rules and transform scripts which validated the data before it was inserted.

In answer to your question though you can achieve this integration using - Robust Transform Maps.

Please mark as helpful or if its resolved the issue, CORRECT! 👍

JvS001
Tera Contributor

Thanks @Andrew_TND . Do you have a pointer, article or similar with some more background on the details of setting this up? thanks again!

Hey @JvS001 I didnt see your reply. Not really all I did was use the "Getting started" instructions and patched my way from there.