I released the new version of Azure Office Companion (AOC), and this new version contains amazing features, below the hot list.
1533 Azure API calls to use with a very extensive searching option
AOC lists all the Azure APIs and we can call any API directly from Microsoft Excel, we can also search with many options like AND / OR and parameter available for the using, this is what I call the 101 dynamic mapping.
One to one dynamic mapping of the parameters directly into the API calls from any Excel Sheet
This is a very powerful feature, some Azure APIs need one parameter only, others need multiple, like location or resource group, in AOC we can define which Excel Sheet the API needs to use to get the parameters.
When defined, the Azure API will execute a call for each row in the Excel Sheet and it will return the total result in a single new Excel sheet.
Let say that we’d like to call some Azure APIs and passing the subscription id to them.
Click on Subs to retrieve all our subscriptions
Click on Enlist and open the Enlist Form
Select the Excel sheet to retrieve our data for the API Call.
Search for virtualmachine in any of the fields, we can also specify for specific fields.
Check Only if parameters are available checkbox to retrieve only the API calls that we will be able to execute using this Excel Sheet.
This option will filter all the API calls and makes our search very easy.
Select the API call 0189 and click Ok to retrieve all virtual machines and all in our subscriptions in the Excel Sheet.
We can use multiple parameters from other Excel Sheets as well.
Another great feature is the DEFCON.
I called DEFCON because I normally use this feature in very critical situations.
Write a word in the search box to highlight all fields containing that word and using the colour you selected.
AOC will also add a new column that you can use to filter all rows, this is extremely useful to limit our working area.
We can use multiple colours in multiple columns, below you can see an example using two simple searches using the words D4s in yellow and A3 in Red.
We can also use the Excel filter option to limit our working area, see below the filter applied for the D4s
The heuristic view provides an intelligent view about the results, it is very useful in many cases, especially during troubleshooting, a simple example below.
The picture below is a result of the list of the virtual networks in a subscription, thank to the heuristic view you can immediately see that two virtual networks are using the same IP schema.
This is tremendously useful also in case of multiple subscription and check any overlapping before peering.
The Group Count provides a very useful view related to the amount of resources.
The example below provides me many important information about the subscription very quickly like, the number of subnets, the number of VNet with same IP schema, number of resources by region.
This feature also creates many new columns that we can use for extensive filtering.
many possibilities to export results in Excel, and we can apply these feature in these cases as well.
People required me and I needed this one, now it is possible to manage multiple configurations.
We can also export them, this is very useful when we need to send the configuration to many persons.
You can download the last version below