Create Desktop Shortcuts via GPO
- User Conguration
- Preferences
- Windows Settings
- Shortcuts
- New -> Shortcut
- update
- name of the link ( myfolder\mylink )
- file system object
- Desktop
- \\mypath\mylink
Server
How to setup a network interface on Debian 10
nano /etc/network/interfaces
allow-hotplug ens192
iface ens192 inet static
address 192.168.xx.yy
netmask 255.255.255.0
gateway 192.168.xx.yyy
dns-nameservers 192.168.xx.z 192.168.xx.w 192.168.xx.t
dns-search mydomain.mytld
Symbolic Link on Windows
c:> mklink /d c:\some\directory \\some_server\some_share
This will create a folder named c:\some\directory which will show the content of the share \\some_server\some_share.
This will work also with a remote disk with i.e. \\some_server\C$.
How to connect to Sql Server 2017 from php on debian 10
apt-get update
apt-get install unixodbc unixodbc-dev php-odbc php-cli
wget https://packages.microsoft.com/debian/10/prod/pool/main/m/msodbcsql17/msodbcsql17_17.4.1.1-1_amd64.deb
odbcinst -i -d -f /opt/microsoft/msodbcsql17/etc/odbcinst.ini
nano /etc/odbc.ini
[MySQLServerDB]
Description = Database SqlServerDB
Driver = ODBC Driver 17 for SQL Server
Server = server[,port]
Hyper-V Virtual Switches
Types of Virtual Switches
External – This type of switch is bound to the physical network cards located in the host. As you would imagine, they provide VMs located on these switches with access to the physical network the Hyper-V host is connected to. The External switch can also share management traffic as well as VM traffic on the same switch and this is one of the options that can be set when creating the external switch.
Internal – This switch is not bound to a physical network card so only allows traffic between VMs and the host itself. However, a new addition to the Internal switch functionality in 2016 is the addition of the NAT forwarding internal switch which does allow external connectivity via NAT from the Hyper-V host.
Private – This type of switch is only used for virtual machines to communicate with each other. This type of switch might be useful for certain specific types of traffic such as cluster network if only using one host as it can’t be utilized between hosts.
How to setup a trigger on first value and on value change with zabbix
Trigger Expression:
{MyTemplate:MyItem.count(#2)}<2 or {MyTemplate:MyItem.diff()=1}
Calculate the Prints Monthly Average on Zabbix
Assuming that “pagecount” is the global counter item of our printer we can create a calculated item with the following expression:
max(pagecount,2592000)-min(pagecount,2592000)
where 2592000 is the number of seconds (30 days, i.e 60sec x 60min x 24hours x 30days) of our interval to get the minimum and the maximum number detected.
Install RSAT – Remote Server Administration Tool
https://www.google.com/search?client=firefox-b-d&q=install+rsat+windows+10+1909
and
https://gallery.technet.microsoft.com/Install-RSAT-for-Windows-75f5f92f
Download the ps1 Powershell file and execute it.
How to use PHPSpreadSheet with composer on Debian 10
from root:
apt-get install composer php-cli
from user:
composer require phpoffice/phpspreadsheet
Into myfile.php (example):
require_once('vendor/autoload.php');
use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Writer\Xlsx;
// Creates New Spreadsheet
$spreadsheet = new Spreadsheet();
// Retrieve the current active worksheet
$sheet = $spreadsheet->getActiveSheet();
// Set the value of cell A1
$sheet->setCellValue('A1', 'Paolo');
// Sets the value of cell B1
$sheet->setCellValue('B1', 'Pizzolongo');
// Write an .xlsx file
$writer = new Xlsx($spreadsheet);
// Save .xlsx file to the current directory
$writer->save('paolo.xlsx');