PowerShell

1.Add AD user
Import-Module ActiveDirectory$groups = Import-Csv ‘c:\scripts\groups.csv‘foreach ($group in $groups) {New-ADGroup -Name $group.name -Path “OU=GroupTest,DC=test,DC=com” -Description “New Groups Created in Bulk” -GroupCategory Security -GroupScope Universal}

2.Add users to group
get-adgroup -Filter {name -like "*GroupName*"} -ResultSetSize 200 | select Name | ForEach-Object{
Add-ADGroupMember -Identity $_.Name -Members 'Username'
}

3.Set default printer
(Get-WmiObject -ComputerName . -Class Win32_Printer -Filter "Name like 'printername%'").SetDefaultPrinter()

4.Drop database
function Delete([string]$databaseName) {
  invoke-sqlcmd -ServerInstance $(SQLDBServer) -U $(SQLDBUser) -P $(SQLDBPassword) -Query "
   USE master
   IF EXISTS(select * from sys.databases where name='$databaseName')
   BEGIN
    ALTER DATABASE [$databaseName] SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
    DROP DATABASE [$databaseName];
   END"
 }
Delete "DatabaseName"

5.Uninstall application
$app = Get-WmiObject -Class Win32_Product | Where-Object {
  $_.Name -match "AppName"
}
if($app) {
  echo $app
  $app.Uninstall()
try {
  Remove-WebSite -Name "AppName" -ErrorAction Stop
  Remove-WebAppPool -Name "AppPoolName" -ErrorAction Stop
}
catch [System.Management.Automation.ItemNotFoundException] {
  echo "Error Occurred while uninstall"
}
}

6.Delete item from folder
Remove-item "$(Folder)\*" -Recurse -Force

7.Move file to One PC from another
$Source =Join-Path $(Win2016Folder) "\CVP*.*"
$Dest = Join-Path  $(Win10Folder) "\ZipCVP"
net use $(Win2016Folder) /user:$(Win2016UserName) $(Win2016Password)
net use $(Win10Folder) /user:$(Win10UserName) $(Win10Password)
Move-Item -Path $Source -Destination $Dest
net use $(Win2016Folder) /d
net use $(Win10Folder) /d

8.Install application
$List = Get-ChildItem $(SetupFolder) -Filter NameOfSetUp*.exe
$ExePath = $List[0].FullName
Start-Process "cmd" "/c $ExePath  ./install.log" -Wait

9.Invoke Database query
Invoke-Sqlcmd -ServerInstance $(SQLDBServer) -U $(SQLDBUser) -P $(SQLDBPassword) -Database "DatabaseName" -Query "
USE [DBName]
UPDATE [dbo].[User] SET [UserPassword] = 'Password',[IsShowStartUp] = 0 WHERE UserName='Admin';"

10. Invoke powershell command
$pass = ConvertTo-SecureString -AsPlainText $(Win10Password) -Force
$cred = New-Object System.Management.Automation.PSCredential -ArgumentList $(Win10UserName),$pass
Set-Item -Path WSMan:\localhost\Client\TrustedHosts -Value '192.168.*.*' -Force;
Invoke-Command -ComputerName 192.168.*.* -Credential $cred -ScriptBlock {
$path1 = "C:\"
Get-ChildItem -Path $path1 -Recurse| Foreach-object {Remove-item -Recurse -path $_.FullName }
}
net use * /d /y

11.Run remote files using PsExec
Start-Process -Wait -FilePath C:\PsExec.exe -ArgumentList "-accepteula -u Username -p Password -s -i 3 \\192.168.xx.xx C:\.exe"

12.Remotely connect desktop
$Server = \"" + IP + "\" ;" +
"$User = \"" + UserName + "\";" +
"$Password = \"" + Password + "\";" +
"cmdkey /generic:TERMSRV /$Server /user:$User /pass:$Password;" +
"mstsc /v:$Server

13.Download files
while(1)
{
$time=Get-Date -format "HH-mm";

$name = $time+"debug.log";
$path="C:\logs\"+$name;
Write-Host $path
Invoke-WebRequest -Uri "http://URL" -OutFile $path
start-sleep -seconds 300
}

14.Get Print Configuration

Get-PrintConfiguration -PrinterName "VirtualPrinter_Q1507420200515 - HP Universal Printer" | Format-List