Amazon Simple Storage Service (S3) is the bedrock of many cloud infrastructures, offering scalable storage solutions for data of all sizes. Whether it’s storing images, videos, backups, or application data, S3 is ubiquitous. Yet, when attempting to retrieve metrics like the number of objects or the total size of a bucket, users may encounter unexpected delays. Let’s delve into why this happens and how to navigate it. I was in a same situation where I need to gather metrics for S3 storage, sizes, and counts. For solutioning it I obviously used the PowerShell and Module is AWSPowershell I have s ..read more

In the world of software development, upgrading libraries and dependencies is often a necessity to keep up with evolving technologies, security patches, and enhanced functionalities. However, in some cases, it’s not always straightforward to immediately jump to the latest version, especially when dealing with critical components like Microsoft Graph SDK. Microsoft Graph SDK offers powerful capabilities for integrating Microsoft services into your applications. But what happens when you need to upgrade to a newer version while still maintaining compatibility with existing code? This is where th ..read more

In the realm of cloud computing, Amazon Web Services (AWS) stands out as a powerhouse, offering a plethora of services tailored to various needs. Among these services, databases play a pivotal role in storing, managing, and analyzing data. Monitoring and reporting on these databases are crucial for maintaining performance, security, and cost-efficiency. In this blog post, we’ll explore how PowerShell can be harnessed to generate insightful reports on AWS databases, providing administrators with actionable insights. I am sharing this sample script which you can modify accordingly as per your en ..read more

In this blog, I will share the steps that you can utilize to access PowerBI Admin API from service principal. There are many articles on the internet about it but there is mixture of information, so I am just documenting step by step that worked for us.      1. Register the APP in Azure AD and do not ADD any API permissions (This is important)      2. Create the Certificate and upload the thumbprint to the APP. Here is the PowerShell command to do it. New-SelfSignedCertificate -Subject ‘CN=DEVTESTCertificate’ -KeyLength 4096 -KeyUsageProperty All -KeyAlgorithm ‘R ..read more

SharePoint, with its powerful collaboration and document management capabilities, is widely used in various organizations. Python, being a versatile programming language, is often employed to interact with SharePoint data using APIs. However, traversing SharePoint lists can sometimes lead to a common stumbling block – the elusive Python KeyError. This error can be solved easily by suing try except statement inside the loop that you are using for traversing. Understanding the KeyError: A KeyError in Python occurs when a dictionary key is not found. In the context of SharePoint lists, it typical ..read more

In the realm of automation, PowerShell stands as a powerful scripting language that empowers administrators and developers to automate repetitive tasks efficiently. SharePoint, on the other hand, is a widely used collaboration platform for document management and content sharing. Combining the capabilities of PowerShell with SharePoint opens a plethora of possibilities, including the seamless synchronization of data from CSV files to SharePoint lists. In this blog post, I am sharing a sample script solution that you can utilize to sync CSV or excel to SharePoint list. Create a SharePoint List ..read more

Managing resources efficiently is a key aspect of any AWS (Amazon Web Services) environment. Among the numerous services offered by AWS, EC2 (Elastic Compute Cloud) instances are fundamental for hosting applications and workloads. Keeping track of your EC2 inventory is crucial for optimizing costs, ensuring security, and maintaining overall system health. In this blog post, we’ll explore how to fetch an AWS EC2 inventory report using PowerShell, providing a streamlined approach to stay on top of your cloud resources. I am sharing this sample script which you can modify accordingly as per your ..read more

In the era of cloud computing, Azure has emerged as a powerful platform, providing a plethora of services to organizations worldwide. Among these services, Azure Storage holds a crucial role, serving as the backbone for data storage needs. Keeping track of Azure Storage Account usage is essential for organizations to ensure optimal resource utilization and cost management. In this blog post, we will delve into how PowerShell can be harnessed to generate comprehensive reports on Azure Storage Account usage within your organization. This post is a follow-up post of à How to Programmatically get ..read more

Azure Storage is a powerful and scalable cloud storage solution provided by Microsoft Azure. Monitoring the usage of your Azure Storage accounts is crucial for optimizing costs and ensuring efficient resource utilization. In this blog post, we will explore how to programmatically retrieve Azure Storage account usage using Azure PowerShell Module. It is easy to get the Storage Usage for one of the accounts as you can use the GUI but to get the storage across multiple accounts is somewhat difficult. For getting the same across multiple accounts I thought I can crawl thru each storage account an ..read more

Azure is a powerful cloud platform that provides a wide range of services to help organizations scale, manage, and deploy their applications and data. Among these services, Azure Disk Storage is a fundamental component for managing and storing data in virtual machines. To keep track of the disks in your organization’s Azure environment, it’s essential to have an efficient reporting mechanism. In this blog, I am sharing the Script that can generate report of Azure Disks across your organization.   Prerequisites for this Solution: vsadmin Azure Module Download the script from Git or P ..read more