How to extract the data from SQL Server to Excel using vba

This is a response from ASH at stackoverflow:

There are so many ways to do this!!

How can I see real time smtp logs on Exchange 2010

SMTP logging is diabled by default. You can read about it and how to enable it at these links.

Understanding Protocol Logging: http://technet.microsoft.com/en-us/library/aa997624.aspx

Configuring Protocol Logging: http://technet.microsoft.com/en-us/library/bb124531.aspx

 

Set-ReceiveConnector "My Receive Connector Name" -ProtocolLoggingLevel Verbose

Set-SendConnector "My Send Connector Name" -ProtocolLoggingLevel Verbose

And could see the logs on

C:\Program Files\Microsoft\Exchange Server\V14\TransportRoles\Logs\ProtocolLog

Removing the device partnership in Exchange 2010 using Powershell

Apparently Exchange 2010 SP1 brought a 10 mobile device per mailbox limit. This is a problem if you are letting a bunch of folks hook their iPhones into a common mailbox to share the calendar. The mailbox gets the message:

You have 10 phone partnerships out of the maximum allowed 10 partnerships. After you reach the maximum, you can't create additional partnerships until you delete existing ones from your account. To do so, sign in to Outlook Web App, click Options > Phone > Mobile Phones, and delete any unused partnerships.

Fortunately, the fix is pretty simple (excellent full write-up here), if you just want to increase the number of devices for your default policy.

1. Start an Exchange powershell instance
2. Run this to set max total devices (change 20 to whatever you want max to be)
   Get-ThrottlingPolicy | Set-ThrottlingPolicy –EASMaxDevices 20
3. Then run this to set the maximum number of simultaneous devices (again, you can change the 20)
   Get-ThrottlingPolicy | Set-ThrottlingPolicy –EASMaxConcurrency 20

Alternativelly, you can remove all partnertships for a mailbox with the following command:

foreach ( $identity in Get-ActiveSyncDeviceStatistics -Mailbox username | Select-Object -Property "Identity" ) {
Remove-ActiveSyncDevice -Identity $identity.identity -Confirm:$true
}

Also you can remove all device partnerships where synchronization date (LastSuccessSync) is more than 30 days ago:

$DevicesToRemove = Get-ActiveSyncDevice -Result Unlimited | Get-ActiveSyncDeviceStatistics | Where {$_.LastSuccessSync -le (Get-Date).AddDays(“-30”)}

$DevicesToRemove | Remove-ActiveSyncDevice

Selecting the Best HPE Smart Array Controller for Your Server

This is a good article by Brynden Hutmacher, Deployment Engineer at dasher.com https://medium.com/@ITsolutions/selecting-the-best-hpe-smart-array-controller-for-your-server-da10b7424c8c

Remove a disconnected Mailbox from Exchange 2010

This is a quick how to which will enable you to remove any disconnected mailboxes from exchange 2010, since the purge mailbox feature is no longer available. (Source: spiceworks).

Query Active Directory from Excel

This is and old post from Remko Weijnen with some comde to get information from Active Directory.

I had to lookup some users in Active Directory today which I received by mail. Offcourse I got full users name while I needed either samAccountName or full adsPath. Usually I write a small VBS script to do the lookup and paste this in Excel for further processing. But today I decided that an Excel function to do the lookup would be nice. So I wrote it.

The function is called GetAdsProp and allows you to search on a specific AD field in the whole AD tree and return the value of another field.

Open Live Writer

This version is able to connect with Google’s blogger.

[OpenLiveWriterSetup.zip](https://github.com/OpenLiveWriter/OpenLiveWriter/files/4027251/OpenLiveWriterSetup.zip)

How to remove the recovery partition

These are the steps to remove the recovery partition in windows, thanks to https://superuser.com/questions/1073883/cant-remove-recovery-partition

1. Go to start and type cmd (this is called command prompt)
2. In command prompt type diskpart and hit enter
3. Type list disk and hit enter
4. From the list of disks find the one you want to work with (I believe in your case there is only one so it should be easy)
5. Once you find the drive you are looking for type select disk 'numberofdrive'
6. Now type list partition and find the partition you want to work with
7. Once you have identified the partition in question type select partition 'numberofpartition'
8. Now type delete partition (WARNING ONCE YOU DO THIS THERE IS NO GOING BACK) and hit enter , if it says "cannot delete a protected partition..." use delete partition override (Note you will also have to repeat these steps with the partition in front of the recovery partition if you plan on extending the system volume)
9. Once it is finish type exit and hit enter

Remove vmkdump foder in VMware esxi 6.x

Run the command esxcli system coredump file list until get a true value for both parameters Active and Configured.

[root@esx:~] esxcli system coredump file list
Path                                                                                                     Active  Configured        Size
-------------------------------------------------------------------------------------------------------  ------  ----------  ----------
/vmfs/volumes/xxxxxxxx-xxxxxxxx-xxxx-xxxxxxxxxxxx/vmkdump/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx.dumpfile    true        true  3740270592

Then run the following two commands to remove de the dump file:

[root@esx:~] esxcli system coredump file set -u
[root@esx:~] esxcli system coredump file remove -f /vmfs/volumes/xxxxxxxx-xxxxxxxx-xxxx-xxxxxxxxxxxx/vmkdump/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx.dumpfile

Now you can remove the vmkdump folder.

Set hardware time on VMware esxi 6.x from console

If you need to change the system time for a VMware esxi 6.x server fron CLI you must use the following command:

esxcli system time set

Update VMware ESXi v5.5

Since the updates for ESXi v5.5 are no more accesible at VMware Updates page, here you’ll find a procedure for install then from esxi console.

Change the nic order on JovianDSS

In JovianDSS it is possible to change the NIC order to suite your needs.

Change vmnic order on vSphere 6.x

This is an article by Marco van Baggun at www.vmbaggum.nl that explains how to change vmnic order on vSphere 6.x

Here you can check how to do it for previous versions.

Enable traffic logs in Fortigate firewalls

Local traffic logs are disabled by default in fortigate firewalls. This logs can be enabled from console.

Check the following:
config  log  memory filter
get                               <<—lists all options

Make sure local-traffic logs are enabled. If not then:
set local-traffic enable
end

Enable "Log Allowed Traffic" and select "All Sessions" on the firewall policy.
Make sure you display logs from the correct location(GUI):
"Log & Report >> Log Settings >> GUI Preferences >> Memory/FortiCloud"

Install latest Java 8 on raspbian

This is a post by BartB at brodzinski.net that explains how to install latest Java 8 on raspbian.

Install ppp package in Raspberry Pi

This is an extract from StackExchange that shows how to install ppp package in Raspberry Pi.

This package is missing dependencies. You need to make sure you update your packages and preferably use a package manager that handles dependencies better. Try this:

pi@raspberrypi:~$ sudo su -
root@raspberrypi:~# apt-get update && apt-get install aptitude
root@raspberrypi:~# aptitude upgrade && dpkg --configure -a && aptitude install ppp

VeraCrypt remembers my password using W10

It appears Windows 10 doesn't do a shutdown in the same sense as Windows 7 did. It does a kind of hybrid shutdown/hybernation to allow super-quick startup. As such, the user isn't really logged off, so VeraCrypt doesn't get alerted to the user's session ending, so doesn't dismount the drive.

I've resolved this issue by adding a task in Task Scheduler (taskschd.msc).

The task must be an umount command ("C:\Program Files\VeraCrypt\VeraCrypt.exe" /d /f /quit ).
And the trigger a registry event:
Registry: System
Source: User32
Event id: 1074

Using this configuration your veracrypt volumes are unmounted even with Fast Startup enabled.

PD: I've tried this solution only with file containers. I don't know if it works with system drives or partitions.

Sonicwall - Export configuration settings using Enterprise Command Line Interface (E-CLI)

Sonicwall TZ firewalls configuration can be exported from command line to a ftp server. Here you can find the Sonicwall related documentation regarding this subject.

examples:

export current-config cli ftp ftp://username:password@hostname/filename.txt

export current-config exp ftp ftp://username:password@hostname/filename.exp

This is the full Sonicwall article:

How to change the default PST location/path registry in Outlook?

Here you can find a Post from www.extendedoffice.com that explains how to change the default PST and OST files location.

How to Set Up a Logon Script Only for Terminal Server Users

You may want to have a logon script that only runs for a user when he or she connects to a Terminal Server through the Terminal Server client or by the console. Extracted from Microsoft Support, this is the original article.