bharkr

<#
.SYNOPSIS
    Creates an Excel workbook with DHCP server information.

.DESCRIPTION
    This script retrieves DHCP server summary data and subnet reservation data from the DHCP server and creates an Excel workbook with the information.

.PARAMETER SummaryData
    Specifies the DHCP server summary data to be included in the workbook.

bharkr

<#
.SYNOPSIS
    Disables the TortoiseHg startup entry on a list of computers.

.DESCRIPTION
    The Disable-TortoiseHgStartup function uses Invoke-Command to remotely access the registry of each computer in the $ComputerName parameter. It attempts to get the 'TortoiseHgOverlayIconServer' startup entry. If the computer isn't responding or doesn't have TortoiseHg installed, it outputs a message.

.PARAMETER ComputerName
    An array of computer names or a single computer name. This can be either a string or an object with a 'Name' property.

bharkr

function Get-DhcpLeaseInfo {
    [CmdletBinding(DefaultParameterSetName='HostName')]
    param(
        [Parameter(Mandatory=$true, HelpMessage='Name of the the DHCP server being queried.')]
        [string]$ComputerName,
        [Parameter(ParameterSetName='HostName', HelpMessage='The host name property to be queried.', Mandatory=$true)]
        [string]$HostName,
        [Parameter(ParameterSetName='OUI', Mandatory=$true, 
            HelpMessage='First three octets of the mac addresses you being searched for. For example: AA-BB-CC')]
        [string]$OUI,

bharkr

#requires -modules VMware.PowerCLI
$vcenterServer = ''

Connect-VIServer $vCenterServer

$virtGuests = Get-VM | Where-Object { $_.PowerState -eq 'PoweredOn' }

$vmInfoReport = @()

foreach ($guest in $virtGuests) {

bharkr

function Install-ZabbixAgent {
    [CmdletBinding()]
    param(
        [Parameter(Mandatory=$true)]
        [string]$ComputerName,

        [Parameter(Mandatory=$true)]
        [string]$ZabbixUrl
    )

bharkr

; https://docs.microsoft.com/en-us/sql/database-engine/install-windows/install-sql-server-using-a-configuration-file?view=sql-server-ver15
; ;SQL Server 2016 Configuration File
[OPTIONS]

ACTION="Install"

SUPPRESSPRIVACYSTATEMENTNOTICE="False"

; By specifying this parameter and accepting Microsoft R Open and Microsoft R Server terms, you acknowledge that you have read and understood the terms of use. 

bharkr

$servers = @('server2','server1') 
$report_csv = "C:\users\$env:username\desktop\cert_report.csv"
 
$Results = @()
$Results = Invoke-Command -ComputerName $Servers {
        $Certs = @{} | Select Certificate,Expired
        $Cert = Get-ChildItem Cert:\LocalMachine\My | Where-Object {$_.issuer -match 'Incommon'}
        If($Cert){
            $Certs.Certificate = $Cert.subject
            $Certs.Expired = $Cert.NotAfter