In my previous post I talked about generating AWS Billing data for last 12 months in Excel file and also showed you how to create a chart on Excel showing cost comparison all using Powershell. To me this is a nice and quick way to generate such report and email to stake holders automatically. I…
Tag: Excel
Azure DevOps Audit report in Excel
In my last few posts I have discussed about Microsoft Azure DevOps Users, Groups, License audit etc. Periodically, we run those audits to perform access review and license true up. Refer to my previous posts here: Azure DevOps Users and Groups Report in Excel Azure DevOps basic User and License Audit In this post, we…
Automate AWS billing report in Excel
I have posted several articles in past on how to generate billing reports for different AWS services and provided scripts to get those reports in csv format. Those reports are good and handy to quickly refer in discussions. However, if you want to present a nice AWS Cloud expense report to management you would need…
Azure DevOps basic User and License Audit
In my previous post I discussed about Azure DevOps and shared a script to generate users and groups report in an Excel spreadsheet. We can periodically generate such report and perform audit on users and groups based on Company requirements. Today, I am going discuss about license usage and user activity audit. A common use…
Azure DevOps Users and Groups Report in Excel
Azure DevOps is a Microsoft product which provides version control, project management, automated builds, lab management, testing and release management,Code repository capabilities. It covers the application life-cycle and enables DevOps capabilities. Organizations using Azure DevOps allow users to login and perform different job roles including manage repositories, work items, perform build and release management etc….