Morning all,
I have a business requirement to export the Windows Defender reports from Intune which I can do if using a PowerShell script (https://github.com/ztrhgf/useful_powershell_functions/blob/master/INTUNE/Get-IntuneReport.ps1).
The script has four main elements.
1. The OAuth2 authentication request.
2. Rest API Post request to generate the required report(s).
3. Rest API Get request to check if the report has been generated (loops)
4. Rest API Get request to download the zip file which contains a CSV file.
Can anyone help me with some code please which would allow me to display the data for the report 'UnhealthyDefenderAgents'?
I do have PoC code for accessing MS Graph.
let
token_uri = "https://login.windows.net/" & #"Azure Tenant ID" & "/oauth2/token",
resource="https://graph.microsoft.com",
tokenResponse = Json.Document(Web.Contents(token_uri,
[
Content = Text.ToBinary(Uri.BuildQueryString(
[
client_id = #"Azure Application ID",
resource = resource,
grant_type = "client_credentials",
client_secret = #"Azure Application Client Secret"
]
)),
Headers = [Accept = "application/json"], ManualStatusHandling = {400}
])),
access_token = tokenResponse[access_token],
Source = OData.Feed("https://graph.microsoft.com/v1.0/deviceManagement/managedDevices", [ Authorization = "Bearer " & access_token ], [ ExcludedFromCacheKey = {"Authorization"}, ODataVersion = 4, Implementation = "2.0" ])
in
Source
Thanks in advance for any help you can give.
Mike
