MicrosoftNathan Swift Hi Nathan
The above has been deployed using this example u have given : https://github.com/Azure/Azure-Security-Center/tree/master/Secure%20Score/Send-SecureScoreBriefing As custom template, getting issues with Secure Score API :
I have checked the log workspace that there is not table "SecureScore_CL" But there is a table "SecureScores" which is returning some data.
Please help.
Please check with below Output of the step "Secure Score Wiz" :
{
"statusCode": 400,
"headers": {
"Cache-Control": "no-store, no-cache",
"Pragma": "no-cache",
"Set-Cookie": "ARRAffinity=7db823145b5495aa78395fc35197239c6041a7bf99b820e8557a766b57a1f260;Path=/;HttpOnly;Secure;Domain=azuremonitorlogs-ci.azconn-ci-002.p.azurewebsites.net,ARRAffinitySameSite=7db823145b5495aa78395fc35197239c6041a7bf99b820e8557a766b57a1f260;Path=/;HttpOnly;SameSite=None;Secure;Domain=azuremonitorlogs-ci.azconn-ci-002.p.azurewebsites.net",
"x-ms-request-id": "27cdd56d-1e89-4516-93b7-9c715c619c05",
"Strict-Transport-Security": "max-age=31536000; includeSubDomains",
"X-Content-Type-Options": "nosniff",
"X-Frame-Options": "DENY",
"Timing-Allow-Origin": "*",
"x-ms-apihub-cached-response": "false",
"x-ms-apihub-obo": "false",
"Date": "Mon, 31 Jul 2023 08:49:50 GMT",
"Content-Length": "787",
"Content-Type": "application/json",
"Expires": "-1"
},
"body": {
"ResultStatus": "BadRequest",
"Content": {
"error": {
"message": "The request had some invalid properties",
"code": "BadArgumentError",
"correlationId": "eaa0a656-1c01-422c-8185-0d0a9374f71a",
"innererror": {
"code": "SemanticError",
"message": "A semantic error occurred.",
"innererror": {
"code": "SEM0100",
"message": "'where' operator: Failed to resolve table or column expression named 'SecureScore'"
}
}
}
},
"Message": "Failed to get HTTP response because of invalid input (DRAFT, visualizeQuery). Bad request input. Please Check user input parameters (query syntax, chart type or other resource input)\r\nclientRequestId: 27cdd56d-1e89-4516-93b7-9c715c619c05"
}
}