This is a simple powershell script to query and display hardware and OS information from a remote computer.
It uses CIM (Common Information Model) that is available since Powershell version 3 so as long as you have version 3 and up, you should be able to run this script against any server that you have access to.
And if you are running powershell version lower than 3, you could simply replace "Get-CimInstance -ClassName" with "Get-WmiObject" in this script and it should work without a hitch.
# Specify the server name here $server = "Server1" # pull all the information $hardware = Get-CimInstance -ClassName Win32_ComputerSystem -ComputerName $server $OS = Get-CimInstance -ClassName Win32_OperatingSystem -ComputerName $server $CPU = Get-CimInstance -ClassName Win32_Processor -ComputerName $server $PhysicalMemory = Get-CimInstance -ClassName CIM_PhysicalMemory -ComputerName $server $Bios = Get-CimInstance -ClassName Win32_BIOS -ComputerName $server # build custom array to get some key properties in a single row $server_summary = New-Object PSObject Add-Member -inputObject $server_summary -memberType NoteProperty -Name Manufacturer -value $hardware.Manufacturer Add-Member -inputObject $server_summary -memberType NoteProperty -Name Model -value $hardware.Model Add-Member -inputObject $server_summary -memberType NoteProperty -Name HypervisorPresent -value $hardware.HypervisorPresent Add-Member -inputObject $server_summary -memberType NoteProperty -Name Bios -value $Bios.Name Add-Member -inputObject $server_summary -memberType NoteProperty -Name OS -value $OS.Caption Add-Member -inputObject $server_summary -memberType NoteProperty -Name OSArchitecture -value $OS.OSArchitecture Add-Member -inputObject $server_summary -memberType NoteProperty -Name CPUs -value $CPU.count Add-Member -inputObject $server_summary -memberType NoteProperty -Name PhySicalMemory_GB -value $total_memory_gb Add-Member -inputObject $server_summary -memberType NoteProperty -Name OSVersionNumber -value $OS.Version Add-Member -inputObject $server_summary -memberType NoteProperty -Name ServicePackMajorVersion -value $OS.ServicePackMajorVersion Add-Member -inputObject $server_summary -memberType NoteProperty -Name ServicePackMinor -value $OS.ServicePackMinorVersion Add-Member -inputObject $server_summary -memberType NoteProperty -Name LastBootUpTime -value $OS.LastBootUpTime # Display the data on the screen # But first, lets up the buffer size so we can see the complete output on the screen $Host.UI.RawUI.BufferSize = New-Object Management.Automation.Host.Size (500, 3000) "summary" "=======" $server_summary | ft -AutoSize "" "Detailed Properties" "===================" "Hardware:" $hardware | ft -Property * "Bios:" $Bios | ft -Property * "Operating System:" $OS | ft -Property * "CPUs:" $CPU | ft -Property * "Physical Memory:" $PhysicalMemory | ft -property *
Being able to get information and save it on a Excel as a report can be a common and tedious task. What if we could join dbatools and ImportExcel PorwerShell modules to accomplish this in a easier and fast way? We will see how to export roles and its' member and save that info on a multi spreadsheet Excel file with handy tables ready to be explored.
2020-06-30
6,155 reads
I have created this script for one of our client, the requirement was all the databases should be in full recovery model and should be monitored. Also, I added other important parameters like AutoShrink, AutoClose etc. Output:
2020-06-16
1,027 reads
This script can install Service pack, security patch and Cumulative update on SQL instance(Database Engine).
2020-05-26 (first published: 2020-05-19)
1,616 reads
Scripts contains 4 following functions. Users can create 3 different script from this for inserting, fetching and deleting a document.
1. Function Generate-MasterKeyAuthorizationSignature - This function is used to create connection to Azure cosmos DB. This function codes were taken from Technet.
2. Function Post-CosmosDb - Insert single document in azure cosmos DB. Same function can be used to perform bulkinsert. This function code was taken from following article. To make it useful i made some modification in it.
(https://www.systemcenterautomation.com/2018/06/cosmos-db-rest-api-powershell/)
3. Function Get-CosmosDocument - Fetch single document from azure cosmos DB. Same function can be used to fetch all documents from Cosmos DB.
4. Function Delete-CosmosDbDocument - Delete single document from cosmos DB. Same function can be used to delete more than one document with some additional codes.
To use any of the function like Post,Get, Delete. you have to comment the other 2 function call. If you are using all 3 functions(Post,Get, Delete), Be cautious while using them.
2020-05-11 (first published: 2020-04-30)
3,531 reads
A common question that I've seen online is how do I return multiple sql datasets from a single query using INVOKE-SQLCMD. Most of the answers out there say it is not possible, but it is in fact possible by using the OutputAs dataset parameter. This parameter outputs a dataset that has all of the information […]
2020-04-24 (first published: 2020-04-16)
6,169 reads
