Public/Get-CCMLastHardwareInventory.ps1
function Get-CCMLastHardwareInventory { <# .SYNOPSIS Returns info about the last time Hardware Inventory ran .DESCRIPTION This function will return info about the last time Hardware Inventory was ran. This is pulled from the InventoryActionStatus WMI Class. The hardware inventory major, and minor version is included. This can be helpful in troubleshooting hardware inventory issues. .PARAMETER CimSession Provides CimSession to gather hardware inventory last run info from .PARAMETER ComputerName Provides computer names to gather hardware inventory last run info from .EXAMPLE C:\PS> Get-CCMLastHardwareInventory Returns info regarding the last hardware inventory cycle for the local computer .EXAMPLE C:\PS> Get-CCMLastHardwareInventory -ComputerName 'Workstation1234','Workstation4321' Returns info regarding the last hardware inventory cycle for Workstation1234, and Workstation4321 .NOTES FileName: Get-CCMLastHardwareInventory.ps1 Author: Cody Mathis Contact: @CodyMathis123 Created: 2020-01-01 Updated: 2020-01-18 #> [CmdletBinding(DefaultParameterSetName = 'ComputerName')] [Alias('Get-CCMLastHINV')] param ( [Parameter(Mandatory = $false, ValueFromPipelineByPropertyName = $true, ParameterSetName = 'CimSession')] [Microsoft.Management.Infrastructure.CimSession[]]$CimSession, [Parameter(Mandatory = $false, ValueFromPipelineByPropertyName = $true, ParameterSetName = 'ComputerName')] [Alias('Connection', 'PSComputerName', 'PSConnectionName', 'IPAddress', 'ServerName', 'HostName', 'DNSHostName')] [string[]]$ComputerName = $env:ComputerName ) begin { $getLastHinvSplat = @{ Namespace = 'root\CCM\InvAgt' Query = "SELECT LastCycleStartedDate, LastReportDate, LastMajorReportVersion, LastMinorReportVersion, InventoryActionID FROM InventoryActionStatus WHERE InventoryActionID = '{00000000-0000-0000-0000-000000000001}'" } } process { foreach ($Connection in (Get-Variable -Name $PSCmdlet.ParameterSetName -ValueOnly)) { $Computer = switch ($PSCmdlet.ParameterSetName) { 'ComputerName' { Write-Output -InputObject $Connection switch ($Connection -eq $env:ComputerName) { $false { if ($ExistingCimSession = Get-CimSession -ComputerName $Connection -ErrorAction Ignore) { Write-Verbose "Active CimSession found for $Connection - Passing CimSession to CIM cmdlets" $getLastHinvSplat.Remove('ComputerName') $getLastHinvSplat['CimSession'] = $ExistingCimSession } else { Write-Verbose "No active CimSession found for $Connection - falling back to -ComputerName parameter for CIM cmdlets" $getLastHinvSplat.Remove('CimSession') $getLastHinvSplat['ComputerName'] = $Connection } } $true { $getLastHinvSplat.Remove('CimSession') $getLastHinvSplat.Remove('ComputerName') Write-Verbose 'Local computer is being queried - skipping computername, and cimsession parameter' } } } 'CimSession' { Write-Verbose "Active CimSession found for $Connection - Passing CimSession to CIM cmdlets" Write-Output -InputObject $Connection.ComputerName $getLastHinvSplat.Remove('ComputerName') $getLastHinvSplat['CimSession'] = $Connection } } $Result = [System.Collections.Specialized.OrderedDictionary]::new() $Result['ComputerName'] = $Computer try { [ciminstance[]]$LastHinv = Get-CimInstance @getLastHinvSplat if ($LastHinv -is [Object] -and $LastHinv.Count -gt 0) { foreach ($Occurrence in $LastHinv) { $Result['LastCycleStartedDate'] = $Occurrence.LastCycleStartedDate $Result['LastReportDate'] = $Occurrence.LastReportDate $Result['LastMajorReportVersion'] = $Occurrence.LastMajorReportVersion $Result['LastMinorReportVersion'] = $Occurrence.LastMinorReportVersion [PSCustomObject]$Result } } else { Write-Warning "No hardware inventory run found for $Computer" } } catch { $ErrorMessage = $_.Exception.Message Write-Error $ErrorMessage } } } } |