Change Debian 10 VM Resolution on Hyper-V
from root or sudo:
nano /etc/default/grub
find the row with GRUB_CMDLINE_LINUX_DEFAULT
and complete with:
“quiet video=hyperv_fb:1920×1080”
or the resolution you want; save and exit
update-grub
reboot the vm
Windows Server
Auto execution of an Excel file
MyFile.bat:
runas /user:mydomain\myuser “C:\Program Files\Microsoft Office\Office14\excel.exe \\myserver\path\to\file\myfile.xlsx”
If the excel fila has an auto_load macro it’s possibile to execute an update and close the file saving changes automatically.
Windows Search not working on Windows 2008R2 server
Control Panel -> Indexing Options
or
Start -> indicizzazione
Start -> indexing
Advanced -> new index
Privileges on MySQL
mysql> GRANT ALL PRIVILEGES ON *.* TO 'username'@'%' identified by 'password';
CREATE USER 'name'@'localhost' IDENTIFIED BY 'password';
GRANT USAGE ON *.* TO 'name'@'localhost';
GRANT all privileges ON `dbname`.* TO 'name'@'localhost' WITH GRANT OPTION;
FLUSH PRIVILEGES;
Uptime Windows Server
from CMD:
net statistics server
from task manager:
Days – Hours – Minutes – Seconds
How to remove double quotes from variables in batch file with cmd
set widget="my little string" set widget set widget=%widget:"=% set widget
Output:
widget="my little string" widget=my little string
How to Configure NTP Server in Windows Server 2016
This article shows how to configure Windows Time Service on Windows Server 2016 so that it acts as an NTP server for domain client computers.
Configure Windows Time Service
1. Type the following commands on PowerShell:
w32tm /config /manualpeerlist:pool.ntp.org /syncfromflags:MANUAL
Stop-Service w32time
Start-Service w32time
Now the Windows Server 2016 is an NTP client of pool.ntp.org and its time/clock is synced with the NTP pool servers (The server is at the same time the NTP server for other domain client systems).
If your Windows Server 2016 machine is a VM inside Hyper-V, you have to disable time sync. Go to VM settings-> Management-> Integration Services and uncheck Time Synchronization. Otherwise, Windows Server 2016 time/clock will be synced with the Host time/clock.
2. Go to the client machines and run the following command on PowerShell to force them to sync their time/clock with the domain controller on the Windows Server 2016.
w32tm /resync
You can check the time synchronization status using the following command.
w32tm /query /status
Disable MapsBroker service on a Windows Server
This Powershell script executed with the correct rights:
Invoke-Command -ComputerName-ScriptBlock{Get-Service -Name MapsBroker | Set-Service -StartupType Disabled}
Get AD Users with creation Date
Get-ADUser -Filter * -SearchBase "DC=domain,DC=local" -Properties whenCreated | export-csv -Path c:\path\to\file.csv