ok well ill post the whole script then. any sensitive info will be replaced with a string of *
<#
.SYNOPSIS
This script will query different data sources and provide applicable metadata for VMs
.DESCRIPTION
This script queries VMWare, Active Directory, & BMC Discovery to join applicable metadata from each dataset to provide a unified view of the systems
.PARAMETER Location
The parameter location is used to refine the location of where geographicaly applicable system metadata is queried from
e.g. AK
.EXAMPLE
The example below will query all defined vCenter instances and join applicable metadata for each VM from AD & Discovery
PS C:\> Get-VmInventory
.EXAMPLE
The example below will query the AK vCenter instance and join applicable metadata for each VM from AD & Discovery
PS C:\> Get-VmInventory -location AK
.NOTES
*******************************
Script: Vmware_Get-VmInventory
Current Version: 1.0
Published: 23 Oct 2023
Revision Date: 23 Oct 2023
Change Log:
v1.0 - Script creation
Module Dependencies:
Join-Object
PowerCLI
#>
Begin{
#Functions (load the required functions)
function Get-FolderPath{
<#
.SYNOPSIS
Returns the folderpath for a folder
.DESCRIPTION
The function will return the complete folderpath for
a given folder, optionally with the "hidden" folders
included. The function also indicats if it is a "blue"
or "yellow" folder.
.PARAMETER Folder
On or more folders
.PARAMETER ShowHidden
Switch to specify if "hidden" folders should be included
in the returned path. The default is $false.
.EXAMPLE
PS> Get-FolderPath -Folder (Get-Folder -Name "MyFolder")
.EXAMPLE
PS> Get-Folder | Get-FolderPath -ShowHidden:$true
#>
param(
[parameter(valuefrompipeline = $true,
position = 0,
HelpMessage = "Enter a folder")]
[VMware.VimAutomation.ViCore.Impl.V1.Inventory.FolderImpl[]]$Folder,
[switch]$ShowHidden = $false
)
begin{
$excludedNames = "Datacenters","vm","host"
}
process{
$Folder | %{
$folderid = $_.Id
$fld = $_.Extensiondata
$fldType = $_.Type
$path = $fld.Name
while($fld.Parent){
$fld = Get-View $fld.Parent
if((!$ShowHidden -and $excludedNames -notcontains $fld.Name) -or $ShowHidden){
$path = $fld.Name + "\" + $path
}
}
$row = "" | Select Name,Path,Type,FolderId
$row.Name = $_.Name
$row.Path = $path
$row.Type = $fldType
$row.FolderId = $folderid
$row
}
}
}
#Populate the Vcenters array with the FQDNs of all vCenters.
$Vcenters = @(`
*******************************
#define BMC Discovery API endpoint & auth info
[System.Net.ServicePointManager]::SecurityProtocol = [System.Net.SecurityProtocolType]::Tls12
#exact query context can be generated directly within the UI
$apiURL = "**************************************************"
$apiHeaders = @{"Authorization" = "Bearer $apikey"}
$apiKey = ****************************************************
$apiQuery = "search Host show name, #InferredElement:Inference:Associate:DiscoveryAccess.endpoint as 'Scannedvia', #Host:HostedSoftware:AggregateSoftware:BusinessApplicationInstance.name as 'BusinessApp'"
$apiParams = @{"query" = $apiQuery; "format" = "object"; "limit" = 0}
}
process{
#Query BMC Discovery via Rest API
$BmcDiscoResponse = Invoke-RestMethod -uri $apiurl -Headers $apiHeaders -method Get -Body $apiparams
$adhosts = get-adcomputer -filter * -properties name,enabled,description,CanonicalName,operatingSystem,lastlogondate,managedby | select @{Name='name';Expression={$_.name.ToLower()}},enabled,description,CanonicalName,operatingSystem,lastlogondate,managedby
#$adhosts = get-adcomputer -filter {(operatingsystem -notlike "Windows 10*") -and (operatingsystem -notlike "Windows 7*") -and (operatingsystem -notlike "Windows 8*")} -properties name,enabled,description,CanonicalName,operatingSystem,lastlogondate,managedby
# Loop thru all vCenters
Foreach ($vcenter in $Vcenters) {
connect-viserver $vcenter
#get a list of all vm folders, fullpath, & associated IDs
$VMFolders= get-folder | get-folderPath
#get a list of all vms & associated containing folders
$vms = get-vm | select @{Name='name';Expression={$_.name.ToLower()}}, powerstate,folderid
#Join VMs output with VMFolders output to get full folder path of VMs
$VMJoinObjParams = @{
Left = $vms
Right = $VMfolders
LeftJoinProperty = 'FolderId'
RightJoinProperty = 'FolderId'
LeftProperties = 'Name', 'Powerstate'
RightProperties = 'Path'
Type = 'AllInLeft'
}
$VmsWFolders = Join-Object @VMJoinObjParams
#Join VMsWFolders output with Active Directory data
$ADJoinObjParams = @{
Left = $VmsWFolders
Right = $ADhosts
LeftJoinProperty = 'Name'
RightJoinProperty = 'Name'.ToLower()
LeftProperties = 'Name','Powerstate','Path'
RightProperties = 'Description','Operatingsystem','managedby','CanonicalName'
Type = 'AllInLeft'
Prefix = 'AD_'
}
$VmsWAd = Join-Object @ADJoinObjParams
#Join VMsWFolders output with Active Directory data
$BmcJoinObjParams = @{
Left = $VmsWAd
Right = $BmcDiscoResponse.results
LeftJoinProperty = 'Name'
RightJoinProperty = 'Name'
LeftProperties = 'Name','Powerstate','Path','AD_Description','AD_Operatingsystem','AD_managedby','AD_CanonicalName'
RightProperties = 'Name','ScannedVia','BusinessApp'
Type = 'OnlyIfInBoth'
Prefix = 'BMC_'
}
$VmsWAdWBmc = Join-Object @BmcJoinObjParams
#Output to CSV
$VmsWAdWBmc | Select name, powerstate, path, AD_Description, AD_Operatingsystem, AD_managedby, AD_CanonicalName, BMC_ScannedVia, @{Name='BusinessApp';Expression={$_.BMC_BusinessApp}}| Export-Csv -path c:\tmp\VMInventory_$(Get-Date -Format "MM-dd-yyyy").csv -Append -NoTypeInformation
}
}
end {
# Disconnect from each vCenter
Foreach ($vcenter in $Vcenters) {
Disconnect-viserver $vcenter -Confirm:$false
}
}
