steampipe plugin install azure

Table: azure_service_fabric_cluster - Query Azure Service Fabric Clusters using SQL

Azure Service Fabric is a distributed systems platform that makes it easy to package, deploy, and manage scalable and reliable microservices and containers. It also provides comprehensive runtime and lifecycle management capabilities to applications that are composed of these microservices or containers. This makes it an ideal tool for developers and administrators looking to manage complex microservices architectures.

Table Usage Guide

The azure_service_fabric_cluster table provides insights into Service Fabric Clusters within Azure. Developers and administrators can explore cluster-specific details through this table, including the cluster's health, configuration, and node types. Utilize it to uncover information about clusters, such as their reliability tier, upgrade mode, and the version of Service Fabric they're running.

Examples

Basic info

Explore the status and configuration of your Azure Service Fabric clusters to understand their current operational state and setup. This is crucial for managing your clusters effectively and ensuring they are configured according to your organization's standards.

select
name,
id,
provisioning_state,
type,
cluster_code_version,
management_endpoint,
upgrade_mode,
vm_image
from
azure_service_fabric_cluster;
select
name,
id,
provisioning_state,
type,
cluster_code_version,
management_endpoint,
upgrade_mode,
vm_image
from
azure_service_fabric_cluster;

List azure active directory details for clusters

Discover the segments that contain key Azure Active Directory details for specific clusters. This is useful for understanding the configuration and security measures of your Azure Service Fabric clusters.

select
name,
id,
azure_active_directory ->> 'clientApplication' as client_application,
azure_active_directory ->> 'clusterApplication' as cluster_application,
azure_active_directory ->> 'tenantId' as tenant_id
from
azure_service_fabric_cluster;
select
name,
id,
json_extract(azure_active_directory, '$.clientApplication') as client_application,
json_extract(azure_active_directory, '$.clusterApplication') as cluster_application,
json_extract(azure_active_directory, '$.tenantId') as tenant_id
from
azure_service_fabric_cluster;

List certificate details for clusters

Determine the security status of your clusters by examining the details of their associated certificates. This is useful for ensuring the integrity and validity of your clusters' security certificates.

select
name,
id,
certificate ->> 'thumbprint' as thumbprint,
certificate ->> 'thumbprintSecondary' as thumbprint_secondary,
certificate ->> 'x509StoreName' as x509_store_name
from
azure_service_fabric_cluster;
select
name,
id,
json_extract(certificate, '$.thumbprint') as thumbprint,
json_extract(certificate, '$.thumbprintSecondary') as thumbprint_secondary,
json_extract(certificate, '$.x509StoreName') as x509_store_name
from
azure_service_fabric_cluster;

List fabric setting details for clusters

Determine the configuration details for your clusters in Azure Service Fabric. This can help you understand and manage the settings parameters for each cluster, ensuring optimal performance and security.

select
name,
id,
settings ->> 'name' as settings_name,
jsonb_pretty(settings -> 'parameters') as settings_parameters
from
azure_service_fabric_cluster,
jsonb_array_elements(fabric_settings) as settings;
select
name,
c.id,
json_extract(settings.value, '$.name') as settings_name,
json_extract(settings.value, '$.parameters') as settings_parameters
from
azure_service_fabric_cluster as c,
json_each(fabric_settings) as settings;

List node type details for clusters

Explore the characteristics of different nodes within your Azure Service Fabric Clusters. This query helps you understand the configuration and capabilities of each node, which can be beneficial for managing resources and optimizing performance.

select
name,
id,
types ->> 'clientConnectionEndpointPort' as type_client_connection_endpoint_port,
types ->> 'durabilityLevel' as type_durability_level,
types -> 'httpGatewayEndpointPort' as type_http_gateway_endpoint_port,
types -> 'isPrimary' as type_is_primary,
types ->> 'name' as type_name,
types -> 'vmInstanceCount' as type_vm_instance_count,
jsonb_pretty(types -> 'applicationPorts') as settings_application_ports,
jsonb_pretty(types -> 'ephemeralPorts') as settings_ephemeral_ports
from
azure_service_fabric_cluster,
jsonb_array_elements(node_types) as types;
select
name,
c.id,
json_extract(types.value, '$.clientConnectionEndpointPort') as type_client_connection_endpoint_port,
json_extract(types.value, '$.durabilityLevel') as type_durability_level,
json_extract(types.value, '$.httpGatewayEndpointPort') as type_http_gateway_endpoint_port,
json_extract(types.value, '$.isPrimary') as type_is_primary,
json_extract(types.value, '$.name') as type_name,
json_extract(types.value, '$.vmInstanceCount') as type_vm_instance_count,
types.value as settings_application_ports,
types.value as settings_ephemeral_ports
from
azure_service_fabric_cluster as c,
json_each(node_types) as types;

Schema for azure_service_fabric_cluster

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
add_on_featuresjsonbThe list of add-on features to enable in the cluster.
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
available_cluster_versionsjsonbThe service fabric runtime versions available for this cluster.
azure_active_directoryjsonbThe azure active directory authentication settings of the cluster.
certificatejsonbThe certificate to use for securing the cluster. The certificate provided will be used for node to node security within the cluster, SSL certificate for cluster management endpoint and default admin client.
certificate_common_namesjsonbDescribes a list of server certificates referenced by common name that are used to secure the cluster.
client_certificate_common_namesjsonbThe list of client certificates referenced by common name that are allowed to manage the cluster.
client_certificate_thumbprintsjsonbThe list of client certificates referenced by thumbprint that are allowed to manage the cluster.
cloud_environmenttextThe Azure Cloud Environment.
cluster_code_versiontextThe service fabric runtime version of the cluster. This property can only by set the user when **upgradeMode** is set to 'Manual'.
cluster_endpointtextThe azure resource provider endpoint. A system service in the cluster connects to this endpoint.
cluster_idtextA service generated unique identifier for the cluster resource.
cluster_statetextThe current state of the cluster. Possible values include: 'WaitingForNodes', 'Deploying', 'BaselineUpgrade', 'UpdatingUserConfiguration', 'UpdatingUserCertificate', 'UpdatingInfrastructure', 'EnforcingClusterVersion', 'UpgradeServiceUnreachable', 'AutoScale', 'Ready'.
diagnostics_storage_account_configjsonbThe storage account information for storing service fabric diagnostic logs.
etagtextAzure resource etag.
event_store_service_enabledbooleanIndicates if the event store service is enabled.
fabric_settingsjsonbThe list of custom fabric settings to configure the cluster.
idtextAzure resource identifier.
management_endpointtextThe http management endpoint of the cluster.
nametext=Azure resource name.
node_typesjsonbThe list of node types in the cluster.
provisioning_statetextThe provisioning state of the cluster resource. Possible values include: 'Updating', 'Succeeded', 'Failed', 'Canceled'.
regiontextThe Azure region/location in which the resource is located.
reliability_leveltextThe reliability level sets the replica set size of system services. Possible values include: 'None', 'Bronze', 'Silver', 'Gold', 'Platinum'.
resource_grouptext=The resource group which holds this resource.
reverse_proxy_certificatejsonbThe server certificate used by reverse proxy.
reverse_proxy_certificate_common_namesjsonbDescribes a list of server certificates referenced by common name that are used to secure the cluster.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
subscription_idtext=, !=, ~~, ~~*, !~~, !~~*The Azure Subscription ID in which the resource is located.
tagsjsonbA map of tags for the resource.
titletextTitle of the resource.
typetextAzure resource type.
upgrade_descriptionjsonbThe policy to use when upgrading the cluster.
upgrade_modetextThe upgrade mode of the cluster when new service fabric runtime version is available. Possible values include: 'Automatic', 'Manual'.
vm_imagetextThe VM image VMSS has been configured with. Generic names such as Windows or Linux can be used.

Export

This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.

You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh script:

/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- azure

You can pass the configuration to the command with the --config argument:

steampipe_export_azure --config '<your_config>' azure_service_fabric_cluster