search

turbot / steampipe-plugin-okta

Use SQL to instantly query users, groups, applications and more from Okta. Open source CLI. No DB required.
https://hub.steampipe.io/plugins/turbot/okta
Apache License 2.0
8 stars 4 forks source link

Added support for profile column in the table okta_factor Closes #129 #130

Closed ParthaI closed 3 months ago

ParthaI commented 3 months ago

Example query results

Results ``` > select id, user_name, created, factor_type, jsonb_pretty(profile) as profile from okta_factor +----------------------+-------------------+---------------------------+---------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> | id | user_name | created | factor_type | profile > +----------------------+-------------------+---------------------------+---------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> | ost1m64qvuJk6dICv5d7 | hetlsk@guossr.com | 2021-08-30T18:23:16+05:30 | token:software:totp | { > | | | | | "credentialId": "hetlsk@guossr.com" > | | | | | } > | mbl1m6472anhxTgOE5d7 | hetlsk@guossr.com | 2021-08-30T18:24:44+05:30 | sms | { > | | | | | "phoneNumber": "+911234567890" > | | | | | } > | opfg6o5fqcXWpMfKY5d7 | hetlsk@guossr.com | 2024-04-02T23:07:34+05:30 | push | { > | | | | | "keys": [ > | | | | | { > | | | | | "e": "AQAB", > | | | | | "n": "zkkbVZd1ppo5mKSTXu20TRc5GNhQkExcgQZC5jBFsYxnolksd7RHFnsilePoYGwTObBG-hgRQzj012t0V_TKJb9-2IkDEjCFHQnQrLMw6vpR9IGbcXukOWASu5Dn9wlF84spprvWUjU8patUefAeZG7D907E> | | | | | "kid": "default", > | | | | | "kty": "RSA", > | | | | | "use": "sig", > | | | | | "jwkType": "proofOfPossession" > | | | | | } > | | | | | ], > | | | | | "name": "Redmi Note 7 Pro", > | | | | | "version": "29", > | | | | | "platform": "ANDROID", > | | | | | "deviceType": "SmartPhone_Android", > | | | | | "credentialId": "hetlsk@guossr.com" > | | | | | } > +----------------------+-------------------+---------------------------+---------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> ```