How to exclude Virtual Machine from Intune integration?

[AnciaM]

I am looking for a way to exclude any virtual machine from the Intune integration.Is there a way to achieve in ETL Transform Map.

[J Siva]

Hi @AnciaM 
Are you using SG connector for Microsoft Intune?
If yes, then I recommend using a custom data stream with an updated URI that excludes virtual machines.
Steps:
1. Copy the OOB datastream -> Computers

2. Update the default value of the Input variable "nextLink"  as beta/deviceManagement/managedDevices?$filter=model ne 'Virtual Machine'

3. Deactivate the OOB Computers data stream and update the Data source "SG-Intune Computers"  by replacing the OOB data stream id with your custom data stream id in the script.

Regards,
Siva

[AnciaM]

@J Siva : 

How to do the first step ? Is this to be done in ETL ?

[J Siva]

Hi..
I'm assuming that you are currently using SG connector for Microsoft Intune.
If yes, then Go to flow designer, there you can see "Data stream" section. There search for "Computers".

[AnciaM]

@J Siva : Where should step 3 be done , in which script should the custom data stream id be put . Also when you say custom data stream id  does it mean the sys_id from sys_hub_action_type_definition table ?