Script-Code – Page 24

Get the VMware tools status and version for all guests

This script connect to your VI Server, then retrieve all the virtual machine names and get the VMware tools status and version. Script: Connect-VIServer -Server VIServerName get-vm | % { get-view $_.ID } | select Name, @{ Name=”hostName”; Expression={$_.guest.hostName}}, @{

Get the virtual desktop uptime

This script lists the following informations : list all the VDI workstations from your VMware connexion servers that host the ldap database DC=vdi,DC=vmware,DC=int get the username assigned to the VDI check if the VDI is reachable (ping) and then get

Get the size of the Exchange databases

This script lists and gets the size of the Exchange databases Script : Get-MailboxDatabase -Status | select Name,DatabaseSize| Out-GridView Reference Get-MailboxDatabase This cmdlet is available only in on-premises Exchange Server 2013. Use the Get-MailboxDatabase cmdlet to retrieve one or more

Get the number of mailboxes on each Exchange store

This script get the number of mailboxes on each Exchange store Script : Get-MailboxDatabase | Select-Object Name,@{Name=”Number of users”;Expression={(Get-Mailbox -Database $_.name).Count}}|Out-GridView Reference Get-MailboxDatabase This cmdlet is available only in on-premises Exchange Server 2013. Use the Get-MailboxDatabase cmdlet to retrieve one

Get the Exchange database statistics

This script gets the following Exchange database statistics : Server name Database name The last full backup The number of mailboxes The database size The average mailbox size The database whitespace Script : function Get-DatabaseStatistics { $Databases = Get-MailboxDatabase -Status foreach($Database

Get the cluster quorum type

This command gets the cluster quorum type Command : Get-Cluster -Name ClusterName | Get-ClusterQuorum My Powershell script categories Active Directory Cluster Database Exchange Files and folders Hardware Network Operating System PKI SCCM Service and process Tips VMWare Reference Get-ClusterQuorum

Get shared folder informations on a remote host

This script gets the shared folder informations and ACL configured on a remote host (source : http://social.technet.microsoft.com/Forums/en-US/winserverpowershell/thread/1903cfde-ad34-464e-9419-94d07ed9de88/) Script : Function Get-NtfsRights($name,$path,$comp){ $path = [regex]::Escape($path) $share = “\\$comp\$name” $path = $path -replace “\\ “,” ” $path $wmi = gwmi Win32_LogicalFileSecuritySetting -filter

Get OS information using WMI

Fill a host file (hosts.txt) with the hostnames you want to retrieve OS information Script : $Catalog = GC “C:\hosts.Txt” ForEach($Machine in $Catalog) {$QueryString = Gwmi Win32_OperatingSystem -Comp $Machine $QueryString = $QueryString.Caption Write-Host $Machine “:” $QueryString} My Powershell script categories

Get operating system name information using Active Directory

You can use one of these script to get operating system name information retrieve from the Active Directory using two different methods : .Net or the Active Directory cmdlet Get-ADObject Script (using .NET) : $strCategory = “computer” $objDomain = New-Object

Get installed software list on a specific computer

This script gets the installed software list on a specific computer using WMI Script : $strComputer = “computer_hostname” $colItems = get-wmiobject -class “Win32_Product” -namespace “root\CIMV2” ` -computername $strComputer foreach ($objItem in $colItems) { write-host “Caption: ” $objItem.Caption write-host “Description: “