Check running Services

PS C:>  net start 
...
OracleOraDB19Home1TNSListener
...
Windows Search
Windows Update
..

Manage services

--- Start stop
C:>  net start/stop "SERVICE-NAME" 
--- Delete a Service 
C:> SC DELETE "SERVICE-NAME"

User management

Show current user

PS C:> whoami
DomainmyUser

List user group members

PS C:> NET LOCALGROUP ORA_DBA
Alias name     ORA_DBA
Comment        Oracle DBA Group
Members
------------------------------------- 
DOMAINdbadmin
DOMAINUser2
NT AUTHORITYSYSTEM

Add new user

Syntax: net user username password /ADD /DOMAIN

C:> net user Oracle * /add /MyDomain
Type a password for the user: *****
Retype the password to confirm: ****
The command completed successfully.
-- Change password

C:> net user Oracle *
Type a password for the user:
Retype the password to confirm:

list all processes in Windows

Choose from following options 

C:> tasklist
--- Via WMI ( more details)
C:> wmic process
--- PowerShell
PS C:>  get-process 

tail -f in PowerShell

PS C:>  Get-Content -Path "C:APPORACLEdiagrdbmsPATHtracealert_MYDB.log" -Wait

Storage 

Check system Block size

C:> fsutil fsinfo ntfsinfo D:

NTFS Volume Serial Number :                           
Version :                                                                             
Bytes Per Sector  :               512
Bytes Per Physical Sector :       <Not Supported> 
Bytes Per Cluster :               4096      -------- 4K /64K etc..
Bytes Per FileRecord Segment    : 1024
Clusters Per FileRecord Segment:  

Check (shared) drive space usage

This is specially useful to check shared drive overall usage as you can’t see the info through the explorer

C:> fsutil volume diskfree D:
Total # of free bytes        : 37252968448
Total # of bytes             : 858856091648
Total # of avail free bytes  : 37252968448   --> 34.69GB free

There is simple script check_freespace.bat you can use to get the result in GB units

C:> check_freespace.bat \RemoteServerS01$
Total # of free bytes        : 2846.80 GB
Total # of bytes             : 3311.81 GB
Total # of avail free bytes  : 2846.80 GB

Map/unmap network drives

 Workstations/ servers might have network drives attached to them. Here are ways to add and delete the mapping

1. Map shared drive to Z:
C:> net use Z: \StorageServerDrive$ /user:MyUser Mypassword /persistent:Yes
2. Delete mapping 
C:> net use Z: /delete

 -- Delete all mappings 
C:> net use * /delete

Miscellaneous  

Grep in Windows

File content or command output filtering . with below  metacharacters : 
‘.’ any character  
‘*’ zero or more occurrences of previous character or class

C:> FINDSTR /i /r /c:"^ORA-600*" alert_MyDB.log 
-- Using PowerShell
PS C:> Select-String "^ORA-1146"
--- ls | grep equivalent
C:>  DIR /B | findstr /i /r /c:"alert.*log"
alert_MyDB.log

File naming & variable Substrings

Get a substring of a string of a variable from position X in string with Y characters length.%Variable:~X,Y%:

C:> SET VAR=FOOBARFOOBA
C:> ECHO %VAR:~3,8%
     BARFOOBA

Example: db_bkp_YYYYMMDD_HHMMSS.log

ECHO db_bkp_%date:~-4,4%%date:~-10,2%%date:~-7,2%_%time:~0,2%%time:~3,2%%time:~6,2%.log
C:>  db_bkp_20220514_134656.log    

• %date:~-4,4% : the last 4 characters of the current locale date which is obviously the year, YYYY

• %date:~-10,2% : the tenth and ninth characters from right side of the current locale date, MM

• %date:~-7,2% : the seventh and sixth characters from right side of the current locale date , the day,DD

• %time:~0,2% : the first 2 characters of the current locale time which is the hour,HH

• %time:~3,2% : the fourth and fifth character of the current locale time which is the minute ,Min

• %time:~6,2% : the seventh and eighth caractere of the current local time which is the seconds,SS

taskkill /F /PID 11764
taskkill /IM "SocketHeciServer.exe" /F

--- Get
tzutil /g
Eastern Standard Time
--- list 
tzutil /l
--- Set
tzutil /s "Mountain Standard Time"

C:> cacls D:oracle
D:oracle BUILTINAdministrators:(OI)(CI)F
          NT AUTHORITYSYSTEM:(OI)(CI)F
          ServerORA_OraDB19Home1_SVCACCTS:(OI)(CI)F
          DomainUser1:(OxI)(CI)F

C:> icacls .private.key /inheritance:r /grant:r "%username%":"(R)"

C:> query session /server:RemoteServer
SESSIONNAME       USERNAME                 ID  STATE   TYPE        DEVICE
services                                    0  Disc
console                                     1  Conn
rdp-tcp#1         RemoteUser                2  Active   rdpwd
rdp-tcp                                 65536  Listen

C:> reset session 2 /server:RemoteServer

C:> RunAs.exe /user:Administrator "rundll32 sysdm.cpl,EditEnvironmentVariables"
Enter the password for Administrator: ***

--- Option 2 direct access as admin:
C:> SystemPropertiesAdvanced
Note: Once the window is displayed –> click environment variables

C:> PathEd.exe add "C:Program FilesMyPortableApp"
 
--- Remove a directory from your Machine path

C:> PathEd.exe remove "C:Program FilesRepoZ"

Script : archive_cleanup.ps1
1. Define the trigger, user, and action
$Trigger= New-ScheduledTaskTrigger -At 10:00pm –Daily 
$User= "NT AUTHORITYSYSTEM"           
$Action= New-ScheduledTaskAction -Execute "PowerShell.exe" -Argument "-ExecutionPolicy Bypass -File J:archive_cleanup.ps1" 

2. Create and specify the name of the task
Register-ScheduledTask -TaskName "CleanupDBarchives" -Trigger $Trigger -User $User -Action $Action -RunLevel Highest –Force