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: REST Api
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…
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….
Create Azure DevOps User Story using Powershell
In my previous post I talked about creating Azure DevOps(ADO) Task from ITSM Incident. I am going to talk about another use case today. We will create ADO User Story work item from ITSM Change Management Ticket. As mentioned in my previous post, Engineering team is using ADO to track their activities, where as rest…
Managing attachments in Confluence using Powershell
In my previous post I discussed about managing Confluence page and it’s content. This is the second part of the series. Today, I am going to share some script blocks to manage attachments in Confluence pages. Before you start, you still need to set up access on Confluence to manage pages, content,Space etc. Let’s set…
AWS RDS Billing Report
Amazon Relational Database Service(RDS) is a Cloud-based distributed relational database service. In today’s blog, I will share a script to generate RDS billing report for each RDS instance for a specified date range. Before we start, we need to setup our AWS credentials and AWS Powershell SDK . Refer following documents to set those :…
AWS Elastic IP Billing Report
In my previous blog I wrote about billing report for EBS Volumes under EC2 – Other service category of AWS Cost Explorer API. Today, I am going to provide another script which will help you to generate billing report specific to Elastic IP address usage in AWS. So, if you have already gone through the…
Service Now Change Management using Powershell
In previous post, I talked about Service Now Incident management using Powershell. In this blog, I am going to talk about Change management using Powershell with an example. Again, the scenario remains the same, still trying to automate a lot of stuff and this time leveraging Service Now Change management. In one of my previous…