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)

https://www.microsoft.com/en-us/download/details.aspx?id=11533

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

https://technet.microsoft.com/en-us/library/ee692796.aspx

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:

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:

After this specific action above command should be succesfully as in my case:

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

http://exchangeserverpro.com/cannot-activate-database-copy-content-index-catalog-files-in-failed-state/

http://www.exchangeitpro.com/2013/07/11/error-microsoft-exchange-search-service-may-not-be-running-on-server-specific-rpc-error-message-error-0x6d9/

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

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

Download

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