Filter on populated CI's using the SGC for Intune (or Defender)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-16-2025 04:27 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-16-2025 05:20 AM
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! 👍
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-16-2025 11:58 PM
Thanks @Andrew_TND . Do you have a pointer, article or similar with some more background on the details of setting this up? thanks again!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-23-2025 06:15 AM
Hey @JvS001 I didnt see your reply. Not really all I did was use the "Getting started" instructions and patched my way from there.