Get-Invent 1.2.0

Get-Invent

💡 Only PowerShell 5.1 (pwsh core not supported)

Module for remote and local viewing of physical hardware characteristics: OS, Mother Board, CPU, RAM, Physical Disk, Logical Disk, Video Card, Network Adapter.

Get-Help Get-Invent
Get-Module Get-Invent | fl Description
Get-Invent localhost default local
Get-Invent -srv server-01 remote
Get-Invent -Full server-01 full report (version 1.1)
Get-Invent -Full -SQL server-01 output to database SQLite (version 1.2)

Out to database SQLite

💡 Dependencies: Module MySQLite

When creating a database, the database is checked if it exists in the specified path (by default, the desktop of the current user and a file named Get-Invent.db), if it does not exist, a new database is created. If it is absent, a new database is created, the tables for CPU (basic report), Memory, PhysicalDisk and VideoCard are checked and created according to the same principle, and filled with corresponding values from the full report (-Full). When filling the database with information from other hosts, it is necessary to manually specify the path to it (key -Path), in each table the first value Host is assigned to the computer name, by which you can easily identify the host name when filtering by the required model.

To opras several hosts at once, and fill the database, use the following construction:

Create a sheet that can be used in the future:

$HostsList = "$home\desktop\Host-List.txt"
@("server-01","server-02","server-03") | Out-File $HostsList

Read the list of servers and add it to the loop:

$Hosts = Get-Content $HostsList
    foreach ($srv in $hosts) {
    Get-Invent -srv $srv -Full -SQL
}

Database example: Get-Invent.db