Two quick MySQL tips

Posted by on Oct 4, 2010 in CRM 4.0 |

MySQL: Running a SQL script from the command line:

MySQL: Stopping a long query:

Get the id from the first column then run:

Read More

Get Mailbox Sizes in Exchange 2007 using Powershell

Posted by on Oct 4, 2010 in CRM 4.0 |

Paste the following into the powershell command prompt:

a text file located at c:\mailboxes.txt should now contain the mailbox size information with item counts for each user.

Read More

Exchange 2003 Tips

Posted by on Jul 13, 2010 in CRM 4.0 |

Prequisite for installation of Exchange Server:

IIS, SMTP, WWW service ,NNTP, W3SVC
NET Framework
ASP.NET
Then run Forestprep.exe
The run domainprep.exe

Standard port numbers for SMTP, POP3, IMAP4, RPC, LDAP and Global Catalog:

25 SMTP
110 POP3
143 IMAP4
135 RPC
389 LDAP
636 LDAP (SSL)
3268 Global Catalog
465 SMTP/SSL
993 IMAP4/SSL
563 IMAP4/SSL
53 DNS
80 HTTP
88 Kerberos
102 X.400
110 POP3
119 NNTP
137 – NetBIOS Session Service
139 – NetBIOS Name Service
379 LDAP (SRS)
443 HTTP (SSL)
445 – NetBIOS over TCP
563 NNTP (SSL)
691 LSA
993 IMAP4 (SSL)
994 IRC (SSL)
995 POP3 (SSL)
1503 T.120
1720 H.323
1731 Audio conferencing
1863 – MSN IM
3268 GC
3269 GC (SSL)
6001 Rpc/HTTP Exchange Store
6002 HTTP Exchange Directory Referral service
6004 Rpc/HTTP NSPI Exchange Directory Proxy service/Global Catalog

Read More
%d bloggers like this: