turbot / steampipe-plugin-azure

Use SQL to instantly query Azure resources across regions and subscriptions. Open source CLI. No DB required.
https://hub.steampipe.io/plugins/turbot/azure
Apache License 2.0
37 stars 17 forks source link

Add table azure_resource_health_emerging_issue Closes #664 #683

Closed ParthaI closed 6 months ago

ParthaI commented 11 months ago

Integration test logs

Logs ``` N/A ```

Example query results

Results ``` > select * from azure_resource_health_emerging_issue +---------+------------------------------------------------------------+----------------------------------------------------+---------------------------+----------------+-------> | name | id | type | refresh_timestamp | status_banners | status> +---------+------------------------------------------------------------+----------------------------------------------------+---------------------------+----------------+-------> | default | /providers/Microsoft.ResourceHealth/emergingissues/default | /providers/Microsoft.ResourceHealth/emergingissues | 2024-02-13T21:25:25+05:30 | [] | [] > +---------+------------------------------------------------------------+----------------------------------------------------+---------------------------+----------------+-------> ```
github-actions[bot] commented 9 months ago

This PR is stale because it has been open 60 days with no activity. Remove stale label or comment or this will be closed in 30 days.

ParthaI commented 7 months ago

The Resource Health Go package we are using to list the resources. However, the SDK throws the error while parsing the API response as follows.

2024/01/18 19:54:06 failed to advance page: unmarshalling type *armresourcehealth.EmergingIssueListResult: unmarshalling type *armresourcehealth.EmergingIssueListResult: struct field Value: unmarshalling type *armresourcehealth.EmergingIssuesGetResult: struct field Properties: unmarshalling type *armresourcehealth.EmergingIssue: struct field RefreshTimestamp: parsing time "\"2024-01-18 14:18:54Z\"" as "\"2006-01-02T15:04:05.999999999Z07:00\"": cannot parse " 14:18:54Z\"" as "T"

I raised a support request on the SDK side to address this issue. Support request issue ref: https://github.com/Azure/azure-sdk-for-go/issues/22272

I will revisit this PR once the support request issue is resolved.

Thanks~

bigdatasourav commented 7 months ago

Closing this issue for now, we will revisit this once we have an update from the above SDK issue.

ParthaI commented 6 months ago

Reopening this PR as the Azure SDK issue has been resolved and released. I have tested the branch and it is working fine now. This PR is good to review now.

ParthaI commented 6 months ago

Closing the PR as per this issue comment.