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. […]
Category: Inventory True Up
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 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 […]
Prepare for Logging
As this script is intended to run unattended as a PowerShell job on a Windows server, Event logging will be used.
Create a Folder Structure For Daily Reporting
This is the folder structure for the daily server CMDB true up reports. The code snippet assumes that the script it’s part of is deployed as a PowerShell scheduled job running on the server that provides the file share and therefore absolute paths are used. Create the Folder Structure and Implement the File Naming scheme: […]
An Approach To Server Inventory True Up
Problem Statement: Your organization uses ServiceNow and ServiceNow Discovery to populate and manage your server CMDB. How do you validate that the server CMDB server inventory is correct? How do you do this on an on going basis? Goals: Automate all data gathering and reporting. Compare the server inventory against sources of truth for deployed […]