Tips - MAC addresses and producer correlation, subnet calculator and

Due to MAC address that is used from an ethernet device you could have opportunity to determine some vendor information based on that.

For that purpose I am indicating a web site (there are plenty similar on the web) that can be used for this search purpose.

https://www.adminsub.net/mac-address-finder

The same website has a simple form to calculate, from IP and subnet, all other useful network information:

http://www.adminsub.net/ipv4-subnet-calculator

If finally you need to understand which is the service associated to a port number you can review this link too:

https://www.adminsub.net/tcp-udp-port-finder

Excel - Find Vertical

There is an interesting function in excel that permit you to search a cell value (A2) on a differente Excel sheet. ('PDQ original Data'!1:1048576)

This function will search, this value A2 on first column on different shee ('PDQ original Data'!1:1048576).

If a value will be found function, function result will be correspondent cell  column field value (13).

Last function value should be False as in following examples:

=CERCA.VERT(A2;'PDQ original Data'!1:1048576;13;FALSO)

= VLOOKUP(A2;'PDQ original Data'!1:1048576;13;FALSE)

More information can be found at following Microsoft Article

https://support.microsoft.com/it-it/kb/181213

https://support.microsoft.com/en-en/kb/181213

Powershell - CRC - Md5 Calculation

If you need to calculate CRC you can use this Microsoft tool  (FCIV)


Here is a syntax example but you could obviously use a different syntax




Get-ChildItem C:\Scripts, C:\Test, "C:\Documents and Settings\Kenmyer\Desktop" -filter "*.ps1"

[update 2016.04.09]

Here it is a free tool about MD5 Calculation:


http://winmd5.com/

Exchange 201x - How to monitor db status before moving active DB through replica


Here is syntax to verify DB copy status:


Get-MailboxDatabaseCopyStatus | fl name, contentindexstate
Articoli di riferimento:




exchange-2010-cannot-activate-database

To resolve the issue update the content index on the server on which it has failed.


Update-MailboxDatabaseCopy "MB-HO-03HO-EX2010-MB1" -CatalogOnly


If precedent solution does not resolve you need to start/restart specific Exchange services:



Windows 10 - Updating GPO administrative templates

If you want to manage Windows 10 systems through Group Policy, you need to download .admx using this article:


How to create and manage the Central Store for Group Policy Administrative Templates in Windows
https://support.microsoft.com/en-us/kb/3087759

Precedent update could create and error and this article would help to solve:

KB3077013 “‘Microsoft.Policies.Sensors.WindowsLocationProvider’ is already defined” error when you edit a policy in Windows

https://support.microsoft.com/en-us/kb/3077013

If you like you can review this Italian article too.

http://www.devadmin.it/2016/09/19/windows-10-aggiornamento-group-policy-administrative-templates/?wt.mc_id=AID520875_EML_4791255

Manual - Data Science with Microsoft SQL Server 2016 free Microsoft e-Book

Data Science with Microsoft SQL Server 2016
Published: October 2016|90 pages

Data Science with Microsoft SQL Server 2016

Buck Woody, Danielle Dean, Debraj GuhaThakurta, Gagan Bansal, Matt Conners, Wee-Hyong Tok
The world around us—every business and nearly every industry—is being transformed by technology. SQL Server 2016 was built for this new world and to help businesses get ahead of today’s disruptions. With this free ebook, learn to install, configure, and use Microsoft’s SQL Server R Services in data science projects. R is one of the most popular, powerful data analytics languages and environments in use by data scientists|Less


Server - Port to be opened about Domain controller and relative joining

During these days I faced necessity to eviscerate firewall rules for specifics projects.

At the same time if you need to find which ports are used from pcs/server to well communicate to Domain controller here they are verbosely list that I found thanks to colleague's help.

Obviously this rules need to be enabled in bidirectional way.

Domain Controller 123/UDP W32Time 
Domain Controller 135 TCP/UDP RPC Endpoint Mapper 
Domain Controller 136 TCP/UDP Netbios
Domain Controller 137 TCP/UDP Netbios Name Resolution
Domain Controller 138 TCP/UDP Netbios Datagram Service 
Domain Controller 139 TCP/UDP Netbios Session Service 
Domain Controller 3268/TCP LDAP GC
Domain Controller 3269/TCP LDAP GC SSL
Domain Controller 389/TCP/UDP LDAP
Domain Controller 445 TCP/UDP SMB
Domain Controller 464/TCP/UDP Kerberos password change
Domain Controller 49152-65535/TCP/UDP RPC for LSA, SAM, Netlogon, DFSR RPC, FRS RPC
Domain Controller 53/TCP/UDP DNS
DNS server 53/TCP/UDP DNS
Domain Controller 636/TCP LDAP SSL
Domain Controller 88/TCP/UDP Kerberos
Domain Controller icmp reply ping reply from DC
Domain Controller icmp request ping to DC
Domain Controller TCP 1688 MS KMS Licensing
Domain Controller TCP 5722 MS Knowledge base - file replication - RPC, DFSR, SYSVOL
Domain Controller TCP 593 Rpc over HTTPS 
DHCP server UDP 67 - 68 DHCP relay