tag:blogger.com,1999:blog-63163795115704512572024-03-14T11:18:03.377+01:00kakaladaskklohttp://www.blogger.com/profile/09441744195306296820noreply@blogger.comBlogger123125tag:blogger.com,1999:blog-6316379511570451257.post-42041783419527988732023-04-27T12:11:00.001+02:002023-04-27T12:11:34.659+02:00Can't map Azure drive storage as netword drive<p>To map an Azure drive from a windows computer you must ensure that the value of registry key is 3:</p> <p>HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Lsa\lmcompatibilitylevel</p> <p>You can use this command to change the key from command line</p> <p><font color="#0000ff" face="Courier New">reg add HKLM\SYSTEM\CurrentControlSet\Control\Lsa /v lmcompatibilitylevel /t REG_DWORD /d 0x3</font></p>kklohttp://www.blogger.com/profile/09441744195306296820noreply@blogger.com0tag:blogger.com,1999:blog-6316379511570451257.post-52346410792267331692022-03-10T17:00:00.002+01:002023-06-27T08:44:56.297+02:00Check domain controllers replication<p><a href="https://www.manageengine.com/products/active-directory-audit/kb/how-to/how-to-check-if-domain-controllers-are-in-sync-with-each-other.html">This</a> is well explained article from <a href="https://www.manageengine.com/">ManageEngine</a></p> <a name='more'></a> <h5>Step 1 - Check the replication health</h5> <p>Run the following command : <br />Repadmin /replsummary</p> <p>The “/replsummary” operation quickly summarizes replication state and relative health of a forest.</p> <p><img alt="how-to-check-if-domain-controllers-are-in-sync-with-each-other" src="https://www.manageengine.com/products/active-directory-audit/kb/images/how-to-check-if-domain-controllers-are-in-sync-with-each-other.png" /></p> <h5>Step 2 - Check the inbound replication requests that are queued.</h5> <p>Repadmin /Queue</p> <p>This command lists elements that are remaining in the replication queue. It displays inbound replication requests that the Domain Controller needs to issue in order to become consistent with its source replication partners.</p> <p><img alt="how-to-check-if-domain-controllers-are-in-sync-with-each-other-2" src="https://www.manageengine.com/products/active-directory-audit/kb/images/how-to-check-if-domain-controllers-are-in-sync-with-each-other-2.png" /></p> <h5>Step 3 - Check the replication status</h5> <p>Repadmin /Showrepl</p> <p>This command displays the replication status when the specified domain controller last attempted to implement an inbound replication of Active Directory partitions. It helps in figuring out the replication topology and replication failure.</p> <p><img alt="how-to-check-if-domain-controllers-are-in-sync-with-each-other-3" src="https://www.manageengine.com/products/active-directory-audit/kb/images/how-to-check-if-domain-controllers-are-in-sync-with-each-other-3.png" /></p> <h5>Step 4 - Synchronize replication between replication partners</h5> <p>Repadmin /syncall</p> <p>It ensures synchronization between replication partners</p> <h5>Step 5 - Force the KCC to recalculate the topology</h5> <p>Repadmin /KCC</p> <p>This command forces the KCC (Knowledge Consistency Checker) on targeted domain controller(s) to immediately recalculate its inbound replication topology. It checks and creates the connections between the Domain Controllers. By default KCC runs in the background every 15 minutes to check if a new connection has been established between DCs.</p> <p><img alt="how-to-check-if-domain-controllers-are-in-sync-with-each-other-4" src="https://www.manageengine.com/products/active-directory-audit/kb/images/how-to-check-if-domain-controllers-are-in-sync-with-each-other-4.png" /></p> <h5>Step 6 - Force replication</h5> <p>Repadmin /replicate</p> <p>This command forces the replication of the specified directory partition to the destination domain controller from the source DC.</p> <h6>FAQs:</h6> <ul> <li> <h6>How do I check my AD replication status?</h6> <p>Running the <em>repadmin /showrepl</em> can help you view the replication status. <br />If you would like an overall replication health summary, the command repadmin /replsummary should help.</p> </li> <li> <h6>How do I fix Active Directory replication issues?</h6> </li> </ul> <blockquote> <p>To diagnose replication errors, users can run the AD status replication tool that is available on DCs or read the replication status by running <em>repadmin /showrepl</em>. <br />To view only the replication errors, use the command: <em>repadmin /showrepl /errorsonly</em></p> </blockquote> <ul> <li> <h6>How do you force AD replication?</h6> </li> </ul> <blockquote> <p>To force replication between two domain controllers, run the following command on the DC you wish to update: <br /><em>repadmin /syncall <DC-name> /AeD</em> <br />In case you want to make changes on a DC and push replication to other DCs, the following command should do the trick: <br /><em>repadmin /syncall <DC-name> /APeD</em></p> </blockquote> <ul> <li> <h6>How often does AD replication occur?</h6> </li> </ul> <blockquote> <p><u>Intra-site replication</u>: With the exception of critical directory updates that are replicated immediately, the source DC updates changes to its closest replication partner every 15 seconds.</p> <p><u>Inter-site replication</u>: By default, the replication interval is 180 minutes and can be adjusted to be as low as 15 minutes.</p> </blockquote> <ul> <li> <h6>What is the default replication time for Active Directory?</h6> </li> </ul> <blockquote> <p><u>Intra-site replication</u>: With the exception of critical directory updates that are replicated immediately, the source DC updates changes to its closest replication partner every 15 seconds.</p> <p><u>Inter-site replication</u>: By default, the replication interval is 180 minutes and can be adjusted to be as low as 15 minutes.</p> <p>To change the default replication time, users can go into the Active Directory Sites and Services snap-in → Inter-site transport container → IP container → Site link you want to modify the interval on → Enter your desired value besides "Replicate every" → Save changes.</p></blockquote>kklohttp://www.blogger.com/profile/09441744195306296820noreply@blogger.com0tag:blogger.com,1999:blog-6316379511570451257.post-62907953217682794702022-03-01T11:53:00.001+01:002022-03-01T11:54:13.528+01:00Add-WindowsCapability failed. Error code = 0x800f0954 – RSAT Fix<p><a href="https://thesysadminchannel.com/solved-add-windowscapability-failed-error-code-0x800f0954-rsat-fix/">This</a> is a post by <a href="https://thesysadminchannel.com/author/pcontreras/">Paul</a> at <a href="https://thesysadminchannel.com/">the sysadmin channel</a></p> <p>If you have tried to <a href="https://thesysadminchannel.com/install-rsat-for-windows-10-version-1809-1903-and-later/">install Remote Server Administration tools for Windows 10 version 1809, 1903 or later</a> you might have come across: <strong>Add-WindowsCapability failed. Error code = 0x800f0954</strong>. If you haven’t, that’s great! If you have, you’re in luck because today we’re going to go over the steps needed to fix the issue.</p> <p><img alt="Add-WindowsCapability -Name RSAT Error" src="https://thesysadminchannel.com/wp-content/uploads/2020/08/Add-WindowsCapability-Name-RSAT-Error.png" width="644" height="269" /></p> <a name='more'></a> <p>By default, the WindowsCapability logs are stored in <strong>C:\Windows\Logs\DISM\dism.log</strong> so we’ll check there to see what’s happening behind the scenes.</p> <p><code>DISM   DISM Package Manager: PID=1280 TID=6320  Error in operation: (null) (CBS HRESULT=0x800f0954) - CCbsConUIHandler::Error</code></p> <p><code>DISM   DISM Package Manager: PID=1280 TID=5772 Failed finalizing changes. - CDISMPackageManager::Internal_Finalize(hr:0x800f0954)</code></p> <p><code>DISM   DISM Package Manager: PID=1280 TID=5772 Failed processing package changes with session options - CDISMPackageManager::ProcessChangesWithOptions(hr:0x800f0954)</code></p> <p><code>DISM   API: PID=11232 TID=1244 Failed to install capability. - CAddCapabilityCommandObject::InternalExecute(hr:0x800f0954)</code></p> <p><code>DISM   API: PID=11232 TID=1244 InternalExecute failed - CBaseCommandObject::Execute(hr:0x800f0954)</code></p> <p><code>DISM   API: PID=11232 TID=8352 CAddCapabilityCommandObject internal execution failed - DismAddCapabilityInternal(hr:0x800f0954)</code></p> <h4>Fix: Add-WindowsCapability failed. RSAT Error code = 0x800f0954</h4> <p>The steps to fix this are pretty simple and should only take a couple of minutes.</p> <ul> <li>On the problem child machine open <strong>gpedit.msc</strong></li> <li>Go to <strong>Computer Configuration</strong> -> <strong>Administrative Templates</strong> -> <strong>System</strong></li> <li>Open <strong>Specify settings for optional component installation and component repair</strong></li> </ul> <p><a href="https://thesysadminchannel.com/wp-content/uploads/2020/08/Gpedit-settings-for-windows-capability-fix.png"><img alt="Gpedit settings for windows capability fix" src="https://thesysadminchannel.com/wp-content/uploads/2020/08/Gpedit-settings-for-windows-capability-fix.png" width="675" height="291" /></a></p> <ul> <li>With that settings open, select <strong>Enabled</strong></li> <li>Check <strong>Download repair content and optional features directly from Windows Updates instead of Windows Server Updates Services (WSUS)</strong></li> </ul> <p><a href="https://thesysadminchannel.com/wp-content/uploads/2020/08/Specify-Settings-for-optional-component-installations.png"><img alt="Specify Settings for optional component installations" src="https://thesysadminchannel.com/wp-content/uploads/2020/08/Specify-Settings-for-optional-component-installations.png" width="686" height="636" /></a></p> <ul> <li>Go back in your Powershell Window </li> <li>Run a <strong>gpupdate /force</strong></li> <li>Rerun the <strong>Add-WindowsCapability</strong> again to install the feature</li> </ul> <p><a href="https://thesysadminchannel.com/wp-content/uploads/2020/08/Add-WindowsCapability-Name-RSAT-Succeeded.png"><img alt="Add-WindowsCapability -Name RSAT Succeeded" src="https://thesysadminchannel.com/wp-content/uploads/2020/08/Add-WindowsCapability-Name-RSAT-Succeeded.png" width="684" height="392" /></a></p> <p><a href="https://thesysadminchannel.com/wp-content/uploads/2020/08/Apps-Settings-3.png"><img alt="Apps Settings 3" src="https://thesysadminchannel.com/wp-content/uploads/2020/08/Apps-Settings-3.png" width="680" height="417" /></a></p> <p>Once you’ve installed the RSAT tools for 1809, 1903 and later you might want to consider undoing those settings because this will install unnecessary updates on your machine. You would especially want to reconsider this if you’re <a href="https://youtu.be/a2AWwhUaQuw">deploying software updates using SCCM</a>. Hopefully you’ve been able to fix the <strong>Add-WindowsCapability failed. Error code = 0x800f0954</strong> error that so many of us have been running into.</p>kklohttp://www.blogger.com/profile/09441744195306296820noreply@blogger.com0tag:blogger.com,1999:blog-6316379511570451257.post-70169790669045352022022-02-16T17:00:00.001+01:002022-02-16T17:03:39.690+01:00Setting up Static Addresses for Fortigate SSL VPN clients<p>This is a post by <a href="https://travelingpacket.com/author/cjcott01/">cjcott01</a> from  <a title="https://travelingpacket.com/2021/09/27/setting-up-static-addresses-for-fortigate-ssl-vpn-clients/" href="https://travelingpacket.com/2021/09/27/setting-up-static-addresses-for-fortigate-ssl-vpn-clients/">travelingpacket.com</a> that explians how to assign static addresses for Fortigate SSL VPN CLients</p> <p> </p> <a name='more'></a> <p>I needed to have a specific SSL VPN client to always have the same IP address. This is not overly simple as it seems it should be. I have read there are very neat ways to do it through FortiAuth, or Radius options – but Here I am just doing all Fortigate configuration.</p> <p>I am using a local account on the firewall in this example, but it would work with an AD users without issues – you would just have to map the user directly and not use groups.</p> <p>SO, in this example I have a Scan gun that needs to have a specific IP every time it connects. So an overview of the steps are:</p> <ul> <li>Setup SSL VPN (Should be already done if you are trying this). </li> <li>Have LDAP or Radius integration already setup if you are specifically using that. </li> <li>Setup Address object that you need the device to get – For this example 10.200.253.241. </li> <li>Create a user object either local, or LDAP/Radius. – In this example Bargun01. </li> <li>Create a specific portal if needed just for this user. </li> <li>Create group/portal matching in SSL Settings. </li> <li>Create firewall policy allowing that client in.</li> </ul> <p>Ok, first lets create our address object .</p> <p><a href="https://i0.wp.com/travelingpacket.com/wp-content/uploads/2021/09/bargun-1.jpg?ssl=1"><img alt="" src="https://i0.wp.com/travelingpacket.com/wp-content/uploads/2021/09/bargun-1.jpg?resize=630%2C146&ssl=1" width="630" height="146" /></a></p> <p>Next lets create our user object – We need to do a specific user object, because we only want one device to be logged in and match this policy.</p> <p><a href="https://i0.wp.com/travelingpacket.com/wp-content/uploads/2021/09/Bargun-user.jpg?ssl=1"><img alt="" src="https://i0.wp.com/travelingpacket.com/wp-content/uploads/2021/09/Bargun-user.jpg?resize=630%2C268&ssl=1" width="630" height="268" /></a></p> <p>Then lets create the portal specific for this device – which only needs access to one server. In this portal we will match the it to the individual IP object we created, and set the remote access server it needs. Notice that the source IP Pool is the specific IP we set – this is where all the real magic is.</p> <p><a href="https://i0.wp.com/travelingpacket.com/wp-content/uploads/2021/09/portal.jpg?ssl=1"><img alt="" src="https://i0.wp.com/travelingpacket.com/wp-content/uploads/2021/09/portal.jpg?resize=630%2C286&ssl=1" width="630" height="286" /></a></p> <p>Next lets match up our user to the portal.</p> <p><a href="https://i0.wp.com/travelingpacket.com/wp-content/uploads/2021/09/ssl-sett.png?ssl=1"><img alt="" src="https://i0.wp.com/travelingpacket.com/wp-content/uploads/2021/09/ssl-sett.png?resize=582%2C327&ssl=1" width="582" height="327" /></a></p> <p>One more thing to do – and that’s to setup our firewall policy! Notice that the user matches what we put in the portal. Very specific. That’s it.</p> <p><a href="https://i0.wp.com/travelingpacket.com/wp-content/uploads/2021/09/policy.jpg?ssl=1"><img alt="" src="https://i0.wp.com/travelingpacket.com/wp-content/uploads/2021/09/policy.jpg?resize=630%2C129&ssl=1" width="630" height="129" /></a></p>kklohttp://www.blogger.com/profile/09441744195306296820noreply@blogger.com0tag:blogger.com,1999:blog-6316379511570451257.post-70137474912567569122022-02-02T17:38:00.001+01:002022-02-02T17:38:07.826+01:00VMware ESXi Commandline Get CPU and Memory Information<p>This is a post by <a href="https://www.virtualizationhowto.com/author/john-lee/"><b>brandon.lee</b></a> published at <a href="https://www.virtualizationhowto.com/2019/09/vmware-esxi-commandline-get-cpu-and-memory-information/">https://www.virtualizationhowto.com/2019/09/vmware-esxi-commandline-get-cpu-and-memory-information/</a> that explains several ways to get hardware info relative to your vmware esxi host</p> <p>There are times with your virtual infrastructure running on top of <a href="https://www.virtualizationhowto.com/2019/08/vmware-vsphere-6-7-update-3-announced-new-features/">VMware vSphere</a> that you need to gather information about the physical servers you are running on. Have you ever wanted to know the details about CPU, memory, or other physical hardware? From time to time it is very handy to be able to gather some of these details from the <a href="https://www.vmware.com/products/vsphere.html">VMware ESXi</a> command line. Let’s take a look at <a href="https://www.virtualizationhowto.com/2019/08/use-powercli-to-see-esxi-host-failed-login-errors/">VMware ESXi</a> commandline get CPU and Memory Information.</p> <a name='more'></a> <p><b>Use Cases of ESXi Commandline Tools for Physical Hardware Info</b></p> <p>You might wonder, when would I ever want to query physical hardware information about an ESXi host when I can get a lot of information from the <a href="https://www.virtualizationhowto.com/2019/07/whats-new-with-vmware-vsphere-6-5-update-3-features/">vSphere Client</a>?</p> <p>Let’s think about a couple of use cases for that. What if you are remotely accessing the ESXi server and are unable to log into the web interface of the ESXi host for one reason or another and you need to know what type of CPU the host is configured with?</p> <p>What about memory information? If you have been tasked with gathering information or inventory of CPU types, memory configurations and other physical hardware present in the ESXi host, having the ability to get this information from the commandline becomes essential.</p> <p>Have you ever been in a situation where you could not remember the memory layout found in the ESXi host for memory upgrade purposes? You know you have 256 GB of memory, but you don’t know if it was configured with 8×32 GB DIMMs or 16×16 GB DIMMs.</p> <p>This type of information becomes difficult to obtain without having a way to query the physical hardware information outside of the vSphere Client.</p> <p><b>VMware ESXi Commandline Tools Get CPU and Memory Information</b></p> <p>Let’s take a look at a few commandline tools that you can take advantage of to get the hardware information like CPU and Memory statistics from your physical <a href="https://www.virtualizationhowto.com/2019/04/upgrade-to-vmware-vsphere-esxi-6-7-update-2-with-command-line/">ESXi host</a>.</p> <p><b>Get the VMware Version Quickly</b></p> <p>To get the version of VMware that is running on your ESXi host very quickly, the very “Linux” like -v works with the vmware command like so:</p> <p><a href="https://www.virtualizationhowto.com/wp-content/uploads/2019/09/Easily-get-the-version-of-VMware-vSphere-you-are-running-on-your-ESXi-host.png"><img title="clip_image001" style="margin: 0px; display: inline; background-image: none;" border="0" alt="clip_image001" src="https://drive.google.com/uc?id=1W5_NdeGC_G3S-11CbPdi2VWD2DD55SvN" width="244" height="37" /></a>Easily get the version of VMware vSphere you are running on your ESXi host</p> <p><b>Get the Manufacturer and Model of your ESXi Host</b></p> <p>Now, on to the even more exciting info you can query from the commandline of your ESXi host, there is an interesting command called <b>vim-cmd hostsvc/hosthardware</b> that will yield really useful information about your physical server. This includes the <b>Vendor</b> and <b>Model</b>.</p> <p><a href="https://www.virtualizationhowto.com/wp-content/uploads/2019/09/Get-ESXi-host-vendor-and-model-from-the-commandline.png"><img title="clip_image002" style="margin: 0px; display: inline; background-image: none;" border="0" alt="clip_image002" src="https://drive.google.com/uc?id=1GNbhIrbO_N_jcVeW_Sjw2XLidwUYHyWV" width="244" height="139" /></a>Get ESXi host vendor and model from the commandline</p> <p><b>Get the Number of CPU Cores and Type</b></p> <p>This same <b>vim-cmd hostsvc/hosthardware</b> command will allow you to see information about the CPU. This includes the number of CPUs installed, cores, and threads. Additionally in the <b>description</b> field you will see the Type of CPU installed. As you can see below, it details the <a href="https://www.virtualizationhowto.com/home-lab/">Intel Xeon CPU D-1541 running at 2.10 GHz installed in my home lab host</a>.</p> <p><a href="https://drive.google.com/uc?id=1lHBAAU0rcPyp3L38-gmKkPbu6-yJUNDh"><img title="clip_image003" style="margin: 0px; display: inline; background-image: none;" border="0" alt="clip_image003" src="https://drive.google.com/uc?id=13buTHJXiS-RRRylGEzwuAQDKbf47Tr0O" width="244" height="150" /></a></p> <p>The <b>smbiosdump</b> command is another extremely useful command that presents information about your BIOS and other low level hardware information.</p> <p><a href="https://www.virtualizationhowto.com/wp-content/uploads/2019/09/SMBIOSDUMP-command-allows-you-to-see-very-useful-BIOS-information.png"><img title="clip_image004" style="margin: 0px; display: inline; background-image: none;" border="0" alt="clip_image004" src="https://drive.google.com/uc?id=19X17FlM5wpONbd7auOtNKJmC5kLIgWS_" width="244" height="155" /></a>SMBIOSDUMP command allows you to see very useful BIOS information</p> <p>Back to one of the very handy use cases for being able to query physical hardware information from the command line is when you are trying to remember or figure out the memory layout in your ESXi host. Using the <b>smbiosdump</b> utility, you can see detailed information regarding the memory configuration of your host. This includes:</p> <p>· Maximum memory size you can install in the system</p> <p>· Location of memory slot, if it is populated</p> <p>· Manufacturer</p> <p>· Type</p> <p>· Size</p> <p>· Speed</p> <p><a href="https://drive.google.com/uc?id=1Aqc0abu7tZIa9cocw7m568RLMEoZHaCR"><img title="clip_image005" style="display: inline; background-image: none;" border="0" alt="clip_image005" src="https://drive.google.com/uc?id=1aMazDDAIbBmPBadQe4ykiwN76ZvbRSkC" width="244" height="174" /></a>Getting detailed memory information from your ESXi host with smbiosdump</p> <p>Using this command you can easily buzz through your slots and see what size, type, and manufacturer you have installed in each slot which can be extremely handy if you don’t have the liberty of shutting down your host and checking out the memory installed.</p> <p><b>Concluding Thoughts</b></p> <p>It is great to know that you can use <a href="https://www.virtualizationhowto.com/2019/04/upgrade-vmware-vsphere-esxi-to-6-7-update-2-with-vum-new-features/">VMware ESXi</a> Commandline Get CPU and Memory Information if needed from your physical ESXi hosts in your environment.</p> <p>There are many great use cases for having this ability when you either physical can’t get the information from your host or you don’t have the ability to hit the host with the web interface or using the vSphere client.</p> <p>Using the tools presented here you can quickly and easily get CPU and Memory information from your ESXi hosts.</p>kklohttp://www.blogger.com/profile/09441744195306296820noreply@blogger.com0tag:blogger.com,1999:blog-6316379511570451257.post-47919746701055697342021-07-27T16:06:00.001+02:002021-07-27T16:06:00.073+02:00Deleting a Specific Email from Entire Organization in Exchange 2010<p>This is an extract from a <a href="https://social.technet.microsoft.com/wiki/contents/articles/13915.deleting-a-specific-email-from-entire-organization-in-exchange-2010.aspx">post</a> at Microsoft Social Technet:</p> <p>There are many scenarios where we need to get rid of some Emails from the whole server</p> <p>1. Virus</p> <p>2.Confidential Email sent wrongly – Got to remove it</p> <p>3. Need to remove a Email with Specific subject from all the mailboxes</p> <p>Exchange 2010 has Good features on Searching it and Remove it .</p> <p>So Will Learn how to do that.</p> <a name='more'></a> <p>For a User to Execute this commands , he needs specific permissions like he should be a member of Discovery Management role and he should be member of Mailbox Import Export</p> <p>By Default, Administrator is not a member these roles</p> <p>Use Exchange Management Shell</p> <p>Replace the User Name with the Person whom you want to give access to Search and delete</p> <pre><font color="#809ec2" size="2">Add-RoleGroupMember "Discovery Management" -Member "User Name"</font></pre>
<p>To Add a User in Mailbox Import Export Role – Run in Exchange Management Shell</p>
<p><font color="#4f81bd" size="2" face="Courier New">New-Managementroleassignment –Role "Mailbox Import Export" –User "Administrator"</font></p>
<p>Now Before Deleting in Bulk , We can use a log only switch to verify how many Mails we are going to delete</p>
<p>and to verify the we are going to delete the right one</p>
<p><font color="#4f81bd" size="2" face="Courier New">Get-mailbox | search-mailbox –searchquery "Subject:'virus'" –Logonly –Targetmailbox administrator –Targetfolder Inbox</font></p>
<p>Now this will show how many mailboxes have this content</p>
<p>A mail will be generated to Administrators inbox with Item Count As shown below –</p>
<p>Now we will go ahead and delete it</p>
<p><font color="#4f81bd" size="2" face="Courier New">Get-mailbox | search-mailbox –searchquery "Subject:'virus'" –DeleteContent</font></p>kklohttp://www.blogger.com/profile/09441744195306296820noreply@blogger.com0tag:blogger.com,1999:blog-6316379511570451257.post-74781511524952460612021-04-28T17:47:00.001+02:002021-04-28T17:49:32.762+02:00How to extract the data from SQL Server to Excel using vba<p><a href="https://stackoverflow.com/questions/46412326/how-to-extract-the-data-from-sql-server-to-excel-using-vba">This</a> is a response from <a href="https://stackoverflow.com/users/5212614/ash">ASH</a> at stackoverflow:</p> <p>There are so many ways to do this!!</p> <a name='more'></a> <pre><code>Sub ADOExcelSQLServer()
' Carl SQL Server Connection
' FOR THIS CODE TO WORK
' In VBE you need to go Tools References and check Microsoft Active X Data Objects 2.x library
'
Dim Cn As ADODB.Connection
Dim Server_Name As String
Dim Database_Name As String
Dim User_ID As String
Dim Password As String
Dim SQLStr As String
Dim rs As ADODB.Recordset
Set rs = New ADODB.Recordset
Server_Name = "NAME" ' Enter your server name here
Database_Name = "AdventureWorksLT2012" ' Enter your database name here
User_ID = "" ' enter your user ID here
Password = "" ' Enter your password here
SQLStr = "SELECT * FROM [SalesLT].[Customer]" ' Enter your SQL here
Set Cn = New ADODB.Connection
Cn.Open "Driver={SQL Server};Server=" & Server_Name & ";Database=" & Database_Name & _
";Uid=" & User_ID & ";Pwd=" & Password & ";"
rs.Open SQLStr, Cn, adOpenStatic
' Dump to spreadsheet
With Worksheets("sheet1").Range("a1:z500") ' Enter your sheet name and range here
.ClearContents
.CopyFromRecordset rs
End With
' Tidy up
rs.Close
Set rs = Nothing
Cn.Close
Set Cn = Nothing
End Sub
</code></pre>
<p>OR . . . </p>
<pre><code>Sub ADOExcelSQLServer()
Dim Cn As ADODB.Connection
Dim Server_Name As String
Dim Database_Name As String
Dim User_ID As String
Dim Password As String
Dim SQLStr As String
Dim rs As ADODB.Recordset
Set rs = New ADODB.Recordset
Server_Name = "Server_Name" ' Enter your server name here
Database_Name = "Northwind" ' Enter your database name here
User_ID = "" ' enter your user ID here
Password = "" ' Enter your password here
SQLStr = "SELECT * FROM Orders" ' Enter your SQL here
Set Cn = New ADODB.Connection
Cn.Open "Driver={SQL Server};Server=" & Server_Name & ";Database=" & Database_Name & _
";Uid=" & User_ID & ";Pwd=" & Password & ";"
rs.Open SQLStr, Cn, adOpenStatic
With Worksheets("Sheet1").Range("A2:Z500")
.ClearContents
.CopyFromRecordset rs
End With
rs.Close
Set rs = Nothing
Cn.Close
Set Cn = Nothing
End Sub
</code></pre>
<p>Or . . . </p>
<pre><code>Sub TestMacro()
' Create a connection object.
Dim cnPubs As ADODB.Connection
Set cnPubs = New ADODB.Connection
' Provide the connection string.
Dim strConn As String
'Use the SQL Server OLE DB Provider.
strConn = "PROVIDER=SQLOLEDB;"
'Connect to the Pubs database on the local server.
strConn = strConn & "DATA SOURCE=(local);INITIAL CATALOG=NORTHWIND.MDF;"
'Use an integrated login.
strConn = strConn & " INTEGRATED SECURITY=sspi;"
'Now open the connection.
cnPubs.Open strConn
' Create a recordset object.
Dim rsPubs As ADODB.Recordset
Set rsPubs = New ADODB.Recordset
With rsPubs
' Assign the Connection object.
.ActiveConnection = cnPubs
' Extract the required records.
.Open "SELECT * FROM Categories"
' Copy the records into cell A1 on Sheet1.
Sheet1.Range("A1").CopyFromRecordset rsPubs
' Tidy up
.Close
End With
cnPubs.Close
Set rsPubs = Nothing
Set cnPubs = Nothing
End Sub
</code></pre>
<p>Also, check out the links below.</p>
<p><a href="https://www.excel-sql-server.com/excel-import-to-sql-server-using-distributed-queries.htm#Introduction">https://www.excel-sql-server.com/excel-import-to-sql-server-using-distributed-queries.htm#Introduction</a></p>
<p><a href="https://www.excel-sql-server.com/excel-sql-server-import-export-using-vba.htm#Introduction">https://www.excel-sql-server.com/excel-sql-server-import-export-using-vba.htm#Introduction</a></p>kklohttp://www.blogger.com/profile/09441744195306296820noreply@blogger.com0tag:blogger.com,1999:blog-6316379511570451257.post-80038290083632652522021-04-23T12:53:00.001+02:002021-04-23T12:53:17.216+02:00How can I see real time smtp logs on Exchange 2010<p>SMTP logging is diabled by default. You can read about it and how to enable it at these links.</p> <p>Understanding Protocol Logging: <a href="http://technet.microsoft.com/en-us/library/aa997624.aspx">http://technet.microsoft.com/en-us/library/aa997624.aspx</a></p> <p>Configuring Protocol Logging: <a href="http://technet.microsoft.com/en-us/library/bb124531.aspx">http://technet.microsoft.com/en-us/library/bb124531.aspx</a></p> <p> </p> <pre>Set-ReceiveConnector "My Receive Connector Name" -ProtocolLoggingLevel Verbose</pre>
<pre>Set-SendConnector "My Send Connector Name" -ProtocolLoggingLevel Verbose</pre>
<p>And could see the logs on</p>
<p> C:\Program Files\Microsoft\Exchange Server\V14\TransportRoles\Logs\ProtocolLog</p>kklohttp://www.blogger.com/profile/09441744195306296820noreply@blogger.com0tag:blogger.com,1999:blog-6316379511570451257.post-18747594870258688202020-12-29T14:43:00.001+01:002020-12-29T14:44:33.747+01:00Removing the device partnership in Exchange 2010 using Powershell<p>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:</p> <pre>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.</pre>
<p>Fortunately, the fix is pretty simple (<a href="http://thoughtsofanidlemind.com/2014/01/15/eas-device-partnerships/">excellent full write-up here</a>), if you just want to increase the number of devices for your default policy.</p>
<ol>
<li>Start an Exchange powershell instance </li>
<li>Run this to set max total devices (change 20 to whatever you want max to be)
<br /><a href="https://technet.microsoft.com/en-us/library/dd298094.aspx"><i>Get-ThrottlingPolicy</i></a><i> | </i><a href="https://technet.microsoft.com/en-us/library/dd298094.aspx"><i>Set-ThrottlingPolicy</i></a><i> –EASMaxDevices 20</i></li>
<li>Then run this to set the maximum number of simultaneous devices (again, you can change the 20)
<br /><a href="https://technet.microsoft.com/en-us/library/dd298094.aspx"><i>Get-ThrottlingPolicy</i></a><i> | </i><a href="https://technet.microsoft.com/en-us/library/dd298094.aspx"><i>Set-ThrottlingPolicy</i></a><i> –EASMaxConcurrency 20</i></li>
</ol>
<p>Alternativelly, you can remove all partnertships for a mailbox with the following command:</p>
<blockquote>
<p><em>foreach ( $identity in Get-ActiveSyncDeviceStatistics -Mailbox username | Select-Object -Property "Identity" ) {
<br />Remove-ActiveSyncDevice -Identity $identity.identity -Confirm:$true
<br /> }</em>
<br /></p>
</blockquote>
<p>Also you can remove all device partnerships where synchronization date (LastSuccessSync) is more than 30 days ago:</p>
<blockquote>
<p><em>$DevicesToRemove = Get-ActiveSyncDevice -Result Unlimited | Get-ActiveSyncDeviceStatistics | Where {$_.LastSuccessSync -le (Get-Date).AddDays(“-30”)}</em></p>
<p><em><em>$DevicesToRemove | Remove-ActiveSyncDevice</em></em></p></blockquote>kklohttp://www.blogger.com/profile/09441744195306296820noreply@blogger.com1tag:blogger.com,1999:blog-6316379511570451257.post-22587744215026454882020-12-20T10:30:00.001+01:002020-12-20T10:30:55.513+01:00Selecting the Best HPE Smart Array Controller for Your Server<p><a href="https://medium.com/@ITsolutions/selecting-the-best-hpe-smart-array-controller-for-your-server-da10b7424c8c">This</a> is a good article by Brynden Hutmacher, Deployment Engineer at dasher.com <a title="https://medium.com/@ITsolutions/selecting-the-best-hpe-smart-array-controller-for-your-server-da10b7424c8c" href="https://medium.com/@ITsolutions/selecting-the-best-hpe-smart-array-controller-for-your-server-da10b7424c8c">https://medium.com/@ITsolutions/selecting-the-best-hpe-smart-array-controller-for-your-server-da10b7424c8c</a></p> <a name='more'></a> <p>In order to keep up with the ever changing landscape of storage drives, storage companies are constantly improving the performance and functionality of the controllers that are used to allow the drives to talk to the CPU and then to the operating system. Storage controllers are often referred to as RAID controllers because in many cases the controller provides hardware RAID capabilities. Many servers come with controllers that use software RAID and these are often embedded in the server at no additional cost. Also, many controllers can have their RAID function turned off, to present HDDs as a JBOD (Just a Bunch Of Disks), so that the SW that is running on the servers can manage data redundancy at the SW layer and not at the hardware layer.</p> <p>Hewlett Packard Enterprise has just come out with their new Gen10 servers and as such they have released a new line of storage controllers that they are shipping as options to these servers. HPE refers to their controllers as “Smart Array Controllers.” This blog post is a secret decoder ring that can be used to determine which features a controller may include based on the name of the controller.</p> <p>Here is a link to the <a href="https://www.hpe.com/h20195/v2/Getdocument.aspx?docname=a00017196ENW"><em>HPE Smart Array Gen10 Controllers Data Sheet</em></a> which provides every controller model with a detailed breakdown of all of the models’ features. It is a terrific resource when you are trying to determine the best array controller for your server and workload requirements.</p> <p>Please refer to the graphic below as a cheat sheet.</p> <p><img alt="Image for post" src="https://miro.medium.com/max/1024/0*8DKtl-YQaqxzBl5l.png" width="1024" height="576" /></p> <p>Here are some example controller names: S100i SR, E208i-a SR, E208e-p SR, P408e-p SR, P816i-a SR</p> <p>Here are the controller name possibilities:</p> <p> </p> <p><img alt="Image for post" src="https://miro.medium.com/max/308/0*1SlwB9z0E_DbmLIp.png" width="308" height="34" /></p> <p><img alt="Image for post" src="https://miro.medium.com/max/60/0*bZfCzyAzSYHHX8zi.png?q=20" width="53" height="25" /></p> <p><img alt="Image for post" src="https://miro.medium.com/max/53/0*bZfCzyAzSYHHX8zi.png" width="53" height="25" /></p> <p>The letter at the front of the controller will be: S/E/P (The previous generation used : B/H/P).</p> <p>The “S” stands for Software RAID. The S100i is replacing the B140i as the embedded controller on Gen10 servers. This is a 6Gb/s controller that only supports SATA drives and is a Software RAID controller, not a Hardware RAID controller (please note the “i” doesn’t stand for embedded like it used to — it stands for the fact that this controller only supports internal drive connections. More on this below). <strong><em>Like the B140i this controller can only be used with the BIOS in UEFI mode.</em></strong></p> <p>The “E” stands for “Essential” controllers and they are replacing the H series controllers. These controllers are all 12Gb/s SAS and 6Gb/s SATA controllers. This is a mixed mode hardware controller with no cache and RAID is limited to 0, 1, 5 and 10. <strong>Mixed mode </strong>refers to the fact that you can have both RAID protected logical drives and HBA accessed physical drives on one controller simultaneously. In the previous generation, the array controllers could only operate in one mode or the other. These controllers can be used in either legacy or UEFI mode.</p> <p>The “P” stands for “Performance” controllers which has not changed since the last generation other than the feature that it is also now mixed mode capable .</p> <p><img alt="Image for post" src="https://miro.medium.com/max/61/0*RaBdkQSlB0FnkdzM.png" width="61" height="33" /></p> <p>The first number on the controllers is unchanged, they are still 1/2/4/8. They are a general number for comparing the entry level to the more performance and feature rich levels. For example, the 4 and 8 series have more cache, while the 1 series is included on the server and has no cache.</p> <p><img alt="Image for post" src="https://miro.medium.com/max/97/0*b7ek60Lfj9mcihZc.png" width="97" height="31" /></p> <p>The next two numbers are used to tell you how many SAS lanes the controllers have. There are four options 00/04/08/16 which are zero, four, eight or sixteen lanes respectively (the S100i controller has no SAS lanes and therefore it can support up to 14 SATA drives and no SAS drives).</p> <p><img alt="Image for post" src="https://miro.medium.com/max/45/0*C2y_d4nY7HIv5WdC.png" width="45" height="29" /></p> <p>The i/e letter(s) immediately following the three numbers designates if the controller is an internal or external controller. There is currently one controller (P416ie) that has both internal and external ports and it is designated as “ie”.</p> <p><img alt="Image for post" src="https://miro.medium.com/max/87/0*425yyua-QqupvxJY.png" width="87" height="25" /></p> <p>The letter following the dash a/b/c/m/p refers to the form factor of the controller. The options are: a:AROC/b:Blade/c:Synergy/m:Mezzanine/p:PCIe respectively. AROC stands for ”Adaptive RAID on Chip” which means that the card occupies a dedicated storage controller slot and does not use a PCIe slot. Blade, means that the the cards are meant for HPE C7000 Series Blades. Synergy, means the cards are meant for the new HPE Synergy Compute Nodes. Mezzanine are used on several different form factors: synergy, blades and on externally attached storage shelves like the MSA 1040 and 2040. PCIe means that the cards are meant for standard HPE rack and tower servers and will be installed in a PCIe slot.</p> <p><img alt="Image for post" src="https://miro.medium.com/max/62/0*ZFXJSZ8_bOE-B5cZ.png" width="62" height="22" /></p> <p>The last two letters SR/MR designate the manufacturer of the chipset. SR is the same chipset that has been used on HPE’s previous controllers and MR is for the LSI (now Broadcom) MegaRAID chipset. We believe the MR is only going to be available on the P8xx series of controllers. However this has not been released yet, but was discussed at HPE Discover in the summer of 2017.</p> <p>There is one other designation the you will see; some AROC controllers will also have a LH controller option. This controller option is used only on the DL360 and DL560 servers and needs to be used if you want to install two GPUs into these servers.</p> <p>Hopefully this blog post sheds a bit of light on the Gen10 Smart Array Controller naming conventions. If you need assistance selecting the right controller for your server or workload email <a>marketing@dasher.com</a> and we’ll get you in touch with one of our engineers.</p>kklohttp://www.blogger.com/profile/09441744195306296820noreply@blogger.com0tag:blogger.com,1999:blog-6316379511570451257.post-21340654649179828392020-11-23T14:22:00.001+01:002020-11-23T14:22:48.348+01:00Remove a disconnected Mailbox from Exchange 2010<p>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: <a href="https://community.spiceworks.com/how_to/27071-removing-disconnected-mailboxes-from-exchange-2010">spiceworks</a>).</p> <a name='more'></a> <h4>Step 1: Run a clean on your mailbox store</h4> <p>Perform the below command in order to run the Clean task on your exchange mailbox store, you need to do this via the Exchange Command Powershell</p> <p>clean-mailboxdatabase [Mailbox Store Name]</p> <p><strong>Step 2: Get a list of disconnected mailboxes in your database</strong></p> <p>Then run the below command to get a list of mailboxes that are in a disconnected state</p> <p>Get-MailboxStatistics –Database [Mailbox Store Name] | Where-Object {$_.DisconnectDate -Notlike $NULL} | FL DisplayName, DisconnectDate, MailboxGuid</p> <p><strong>Step 3: Results</strong></p> <p>You should now see a result similar to the below</p> <p>DisplayName    : USERNAME <br /> DisconnectDate : 29/10/2018 1:15:03 <br />MailboxGuid    : 7bb4935d-0ba5-4b5a-b6d0-a3f2f2e4d17f</p> <h4>Step 4: Gather maxboxguid</h4> <p>Take the MailboxGuid and copy it to Notepad. For easy modification.</p> <p>The MailboxGuid is needed to remove the mailbox completely, use the below command to remove the mailbox</p> <h4>Step 5: Remove / Delete the mailbox/'s</h4> <p>Now run the below comand inserting the Mailboxguid that you want to remove, repeat the process if you have multiple mailboxes to remove</p> <p>Remove-Mailbox –Database [Mailbox Store Name] -StoreMailboxIdentity 7bb4935d-0ba5-4b5a-b6d0-a3f2f2e4d17f</p> <p>you will now be prompted to confirm that you want to completely remove the mailbox, if you agree accept this prompt.</p> <p>You can the re run the Get-MailboxStatistics above to check there are no disconnected mailboxes remaining.</p> <p>Step 6: Verify</p> <p>to verify the mailboxes are no longer there , re -run the command in step 2, hopefully this will now display zero results.</p> <p>Job Done !</p>kklohttp://www.blogger.com/profile/09441744195306296820noreply@blogger.com0tag:blogger.com,1999:blog-6316379511570451257.post-19723276832621923672020-11-09T13:01:00.001+01:002020-11-23T14:26:05.991+01:00Query Active Directory from Excel<p><a href="https://www.remkoweijnen.nl/blog/2007/11/01/query-active-directory-from-excel/">This</a> is and old post from Remko Weijnen with some comde to get information from Active Directory.</p> <p>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.</p> <p>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.</p> <a name='more'></a> <p>So how does it work? In this example I have full name in Cell A2, in B2 I want to lookup the Accountname and in C2 the E-Mail address.</p> <p>In Cell B2 use the formula: =GetAdsprop("cn"; A2; "samAccountName")</p> <p>In Cell B3 use the formula: =GetAdsprop("cn"; A2; "mail")</p> <p><img alt="GetAdsProp Screenshot" src="https://www.remkoweijnen.nl/blog/wp-content/uploads/2007/11/getadspropscreenshot.png" /></p> <p>This is the code:</p> <p>Visual Basic</p> <p><font color="#0000ff" face="Courier New">Function GetAdsProp(ByVal SearchField As String, ByVal SearchString As String, ByVal ReturnField As String) As String</font></p> <p><font color="#0000ff" face="Courier New">' Get the domain string ("dc=domain, dc=local")</font></p> <p><font color="#0000ff" face="Courier New">Dim strDomain As String</font></p> <p><font color="#0000ff" face="Courier New">strDomain = GetObject("LDAP://rootDSE").Get("defaultNamingContext")</font></p> <p><font color="#0000ff" face="Courier New">' ADODB Connection to AD</font></p> <p><font color="#0000ff" face="Courier New">Dim objConnection As ADODB.Connection</font></p> <p><font color="#0000ff" face="Courier New">Set objConnection = CreateObject("ADODB.Connection")</font></p> <p><font color="#0000ff" face="Courier New">objConnection.Open "Provider=ADsDSOObject;"</font></p> <p><font color="#0000ff" face="Courier New">' Connection</font></p> <p><font color="#0000ff" face="Courier New">Dim objCommand As ADODB.Command</font></p> <p><font color="#0000ff" face="Courier New">Set objCommand = CreateObject("ADODB.Command")</font></p> <p><font color="#0000ff" face="Courier New">objCommand.ActiveConnection = objConnection</font></p> <p><font color="#0000ff" face="Courier New">' Search the AD recursively, starting at root of the domain</font></p> <p><font color="#0000ff" face="Courier New">objCommand.CommandText = _</font></p> <p><font color="#0000ff" face="Courier New">"<LDAP://" & strDomain & ">;(&(objectCategory=User)" & _</font></p> <p><font color="#0000ff" face="Courier New">"(" & SearchField & "=" & SearchString & "));" & SearchField & "," & ReturnField & ";subtree"</font></p> <p><font color="#0000ff" face="Courier New">' RecordSet</font></p> <p><font color="#0000ff" face="Courier New">Dim objRecordSet As ADODB.Recordset</font></p> <p><font color="#0000ff" face="Courier New">Set objRecordSet = objCommand.Execute</font></p> <p><font color="#0000ff" face="Courier New">If objRecordSet.RecordCount = 0 Then</font></p> <p><font color="#0000ff" face="Courier New">GetAdsProp = "not found" ' no records returned</font></p> <p><font color="#0000ff" face="Courier New">Else</font></p> <p><font color="#0000ff" face="Courier New">GetAdsProp = objRecordSet.Fields(ReturnField) ' return value</font></p> <p><font color="#0000ff" face="Courier New">End If</font></p> <p><font color="#0000ff" face="Courier New">' Close connection</font></p> <p><font color="#0000ff" face="Courier New">objConnection.Close</font></p> <p><font color="#0000ff" face="Courier New">' Cleanup</font></p> <p><font color="#0000ff" face="Courier New">Set objRecordSet = Nothing</font></p> <p><font color="#0000ff" face="Courier New">Set objCommand = Nothing</font></p> <p><font color="#0000ff" face="Courier New">Set objConnection = Nothing</font></p> <p><font color="#0000ff" face="Courier New">End Function</font></p> <p>That’s nice, but want if we want to perform some action on the looked up results? In my case I needed to move the users to another OU. So I made a function for that too. It’s called MoveADObject.</p> <p><font color="#0000ff" face="Courier New">Function MoveADObject(ByVal strObjectCN, ByVal strDestinationOU)</font></p> <p><font color="#0000ff" face="Courier New">Dim objDestination As IADsContainer</font></p> <p><font color="#0000ff" face="Courier New">Set objDestination = GetObject("LDAP://" & strDestinationOU)</font></p> <p><font color="#0000ff" face="Courier New">' Let the user confirm the move</font></p> <p><font color="#0000ff" face="Courier New">If MsgBox("Move " & strObjectCN & vbCrLf & "to " & objDestination.AdsPath, vbQuestion + vbYesNo) = vbYes Then</font></p> <p><font color="#0000ff" face="Courier New">' Move the object!</font></p> <p><font color="#0000ff" face="Courier New">Dim objMoved As IADs</font></p> <p><font color="#0000ff" face="Courier New">Set objMoved = objDestination.MoveHere(strObjectCN, vbNullString)</font></p> <p><font color="#0000ff" face="Courier New">' Set the new AdsPath as the function result</font></p> <p><font color="#0000ff" face="Courier New">MoveADObject = objMoved.AdsPath</font></p> <p><font color="#0000ff" face="Courier New">End If</font></p> <p><font color="#0000ff" face="Courier New">'Cleanup</font></p> <p><font color="#0000ff" face="Courier New">Set objMoved = Nothing</font></p> <p><font color="#0000ff" face="Courier New">Set objDestination = Nothing</font></p> <p><font color="#0000ff" face="Courier New">End Function</font></p> <p>To move an object (eg a user) in Active Directory you need it’s full path which is something like ("CN=User,OU=MyOU,DC=MyDomain,DC=local" Every object in Active Directory has this stored in a propery adsPath. So we use the GetAdsProp function to do a lookup. Put this formula in Cell B4: =GetAdsProp("cn";A2;"AdsPath")</p> <p> </p> <p><img alt="GetAdsProp Screenshot #2" src="https://www.remkoweijnen.nl/blog/wp-content/uploads/2007/11/getadspropscreenshot2.png" /></p> <p>Now use the following formula in Cell D2: =MoveADObject(C2;"OU=Admin Users,OU=Users,OU=Netherlands,DC=europe,dc=unity")</p> <p>The function asks for your confirmation first:</p> <p><img alt="MoveADObject Screenshot" src="https://www.remkoweijnen.nl/blog/wp-content/uploads/2007/11/moveadobjectscreenshot.png" /></p> <p>And the the object is moved. After the moving the value of the Cell will be the <em>new adsPath</em>.</p> <p>I added both functions to an Excel XLA Addin which you can add in your Addins directory, then it will be available in all you Excel sheets. (The Addins directory is usually in %userprofile%\AppData\Roaming\Microsoft\Addins ) </p> <p><a href="https://www.remkoweijnen.nl/blog/download/rwadaddin-zip/">RWADAddin.zip (19859 downloads) </a></p> <p>Also, you may need to add a reference to "Microsoft ActiveX Data Objects 2.5 Library": This reference is required for <code>early binding</code>.</p> <p>Tools > References > Check the checkbox in front of "Microsoft ActiveX Data Objects 2.5 Library"</p> <a href="https://drive.google.com/uc?id=1jseRp4VwpzrsTlDY06XU85k8X_NcNTEZ"><img title="image" style="margin: 0px; display: inline; background-image: none;" border="0" alt="image" src="https://drive.google.com/uc?id=1NI0TbKFuEgOD-Y_uYeBIcVtYXpY2Y_5b" width="244" height="199" /></a>kklohttp://www.blogger.com/profile/09441744195306296820noreply@blogger.com0tag:blogger.com,1999:blog-6316379511570451257.post-2098686184149124302020-11-07T21:52:00.001+01:002020-11-07T21:52:09.738+01:00Open Live Writer<p>This version is able to connect with Google’s blogger.</p> <p>[OpenLiveWriterSetup.zip](<a href="https://github.com/OpenLiveWriter/OpenLiveWriter/files/4027251/OpenLiveWriterSetup.zip">https://github.com/OpenLiveWriter/OpenLiveWriter/files/4027251/OpenLiveWriterSetup.zip</a>)</p>kklohttp://www.blogger.com/profile/09441744195306296820noreply@blogger.com0tag:blogger.com,1999:blog-6316379511570451257.post-66706596838769974452020-01-03T10:18:00.001+01:002020-01-03T10:18:49.447+01:00How to remove the recovery partition<p>These are the steps to remove the recovery partition in windows, thanks to <a title="https://superuser.com/questions/1073883/cant-remove-recovery-partition" href="https://superuser.com/questions/1073883/cant-remove-recovery-partition">https://superuser.com/questions/1073883/cant-remove-recovery-partition</a></p><ol><li>Go to start and type <code>cmd</code> (this is called command prompt)
<li>In command prompt type <code>diskpart</code> and hit enter
<li>Type <code>list disk</code> and hit enter
<li>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)
<li>Once you find the drive you are looking for type <code>select disk 'numberofdrive'</code><li>Now type <code>list partition</code> and find the partition you want to work with
<li>Once you have identified the partition in question type <code>select partition 'numberofpartition'</code><li>Now type <code>delete partition</code> (<strong><em>WARNING ONCE YOU DO THIS THERE IS NO GOING BACK</em></strong>) and hit enter , if it says "cannot delete a protected partition..." use <code>delete partition override</code> (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)
<li>Once it is finish type <code>exit </code>and hit enter</li></ol>kklohttp://www.blogger.com/profile/09441744195306296820noreply@blogger.com0tag:blogger.com,1999:blog-6316379511570451257.post-31618177492081286042019-10-22T10:40:00.001+02:002019-10-22T10:41:18.621+02:00Remove vmkdump foder in VMware esxi 6.x<p>Run the command <font color="#333333" face="Courier New">esxcli system coredump file list</font> until get a true value for both parameters Active and Configured.</p><p><font color="#333333" face="Courier New" size="2">[root@esx:~] esxcli system coredump file list<br>
Path Active Configured Size<br>
------------------------------------------------------------------------------------------------------- ------ ---------- ----------<br>
/vmfs/volumes/xxxxxxxx-xxxxxxxx-xxxx-xxxxxxxxxxxx/vmkdump/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx.dumpfile true true 3740270592</font></p><p>Then run the following two commands to remove de the dump file:</p><p><font color="#333333" face="Courier New" size="2">
[root@esx:~] esxcli system coredump file set -u<br>
[root@esx:~] esxcli system coredump file remove -f /vmfs/volumes/xxxxxxxx-xxxxxxxx-xxxx-xxxxxxxxxxxx/vmkdump/xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx.dumpfile</font></p><p>Now you can remove the vmkdump folder.</p>kklohttp://www.blogger.com/profile/09441744195306296820noreply@blogger.com0tag:blogger.com,1999:blog-6316379511570451257.post-61478631258389282812019-10-17T14:17:00.001+02:002019-10-17T14:17:20.149+02:00Set hardware time on VMware esxi 6.x from console<p>If you need to change the system time for a VMware esxi 6.x server fron CLI you must use the following command:</p><p><strong><font face="Consolas">esxcli system time set</font></strong></p><p>
<br></p><a name='more'></a><p>Usage: esxcli system time set [cmd options]<br>
Description:<br>
set Set the system clock time. Any missing parameters will default to the current time<br>
Cmd options:<br>
-d|--day=<long> Day<br>
-H|--hour=<long> Hour<br>
-m|--min=<long> Minute<br>
-M|--month=<long> Month<br>
-s|--sec=<long> Second<br>
-y|--year=<long> Year</p><p>So, to set the system time to 17th October 2019, 14:01:<br><font face="Consolas"><strong>
esxcli system time set -d 17 -H 14 -m 01 -M 10 -y 2019</strong></font></p>
<p>Also, make sure that you also set the hardware clock time as the system time will revert this on a reboot:</p>
<p><font face="Consolas"><strong>esxcli hardware clock set -d 17 -H 14 -m 01 -M 10 -y 2019</strong></font></p>
<p>To check the hardware and system time we can use the following commands:</p>
<p><font face="Consolas"><strong>esxcli hardware clock get<br>
esxcli system time get</strong></font></p>kklohttp://www.blogger.com/profile/09441744195306296820noreply@blogger.com0tag:blogger.com,1999:blog-6316379511570451257.post-17441369397282036732019-09-27T11:27:00.001+02:002019-09-27T11:27:54.652+02:00Update VMware ESXi v5.5<p>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.</p>
<a name='more'></a>
<p><br></p><pre># Cut and paste these commands into an ESXi shell to update your host
#
esxcli network firewall ruleset set -e true -r httpClient
esxcli software profile update -p ESXi-5.5.0-20180904001-standard \
-d https://hostupdate.vmware.com/software/VUM/PRODUCTION/main/vmw-depot-index.xml
esxcli network firewall ruleset set -e false -r httpClient
#
# Reboot to complete the upgrade<br>reboot
</pre>kklohttp://www.blogger.com/profile/09441744195306296820noreply@blogger.com0tag:blogger.com,1999:blog-6316379511570451257.post-82770953289442350162019-08-08T13:35:00.001+02:002019-08-08T13:40:26.300+02:00Change the nic order on JovianDSSIn JovianDSS it is possible to change the NIC order to suite your needs. <br />
<a name='more'></a><br />
Log on to JovianDSS console and press “Ctrl+Alt+T” to enter Extended tools menu:<br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhmqlAzQcKGrtoKbDSlLsy2Vckv_lp1YHPuuWF3MUXN1cISIfo9pnRxYybmSEScJ4WnXsbI0_-t19J4s2aPi47IWnA0Xy8EhJ57dMDJvPr7h3oOpjuYkdAEH95OsNqN3PtTSV_1U6-1azk/s1600/001.png" imageanchor="1"><img border="0" data-original-height="291" data-original-width="568" height="164" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhmqlAzQcKGrtoKbDSlLsy2Vckv_lp1YHPuuWF3MUXN1cISIfo9pnRxYybmSEScJ4WnXsbI0_-t19J4s2aPi47IWnA0Xy8EhJ57dMDJvPr7h3oOpjuYkdAEH95OsNqN3PtTSV_1U6-1azk/s320/001.png" width="320" /></a><br />
Select Add-ons and then Nics management, the following list will appear:<br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi1Guo2Y1SSnb53RZkFeaWJ0BDp-aErxHufmdzE2VrcucxkB_PoF0VKwSPc9rVqdxDzk2abP64koEqKISe-6ILvKSWFk4hIwizz4hc67c7iiOx5oOIwZwoUza0l3v1J1JCZ5ZGxSAZP-vo/s1600/002.png" imageanchor="1"><img border="0" data-original-height="341" data-original-width="395" height="276" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi1Guo2Y1SSnb53RZkFeaWJ0BDp-aErxHufmdzE2VrcucxkB_PoF0VKwSPc9rVqdxDzk2abP64koEqKISe-6ILvKSWFk4hIwizz4hc67c7iiOx5oOIwZwoUza0l3v1J1JCZ5ZGxSAZP-vo/s320/002.png" width="320" /></a><br />
Select the NIC, and you can either rename the NIC name or even remove it:<br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEglcvDaASnK8u-z2XUhCvcjhpFAYfuvMVKYDZS0AInziZJGddUFDixivifWKFeBoWnkB6ROItv-pUG0z-BVKiDqSurcm56pxVznMAvl-9FXLulajjyE58Ub1YOYrN8QKXV_rJtI2mcWhWg/s1600/003.png" imageanchor="1"><img border="0" data-original-height="165" data-original-width="231" height="229" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEglcvDaASnK8u-z2XUhCvcjhpFAYfuvMVKYDZS0AInziZJGddUFDixivifWKFeBoWnkB6ROItv-pUG0z-BVKiDqSurcm56pxVznMAvl-9FXLulajjyE58Ub1YOYrN8QKXV_rJtI2mcWhWg/s320/003.png" width="320" /></a><br />
Remember that you should choose a free name for the NIC adapter:<br />
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiPV97utBtqRVvjaM3Fx0LGRV0WR7yy511zEWPgTFemRVkF2V0lB0PhNukCapcSno0dfXzy4VVmDnhgkRktU4YvnHykiDAGthDi4QBA4xj3LDZCrjz7SFTtWF-oJwitNK76Si90CGYAI2w/s1600/004.png" imageanchor="1"><img border="0" data-original-height="117" data-original-width="305" height="123" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiPV97utBtqRVvjaM3Fx0LGRV0WR7yy511zEWPgTFemRVkF2V0lB0PhNukCapcSno0dfXzy4VVmDnhgkRktU4YvnHykiDAGthDi4QBA4xj3LDZCrjz7SFTtWF-oJwitNK76Si90CGYAI2w/s320/004.png" width="320" /></a>
kklohttp://www.blogger.com/profile/09441744195306296820noreply@blogger.com0tag:blogger.com,1999:blog-6316379511570451257.post-32271746366587390772019-08-08T12:41:00.001+02:002019-10-02T14:27:24.204+02:00Change vmnic order on vSphere 6.x<p>This is an article by <a href="https://www.vmbaggum.nl/author/marco/" target="_blank">Marco van Baggun</a> at <a href="https://www.vmbaggum.nl/2017/04/change-vmnic-order-vsphere-6-x/">www.vmbaggum.nl</a> that explains how to change vmnic order on vSphere 6.x</p><p><a href="http://kakaladas.blogspot.com/2011/10/reordering-vmnics-on-vsphere-4x.html">Here</a> you can check how to do it for previous versions.</p><a name='more'></a><p>There is always one ESXi host who thinks he’s special and therefore has a different configuration than its siblings. This week it was a brand spanking new UCS blade server that didn’t want to play nice and the result was a different vmnic order.<p>I’ve done this fix several times before with the older versions (< v5.5) of vSphere but now it was vSphere 6.0 so the KB article <a href="https://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=2019871">2019871</a> that describes how to do this up to version 5.1 did not apply any more. But all the way at the bottom there is a link to KB article <a href="https://kb.vmware.com/selfservice/search.do?cmd=displayKC&docType=kc&docTypeID=DT_KB_1_1&externalId=2091560">2091560</a> that describe how to do this with vSphere 6.x!<h6>How to change the vmnic order</h6><p>Log on to your “special” ESXi host with your favorite SSH client.<p>Run the following command to see the current assignment of aliases to device locations:<p><font face="Courier New">localcli --plugin-dir /usr/lib/vmware/esxcli/int/ deviceInternal alias list</font><p>The output will look as follows:<p><font face="Courier New">Bus type Bus address Alias
<br>-------------------------------<br>
pci s00000000:03.00 vmnic0<br>
pci s00000000:04.00 vmnic1<br>pci s0000000f:06.00 vmhba1<br>
pci s0000000f:05.00 vmnic5<br>
pci s00000000:05.00 vmnic2<br>pci s00000000:06.00 vmhba0<br>pci s0000000f:03.00 vmnic3<br>pci s0000000f:04.00 vmnic4</font><p>Then to reassign an alias run the following command:<p><font face="Courier New">localcli --plugin-dir /usr/lib/vmware/esxcli/int/ deviceInternal alias store --bus-type pci --alias vmnicN --bus-address B</font><p>For example, if you want to swap vmnic3 and vmnic4 use the following commands:<p><font face="Courier New">localcli --plugin-dir /usr/lib/vmware/esxcli/int/ deviceInternal alias store --bus-type pci --alias vmnic3 --bus-address s0000000f:04.00
<br>localcli --plugin-dir /usr/lib/vmware/esxcli/int/ deviceInternal alias store --bus-type pci --alias vmnic4 --bus-address s0000000f:03.00</font><p>After you re-assigned the aliases perform a clean reboot of the ESXi host and you’re done!</p>kklohttp://www.blogger.com/profile/09441744195306296820noreply@blogger.com0tag:blogger.com,1999:blog-6316379511570451257.post-42757471578675046992019-07-01T12:54:00.001+02:002019-07-01T12:55:51.868+02:00Enable traffic logs in Fortigate firewalls<p>Local traffic logs are disabled by default in fortigate firewalls. This logs can be enabled from console.</p><p>Check the following:<br><font color="#0000ff"><font face="Consolas">config log memory filter</font><br><font face="Consolas">get </font><font color="#666666"><<—lists all options</font></font></p><p><font color="#0000ff"><font color="#666666"></font><br></font>Make sure local-traffic logs are enabled. If not then:<br><font color="#0000ff" face="Consolas">set local-traffic enable<br>end</font></p><p>Enable "Log Allowed Traffic" and select "All Sessions" on the firewall policy.<br>Make sure you display logs from the correct location(GUI):<br>"Log & Report >> Log Settings >> GUI Preferences >> Memory/FortiCloud"</p>kklohttp://www.blogger.com/profile/09441744195306296820noreply@blogger.com0tag:blogger.com,1999:blog-6316379511570451257.post-63809904279889928532019-06-11T10:12:00.001+02:002019-06-11T10:12:46.702+02:00Install latest Java 8 on raspbian<p>This is a post by <a href="http://wp.brodzinski.net/author/admin/" target="_blank">BartB at brodzinski.net</a> that explains how to install latest Java 8 on raspbian.<a name='more'></a><p>I’m always looking for this commands when I need to install latest Java 8 JDK on my RPi, so I’m adding them here just in case I’ll need to use them again.<p>Unfortunately default Raspbian repository contains old Java version <strong>1.8.0_65-b17</strong> while the latest (when I’m writing this post) is <strong>1.8.0_151-b12</strong>.<h3>Installation</h3><p>First install dirmngr:<p><code>sudo</code> <code>apt-get </code><code>install</code> <code>dirmngr</code><p>Second add deb repositories and key:<p><code>echo</code> <code>"deb <a href="http://ppa.launchpad.net/webupd8team/java/ubuntu">http://ppa.launchpad.net/webupd8team/java/ubuntu</a> trusty main"</code> <code>| </code><code>sudo</code> <code>tee</code> <code>/etc/apt/sources</code><code>.list.d</code><code>/webupd8team-java</code><code>.list</code><p><code>echo</code> <code>"deb-src <a href="http://ppa.launchpad.net/webupd8team/java/ubuntu">http://ppa.launchpad.net/webupd8team/java/ubuntu</a> trusty main"</code> <code>| </code><code>sudo</code> <code>tee</code> <code>-a </code><code>/etc/apt/sources</code><code>.list.d</code><code>/webupd8team-java</code><code>.list</code><p><code>sudo</code> <code>apt-key adv --keyserver hkp:</code><code>//keyserver</code><code>.ubuntu.com:80 --recv-keys EEA14886</code><p><strong>Warning!</strong> If you add <strong>xentail</strong> repositories (as many RPi forums and other pages state) you’ll end up with old 1.8.0_65 version, you must be using <strong>trusty</strong> repositories in order to install latest Java version.<p>Update repositories:<p><code>sudo</code> <code>apt-get update</code><p>Install Java installer:<p><code>sudo</code> <code>apt-get </code><code>install</code> <code>oracle-java8-jdk</code><h3>Verify Java version</h3><p>To be 100% sure I have proper version of Java I use basic command:<p><code>java -version</code><h3>Remove old Java</h3><p>In case you have old Java 8 JDK<p><code>sudo</code> <code>apt-get remove --purge oracle-java8-jdk</code></p>kklohttp://www.blogger.com/profile/09441744195306296820noreply@blogger.com0tag:blogger.com,1999:blog-6316379511570451257.post-74699609772431964282019-06-04T13:40:00.001+02:002019-06-11T10:13:21.847+02:00Install ppp package in Raspberry Pi<p>This is an extract from <a href="https://raspberrypi.stackexchange.com/questions/64179/installing-package-error-sudo-apt-get-install-ppp" target="_blank">StackExchange</a> that shows how to install ppp package in Raspberry Pi.</p><p>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:</p><p><pre>pi@raspberrypi:~$ sudo su -
root@raspberrypi:~# apt-get update && apt-get install aptitude
root@raspberrypi:~# aptitude upgrade && dpkg --configure -a && aptitude install ppp</pre>kklohttp://www.blogger.com/profile/09441744195306296820noreply@blogger.com0tag:blogger.com,1999:blog-6316379511570451257.post-45656935912167070762018-07-13T13:24:00.000+02:002018-07-13T13:25:09.361+02:00VeraCrypt remembers my password using W10<p>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.<p>I've resolved this issue by adding a task in Task Scheduler (taskschd.msc).<p>The task must be an umount command ("C:\Program Files\VeraCrypt\VeraCrypt.exe" /d /f /quit ).<br>And the trigger a registry event:<br>Registry: System<br>Source: User32<br>Event id: 1074<p>Using this configuration your veracrypt volumes are unmounted even with Fast Startup enabled.<p>PD: I've tried this solution only with file containers. I don't know if it works with system drives or partitions.</p>kklohttp://www.blogger.com/profile/09441744195306296820noreply@blogger.com0tag:blogger.com,1999:blog-6316379511570451257.post-27190398342769413822018-07-12T12:20:00.001+02:002018-07-12T13:12:59.752+02:00Sonicwall - Export configuration settings using Enterprise Command Line Interface (E-CLI)<p>Sonicwall TZ firewalls configuration can be exported from command line to a ftp server. <a href="https://www.sonicwall.com/en-us/support/knowledge-base/170504991622695" target="_blank">Here</a> you can find the Sonicwall related documentation regarding this subject.</p><p>examples:</p><p><strong>export current-config cli ftp <a href="ftp://username:password@hostname/filename.txt">ftp://username:password@hostname/filename.txt</a></strong></p><p><strong>export current-config exp ftp <a href="ftp://username:password@hostname/filename.exp">ftp://username:password@hostname/filename.exp</a></strong></p><p><br></p><p><br></p><p>This is the full Sonicwall article:</p>
<a name='more'></a>
<h4>Export configuration settings using Enterprise Command Line Interface (E-CLI)</h4><p>Last Updated: 5/11/2018 <strong>5004</strong> Views <strong>22</strong> Users found this article helpful<h5>Description</h5><p>Export configuration settings using Enterprise Command Line Interface (E-CLI)<h5>Resolution</h5><p>SonicOS 5.9 introduces a new, more robust, enterprise-level Command Line Interface (E-CLI). This article describes how to export configuration settings using E-CLI.<p>The CLI can be accessed via Serial cable and SSH.<p><strong>Global System Commands</strong><br>The following system commands are global and can be executed from anywhere in the <strong>config</strong> module.<p><strong>Command <br></strong><br><strong>Description</strong><br><strong>Command</strong><br><strong>Description</strong><p><strong>Tab</strong> key<br>Tab key aids in completing a command. Displays useful information such as the next option in the command.<br><em>end</em><br>Exit current mode and return to global configuration mode without saving changes made in the current mode.<p><strong> </strong>key<br>The key lists the next command or commands with a short description of each command. For certain commands, the key even displays examples of using the given command.<br><em>exit</em><br>Exit current mode without saving changes made in the current mode<p><strong>q </strong>key<br>The key breaks listing of commands or information. Useful when the output of a command like <em><strong>Show current-config</strong></em> needs to be stopped.<br><em>export</em><br>Export system status or configuration<p><em>cancel</em><br>Exit from the mode without saving changes.<br><em>help</em><br>Display command help<p><em>clear</em><br>Reset functions.<br><em>no</em><br>Negate a command or set its defaults.<p><em>commit</em><br>Save configuration changes. The command commit best-effort will save only valid changes <br><em>show</em><br>Show system status or configuration. <p><em>diag</em><br>Diagnostic functions.<hr><p><strong><strong>Procedure:</strong></strong><p>To be able to export SonicOS configuration settings via CLI, you require a FTP server to be installed and reachable from the SonicWall. You need to ensure read / write permissions for the FTP folder where the firmware is to be downloaded from or uploaded into.<br>In the new E-CLI, all commands related to FTP have the FTP URL in the form: <em>ftp://username:password@hostname/filename</em>. In the examples below, the username and password is "test". The IP address of the FTP server is 10.10.10.2. <br>Export System Command can be used to export configuration settings and pending configuration. Configuration can be exported in two formats: SonicOS and CLI.<p>SonicOS format exports the settings in the <em><strong>.exp</strong></em> format which can be later imported from the WebUI.<br>The CLI format export the settings in the E-CLI command format. The exported file can be edited using a text editor.<br>Login to the CLI using the admin username and password.<br>Navigate to the config prompt by entering <strong>config</strong> and press enter. Configuration settings can be exported from either outside the <strong>config </strong>mode or within it. However, exporting pending configuration requires the user to be be in the <strong>config </strong>mode. Moreover, pending configuration can only be exported in the CLI format.<br>Export configuration settings using SonicOS format.<p><strong>export current-config sonicos ftp ftp://test:test@10.10.10.2/sonicos.exp</strong><p>Export configuration settings using E-CLI format<p><strong>export current-config cli ftp ftp://test:test@10.10.10.2/sonic-cli.wri</strong><p>Export pending configuration settings using SonicOS format.<p><strong>export pending-config cli ftp ftp://test:test@10.10.10.2/sonic-cli-pending.wri</strong><p><strong><br></strong><img alt="Image" src="https://sonicwall.rightanswers.com/portal/app/portlets/results/onsitehypermedia/090170804245473.png?linkToken=eyJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJzb25pY3dhbGwiLCJleHAiOjE1NjI5MjI0OTQsImlhdCI6MTUzMTM4NjQ5NH0.B2Gq6ySOgiy5shS6Ry_jV87W1C17xBzi8adMuy9wpqM"><br>In the screen shot shown above,the FTP server username is SonicWall & password is password.Once we hit enter, it ill start exporting the config files to FTP server as shown below.<br><img alt="Image" src="https://sonicwall.rightanswers.com/portal/app/portlets/results/onsitehypermedia/090170804935334.png?linkToken=eyJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJzb25pY3dhbGwiLCJleHAiOjE1NjI5MjI0OTQsImlhdCI6MTUzMTM4NjQ5NH0.B2Gq6ySOgiy5shS6Ry_jV87W1C17xBzi8adMuy9wpqM"><br>Once it finish exporting we will see the config file in the FTP server.kklohttp://www.blogger.com/profile/09441744195306296820noreply@blogger.com0tag:blogger.com,1999:blog-6316379511570451257.post-59297900233704159342018-06-22T11:25:00.001+02:002018-06-22T11:25:20.507+02:00How to change the default PST location/path registry in Outlook?<h4><a href="https://www.extendoffice.com/documents/outlook/2374-outlook-change-default-pst-location.html" target="_blank">Here</a> you can find a Post from <a href="http://www.extendedoffice.com">www.extendedoffice.com</a> that explains how to change the default PST and OST files location. <br clear="all"></h4><a name='more'></a><p>Normally we can open the saving folder of an Outlook data file (.pst files or .ost files) with the <strong>Open File Location</strong> command in Outlook. However, it seems quite tough to open the location folder of a .pst file manually for copying, backup, or something else. In truth, we can customize the location folder for Outlook’s .pst files. In this article, I will guide you to change the default PST location/path registry in Outlook.<p><hr><p>For customizing default PST/OST location/path for Microsoft Outlook in registry Editor, you can walk it through step by step as following:<p>Step 1: Open the Run dialog box with pressing the <strong>Win</strong> + <strong>R </strong>keys in a meanwhile, enter the <strong>regedit</strong> into the <strong>Open</strong> box, and click the <strong>OK</strong> button.<p><img width="412" height="212" src="https://www.extendoffice.com/images/stories/doc-outlook/default-pst-location/doc-default-pst-location-6.png"><p>Step 2: In the coming User Account Control dialog box, click the <strong>Yes </strong>button.<p><img alt="doc-default-pst-location-7" src="https://www.extendoffice.com/images/stories/doc-outlook/default-pst-location/doc-default-pst-location-7.png"><p>Step 3: Find out and select the <strong>Outlook</strong> key with one of following paths:<p><strong>Outlook 2013</strong>: HKEY_CURRENT_USER\Software\Microsoft\Office\15.0\Outlook<br><strong>Outlook 2010</strong>: HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Outlook<br><strong>Outlook 2007</strong>: HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Outlook<p><img alt="doc-default-pst-location-3" src="https://www.extendoffice.com/images/stories/doc-outlook/default-pst-location/doc-default-pst-location-3.png"><p>Step 4: Click the <strong>Edit</strong> > <strong>New</strong> > <strong>Expandable String Value</strong>, and name the new created expandable string value as <strong><em>ForcePSTPath</em></strong>.<p><strong>Note</strong>: To change the default location folder of .ost files generated by exchange accounts, you can create an expandable string value and name it as <strong><em>ForceOSTPath</em></strong>.<p><img width="576" height="374" src="https://www.extendoffice.com/images/stories/doc-outlook/default-pst-location/doc-default-pst-location-4.png"><p>Step 5: Double click the new created <strong><em>ForcePSTPath</em></strong> to open the Edit string dialog box, and then enter or paste your custom saving path into the <strong>Value data</strong> box, and then click the <strong>OK </strong>button. See screen shot below:<p><img width="576" height="375" src="https://www.extendoffice.com/images/stories/doc-outlook/default-pst-location/doc-default-pst-location-5.png"><p>Step 6: Close the Registry Editor, and restart your Microsoft Outlook.<p>From now on, when you create a new Outlook data file (.pst file), it will open the specified default location for saving this .pst file.<p><strong>Notes</strong>:<p>(1) This method won’t affect the saving location folder of existing .pst files.<p>(2) This method won’t affect the default location folder of outlook data files generated by IMAP accounts.kklohttp://www.blogger.com/profile/09441744195306296820noreply@blogger.com0