AzureQL is node.js package that allows you to query Microsoft Azure resources with SQL syntax
npm install azureqlAzureQL needs the following inputs:
- appId - ApplicationId of an Azure Active Directory application with permissions to access Azure API
- password - The password of the Azure AD app
- subscriptionId - the ID of the subscription
- tenantId - Get it from the Azure Portal, navigate to Active Directory, Manage / Properties, and copy the Directory ID
Getting started:
var AzureQL = require ('azureql');
AzureQL.init(process.env.appId, process.env.password, process.env.tenantId, process.env.subscriptionId, () => {
AzureQL.performQuery('select * from VirtualMachines where name="myVM"', (response) => {
log.console(response.results);
});
});As of now, supported resources (tables) to query are: VirtualMachines, ScaleSets, ServiceFabrics, CosmosDbs, StorageAccounts, NetworkSecurityGroups, ApplicationGateways, HDInsights, LoadBalancers, Batches, VirtualNetworks, AppServices, Redis, ResourceGroups, ExpressRoutes
More will be added soon.
All tables, columns and return objects are valid representations of the Azure API object models which you can find here.