In this blog I describe creating a PowerShell Function to save email attachments to a local folder while keeping the mail message itself in your mailbox. Problem Statement: Like most of us I receive a lot of email every day. Some important, some not. Many that have attachments. I want to automate saving my email […]
Category: Scripting
Experiment with PowerShell and ServiceNow using ServiceNow free Developer Instance
Problem Statement: If the company you work for doesn’t use ServiceNow, or perhaps it does but you are unable to get the needed privilege’s to access it using the SNOW REST API. What to do? Solution: The ServiceNow Developer program. Through this program you are given full access to a ServiceNow instance at no cost. […]
Create an AzKeyVault RBAC Secret Report Using PowerShell
Problem Statement: Implementing the new RBAC Key Vault feature brings with it a more complex security model that makes it more difficult to track who has access to what. In this post I create a PowerShell script to provide basic reporting of who has access to your vault secrets and how they have the access. […]
Using Azure Role-Based Access Control for individual Key Vault Secrets
In this blog I describe my experience experimenting with the Azure Key Vault service RBAC support for implementing access control on individual Secrets. Problem Statement: Today Key Vault does not provide fine grained access control for individual secrets. The access control is at the Key Vault level. All users that have read access to the […]
Generating The CMDB True Up Report
Required PowerShell Modules: ImportExcel: Douglas Finke has created an amazing module for creating Excel workbooks, even when Excel is not installed on the system you run the script from. This is a must have for your pragmatic PowerShell tool box. I use it all the time. I’ve linked to it’s page on the PowerShell gallery. […]
Merge CMDB Data with AD Data
Required PowerShell Modules: ImportExcel: Douglas Finke has created an amazing module for creating Excel workbooks, even when Excel is not installed on the system you run the script from. This is a must have for your pragmatic PowerShell tool box. I use it all the time. I’ve linked to it’s page on the PowerShell gallery. […]
Gather AD Data For CMDB True Up
Required PowerShell Modules: ActiveDirectory: This module is installed when you install the Remote Server Administration Tools (RSAT). As of Windows 10 RSAT is installed as a optional feature. How you go about selecting computer objects from AD for inclusion in your CMDB true up activity is dependent on what your AD architecture is and what […]
Merge CMDB Data into the Nutanix VM Data
Approach: I decided on using IP Addresses to match the exported server CMDB data with the VM data collected from Nutanix Prism Central. The first step is to add CMDB properties to the existing objects that hold the VM data. The Nutanix VM data can have one or more IPv4 address in the ‘IP Address(es)’ […]
Gathering Nutanix VM Inventory
The next step for performing a true-up of the ServiceNow server CMDB is to identify a source of truth for deployed servers. This could be VMware or some other virtualization platform, or maybe physical servers. In my environment I’m dealing with multiple Nutanix clusters, some foundation as Nutanix AHV and some with VMware installed. Required […]
Gathering ServiceNow CMDB Server Data
Process to True Up a ServiceNow CMDB A version of this blog was first published in my Linkedin profile blog. We use ServiceNow to maintain a CMDB of all our deployed servers. I have mixed feelings about ServiceNow, but the ServiceNow Discovery capability works well. ServiceNow provides a REST API that can be used to […]