Use SQL to instantly query groups, service principals, users and more from Azure Active Directory. Open source CLI. No DB required.
7
stars
12
forks
source link
Add azuread_conditional_access_named_location table Closes #191 #199
Closed
ParthaI closed 2 months ago
Example query results
Results
``` > select * from azuread_conditional_access_named_location +--------------------------------------+--------------------------------------+--------------+---------------+---------------------------+---------------------------+---------------------------------------------------------------------------------------------------------------------------------------+-----------+> | tenant_id | id | display_name | location_type | created_date_time | modified_date_time | location_info | title |> +--------------------------------------+--------------------------------------+--------------+---------------+---------------------------+---------------------------+---------------------------------------------------------------------------------------------------------------------------------------+-----------+> | xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx | 0e6339bb-8192-4161-8fd4-7cd918c30e5f | us-east-1 | IP | 2022-09-05T12:30:11+05:30 | 2022-09-05T12:30:11+05:30 | {"IPv4Cidr":[{"Address":"40.77.12.31/27"},{"Address":"61.22.45.30/27"}],"IPv4Range":[],"IPv6Cidr":[],"IPv6Range":[],"IsTrusted":true} | us-east-1 |> +--------------------------------------+--------------------------------------+--------------+---------------+---------------------------+---------------------------+---------------------------------------------------------------------------------------------------------------------------------------+-----------+ ```