search

turbot / steampipe-plugin-jumpcloud

Use SQL to instantly query resources from JumpCloud. Open source CLI. No DB required.
https://hub.steampipe.io/plugins/turbot/jumpcloud
Apache License 2.0
4 stars 0 forks source link

Table `jumpcloud_device_windows_program` failed with an error `Error: interfaceToColumnValue failed for column "install_date": found 3, expected yyyy-mm-dd or yyyymmdd` #20

Closed Subhajit97 closed 1 year ago

Subhajit97 commented 1 year ago

Describe the bug Query to the table fails with the below error:

image

Steampipe version (steampipe -v) Example: v0.18.6

Plugin version (steampipe plugin list) Example: v0.2.0

To reproduce Run below query:

select
  name,
  version,
  install_date,
  install_location,
  device_id
from
  jumpcloud_device_windows_program;

Expected behavior Query should return data without any error.

Additional context Seems like the install_date column gets some invalid time value that can't be parsed.