tag:blogger.com,1999:blog-75394814482287533832024-03-16T14:52:39.096-04:00virtualpatel.blogspot.comBlog all about VMware but not from VMware.mandivshttp://www.blogger.com/profile/00901843395280966609noreply@blogger.comBlogger155125tag:blogger.com,1999:blog-7539481448228753383.post-38325753777118691562018-05-14T13:58:00.000-04:002018-05-14T14:15:14.986-04:00NSX-T Resources<div dir="ltr" style="text-align: left;" trbidi="on">
Hi<br />
<br />
Its been a while when I last blogged but here I am again with NSX-T.<br />
<br />
Please go through the whole article here about getting anything for NSX-T<br />
<strong style="color: #2277bb; font-family: arial, sans-serif; font-size: 16px;"><br /><br />NSX-T - Reference Architecture</strong><br />
<div style="background-color: white; color: #333333; font-family: Arial, sans-serif; font-size: 14px; margin-top: 10px; padding: 0px;">
<a class="external-link" href="https://blogs.vmware.com/networkvirtualization/2018/02/introducing-vmware-nsx-t-reference-design.html/" rel="nofollow" style="color: #223b66; text-decoration-line: none;">https://blogs.vmware.com/networkvirtualization/2018/02/introducing-vmware-nsx-t-reference-design.html/</a> </div>
<h3 id="NSX-TResources-NSX-T-ReferenceDesign" style="background-color: white; color: #2277bb; font-family: Arial, sans-serif; font-size: 16px; line-height: 1.5; margin: 30px 0px 0px; padding: 0px;">
<strong>NSX-T - Reference Design</strong></h3>
<div style="background-color: white; color: #333333; font-family: Arial, sans-serif; font-size: 14px; margin-top: 10px; padding: 0px;">
https://communities.vmware.com/docs/DOC-37591</div>
<h3 id="NSX-TResources-ContainersandcontainerNetworkingwithNSX-T" style="background-color: white; color: #2277bb; font-family: Arial, sans-serif; font-size: 16px; line-height: 1.5; margin: 30px 0px 0px; padding: 0px;">
<strong>Containers and container Networking with NSX-T</strong></h3>
<div style="background-color: white; color: #333333; font-family: Arial, sans-serif; font-size: 14px; margin-top: 10px; padding: 0px;">
<a class="external-link" href="https://communities.vmware.com/thread/581308" rel="nofollow" style="color: #223b66; text-decoration-line: none;">https://communities.vmware.com/thread/581308</a></div>
<div style="background-color: white; color: #333333; font-family: Arial, sans-serif; font-size: 14px; margin-top: 10px; padding: 0px;">
<strong style="color: #2277bb; font-size: 16px;"><br /><br />NSX-T Hands-on-Labs</strong></div>
<div style="background-color: white; color: #333333; font-family: Arial, sans-serif; font-size: 14px; margin-top: 10px; padding: 0px;">
HOL-1826-01-NET – VMware NSX-T – Getting Started (<a class="external-link" href="https://labs.hol.vmware.com/HOL/catalogs/catalog/681" rel="nofollow" style="color: #223b66; text-decoration-line: none;">https://labs.hol.vmware.com/HOL/catalogs/catalog/681</a>)</div>
<div style="background-color: white; color: #333333; font-family: Arial, sans-serif; font-size: 14px; margin-top: 10px; padding: 0px;">
HOL-1826-02-NET – VMware NSX-T with Kubernetes (<a class="external-link" href="https://labs.hol.vmware.com/HOL/catalogs/catalog/681" rel="nofollow" style="color: #223b66; text-decoration-line: none;">https://labs.hol.vmware.com/HOL/catalogs/catalog/681</a>)</div>
<div style="background-color: white; color: #333333; font-family: Arial, sans-serif; font-size: 14px; margin-top: 10px; padding: 0px;">
<strong style="color: #2277bb; font-size: 16px;"><br /><br />NSX-T White Paper</strong></div>
<div style="background-color: white; color: #333333; font-family: Arial, sans-serif; font-size: 14px; margin-top: 10px; padding: 0px;">
<a class="external-link" href="https://communities.vmware.com/servlet/JiveServlet/previewBody/33837-102-2-46193/VMware-NSX-T-Technical-White-Paper-20170202-v1.0.pdf" rel="nofollow" style="color: #223b66; text-decoration-line: none;">https://communities.vmware.com/servlet/JiveServlet/previewBody/33837-102-2-46193/VMware-NSX-T-Technical-White-Paper-20170202-v1.0.pdf</a></div>
<div style="background-color: white; color: #333333; font-family: Arial, sans-serif; font-size: 14px; margin-top: 10px; padding: 0px;">
<strong style="color: #2277bb; font-size: 16px;"><br />NSX-T Routing</strong></div>
<div style="background-color: white; color: #333333; font-family: Arial, sans-serif; font-size: 14px; margin-top: 10px; padding: 0px;">
<a class="external-link" href="https://blogs.vmware.com/networkvirtualization/2018/02/nsx-t-multi-tiered-routing-architecture.html/" rel="nofollow" style="color: #223b66; text-decoration-line: none;">https://blogs.vmware.com/networkvirtualization/2018/02/nsx-t-multi-tiered-routing-architecture.html/<br /><strong style="color: #2277bb; font-size: 16px;"><br /><br />NSX-T Blog Series</strong></a></div>
<ul style="background-color: white; color: #333333; font-family: Arial, sans-serif; font-size: 14px; margin: 10px 0px 0px 3em;">
<li><a class="external-link" href="https://www.virtuallyghetto.com/2018/03/getting-started-with-vmware-pivotal-container-service-pks-part-1-overview.html" rel="nofollow" style="color: #223b66; text-decoration-line: none;">Getting started with VMware Pivotal Container Service (PKS) Part 1: Overview</a></li>
<li><a class="external-link" href="https://www.virtuallyghetto.com/2018/03/getting-started-with-vmware-pivotal-container-service-pks-part-2-pks-client.html" rel="nofollow" style="color: #223b66; text-decoration-line: none;">Getting started with VMware Pivotal Container Service (PKS) Part 2: PKS Client</a></li>
<li><a class="external-link" href="https://www.virtuallyghetto.com/2018/03/getting-started-with-vmware-pivotal-container-service-pks-part-3-nsx-t.html" rel="nofollow" style="color: #223b66; text-decoration-line: none;">Getting started with VMware Pivotal Container Service (PKS) Part 3: NSX-T</a></li>
<li><a class="external-link" href="https://www.virtuallyghetto.com/2018/03/getting-started-with-vmware-pivotal-container-service-pks-part-4-ops-manager-bosh.html" rel="nofollow" style="color: #223b66; text-decoration-line: none;">Getting started with VMware Pivotal Container Service (PKS) Part 4: Ops Manager & BOSH</a></li>
<li><a class="external-link" href="https://www.virtuallyghetto.com/2018/04/getting-started-with-vmware-pivotal-container-service-pks-part-5-pks-control-plane.html" rel="nofollow" style="color: #223b66; text-decoration-line: none;">Getting started with VMware Pivotal Container Service (PKS) Part 5: PKS Control Plane</a></li>
</ul>
<h3 id="NSX-TResources-SoftwareDownload" style="background-color: white; color: #2277bb; font-family: Arial, sans-serif; font-size: 16px; line-height: 1.5; margin: 30px 0px 0px; padding: 0px;">
<strong>Software Download</strong></h3>
<div style="background-color: white; color: #333333; font-family: Arial, sans-serif; font-size: 14px; margin-top: 10px; padding: 0px;">
NSX-T <a class="external-link" href="https://my.vmware.com/web/vmware/details?productId=673&downloadGroup=NSX-T-210" rel="nofollow" style="color: #223b66; text-decoration-line: none;">https://my.vmware.com/web/vmware/details?productId=673&downloadGroup=NSX-T-210</a><br />
PKS <a class="external-link" href="https://network.pivotal.io/products/pivotal-container-service#/releases/43085" rel="nofollow" style="color: #223b66; text-decoration-line: none;">https://network.pivotal.io/products/pivotal-container-service#/releases/43085</a><br />
PKS CLI <a class="external-link" href="https://network.pivotal.io/products/pivotal-container-service#/releases/43085/file_groups/848" rel="nofollow" style="color: #223b66; text-decoration-line: none;">https://network.pivotal.io/products/pivotal-container-service#/releases/43085/file_groups/848</a><br />
Kubectl CLI <a class="external-link" href="https://network.pivotal.io/products/pivotal-container-service#/releases/43085/file_groups/847" rel="nofollow" style="color: #223b66; text-decoration-line: none;">https://network.pivotal.io/products/pivotal-container-service#/releases/43085/file_groups/847</a><br />
Pivotal Ops Manager for vSphere <a class="external-link" href="https://network.pivotal.io/products/ops-manager" rel="nofollow" style="color: #223b66; text-decoration-line: none;">https://network.pivotal.io/products/ops-manager</a><br />
Stemcell for vSphere <a class="external-link" href="https://network.pivotal.io/products/stemcells" rel="nofollow" style="color: #223b66; text-decoration-line: none;">https://network.pivotal.io/products/stemcells</a>z</div>
<h3 id="NSX-TResources-NSX-TOfficialDocumentation(https://docs.vmware.com/en/VMware-NSX-T/index.html)" style="background-color: white; color: #2277bb; font-family: Arial, sans-serif; font-size: 16px; line-height: 1.5; margin: 30px 0px 0px; padding: 0px;">
<strong>NSX-T Official Documentation</strong><br />(<a class="external-link" href="https://docs.vmware.com/en/VMware-NSX-T/index.html" rel="nofollow" style="color: #223b66; text-decoration-line: none;">https://docs.vmware.com/en/VMware-NSX-T/index.html</a>)</h3>
<ul style="background-color: white; color: #333333; font-family: Arial, sans-serif; font-size: 14px; margin: 10px 0px 0px;">
<li> NSX-T Installation Guide (<a class="external-link" href="https://docs.vmware.com/en/VMware-NSX-T/2.1/nsxt_21_install.pdf" rel="nofollow" style="color: #223b66; text-decoration-line: none;">https://docs.vmware.com/en/VMware-NSX-T/2.1/nsxt_21_install.pdf</a>) </li>
<li> NSX-T Administration Guide (<a class="external-link" href="https://docs.vmware.com/en/VMware-NSX-T/2.1/nsxt_21_install.pdf" rel="nofollow" style="color: #223b66; text-decoration-line: none;">https://docs.vmware.com/en/VMware-NSX-T/2.1/nsxt_21_admin.pdf</a>) </li>
<li> NSX-T Upgrade Guide ((<a class="external-link" href="https://docs.vmware.com/en/VMware-NSX-T/2.1/nsxt_21_install.pdf" rel="nofollow" style="color: #223b66; text-decoration-line: none;">https://docs.vmware.com/en/VMware-NSX-T/2.1/nsxt_21_upgrade.pdf</a>) </li>
<li> NSX-T Troubleshooting Guide ((<a class="external-link" href="https://docs.vmware.com/en/VMware-NSX-T/2.1/nsxt_21_install.pdf" rel="nofollow" style="color: #223b66; text-decoration-line: none;">https://docs.vmware.com/en/VMware-NSX-T/2.1/nsxt_21_troubleshoot.pdf</a>) </li>
<li> NSX-T Container Plug-in for Kubernetes and Cloud Foundry - Installation and Administration Guide ((<a class="external-link" href="https://docs.vmware.com/en/VMware-NSX-T/2.1/nsxt_21_install.pdf" rel="nofollow" style="color: #223b66; text-decoration-line: none;">https://docs.vmware.com/en/VMware-NSX-T/2.1/nsxt_21_ncp_kubernetes.pdf</a>) </li>
<li> NSX-T Container Plug-in for OpenShift - Installation and Administration Guide ((<a class="external-link" href="https://docs.vmware.com/en/VMware-NSX-T/2.1/nsxt_21_install.pdf" rel="nofollow" style="color: #223b66; text-decoration-line: none;">https://docs.vmware.com/en/VMware-NSX-T/2.1/nsxt_21_ncp_openshift.pdf</a>) </li>
<li> NSX Openstack Plugin Release Notes (<a class="external-link" href="https://docs.vmware.com/en/VMware-NSX-T/2.1/nsxt_21_neutron_release_notes.pdf" rel="nofollow" style="color: #223b66; text-decoration-line: none;">https://docs.vmware.com/en/VMware-NSX-T/2.1/nsxt_21_neutron_release_notes.pdf</a>)</li>
<li> NSX OpenStack Plugin Installation and Configuration (<a class="external-link" href="https://docs.vmware.com/en/VMware-NSX-T/2.1/nsxt_21_neutron_install_config.pdf" rel="nofollow" style="color: #223b66; text-decoration-line: none;">https://docs.vmware.com/en/VMware-NSX-T/2.1/nsxt_21_neutron_install_config.pdf</a>)</li>
</ul>
<div style="background-color: white; color: #333333; font-family: Arial, sans-serif; font-size: 14px; margin-top: 10px; padding: 0px;">
<strong style="color: #2277bb; font-size: 16px;"><br />NSX-T Deployment Architecture with NAT </strong></div>
<div style="background-color: white; color: #333333; font-family: Arial, sans-serif; font-size: 14px; margin-top: 10px; padding: 0px;">
NSX-T deployment with PKS using the Network Address Translation (NAT) topology. The following figure shows the NAT deployment architecture:</div>
<div style="background-color: white; margin-top: 10px; padding: 0px;">
<br />
<a class="external-link" href="https://docs.vmware.com/en/VMware-Pivotal-Container-Service/1.0/vmware-pks-10/images/nsx-t-overview.png" rel="nofollow" style="color: #223b66; font-family: Arial, sans-serif; font-size: 14px; text-decoration-line: none;">https://docs.vmware.com/en/VMware-Pivotal-Container-Service/1.0/vmware-pks-10/images/nsx-t-overview.png</a></div>
<h1 style="background-color: white; border: 0px none; font-family: proxima-nova, Arial, sans-serif; font-stretch: inherit; font-variant-east-asian: inherit; font-variant-numeric: inherit; line-height: 0.9em; margin: 0px 0px 18px; overflow: hidden; padding: 0px; vertical-align: baseline; word-wrap: break-word;">
<span style="border: 0px none; font-family: inherit; font-size: small; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; outline: none; padding: 0px; vertical-align: baseline;"><br /><a href="https://communities.vmware.com/message/2769358#2769358" name="&lpos=apps_scodevmw : 74" style="border: 0px none; font-family: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; outline: none; padding: 0px; vertical-align: baseline;"><span style="color: #0b5394;">Early Access: VMware Validated Design for NSX-T in a Workload Domain</span></a></span></h1>
<div>
<span style="background-color: white; color: #333333; font-family: "arial" , sans-serif;"><a href="https://communities.vmware.com/thread/588236" style="font-size: 14px;">https://communities.vmware.com/thread/588236</a><br /><br /><span style="font-size: 14px;"><br /></span></span><br />
<span style="background-color: white; font-family: "arial" , sans-serif;"><span style="font-size: 14px;"><b><span style="color: #0b5394;">NSX REST API Guide</span></b></span><br /><br /><span style="color: #333333; font-size: 14px;"><a href="https://www.vmware.com/support/nsxt/doc/nsxt_20_api.html">https://www.vmware.com/support/nsxt/doc/nsxt_20_api.html</a> </span><br /><br /><span style="color: #333333; font-size: 14px;">Please provide an update to the article and I will update it at my earliest.</span><br /><br /><span style="color: #333333; font-size: 14px;">There are some other information also I am waiting on currently so I will update them as well once confirmed.</span><br /><br /><span style="color: #333333; font-size: 14px;">Thank you for your time and please share and care.</span><br /><br /><span style="color: #333333; font-size: 14px;">Have a nice day !!</span></span></div>
</div>
mandivshttp://www.blogger.com/profile/00901843395280966609noreply@blogger.com0tag:blogger.com,1999:blog-7539481448228753383.post-18025231759588608542017-05-08T13:42:00.004-04:002017-05-08T14:29:53.892-04:00NSX Firewall Rules using Application Rule Manager (ARM)Hi All,<br />
<br />
Recently I was engaged in a project for NSX Brownfield deployment and the requirement was to migrate the citrix environment to VMware Horizon View desktops.<br />
<br />
So the challenge we had was to find out what is in use by the Citrix VMs in the existing environment from the service/port perspective so it will be easier to find out the communication path between twoVMs (for test for now) but it can be scaled all the way to the cluster level if needs to.<br />
<br />
So there are few ways this can be achieved and I will cover the same in the series of 3 parts.<br />
<br />
1) Using ARM (Application Rule Manager) which will be covered in this post<br />
2) Using vRNI (vRealize Network Insight) which will be the next post<br />
3) Using LI (vRealize Log Insight) which will be the last post of this series<br />
<br />
So lets get started.<br />
<br />
We are running the latest NSX Manager version 6.3.1.<br />
<br />
Now I assume that the readers are familiar with NSX Manager and other components of VMware vSphere as I will be using the terminologies quite frequently and also the acronyms of the same.<br />
<br />
<br />
So once you go to Networking and Security and you need to click on Flow Monitoring to see the option of application Rule Manager<br />
<br />
Im showing here the screen shot of the same.<br />
<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://4.bp.blogspot.com/-98nALCFjVmM/WRCoqsqJq5I/AAAAAAAAwHk/MzPoVjd1BVkMjFbWxW5VN1fBh9plHs-8gCLcB/s1600/arm-1-2017-05-08_12-18-21.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="372" src="https://4.bp.blogspot.com/-98nALCFjVmM/WRCoqsqJq5I/AAAAAAAAwHk/MzPoVjd1BVkMjFbWxW5VN1fBh9plHs-8gCLcB/s640/arm-1-2017-05-08_12-18-21.jpg" width="640" /></a></div>
<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
Then you need to generate the flows by doing certain activities to invoke the traffic to use particular ports / services.<br />
<br />
So now lets dig deeper in to ARM.<br />
<br />
lets say I want to know the flows between two VMs so I will start with New Session and then give a name to the session.<br />
<br />
Next option is to select the source and here you have only two options to choose from as a Object Type<br />
<br />
1) Virtual Machine<br />
<br />
2) vNIC<br />
<br />
So I will go with VM and provide a name of the VM.<br />
<br />
Thats the only thing you need to provide and once you click OK then it will start gathering the flows from the VM.<br />
<br />
<a href="https://4.bp.blogspot.com/-gvjNUR8gIe4/WRCqBaHyc3I/AAAAAAAAwHw/P1rAT3iLEnoKQF1wk35obYjqD2yLL3YngCLcB/s1600/arm-2-2017-05-08_12-22-10.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em; text-align: center;"><img border="0" height="218" src="https://4.bp.blogspot.com/-gvjNUR8gIe4/WRCqBaHyc3I/AAAAAAAAwHw/P1rAT3iLEnoKQF1wk35obYjqD2yLL3YngCLcB/s400/arm-2-2017-05-08_12-22-10.jpg" width="400" /></a><br />
<br />
<br />
Now click Stop to finish collecting the flows and once you highlight any flows under the View Flows option then you will see two options under Actions.<br />
<br />
<a href="https://1.bp.blogspot.com/-yjE1ppmjCnI/WRCqllYuS_I/AAAAAAAAwH4/cAUSlDjACYwptdyTxXQClIOUE2MggqX2ACEw/s1600/arm-3-2017-05-08_12-25-16.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em; text-align: center;"><img border="0" height="193" src="https://1.bp.blogspot.com/-yjE1ppmjCnI/WRCqllYuS_I/AAAAAAAAwH4/cAUSlDjACYwptdyTxXQClIOUE2MggqX2ACEw/s400/arm-3-2017-05-08_12-25-16.jpg" width="400" /></a><br />
<br />
<br />
<br />
So either you can hide records or you can create a Firewall Rule based on the flow captured.<br />
<br />
After I selected Create Firewall Rule, then I will go to the tab "Firewall Rules" and check what rule is created.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://3.bp.blogspot.com/-VveGNLVfXDk/WRCrjAwTaNI/AAAAAAAAwIA/L52FWMyZH2YJ64eX3WflKX10xv2mN33oACLcB/s1600/arm-4-2017-05-08_12-31-51.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="194" src="https://3.bp.blogspot.com/-VveGNLVfXDk/WRCrjAwTaNI/AAAAAAAAwIA/L52FWMyZH2YJ64eX3WflKX10xv2mN33oACLcB/s640/arm-4-2017-05-08_12-31-51.jpg" width="640" /></a></div>
<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
So before you publish the rule you can modify the Rule with necessary details e,g Source, Destination, Service, Applied To, Action and Log.<br />
<br />
You can create multiple sessions and just select the drop down to see/view specific Flow details about a particular session.<br />
<br />
Name the session properly so you can see what you have captured. In the above screen shot as you can see I've given the name tst-h-ic-blk which I provided to find out the icmp block for horizon and the rule is test rule.<br />
<br />
You can keep the name with the function of the VM/server you are going to create the firewall rule for, so it will be easier to understand take actions on the particular rule set.<br />
<br />
<br />
<br />
<a href="https://3.bp.blogspot.com/-paxZKqG3ttQ/WRCs2jpDy8I/AAAAAAAAwIM/NPBHbQkhpmowryowawxKak0kb3qQSSJrgCLcB/s1600/arm-5-2017-05-08_12-37-11.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em; text-align: center;"><img border="0" height="400" src="https://3.bp.blogspot.com/-paxZKqG3ttQ/WRCs2jpDy8I/AAAAAAAAwIM/NPBHbQkhpmowryowawxKak0kb3qQSSJrgCLcB/s400/arm-5-2017-05-08_12-37-11.jpg" width="295" /></a><br />
<br />
Once you create the rule then you need to go the Firewall Rule tab and publish it and it will be immediately come in to the effect. Which you can verify under Firewall section on the left.<br />
<br />
<a href="https://3.bp.blogspot.com/-OsuR9qnMYKw/WRCtXMyi68I/AAAAAAAAwIQ/t4SO2Z_P6LUmX1sNyFkJ4IxZsEOJjcr8wCLcB/s1600/arm-6-2017-05-08_12-39-51.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em; text-align: center;"><img border="0" height="82" src="https://3.bp.blogspot.com/-OsuR9qnMYKw/WRCtXMyi68I/AAAAAAAAwIQ/t4SO2Z_P6LUmX1sNyFkJ4IxZsEOJjcr8wCLcB/s400/arm-6-2017-05-08_12-39-51.jpg" width="400" /></a><br />
<br />
<br />
So as you can see, it will be added as a new Section to give the name to the rule properly so it will be meaningful.<br />
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
If there are more than one service you can see in the flow then click on the small gear icon on the right besides the services and you can see all the services captured.<br />
<br />
<a href="https://3.bp.blogspot.com/-uZtcZzpqzSg/WRCzXNHrFvI/AAAAAAAAwIg/ZOu8XenLbBQcZIIGJXqzvDFvtZu_ZqxVwCLcB/s1600/arm-7-2017-05-08_13-04-18.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em; text-align: center;"><img border="0" height="320" src="https://3.bp.blogspot.com/-uZtcZzpqzSg/WRCzXNHrFvI/AAAAAAAAwIg/ZOu8XenLbBQcZIIGJXqzvDFvtZu_ZqxVwCLcB/s320/arm-7-2017-05-08_13-04-18.jpg" width="288" /></a><br />
<br />
<br />
Now from the product use perspective this will be a trouble when you have to find out the traffic patterns on a large environment (having no other options of at the cluster level or host level options) so you have only one choice of finding out per VM basis and then go thro each flow collected and create the rule/s.<br />
<br />
May be I can suggest a feature request to VMware about incorporating other options when dealing with multiple items and have a single option to create Firewall rule / rules based on the collected flows. This can be based on the at the Data Center/ Cluster Level which can be considered in aggregation of all the flows captured.<br />
<br />
It will help the Admin of the environment to allow the default communication ports which got captured after running the flow capturing for enough duration which will allow to capture all possible traffic coming from X and going to Y or Z.<br />
<br />
Hoping that in next version this improvement will get incorporated to ease the process of utilizing only ARM to recommend the rules and go with the same.<br />
<br />
Hope this helps.<br />
<br />
In Next post I will cover vRNI to find out how you can utilize the same to create Firewall Rule/s.<br />
<br />
Please share and care.<br />
<br />
Thanks for your time.mandivshttp://www.blogger.com/profile/00901843395280966609noreply@blogger.com0tag:blogger.com,1999:blog-7539481448228753383.post-90023203667427548402017-04-03T17:23:00.001-04:002017-04-03T17:23:19.325-04:00vMotion of NSX EDGE gotcha<a href="http://virtualpatel.blogspot.com/2017/04/vmotion-of-nsx-edge-gotcha.html?spref=bl">virtualpatel.blogspot.com: vMotion of NSX EDGE gotcha</a>: Hi, Recently I was working on a brown field deployment of NSX and ran into an issue where we were not able to connect to the DHCP server ...mandivshttp://www.blogger.com/profile/00901843395280966609noreply@blogger.com0tag:blogger.com,1999:blog-7539481448228753383.post-4987677196580513192017-04-03T17:05:00.000-04:002017-04-03T17:05:01.285-04:00vMotion of NSX EDGE gotchaHi,<div>
<br /></div>
<div>
Recently I was working on a brown field deployment of NSX and ran into an issue where we were not able to connect to the DHCP server from a Logical Switch (which means the VMs are not getting IP addresses from DHCP server) which was a key.</div>
<div>
<br /></div>
<div>
If we put the VM on a regular VDS dvportgroup it gets the DHCP IP correctly.</div>
<div>
<br /></div>
<div>
So we started looking in to the issue further and engage VMware GSS to look in to the issue.</div>
<div>
<br /></div>
<div>
During the troubleshooting we had to decide the location of Edge and try moving it to a different host to verify if its not hitting any uplink issue.</div>
<div>
<br /></div>
<div>
As we were using vCenter Web Client and as soon as we tried migrating (vMotion) it to another host and we were prompted with the NIC mapping page. Where we need to map each interface exists on the NSX Edge to a corresponding portgroup or dvportgroup. Now we have only limited number of portgroups/dvportgroups existed on the Cluster and we could not map all the internal interfaces (which gets created by default on the Edge appliance).<br /><br />The source were listed as "None" so not sure where to map them.</div>
<div>
<br /></div>
<div>
So we ended up using the vSphere client to migrate the Edge appliance, and boom....it got migrated with no notification about mapping all the interfaces. Just select the destination ESXi host and hit "Finish", and we are done.</div>
<div>
<br /></div>
<div>
We were then moved into the next phase of troubleshooting but the above just put me in a dilemma that the behaviour of Web Client is a bug or is it by design.</div>
<div>
<br /></div>
<div>
Interested in getting the answer from VMware so that I can clarify that with the existing and future customers on why to use vSphere client and what is the alternate methods to use when the Fat/Thick client will completely got removed by VMware??</div>
<div>
<br /></div>
<div>
Please leave the comment and share this.</div>
<div>
<br /></div>
<div>
Thanks for your time.</div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
mandivshttp://www.blogger.com/profile/00901843395280966609noreply@blogger.com1tag:blogger.com,1999:blog-7539481448228753383.post-40832596184905484332017-01-03T21:36:00.001-05:002017-01-03T21:36:45.636-05:00vRA and SCCM Timeout Issue<a href="http://virtualpatel.blogspot.com/2017/01/vra-and-sccm-timeout-issue.html?spref=bl">virtualpatel.blogspot.com: vRA and SCCM Timeout Issue</a>: Hi, OK here I am again. Been away for few months working on various projects including vRA, vROPS, SRM, VIN, vRB etc.etc. And one of the...mandivshttp://www.blogger.com/profile/00901843395280966609noreply@blogger.com0tag:blogger.com,1999:blog-7539481448228753383.post-16331359347918105312017-01-03T21:35:00.000-05:002017-01-03T21:35:32.111-05:00vRA and SCCM Timeout IssueHi,<br />
<div>
<br /></div>
<div>
OK here I am again. Been away for few months working on various projects including vRA, vROPS, SRM, VIN, vRB etc.etc. And one of them is MSB. Yes its a new term I've learned and worked on with one of the Federal client along with VMware NSBU. </div>
<div>
<br /></div>
<div>
But here today I'm going to discuss about the timeout issue with vRA and SCCM deployment.</div>
<div>
<br /></div>
<div>
Now before we begin let me give you the overview of what we are dealing with.</div>
<div>
<br /></div>
<div>
In my recent project Im working with VMware on a vRA Distributed architecture with a little bit of vRB and also integrating the SCCM on which the client is heaving depending on for VM/s deployment. </div>
<div>
<br /></div>
<div>
Mainly these are windows 2008 R2 Std and Windows 2012 R2 Std VMs. They are leveraging SCCM to do all major tasks such as putting patches, updates, updating AV signatures, putting legacy apps, some monitoring apps such as WhatsupGold and Logrhythm etc. etc. <br />
<br />
<br />
<br />
So once the VM is built in vRA its been handed over to SCCM for further provisioning and there is a default time out setting in vRA which is only 15 minutes.</div>
<div>
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://3.bp.blogspot.com/-tfiOAQReZTA/WCtHzGFTmsI/AAAAAAAAvnQ/ibWQUb_2agM8FKa0wb99b_DRRHml-DpZACLcB/s1600/global-config-default.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="286" src="https://3.bp.blogspot.com/-tfiOAQReZTA/WCtHzGFTmsI/AAAAAAAAvnQ/ibWQUb_2agM8FKa0wb99b_DRRHml-DpZACLcB/s640/global-config-default.png" width="640" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="text-align: start;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<span style="text-align: start;"><br /></span></div>
<div class="separator" style="clear: both; text-align: justify;">
<span style="text-align: start;">So as you can see the default setting for SCCM machine registration timeout is 5 minutes. So now</span></div>
<div class="separator" style="clear: both; text-align: justify;">
<span style="text-align: start;">lets assume you are doing few tasks using SCCM e.g. Installing OS, putting patches, doing AV updates, putting legacy or custom applications or softwares etc. etc. then you need time to finish all those tasks in the background on SCCM side. With having 5 minutes timeout vRA wont know what is the status of the SCCM VM as the whole process may not be finished and the gugent might not be updating vRA with any status at all so you may see the process/task in vRA as its still running and not completed and eventually the task will fail as no signal received by vRA in time (which is 5 minutes). So to avoid that you need to increase that time out setting by enough time that you can finish the required tasks on SCCM side before hitting the timeout window of vRA. We had to keep it at 45 minutes (screen shot below) on a safer side which accounts few reboots of the OS along with other tasks listed above.</span></div>
<div>
<div class="separator" style="clear: both; text-align: justify;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://4.bp.blogspot.com/-0ODmJ5zhQiA/WGxeWGcYFoI/AAAAAAAAvzk/-g8YLL5U67Ax1RdOMy0iAxrarKPYmgSXwCLcB/s1600/global-config-changed.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="326" src="https://4.bp.blogspot.com/-0ODmJ5zhQiA/WGxeWGcYFoI/AAAAAAAAvzk/-g8YLL5U67Ax1RdOMy0iAxrarKPYmgSXwCLcB/s640/global-config-changed.png" width="640" /></a></div>
<br /><br />After doing the above change we were started receiving finished tasks in vRA successfully which were handled by SCCM then gugent updates vRA server with appropriate status.<br />
<br />
I will cover the SCCM and vRA in one of my upcoming blogs very soon.<br /><br />Hope this will help integrating SCCM and vRA.<br />
<br />
Please share and care.<br /><br />Thanks for your time.<br />
<br />
<br /></div>
mandivshttp://www.blogger.com/profile/00901843395280966609noreply@blogger.com0tag:blogger.com,1999:blog-7539481448228753383.post-29002690414858994582016-05-13T15:27:00.001-04:002016-05-13T15:27:35.047-04:00[Updated] Request to extend a chance for VCDX5<a href="http://virtualpatel.blogspot.com/2015/08/request-to-extend-chance-for-vcdx5.html?spref=bl">virtualpatel.blogspot.com: Request to extend a chance for VCDX5</a>: Hi, I am taking the Liberty here to request VMware Education to extend the chance for Appearing a VCDX 5 Defense after the schedule of Oc...mandivshttp://www.blogger.com/profile/00901843395280966609noreply@blogger.com0tag:blogger.com,1999:blog-7539481448228753383.post-20033842054912841632016-05-03T13:39:00.004-04:002016-05-03T13:39:37.120-04:00New VMware NSX Licensing Scheme is released<a href="http://virtualpatel.blogspot.com/2016/05/new-vmware-nsx-licensing-scheme-is.html?spref=bl">virtualpatel.blogspot.com: New VMware NSX Licensing Scheme is released</a>: Hi all, VMware just announced the new NSX Licensing scheme so please read the FAQ here which has all the preliminary information without...mandivshttp://www.blogger.com/profile/00901843395280966609noreply@blogger.com0tag:blogger.com,1999:blog-7539481448228753383.post-36234145507809815802016-05-03T13:39:00.002-04:002016-05-03T13:39:22.722-04:00New VMware NSX Licensing Scheme is released <div dir="ltr" style="text-align: left;" trbidi="on">
Hi all,<br />
<br />
VMware just announced the new <a href="http://www.vmware.com/products/nsx/compare.html">NSX Licensing scheme</a> so please read the <a href="http://www.vmware.com/files/pdf/products/nsx/vmware-nsx-editions-faq.pdf">FAQ </a>here which has all the preliminary information without even getting panicked and also get in touch with your sales person (assigned to your account) which will give you the better idea.<br />
<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://2.bp.blogspot.com/-rWoyKwudg_g/VyjeUkrgJsI/AAAAAAAAdhE/7NXV5RABIaUdWnAtcSa1nmW-xw9gAJeMACLcB/s1600/nsx-5-3-2016%2B12-16-35%2BPM.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="486" src="https://2.bp.blogspot.com/-rWoyKwudg_g/VyjeUkrgJsI/AAAAAAAAdhE/7NXV5RABIaUdWnAtcSa1nmW-xw9gAJeMACLcB/s640/nsx-5-3-2016%2B12-16-35%2BPM.jpg" width="640" /></a></div>
<br />
<br />
So by looking at this the most suitable one for any small to mid size organization is the "Advanced" version which has mostly all the bells and whistles except the multi site and Cross VC functionalities.<br />
<br />
Its a simple math when making the decisions on what the organization wants. If its ready to spend money to connect their geographically dispersed locations then Enterprise edition is the only choice.<br />
<br />
To promote open stack the standard Edition is having the support for it. Home Lab people might have to go for the Standard Edition depending on the price of it as I'm sure it wont be affordable to choose the Advanced or Enterprise version.<br />
<br />
IPSEC and SSL VPN are part of Enterprise which is rising a question on just using L2VPN when normal organization have staff people who are connecting remotely using their MAC/WIN/*NIX machines. So even for that feature they need to go for Enterprise version. Hoping that this should be part of Advanced and NOT Enterprise but lets see what the future might hold.<br />
<br />
All the remote features are part of Enterprise which is nice as if you don't need it you don't buy them.<br />
<br />
There is no indication on pricing done as the pointer was set to contact the Sales person but even a hint should be fine on the pricing model or even if one has to use just one feature from other edition then what is the cost involved in that (rather than switching from one edition to another completely).<br />
<br />
Home Lab people will surely need most of the features to test and try out various scenarios but not sure what will happen in that area unless the person is a vExpert, then its a different story.<br />
<br />
This granular model looks adaptive but the pricing model will tell us more on how people feel about it. I just heard that it will be based on 1K per socket but I would not go with it unless it come from a valid source or from VMware itself. So hoping something should be publicly available which will give an idea to the large audience.<br />
<br />
Share and care !<br />
<br />
Thanks for your time.<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br /></div>
mandivshttp://www.blogger.com/profile/00901843395280966609noreply@blogger.com0tag:blogger.com,1999:blog-7539481448228753383.post-47931190646681264552016-03-24T22:14:00.001-04:002016-03-24T22:14:40.343-04:00Another VCIX-NV Fiasco at Pearson Vue<a href="http://virtualpatel.blogspot.com/2016/03/another-vcix-nv-fiasco-at-pearson-vue.html?spref=bl">virtualpatel.blogspot.com: Another VCIX-NV Fiasco at Pearson Vue</a>: Hi All, I blogged about my first experience in Jan. 2015 after appearing for this VCIX-NV Exam at Pearson Vue test center. Just came ...mandivshttp://www.blogger.com/profile/00901843395280966609noreply@blogger.com0tag:blogger.com,1999:blog-7539481448228753383.post-13120514092320811702016-03-24T22:11:00.003-04:002016-03-25T22:04:50.147-04:00Another VCIX-NV Fiasco at Pearson Vue <div dir="ltr" style="text-align: left;" trbidi="on">
<div>
Hi All,</div>
<div>
<br /></div>
<div>
I blogged about my <a href="http://virtualpatel.blogspot.com/2015/01/vcix-nv-resources-and-lab-latency.html">first experience</a> in Jan. 2015 after appearing for this VCIX-NV Exam at Pearson Vue test center. Just came back home after having a very disappointing exam experience at Pearson Vue Exam center and thought to just write about it to have it properly fixed by both parties.</div>
<div>
<br /></div>
<div>
Today I went for VCIX-NV (VCXN610) after confirming my appointment yesterday. Drove 30 mins to get there and finished the security procedures on time. Proctor took me inside the exam room and logged me in for the exam and I've started the exam and first surprise, "can't even login to Control Center"...booooom. This happened to me for the first time as appeared for the other similar exams before (e.g. VCAP exams), but never had this exact issue.</div>
<div>
<br /></div>
<div>
Soon after reading the error, raised the hand,and proctor came and he stopped the exam, called the support person right away. After 10 mins of remote troubleshooting, they gave a green signal to proceed as its been checked by the support person so Proctor gave me the credit of lost time and I've started the exam again and same thing happened again, the RDP connection was not setting up to the Control Center and getting the same error "Contact the Testing center administrator or VSS administrator". Called the proctor again.</div>
<div>
<br /></div>
<div>
As the testing was NOT done properly by the support person (who was from Pearson), now Pearson Vue support person engaged VMware Certification support person on the phone. He tried and couldn't fix the powercli error and decided to move me to another station and start the exam again. </div>
<div>
I started on a different station and it took 20-30 seconds just to connect to Control Center through RDP session (or their jump box). Once logged in opened firefox browser and opened few tabs to work optimally to do multitasking. But later realized that was a bad move.</div>
<div>
<br /></div>
<div>
Latency was all over the place and also a square grid was coming up on the whole screen which was not clearing even after refreshing the screen or changing tabs in the browser. The whole connection is so sluggish and feels like its running on 14.4 Kbps modem connection as you can see the page is loading frame by frame. Upon asking Pearson Vue representative, he mentioned that that is being handled by VMware Certification and its in their Lab Latency so they cant do anything locally about it. Even when switching between the tabs n the browser the screen does NOT even load within few seconds. I did not expect this and I am sure if I continued with it and could not even finish 5 questions within the whole Exam Time.</div>
<div>
<br /></div>
<div>
So I called the proctor and he stopped the lab again. He called the Pearson support again and who in turn engaged VMware support. The whole circle started again and no "corner" of resolution found as its a circle.</div>
<div>
<br /></div>
<div>
And while waiting to hear back from the support staff, it's already more than an hour from the start time and I could not even connect properly to the Lab Infrastructure, so they gave me the incident number and asked to reschedule the exam. Glad I did not have to pay for the exam again as there is a policy they have where, if they cant fix the technical issue within 30 mins then, attempt is not considered and candidate can appear for that exam again at the next available schedule.</div>
<div>
<br /></div>
<div>
Now the trouble not stopped here..called up Pearson Vue after coming out of the center as they dont want to call the scheduling staff and I could not even call them from within the center. I just dont wanted to keep the matter in limbo after leaving the testing center but the proctor suggested that with the incident number the scheduling co ordinator should be able to pull up your details and help you reschedule the exam. So I called up and got a person who informed me that their system is in under maintenance, please try calling again after 15 mins.</div>
<div>
<br /></div>
<div>
Tried calling 4 times on 15 mins interval but and their system was still down and no one could help me to reschedule as they don't have ETA from their IT Team. Finally decided to call once reached (after 45 mins of drive) home, and now on hold for more than 1.45 mins and yet no one is available to take the call. Still listening to their hold music. </div>
<div>
<br /></div>
<div>
What a latest technology Pearson is having that no outbound calls allowed to notify the caller on when the system will be in working status or even to just send an email to the caller that system is back up so please call in to reschedule. Now that the call center moved to India, not sure how they are going to attend the callers after their system maintenance with increased inbound calls.</div>
<div>
<br /></div>
<div>
No IVR notification about "system maintenance for exam rescheduling" so that the caller can just listen to it and hung up without wasting time to get the rep on the phone and then he verifies the identity and eventually states the system is down.</div>
<div>
<br /></div>
<div>
And on top of that each time you call you must listen to their 3-4 mins of greeting and there is no way to skip it either. So looks like Pearson Vue believes, everyone else have free time so really no care been taken. Recent changes of merging with VMware Certification, not sure how the portal looks like or which features are available but will find out soon once they finished the merge as still don't see "Manage Account" or "Schedule Exam" buttons under myVMware portal.</div>
<div>
<br /></div>
<div>
Now in this whole waiting game. my personal schedules are totally messed up and which affected my daughters class schedules too and I'm sure Pearson won't do anything about it. If they really care then someone may call and at least discuss about the hassles I had to go through and offer something to make a better future experience/service. And I am sure its not a lot I am asking :-).</div>
<div>
</div>
<div>
Already ranted once about the latency in 2014 when I gave the exam for the first time. But both, Certification team at VMware and Pearson have to really think about some solid solution as I'm sure this is not the first time happening or I'm not the only one faced the issues multiple times with exam scheduling/rescheduling and Lab latency.</div>
<div>
<br /></div>
<div>
Its hard to believe that this is not even 1% of what they are able to do with the technology available on their hands in today's world.</div>
<div>
<br /></div>
<div>
I am going through just plain simple "pain". Irony is even after a year, we are still at the same status with Pearson Vue and nothing improved from the user experience perspective nor in the area of stability of the lab environment. They point to VMware when the issue occurs, so my request here is to sort this out for a vast community out there who are using their technology to make the career and sustain the family or for any other valid/genuine purpose. Please respect people time and money they are investing and don't let them go through this situations as I am sure this can be solved by putting necessary efforts and if required, I am ready to provide feedback and can also request other members of VMware community to come up and do the same.</div>
<div>
<br /></div>
<div>
At this time still waiting on the phone after 2.30 hours of hold time as need to get this exam rescheduled and not sure which date will be available at the soonest. Hopefully by tomorrow I will get someone as cant hold overnight :-).<br />
<br />
===<br />
<br />
<b><span style="color: red;">Update:</span></b><br />
To my surprise I just now received the Exam Score Report even if I did not attempt a single question, and still was able to score 100 marks.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://3.bp.blogspot.com/-Oux7Mb4C6H8/VvShMeq9amI/AAAAAAAAdco/XVQqAuellIUTpR_IP3zbakzgAlswmwwuA/s1600/vcix-nv-3-24-2016%2B9-20-00%2BPM.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="125" src="https://3.bp.blogspot.com/-Oux7Mb4C6H8/VvShMeq9amI/AAAAAAAAdco/XVQqAuellIUTpR_IP3zbakzgAlswmwwuA/s400/vcix-nv-3-24-2016%2B9-20-00%2BPM.jpg" width="400" /></a></div>
<br />
This doesn't look right to me and needs to be fixed.</div>
<div>
<br />
<b><span style="color: blue;"><u>Update (at 3.15 p.m. CST):</u></span></b><br />
<br />
So a responsible Program Manager of Pearson called me today morning who read this blog post too, and assured to take care of the issue through his back channel at VMware.<br />
<br />
In the mean time as per their policy I had to contact VMware Team who issued me a Voucher and I rebooked the Exam for April at the same center. So hoping VMware will fix the issue specifically for this exam before that day by doing required testing and investigation.<br />
<br /></div>
<div>
Thank you for your time.<br />
<br />
Please share and care !</div>
<div>
<br /></div>
</div>
mandivshttp://www.blogger.com/profile/00901843395280966609noreply@blogger.com1tag:blogger.com,1999:blog-7539481448228753383.post-70443164959774659602016-02-05T12:00:00.001-05:002016-02-05T12:00:22.846-05:00vExpert 2016<a href="http://virtualpatel.blogspot.com/2016/02/vexpert-2016.html?spref=bl">virtualpatel.blogspot.com: vExpert 2016</a>: Hi, By now the news is already spread in the community and everyone knows who is the vExpert for 2016. I am really thankful to the VMwa...mandivshttp://www.blogger.com/profile/00901843395280966609noreply@blogger.com0tag:blogger.com,1999:blog-7539481448228753383.post-3074685278381505272016-02-05T11:58:00.001-05:002016-02-05T11:58:17.215-05:00vExpert 2016<div dir="ltr" style="text-align: left;" trbidi="on">
Hi,<br />
<br />
By now the news is already spread in the community and everyone knows who is the vExpert for 2016.<br />
<br />
I am really thankful to the VMware Community and the Program Manager Corey Romero (<a href="https://twitter.com/vCommunityGuy">@vCommunityGuy</a>) who made this possible with his and his team's enormous efforts every year.<br />
<br />
<a href="https://blogs.vmware.com/vmtn/2016/02/vexpert-2016-award-announcement.html">https://blogs.vmware.com/vmtn/2016/02/vexpert-2016-award-announcement.html</a><br />
<br />
One can visit the above link and check out who made it to the list.<br />
<br />
This is 4th year for me and its really amazing to see how much the program grown up.<br />
<br />
With more than 1300+ vExpert this year which is making the program at the top.<br />
<br />
Wishing all the vExpert Congratulations and good luck for next year.<br />
<br />
Share and care !!<br />
<br />
Cheers.<br />
<br />
<br />
<br />
<br />
<br />
<br /></div>
mandivshttp://www.blogger.com/profile/00901843395280966609noreply@blogger.com0tag:blogger.com,1999:blog-7539481448228753383.post-40165671003840551292016-01-29T22:45:00.002-05:002016-01-29T22:45:18.017-05:00Cisco Champion 2016<a href="http://virtualpatel.blogspot.com/2016/01/cisco-champion-2016.html?spref=bl">virtualpatel.blogspot.com: Cisco Champion 2016</a>: Hello, I was just working on something and suddenly saw an email landing in my Inbox with a Title of " Welcome 2016 Cisco Champion...mandivshttp://www.blogger.com/profile/00901843395280966609noreply@blogger.com0tag:blogger.com,1999:blog-7539481448228753383.post-59332061001774459222016-01-29T22:45:00.000-05:002016-01-29T22:47:27.595-05:00Cisco Champion 2016<div dir="ltr" style="text-align: left;" trbidi="on">
Hello,<br />
<br />
I was just working on something and suddenly saw an email landing in my Inbox with a Title of<br />
<br />
<b>"<span style="background-color: white; color: #222222; font-family: "arial" , sans-serif; font-size: inherit;">Welcome 2016 Cisco Champions!"</span></b><br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://2.bp.blogspot.com/-4yJ4kZ9nY3Q/VqwyPuYsM4I/AAAAAAAAdX0/JIExN5X7g20/s1600/image001.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="95" src="http://2.bp.blogspot.com/-4yJ4kZ9nY3Q/VqwyPuYsM4I/AAAAAAAAdX0/JIExN5X7g20/s400/image001.jpg" width="400" /></a></div>
<br />
<br />
So for a second, I thought the result was not announced so what it should be ?<br />
<br />
Curiosity drove me to open the mail and indeed it was the email from the Cisco Community Program Manager and the Team.<br />
<br />
<span style="background-color: white; color: #222222;"><span style="font-family: "times" , "times new roman" , serif;">Brandon Prebynski (<a href="http://www.twitter.com/prebynski">@prebynski</a>), Program Manager</span></span><br />
<div style="background-color: white; color: #222222;">
<span style="font-family: "times" , "times new roman" , serif;"><u></u></span></div>
<div style="background-color: white; color: #222222;">
<span style="font-family: "times" , "times new roman" , serif;"><br /></span></div>
<div style="background-color: white; color: #222222;">
<span style="font-family: "times" , "times new roman" , serif;">Lauren Friedman (<a href="http://www.twitter.com/lauren">@lauren)</a>, DC, EN, Cloud, IOT Lead<u></u><u></u></span></div>
<div style="background-color: white; color: #222222;">
<span style="font-family: "times" , "times new roman" , serif;"><br /></span></div>
<div style="background-color: white; color: #222222;">
<span style="font-family: "times" , "times new roman" , serif;">Kim Austin (<a href="http://www.twitter.com/ciscokima">@ciscokima</a>), Collaboration Lead<u></u><u></u></span></div>
<div style="background-color: white; color: #222222;">
<span style="font-family: "times" , "times new roman" , serif;"><br /></span></div>
<div style="background-color: white; color: #222222;">
<span style="font-family: "times" , "times new roman" , serif;">Brian Remmel (<a href="http://www.twitter.com/bremmel">@bremmel</a>), Security Lead</span></div>
<div style="background-color: white; color: #222222; font-family: arial, sans-serif; font-size: 12.8px;">
<br /></div>
<div style="background-color: white; color: #222222; font-family: arial, sans-serif; font-size: 12.8px;">
<br /></div>
I was awarded for 2015 and now for 2016 so this is my 2nd year getting this Award.<br />
<br />
I am really thankful to the Team and the Program Manager Brandon, for giving me such recognition and hopefully continue to contribute more and more for the community.<br />
<br />
Wish all other Cisco Champions who made to the list of 2016.<br />
<br />
I may know some and may not others but when it comes to the community contribution, it really doesn't matter who, where, why, how?<br />
<br />
I am doing similar contribution for other communities as well which is keeping me strong and helping people out is a major objective here which helps me being consistent.<br />
<br />
Hopefully see all Cisco Champions some time at some event and wishing everyone Good luck for 2017.<br />
<br />
Cheers...<br />
<br />
Share and care !<br />
<div>
<br /></div>
</div>
mandivshttp://www.blogger.com/profile/00901843395280966609noreply@blogger.com0tag:blogger.com,1999:blog-7539481448228753383.post-25455457813699306702015-12-17T20:21:00.001-05:002015-12-17T20:21:32.702-05:00vCenter Server Maintenance Best Practices<a href="http://virtualpatel.blogspot.com/2015/12/vcenter-server-maintenance-best.html?spref=bl">virtualpatel.blogspot.com: vCenter Server Maintenance Best Practices</a>: vCenter Server Maintenance Best Practices I was trying to find best practices for vCenter Server maintenance which shou...mandivshttp://www.blogger.com/profile/00901843395280966609noreply@blogger.com0tag:blogger.com,1999:blog-7539481448228753383.post-42096916704117641252015-12-17T17:40:00.004-05:002018-03-30T10:47:20.877-04:00vCenter Server Maintenance Best Practices<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="MsoNormal" style="margin-bottom: .0001pt; margin-bottom: 0in; text-align: center;">
<div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: center;">
<b></b><br />
<div style="text-align: justify;">
<b><b></b></b><br />
<div style="text-align: left;">
<b><b><b style="text-align: center;"></b></b></b></div>
<b><b>
</b></b></div>
<br />
<div style="display: inline !important; text-align: justify;">
<b><span style="line-height: 115%;"><span style="font-size: large;">vCenter Server Maintenance Best Practices</span></span></b></div>
</div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: left;">
<div style="text-align: left;">
<br /></div>
</div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: left;">
<div style="text-align: left;">
<o:p>I was trying to find best practices for vCenter Server maintenance which should include everything and not just the database. Looking through online public documentation from VMware and other sources I found the following information and compiled in this post. If you feel anything is missing or needs an update then please reach out to me using any available channel and I will modify/update the post.</o:p></div>
</div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: left;">
<div style="text-align: left;">
<o:p><br /></o:p></div>
</div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: left;">
<div style="text-align: left;">
<o:p>While you are at this, you should look at the Database Maintenance plan (if only you are not having anything setup currently) by visiting my friend and a blogger Erik Bussink's (<a href="https://twitter.com/ErikBussink">@ErikBussink</a>) <a href="http://www.bussink.ch/?p=495">blog post</a>.</o:p></div>
</div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: left;">
<div style="text-align: left;">
<o:p><br /></o:p></div>
</div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: left;">
<div style="text-align: left;">
<o:p>Now you can change the frequency depending on the requirements you might have so its not hard coded values posted here. Organization to organization the values may change.</o:p></div>
</div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: left;">
<div style="text-align: left;">
<o:p><br /></o:p></div>
</div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: left;">
<div style="text-align: left;">
<b><i><u><span style="font-size: 18.0pt; line-height: 115%;">Virtual Center Roles <span style="color: red;">(Yearly)</span><o:p></o:p></span></u></i></b></div>
</div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: left;">
<div style="text-align: left;">
<br /></div>
</div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: left;">
<div style="text-align: left;">
• VirtualCenter Administrators: super users who have all privileges on
all systems<o:p></o:p></div>
</div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: left;">
<div style="text-align: left;">
• Virtual Machine Administrators: administrators on a subset of
servers; can perform all operations on their servers, including VM
provisioning, resource allocation and VMotion<o:p></o:p></div>
</div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: left;">
<div style="text-align: left;">
• Virtual Machine User: access to a subset of VMs; can use remote
console, perform power operations, view performance graphs, but cannot
create/delete VMs, set resources or move VMs.<o:p></o:p></div>
</div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: left;">
<div style="text-align: left;">
• Read-Only User: can only view information on a subset of VMs <o:p></o:p></div>
</div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: left;">
<div style="text-align: left;">
• Privilege Management<o:p></o:p></div>
</div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: left;">
<div style="text-align: left;">
• Administrators on the Windows system running the Management Server
are automatically assigned VirtualCenter Administrator privileges<o:p></o:p></div>
</div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: left;">
<div style="text-align: left;">
• VirtualCenter Administrators can delegate privileges to other users
by accessing an existing ActiveDirectory or Domain Controller<o:p></o:p></div>
</div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: left;">
<div style="text-align: left;">
<br /></div>
</div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: left;">
<div style="text-align: left;">
<b><i><u><span style="font-size: 18.0pt; line-height: 115%;">Best Practices for Templates <span style="color: red;">(Quarterly)<o:p></o:p></span></span></u></i></b></div>
</div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: left;">
<div style="text-align: left;">
<br /></div>
</div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: left;">
<div style="text-align: left;">
Virtual
machine templates are very powerful and versatile. The following best
practices, culled from many different areas of IT infrastructure management,
will enable you to derive the most value from templates and avoid starting
ineffective habits.<o:p></o:p></div>
<div style="text-align: left;">
<br /></div>
</div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: left;">
<div style="text-align: left;">
• Install
Antivirus software and keep it up to date: In today’s world of viruses that are
hyper efficient at exploitation and replication, an OS installation routine has
to merely initialize the network subsystem to be vulnerable to attack. By
deploying virtual machines with up to date antivirus protection, this exposure is
limited. Keep the antivirus software current every month by converting the
templates to VMs, powering on, and updating the signature files.<o:p></o:p></div>
</div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: left;">
<div style="text-align: left;">
<br /></div>
<div style="text-align: left;">
• Install
the latest operating system patches, and stay current with the latest releases:
Operating system vulnerabilities and out of date antivirus software can
increase exposure to exploitation significantly, and current antivirus software
isn’t enough to keep exposure to a minimum. When updating a templates antivirus
software, apply any relevant OS patches and hotfixes.<o:p></o:p></div>
</div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: left;">
<br />
<div style="text-align: left;">
• Use the
template notes field to store update records: A good habit to get into is to
keep information about the maintenance of the template in the template itself,
and the Notes field is a great place to keep informal update records.</div>
<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: left;">
<br />
<div style="text-align: left;">
• Plan for
ESX Server capacity for template management: The act of converting a template
to virtual machine, powering it on, accessing the network to obtain updates,
shutting down, and converting back to template requires available ESX Server
resources. Make sure there are ample resources for this very important
activity.</div>
<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: left;">
<br />
<div style="text-align: left;">
• Use a
quarantined network connection for updating templates: The whole point of
keeping antivirus and operating systems up to date is to avoid exploitation, so
leverage the ability of ESX Server to segregate different kinds of network
traffic and apply updates in a quarantined network.</div>
<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: left;">
<br />
<div style="text-align: left;">
• Use the
same datastore for storing templates and for powered on templates: During the
process of converting templates to virtual machines, do not deploy the template
to another datastore. It is faster and more efficient to keep the template’s
files in the same place before and after the update.</div>
<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: left;">
<br />
<div style="text-align: left;">
• Install the VMware Tools in the template: The VMware Tools include
optimized drivers for the virtualized hardware components that use fewer
physical host resources. Installing the VMware Tools in the template saves time
and reduces the chance that a sub optimally configured virtual machine will be
deployed to your production ESX Server infrastructure.</div>
<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: left;">
<br />
<div style="text-align: left;">
• Use a standardized naming convention for templates: Some inventory
panel views do not offer you the opportunity to sort by type, so create a
standard prefix for templates to help you intuitively identify them by sorting
by name. Also, be sure to include enough descriptive information in the
template name to know what is contained in the template.</div>
<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: left;">
<br />
<div style="text-align: left;">
• Defragment the guest OS filesystem before converting to template:
Most operating system installation programs create a highly fragmented
filesystem even before the system begins its useful life. Defragment the OS and
convert to template, and that way you won’t have to worry about it again until
the system has been in production for a while.</div>
<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: left;">
<br />
<div style="text-align: left;">
• Remove Nonpresent Hidden Devices from Templates: This problem will
likely occur only if you about certain devices, notably network devices, even
after they are removed from the system. Refer to Microsoft TechNet article
269155 for removal instructions</div>
<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: left;">
<br />
<div style="text-align: left;">
• Use Folders to Organize and Manage Templates: Folders can be both an
organizational and security container. Use them to keep templates organized and
secure.</div>
<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: left;">
<br />
<div style="text-align: left;">
• Create Active Directory groups that map to VirtualCenter roles:
Rather than assign VirtualCenter roles to individual user accounts, create
dedicated Active Directory groups, and place user accounts in those groups.</div>
<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: left;">
<div style="text-align: left;">
<br /></div>
</div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: left;">
<div style="text-align: left;">
• Store
templates on a shared VMFS volume on the SAN (dedicated LUN) and enable access
to the SAN-based template volume from all ESX servers <o:p></o:p></div>
</div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: left;">
<br />
<div style="text-align: left;">
• SAN templates may only be provisioned to target hosts connected to
SAN</div>
<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: left;">
<br />
<div style="text-align: left;">
• The VC Mgmt Server’s local template repository can be used to
provision VMs onto ESX Servers that are not connected to the SAN</div>
<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: left;">
<br />
<div style="text-align: left;">
• If template deployments to a LUN fail due to SCSI reservations,
increase the “Scsi.ConflictRetries” parameter to a value of “10” through the
Advanced Settings menu</div>
<o:p></o:p></div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: left;">
<div style="text-align: left;">
<br /></div>
</div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: left;">
<b><i><u><span style="font-size: 18.0pt; line-height: 115%;">Roll up Jobs <span style="color: red;">(Quarterly) </span></span></u></i></b><br />
<span style="color: #666666; font-family: "arial" , sans-serif; font-size: 9pt; text-indent: -0.25in;"></span><br />
<div style="text-align: left;">
<span style="color: #666666; font-family: "arial" , sans-serif; font-size: 9pt; text-indent: -0.25in;"><span style="font-size: 9pt;">1.</span><span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal;">
</span></span><span style="color: #666666; font-family: "arial" , sans-serif; font-size: 9pt; text-indent: -0.25in;">Ensure that the jobs
listed in this table are installed:</span></div>
<span style="color: #666666; font-family: "arial" , sans-serif; font-size: 9pt; text-indent: -0.25in;"><span style="font-size: 9pt;">
</span></span></div>
<div style="text-align: left;">
<br /></div>
<div style="text-align: left;">
<div style="text-align: justify;">
<b><b style="text-align: left; text-indent: -0.25in;"><span style="border: none 1.0pt; color: #666666; font-family: "inherit" , "serif"; font-size: 9.0pt; padding: 0in;">Note</span></b><span style="color: #666666; font-family: "arial" , sans-serif; font-size: 9pt; text-align: left; text-indent: -0.25in;">: For managing an
Oracle vCenter Server database, you can use Oracle SQL Developer and for
managing a DB2 vCenter Server database, you can use DB2 Control Center.</span></b><br />
<b><span style="color: #666666; font-family: "arial" , sans-serif; font-size: 9pt; text-align: left; text-indent: -0.25in;"><br /></span></b></div>
</div>
<b>
</b>
<br />
<table border="0" cellpadding="0" cellspacing="0" class="MsoNormalTable" style="border-collapse: collapse; margin-left: .5in; mso-padding-alt: 0in 0in 0in 0in; mso-yfti-tbllook: 1184;">
<tbody>
<tr>
<td style="border: solid black 1.0pt; mso-border-alt: solid black .75pt; padding: 2.25pt 2.25pt 2.25pt 2.25pt;" valign="top"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<b><span style="border: none 1.0pt; font-family: "inherit" , "serif"; font-size: 9.0pt; padding: 0in;">Rollup
Job</span></b><span style="font-family: "arial" , "sans-serif"; font-size: 9.0pt;"><o:p></o:p></span></div>
</td>
<td style="border-left: none; border: solid black 1.0pt; mso-border-alt: solid black .75pt; mso-border-left-alt: solid black .75pt; padding: 2.25pt 2.25pt 2.25pt 2.25pt;" valign="top"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<b><span style="border: none 1.0pt; font-family: "inherit" , "serif"; font-size: 9.0pt; padding: 0in;">Corresponding
File</span></b><span style="font-family: "arial" , "sans-serif"; font-size: 9.0pt;"><o:p></o:p></span></div>
</td>
</tr>
<tr>
<td style="border-top: none; border: solid black 1.0pt; mso-border-alt: solid black .75pt; mso-border-top-alt: solid black .75pt; padding: 2.25pt 2.25pt 2.25pt 2.25pt;" valign="top"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "arial" , "sans-serif"; font-size: 9.0pt;">Event Task Cleanup </span><i><span style="border: none 1.0pt; font-family: "inherit" , "serif"; font-size: 9.0pt; padding: 0in;">myDB</span></i><span style="font-family: "arial" , "sans-serif"; font-size: 9.0pt;"><o:p></o:p></span></div>
</td>
<td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .75pt; mso-border-left-alt: solid black .75pt; mso-border-top-alt: solid black .75pt; padding: 2.25pt 2.25pt 2.25pt 2.25pt;" valign="top"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 9.0pt;">job_cleanup_events_</span><i><span style="border: none 1.0pt; font-family: "inherit" , "serif"; font-size: 9.0pt; padding: 0in;">DB</span></i><span style="font-family: "courier new"; font-size: 9.0pt;">.sql<o:p></o:p></span></div>
</td>
</tr>
<tr>
<td style="border-top: none; border: solid black 1.0pt; mso-border-alt: solid black .75pt; mso-border-top-alt: solid black .75pt; padding: 2.25pt 2.25pt 2.25pt 2.25pt;" valign="top"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "arial" , "sans-serif"; font-size: 9.0pt;">Past Day stats rollup </span><i><span style="border: none 1.0pt; font-family: "inherit" , "serif"; font-size: 9.0pt; padding: 0in;">myDB</span></i><span style="font-family: "arial" , "sans-serif"; font-size: 9.0pt;"><o:p></o:p></span></div>
</td>
<td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .75pt; mso-border-left-alt: solid black .75pt; mso-border-top-alt: solid black .75pt; padding: 2.25pt 2.25pt 2.25pt 2.25pt;" valign="top"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 9.0pt;">job_schedule1_</span><i><span style="border: none 1.0pt; font-family: "inherit" , "serif"; font-size: 9.0pt; padding: 0in;">DB</span></i><span style="font-family: "courier new"; font-size: 9.0pt;">.sql<o:p></o:p></span></div>
</td>
</tr>
<tr>
<td style="border-top: none; border: solid black 1.0pt; mso-border-alt: solid black .75pt; mso-border-top-alt: solid black .75pt; padding: 2.25pt 2.25pt 2.25pt 2.25pt;" valign="top"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "arial" , "sans-serif"; font-size: 9.0pt;">Past Month stats rollup </span><i><span style="border: none 1.0pt; font-family: "inherit" , "serif"; font-size: 9.0pt; padding: 0in;">myDB</span></i><span style="font-family: "arial" , "sans-serif"; font-size: 9.0pt;"><o:p></o:p></span></div>
</td>
<td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .75pt; mso-border-left-alt: solid black .75pt; mso-border-top-alt: solid black .75pt; padding: 2.25pt 2.25pt 2.25pt 2.25pt;" valign="top"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 9.0pt;">job_schedule3_</span><i><span style="border: none 1.0pt; font-family: "inherit" , "serif"; font-size: 9.0pt; padding: 0in;">DB</span></i><span style="font-family: "courier new"; font-size: 9.0pt;">.sql<o:p></o:p></span></div>
</td>
</tr>
<tr>
<td style="border-top: none; border: solid black 1.0pt; mso-border-alt: solid black .75pt; mso-border-top-alt: solid black .75pt; padding: 2.25pt 2.25pt 2.25pt 2.25pt;" valign="top"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "arial" , "sans-serif"; font-size: 9.0pt;">Past Week stats rollup </span><i><span style="border: none 1.0pt; font-family: "inherit" , "serif"; font-size: 9.0pt; padding: 0in;">myDB</span></i><span style="font-family: "arial" , "sans-serif"; font-size: 9.0pt;"><o:p></o:p></span></div>
</td>
<td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .75pt; mso-border-left-alt: solid black .75pt; mso-border-top-alt: solid black .75pt; padding: 2.25pt 2.25pt 2.25pt 2.25pt;" valign="top"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 9.0pt;">job_schedule2_</span><i><span style="border: none 1.0pt; font-family: "inherit" , "serif"; font-size: 9.0pt; padding: 0in;">DB</span></i><span style="font-family: "courier new"; font-size: 9.0pt;">.sql<o:p></o:p></span></div>
</td>
</tr>
<tr>
<td style="border-top: none; border: solid black 1.0pt; mso-border-alt: solid black .75pt; mso-border-top-alt: solid black .75pt; padding: 2.25pt 2.25pt 2.25pt 2.25pt;" valign="top"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "arial" , "sans-serif"; font-size: 9.0pt;">Process Performance Data </span><i><span style="border: none 1.0pt; font-family: "inherit" , "serif"; font-size: 9.0pt; padding: 0in;">myDB</span></i><span style="font-family: "arial" , "sans-serif"; font-size: 9.0pt;"><o:p></o:p></span></div>
</td>
<td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .75pt; mso-border-left-alt: solid black .75pt; mso-border-top-alt: solid black .75pt; padding: 2.25pt 2.25pt 2.25pt 2.25pt;" valign="top"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 9.0pt;">job_dbm_performance_data_</span><i><span style="border: none 1.0pt; font-family: "inherit" , "serif"; font-size: 9.0pt; padding: 0in;">DB</span></i><span style="font-family: "courier new"; font-size: 9.0pt;">.sql<o:p></o:p></span></div>
</td>
</tr>
<tr>
<td style="border-top: none; border: solid black 1.0pt; mso-border-alt: solid black .75pt; mso-border-top-alt: solid black .75pt; padding: 2.25pt 2.25pt 2.25pt 2.25pt;" valign="top"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "arial" , "sans-serif"; font-size: 9.0pt;">Property Bulletin Daily
Update </span><i><span style="border: none 1.0pt; font-family: "inherit" , "serif"; font-size: 9.0pt; padding: 0in;">myDB<br />
</span></i><span style="font-family: "arial" , "sans-serif"; font-size: 9.0pt;"><br />
</span><b><span style="border: none 1.0pt; font-family: "inherit" , "serif"; font-size: 9.0pt; padding: 0in;">Note</span></b><span style="font-family: "arial" , "sans-serif"; font-size: 9.0pt;">: This job only applies to vCenter Server 5.x<o:p></o:p></span></div>
</td>
<td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .75pt; mso-border-left-alt: solid black .75pt; mso-border-top-alt: solid black .75pt; padding: 2.25pt 2.25pt 2.25pt 2.25pt;" valign="top"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 9.0pt;">job_property_bulletin_</span><i><span style="border: none 1.0pt; font-family: "inherit" , "serif"; font-size: 9.0pt; padding: 0in;">DB</span></i><span style="font-family: "courier new"; font-size: 9.0pt;">.sql<o:p></o:p></span></div>
</td>
</tr>
<tr>
<td style="border-top: none; border: solid black 1.0pt; mso-border-alt: solid black .75pt; mso-border-top-alt: solid black .75pt; padding: 2.25pt 2.25pt 2.25pt 2.25pt;" valign="top"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "arial" , "sans-serif"; font-size: 9.0pt;">Topn past day </span><i><span style="border: none 1.0pt; font-family: "inherit" , "serif"; font-size: 9.0pt; padding: 0in;">myDB</span></i><span style="font-family: "arial" , "sans-serif"; font-size: 9.0pt;"><o:p></o:p></span></div>
</td>
<td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .75pt; mso-border-left-alt: solid black .75pt; mso-border-top-alt: solid black .75pt; padding: 2.25pt 2.25pt 2.25pt 2.25pt;" valign="top"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 9.0pt;">job_topn_past_day_</span><i><span style="border: none 1.0pt; font-family: "inherit" , "serif"; font-size: 9.0pt; padding: 0in;">DB</span></i><span style="font-family: "courier new"; font-size: 9.0pt;">.sql<o:p></o:p></span></div>
</td>
</tr>
<tr>
<td style="border-top: none; border: solid black 1.0pt; mso-border-alt: solid black .75pt; mso-border-top-alt: solid black .75pt; padding: 2.25pt 2.25pt 2.25pt 2.25pt;" valign="top"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "arial" , "sans-serif"; font-size: 9.0pt;">Topn past month </span><i><span style="border: none 1.0pt; font-family: "inherit" , "serif"; font-size: 9.0pt; padding: 0in;">myDB</span></i><span style="font-family: "arial" , "sans-serif"; font-size: 9.0pt;"><o:p></o:p></span></div>
</td>
<td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .75pt; mso-border-left-alt: solid black .75pt; mso-border-top-alt: solid black .75pt; padding: 2.25pt 2.25pt 2.25pt 2.25pt;" valign="top"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 9.0pt;">job_topn_past_month_</span><i><span style="border: none 1.0pt; font-family: "inherit" , "serif"; font-size: 9.0pt; padding: 0in;">DB</span></i><span style="font-family: "courier new"; font-size: 9.0pt;">.sql<o:p></o:p></span></div>
</td>
</tr>
<tr>
<td style="border-top: none; border: solid black 1.0pt; mso-border-alt: solid black .75pt; mso-border-top-alt: solid black .75pt; padding: 2.25pt 2.25pt 2.25pt 2.25pt;" valign="top"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "arial" , "sans-serif"; font-size: 9.0pt;">Topn past week </span><i><span style="border: none 1.0pt; font-family: "inherit" , "serif"; font-size: 9.0pt; padding: 0in;">myDB</span></i><span style="font-family: "arial" , "sans-serif"; font-size: 9.0pt;"><o:p></o:p></span></div>
</td>
<td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .75pt; mso-border-left-alt: solid black .75pt; mso-border-top-alt: solid black .75pt; padding: 2.25pt 2.25pt 2.25pt 2.25pt;" valign="top"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 9.0pt;">job_topn_past_week_</span><i><span style="border: none 1.0pt; font-family: "inherit" , "serif"; font-size: 9.0pt; padding: 0in;">DB</span></i><span style="font-family: "courier new"; font-size: 9.0pt;">.sql<o:p></o:p></span></div>
</td>
</tr>
<tr>
<td style="border-top: none; border: solid black 1.0pt; mso-border-alt: solid black .75pt; mso-border-top-alt: solid black .75pt; padding: 2.25pt 2.25pt 2.25pt 2.25pt;" valign="top"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "arial" , "sans-serif"; font-size: 9.0pt;">Topn past year </span><i><span style="border: none 1.0pt; font-family: "inherit" , "serif"; font-size: 9.0pt; padding: 0in;">myDB</span></i><span style="font-family: "arial" , "sans-serif"; font-size: 9.0pt;"><o:p></o:p></span></div>
</td>
<td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .75pt; mso-border-left-alt: solid black .75pt; mso-border-top-alt: solid black .75pt; padding: 2.25pt 2.25pt 2.25pt 2.25pt;" valign="top"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "courier new"; font-size: 9.0pt;">job_topn_past_year_</span><i><span style="border: none 1.0pt; font-family: "inherit" , "serif"; font-size: 9.0pt; padding: 0in;">DB</span></i><span style="font-family: "courier new"; font-size: 9.0pt;">.sql<o:p></o:p></span></div>
</td>
</tr>
</tbody></table>
<div class="MsoNormal" style="background: white; margin-left: 0.5in; text-indent: -0.25in;">
</div>
<div style="text-align: left;">
<div style="text-align: justify;">
<span style="color: #666666; font-family: "arial" , sans-serif; font-size: 9pt; text-align: left; text-indent: -0.25in;"><br /></span>
<span style="color: #666666; font-family: "arial" , sans-serif; font-size: 9pt; text-align: left; text-indent: -0.25in;">2.</span><span style="color: #666666; font-size: 7pt; font-stretch: normal; text-align: left; text-indent: -0.25in;"> </span></div>
</div>
<div style="text-align: left;">
<!--[if !supportLists]--><span style="color: #666666; font-family: "arial" , "sans-serif"; font-size: 9.0pt;"></span><br /></div>
<div style="text-align: left;">
<div style="text-align: justify;">
<span style="color: #666666; font-family: "arial" , "sans-serif"; font-size: 9.0pt;"><span style="font-family: "arial" , sans-serif; font-size: 9pt; text-align: left; text-indent: -0.25in;">where </span><i style="text-align: left; text-indent: -0.25in;"><span style="border: 1pt none; font-family: "courier new"; font-size: 9pt; padding: 0in;">DB</span></i><span style="font-family: "arial" , sans-serif; font-size: 9pt; text-align: left; text-indent: -0.25in;"> is </span><b style="text-align: left; text-indent: -0.25in;"><span style="border: 1pt none; font-family: inherit , serif; font-size: 9pt; padding: 0in;">db2</span></b><span style="font-family: "arial" , sans-serif; font-size: 9pt; text-align: left; text-indent: -0.25in;">, </span><b style="text-align: left; text-indent: -0.25in;"><span style="border: 1pt none; font-family: inherit , serif; font-size: 9pt; padding: 0in;">mssql</span></b><span style="font-family: "arial" , sans-serif; font-size: 9pt; text-align: left; text-indent: -0.25in;">, or </span><b style="text-align: left; text-indent: -0.25in;"><span style="border: 1pt none; font-family: inherit , serif; font-size: 9pt; padding: 0in;">oracle</span></b><span style="font-family: "arial" , sans-serif; font-size: 9pt; text-align: left; text-indent: -0.25in;">.</span></span></div>
</div>
<span style="color: #666666; font-family: "arial" , "sans-serif"; font-size: 9.0pt;">
</span>
<br />
<div style="text-align: left;">
<div style="text-align: left;">
<span style="color: #666666; font-family: "arial" , sans-serif; font-size: 12px;"><br /></span></div>
</div>
<div style="text-align: left;">
<b style="text-align: justify;"><b style="text-align: left; text-indent: -0.25in;"><span style="border: none 1.0pt; color: #666666; font-family: "inherit" , "serif"; font-size: 9.0pt; padding: 0in;">Note</span></b><span style="color: #666666; font-family: "arial" , sans-serif; font-size: 9pt; text-align: left; text-indent: -0.25in;">: Ensure that </span><i style="text-align: left; text-indent: -0.25in;"><span style="border: none 1.0pt; color: #666666; font-family: "inherit" , "serif"; font-size: 9.0pt; padding: 0in;">myDB</span></i><span style="color: #666666; font-family: "arial" , sans-serif; font-size: 9pt; text-align: left; text-indent: -0.25in;"> references the vCenter Server database
and not the master or some other database. If these jobs reference any other
database, you must delete and recreate the jobs. </span></b><b></b></div>
<b>
</b>
<br />
<div class="MsoNormal" style="text-align: left;">
<div style="text-align: left;">
<br /></div>
</div>
<div class="MsoNormal" style="text-align: left;">
<b><i><u><span style="font-size: 16.0pt; line-height: 115%;">Stored Procedures <span style="color: red;">(</span></span></u></i></b><b><i><u><span style="color: red; font-size: 18.0pt; line-height: 115%;">Quarterly</span></u></i></b><b><i><u><span style="color: red;"><span style="font-size: 16pt; line-height: 115%;">) </span></span></u></i></b><br />
<div style="color: red; font-size: 24px; font-style: italic; font-weight: bold; line-height: 27.6px; text-align: left; text-decoration: underline;">
<br /></div>
</div>
<div class="MsoNormal" style="background: white; margin-bottom: 10.5pt; text-align: left; vertical-align: baseline;">
<div style="text-align: left;">
<span style="font-family: "arial" , sans-serif; font-size: 10.5pt;">Verifying the stored procedures
installed in vCenter 5.5 and 6.0<o:p></o:p></span></div>
</div>
<div class="MsoNormal" style="background: white; margin-bottom: 13.5pt; text-align: left; vertical-align: baseline;">
<div style="text-align: left;">
<span style="color: #666666; font-family: "arial" , "sans-serif"; font-size: 9.0pt;">To check the stored procedures
installed in vCenter Server 5.5 and 6.0 using MS SQL:<o:p></o:p></span></div>
</div>
<div class="MsoNormal" style="background: white; margin-left: 0.5in; text-align: left; text-indent: -0.25in;">
<div style="text-align: left;">
<!--[if !supportLists]--><span style="color: #666666; font-family: "arial" , "sans-serif"; font-size: 9.0pt;">1.<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal;">
</span></span><!--[endif]--><span style="color: #666666; font-family: "arial" , "sans-serif"; font-size: 9.0pt;">Navigate to </span><b><span style="border: none 1.0pt; color: #666666; font-family: "inherit" , "serif"; font-size: 9.0pt; padding: 0in;">vCenter DB</span></b><span style="color: #666666; font-family: "arial" , "sans-serif"; font-size: 9.0pt;"> > </span><b><span style="border: none 1.0pt; color: #666666; font-family: "inherit" , "serif"; font-size: 9.0pt; padding: 0in;">Programmability</span></b><span style="color: #666666; font-family: "arial" , "sans-serif"; font-size: 9.0pt;"> > </span><b><span style="border: none 1.0pt; color: #666666; font-family: "inherit" , "serif"; font-size: 9.0pt; padding: 0in;">Stored Procedures</span></b><span style="color: #666666; font-family: "arial" , "sans-serif"; font-size: 9.0pt;">.<o:p></o:p></span></div>
</div>
<div class="MsoNormal" style="background: white; margin-bottom: 12pt; margin-left: 0.5in; text-align: left; text-indent: -0.25in;">
<div style="text-align: left;">
<!--[if !supportLists]--><span style="color: #666666; font-family: "arial" , "sans-serif"; font-size: 9.0pt;">2.<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal;">
</span></span><!--[endif]--><span style="color: #666666; font-family: "arial" , "sans-serif"; font-size: 9.0pt;">Ensure that the stored
procedures listed in this table are installed:<o:p></o:p></span></div>
</div>
<table border="0" cellpadding="0" cellspacing="0" class="MsoNormalTable" style="border-collapse: collapse; margin-left: .5in; mso-padding-alt: 0in 0in 0in 0in; mso-yfti-tbllook: 1184;">
<tbody>
<tr>
<td style="border: solid black 1.0pt; mso-border-alt: solid black .75pt; padding: 2.25pt 2.25pt 2.25pt 2.25pt;" valign="top"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<b><span style="border: none 1.0pt; font-family: "inherit" , "serif"; font-size: 9.0pt; padding: 0in;">Stored
Procedure</span></b><span style="font-family: "arial" , "sans-serif"; font-size: 9.0pt;"><o:p></o:p></span></div>
</td>
<td style="border-left: none; border: solid black 1.0pt; mso-border-alt: solid black .75pt; mso-border-left-alt: solid black .75pt; padding: 2.25pt 2.25pt 2.25pt 2.25pt;" valign="top"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<b><span style="border: none 1.0pt; font-family: "inherit" , "serif"; font-size: 9.0pt; padding: 0in;">Corresponding
File</span></b><span style="font-family: "arial" , "sans-serif"; font-size: 9.0pt;"><o:p></o:p></span></div>
</td>
</tr>
<tr>
<td style="border-top: none; border: solid black 1.0pt; mso-border-alt: solid black .75pt; mso-border-top-alt: solid black .75pt; padding: 2.25pt 2.25pt 2.25pt 2.25pt;" valign="top"><div class="MsoNormal" style="margin-bottom: 0.0001pt; vertical-align: baseline;">
<span style="font-family: "arial" , "sans-serif"; font-size: 9.0pt;">calc_topn1_proc<o:p></o:p></span></div>
</td>
<td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .75pt; mso-border-left-alt: solid black .75pt; mso-border-top-alt: solid black .75pt; padding: 2.25pt 2.25pt 2.25pt 2.25pt;" valign="top"><div class="MsoNormal" style="margin-bottom: 0.0001pt; vertical-align: baseline;">
<span style="border: none 1.0pt; font-family: "courier new"; font-size: 10.0pt; padding: 0in;">calc_topn1_proc_DB.sql</span><span style="font-family: "arial" , "sans-serif"; font-size: 9.0pt;"><o:p></o:p></span></div>
</td>
</tr>
<tr>
<td style="border-top: none; border: solid black 1.0pt; mso-border-alt: solid black .75pt; mso-border-top-alt: solid black .75pt; padding: 2.25pt 2.25pt 2.25pt 2.25pt;" valign="top"><div class="MsoNormal" style="margin-bottom: 0.0001pt; vertical-align: baseline;">
<span style="font-family: "arial" , "sans-serif"; font-size: 9.0pt;">calc_topn2_proc<o:p></o:p></span></div>
</td>
<td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .75pt; mso-border-left-alt: solid black .75pt; mso-border-top-alt: solid black .75pt; padding: 2.25pt 2.25pt 2.25pt 2.25pt;" valign="top"><div class="MsoNormal" style="margin-bottom: 0.0001pt; vertical-align: baseline;">
<span style="border: none 1.0pt; font-family: "courier new"; font-size: 10.0pt; padding: 0in;">calc_topn2_proc_DB.sql</span><span style="font-family: "arial" , "sans-serif"; font-size: 9.0pt;"><o:p></o:p></span></div>
</td>
</tr>
<tr>
<td style="border-top: none; border: solid black 1.0pt; mso-border-alt: solid black .75pt; mso-border-top-alt: solid black .75pt; padding: 2.25pt 2.25pt 2.25pt 2.25pt;" valign="top"><div class="MsoNormal" style="margin-bottom: 0.0001pt; vertical-align: baseline;">
<span style="font-family: "arial" , "sans-serif"; font-size: 9.0pt;">calc_topn3_proc<o:p></o:p></span></div>
</td>
<td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .75pt; mso-border-left-alt: solid black .75pt; mso-border-top-alt: solid black .75pt; padding: 2.25pt 2.25pt 2.25pt 2.25pt;" valign="top"><div class="MsoNormal" style="margin-bottom: 0.0001pt; vertical-align: baseline;">
<span style="border: none 1.0pt; font-family: "courier new"; font-size: 10.0pt; padding: 0in;">calc_topn3_proc_DB.sql</span><span style="font-family: "arial" , "sans-serif"; font-size: 9.0pt;"><o:p></o:p></span></div>
</td>
</tr>
<tr>
<td style="border-top: none; border: solid black 1.0pt; mso-border-alt: solid black .75pt; mso-border-top-alt: solid black .75pt; padding: 2.25pt 2.25pt 2.25pt 2.25pt;" valign="top"><div class="MsoNormal" style="margin-bottom: 0.0001pt; vertical-align: baseline;">
<span style="font-family: "arial" , "sans-serif"; font-size: 9.0pt;">calc_topn4_proc<o:p></o:p></span></div>
</td>
<td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .75pt; mso-border-left-alt: solid black .75pt; mso-border-top-alt: solid black .75pt; padding: 2.25pt 2.25pt 2.25pt 2.25pt;" valign="top"><div class="MsoNormal" style="margin-bottom: 0.0001pt; vertical-align: baseline;">
<span style="border: none 1.0pt; font-family: "courier new"; font-size: 10.0pt; padding: 0in;">calc_topn4_proc_DB.sql</span><span style="font-family: "arial" , "sans-serif"; font-size: 9.0pt;"><o:p></o:p></span></div>
</td>
</tr>
<tr>
<td style="border-top: none; border: solid black 1.0pt; mso-border-alt: solid black .75pt; mso-border-top-alt: solid black .75pt; padding: 2.25pt 2.25pt 2.25pt 2.25pt;" valign="top"><div class="MsoNormal" style="margin-bottom: 0.0001pt; vertical-align: baseline;">
<span style="font-family: "arial" , "sans-serif"; font-size: 9.0pt;">cleanup_events_tasks_proc<o:p></o:p></span></div>
</td>
<td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .75pt; mso-border-left-alt: solid black .75pt; mso-border-top-alt: solid black .75pt; padding: 2.25pt 2.25pt 2.25pt 2.25pt;" valign="top"><div class="MsoNormal" style="margin-bottom: 0.0001pt; vertical-align: baseline;">
<span style="border: none 1.0pt; font-family: "courier new"; font-size: 10.0pt; padding: 0in;">cleanup_events_DB.sql</span><span style="font-family: "arial" , "sans-serif"; font-size: 9.0pt;"><o:p></o:p></span></div>
</td>
</tr>
<tr>
<td style="border-top: none; border: solid black 1.0pt; mso-border-alt: solid black .75pt; mso-border-top-alt: solid black .75pt; padding: 2.25pt 2.25pt 2.25pt 2.25pt;" valign="top"><div class="MsoNormal" style="margin-bottom: 0.0001pt; vertical-align: baseline;">
<span style="font-family: "arial" , "sans-serif"; font-size: 9.0pt;">clear_topn1_proc<o:p></o:p></span></div>
</td>
<td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .75pt; mso-border-left-alt: solid black .75pt; mso-border-top-alt: solid black .75pt; padding: 2.25pt 2.25pt 2.25pt 2.25pt;" valign="top"><div class="MsoNormal" style="margin-bottom: 0.0001pt; vertical-align: baseline;">
<span style="border: none 1.0pt; font-family: "courier new"; font-size: 10.0pt; padding: 0in;">clear_topn1_proc_DB.sql</span><span style="font-family: "arial" , "sans-serif"; font-size: 9.0pt;"><o:p></o:p></span></div>
</td>
</tr>
<tr>
<td style="border-top: none; border: solid black 1.0pt; mso-border-alt: solid black .75pt; mso-border-top-alt: solid black .75pt; padding: 2.25pt 2.25pt 2.25pt 2.25pt;" valign="top"><div class="MsoNormal" style="margin-bottom: 0.0001pt; vertical-align: baseline;">
<span style="font-family: "arial" , "sans-serif"; font-size: 9.0pt;">clear_topn2_proc<o:p></o:p></span></div>
</td>
<td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .75pt; mso-border-left-alt: solid black .75pt; mso-border-top-alt: solid black .75pt; padding: 2.25pt 2.25pt 2.25pt 2.25pt;" valign="top"><div class="MsoNormal" style="margin-bottom: 0.0001pt; vertical-align: baseline;">
<span style="border: none 1.0pt; font-family: "courier new"; font-size: 10.0pt; padding: 0in;">clear_topn2_proc_DB.sql</span><span style="font-family: "arial" , "sans-serif"; font-size: 9.0pt;"><o:p></o:p></span></div>
</td>
</tr>
<tr>
<td style="border-top: none; border: solid black 1.0pt; mso-border-alt: solid black .75pt; mso-border-top-alt: solid black .75pt; padding: 2.25pt 2.25pt 2.25pt 2.25pt;" valign="top"><div class="MsoNormal" style="margin-bottom: 0.0001pt; vertical-align: baseline;">
<span style="font-family: "arial" , "sans-serif"; font-size: 9.0pt;">clear_topn3_proc<o:p></o:p></span></div>
</td>
<td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .75pt; mso-border-left-alt: solid black .75pt; mso-border-top-alt: solid black .75pt; padding: 2.25pt 2.25pt 2.25pt 2.25pt;" valign="top"><div class="MsoNormal" style="margin-bottom: 0.0001pt; vertical-align: baseline;">
<span style="border: none 1.0pt; font-family: "courier new"; font-size: 10.0pt; padding: 0in;">clear_topn3_proc_DB.sql</span><span style="font-family: "arial" , "sans-serif"; font-size: 9.0pt;"><o:p></o:p></span></div>
</td>
</tr>
<tr>
<td style="border-top: none; border: solid black 1.0pt; mso-border-alt: solid black .75pt; mso-border-top-alt: solid black .75pt; padding: 2.25pt 2.25pt 2.25pt 2.25pt;" valign="top"><div class="MsoNormal" style="margin-bottom: 0.0001pt; vertical-align: baseline;">
<span style="font-family: "arial" , "sans-serif"; font-size: 9.0pt;">clear_topn4_proc<o:p></o:p></span></div>
</td>
<td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .75pt; mso-border-left-alt: solid black .75pt; mso-border-top-alt: solid black .75pt; padding: 2.25pt 2.25pt 2.25pt 2.25pt;" valign="top"><div class="MsoNormal" style="margin-bottom: 0.0001pt; vertical-align: baseline;">
<span style="border: none 1.0pt; font-family: "courier new"; font-size: 10.0pt; padding: 0in;">clear_topn4_proc_DB.sql</span><span style="font-family: "arial" , "sans-serif"; font-size: 9.0pt;"><o:p></o:p></span></div>
</td>
</tr>
<tr>
<td style="border-top: none; border: solid black 1.0pt; mso-border-alt: solid black .75pt; mso-border-top-alt: solid black .75pt; padding: 2.25pt 2.25pt 2.25pt 2.25pt;" valign="top"><div class="MsoNormal" style="margin-bottom: 0.0001pt; vertical-align: baseline;">
<span style="font-family: "arial" , "sans-serif"; font-size: 9.0pt;">delete_stats_proc<o:p></o:p></span></div>
</td>
<td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .75pt; mso-border-left-alt: solid black .75pt; mso-border-top-alt: solid black .75pt; padding: 2.25pt 2.25pt 2.25pt 2.25pt;" valign="top"><div class="MsoNormal" style="margin-bottom: 0.0001pt; vertical-align: baseline;">
<span style="border: none 1.0pt; font-family: "courier new"; font-size: 10.0pt; padding: 0in;">delete_stats_proc_DB.sql</span><span style="font-family: "arial" , "sans-serif"; font-size: 9.0pt;"><o:p></o:p></span></div>
</td>
</tr>
<tr>
<td style="border-top: none; border: solid black 1.0pt; mso-border-alt: solid black .75pt; mso-border-top-alt: solid black .75pt; padding: 2.25pt 2.25pt 2.25pt 2.25pt;" valign="top"><div class="MsoNormal" style="margin-bottom: 0.0001pt; vertical-align: baseline;">
<span style="font-family: "arial" , "sans-serif"; font-size: 9.0pt;">insert_stats_proc<o:p></o:p></span></div>
</td>
<td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .75pt; mso-border-left-alt: solid black .75pt; mso-border-top-alt: solid black .75pt; padding: 2.25pt 2.25pt 2.25pt 2.25pt;" valign="top"><div class="MsoNormal" style="margin-bottom: 0.0001pt; vertical-align: baseline;">
<span style="border: none 1.0pt; font-family: "courier new"; font-size: 10.0pt; padding: 0in;">insert_stats_proc_DB.sql</span><span style="font-family: "arial" , "sans-serif"; font-size: 9.0pt;"><o:p></o:p></span></div>
</td>
</tr>
<tr>
<td style="border-top: none; border: solid black 1.0pt; mso-border-alt: solid black .75pt; mso-border-top-alt: solid black .75pt; padding: 2.25pt 2.25pt 2.25pt 2.25pt;" valign="top"><div class="MsoNormal" style="margin-bottom: 0.0001pt; vertical-align: baseline;">
<span style="font-family: "arial" , "sans-serif"; font-size: 9.0pt;">l_purge_stat2_proc<o:p></o:p></span></div>
</td>
<td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .75pt; mso-border-left-alt: solid black .75pt; mso-border-top-alt: solid black .75pt; padding: 2.25pt 2.25pt 2.25pt 2.25pt;" valign="top"><div class="MsoNormal" style="margin-bottom: 0.0001pt; vertical-align: baseline;">
<span style="border: none 1.0pt; font-family: "courier new"; font-size: 10.0pt; padding: 0in;">l_purge_stat2_proc_DB.sql</span><span style="font-family: "arial" , "sans-serif"; font-size: 9.0pt;"><o:p></o:p></span></div>
</td>
</tr>
<tr>
<td style="border-top: none; border: solid black 1.0pt; mso-border-alt: solid black .75pt; mso-border-top-alt: solid black .75pt; padding: 2.25pt 2.25pt 2.25pt 2.25pt;" valign="top"><div class="MsoNormal" style="margin-bottom: 0.0001pt; vertical-align: baseline;">
<span style="font-family: "arial" , "sans-serif"; font-size: 9.0pt;">l_purge_stat3_proc<o:p></o:p></span></div>
</td>
<td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .75pt; mso-border-left-alt: solid black .75pt; mso-border-top-alt: solid black .75pt; padding: 2.25pt 2.25pt 2.25pt 2.25pt;" valign="top"><div class="MsoNormal" style="margin-bottom: 0.0001pt; vertical-align: baseline;">
<span style="border: none 1.0pt; font-family: "courier new"; font-size: 10.0pt; padding: 0in;">l_purge_stat3_proc_DB.sql</span><span style="font-family: "arial" , "sans-serif"; font-size: 9.0pt;"><o:p></o:p></span></div>
</td>
</tr>
<tr>
<td style="border-top: none; border: solid black 1.0pt; mso-border-alt: solid black .75pt; mso-border-top-alt: solid black .75pt; padding: 2.25pt 2.25pt 2.25pt 2.25pt;" valign="top"><div class="MsoNormal" style="margin-bottom: 0.0001pt; vertical-align: baseline;">
<span style="font-family: "arial" , "sans-serif"; font-size: 9.0pt;">l_stats_rollup1_proc<o:p></o:p></span></div>
</td>
<td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .75pt; mso-border-left-alt: solid black .75pt; mso-border-top-alt: solid black .75pt; padding: 2.25pt 2.25pt 2.25pt 2.25pt;" valign="top"><div class="MsoNormal" style="margin-bottom: 0.0001pt; vertical-align: baseline;">
<span style="border: none 1.0pt; font-family: "courier new"; font-size: 10.0pt; padding: 0in;">l_stats_rollup1_proc_DB.sql</span><span style="font-family: "arial" , "sans-serif"; font-size: 9.0pt;"><o:p></o:p></span></div>
</td>
</tr>
<tr>
<td style="border-top: none; border: solid black 1.0pt; mso-border-alt: solid black .75pt; mso-border-top-alt: solid black .75pt; padding: 2.25pt 2.25pt 2.25pt 2.25pt;" valign="top"><div class="MsoNormal" style="margin-bottom: 0.0001pt; vertical-align: baseline;">
<span style="font-family: "arial" , "sans-serif"; font-size: 9.0pt;">l_stats_rollup2_proc<o:p></o:p></span></div>
</td>
<td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .75pt; mso-border-left-alt: solid black .75pt; mso-border-top-alt: solid black .75pt; padding: 2.25pt 2.25pt 2.25pt 2.25pt;" valign="top"><div class="MsoNormal" style="margin-bottom: 0.0001pt; vertical-align: baseline;">
<span style="border: none 1.0pt; font-family: "courier new"; font-size: 10.0pt; padding: 0in;">l_stats_rollup2_proc_DB.sql</span><span style="font-family: "arial" , "sans-serif"; font-size: 9.0pt;"><o:p></o:p></span></div>
</td>
</tr>
<tr>
<td style="border-top: none; border: solid black 1.0pt; mso-border-alt: solid black .75pt; mso-border-top-alt: solid black .75pt; padding: 2.25pt 2.25pt 2.25pt 2.25pt;" valign="top"><div class="MsoNormal" style="margin-bottom: 0.0001pt; vertical-align: baseline;">
<span style="font-family: "arial" , "sans-serif"; font-size: 9.0pt;">l_stats_rollup3_proc<o:p></o:p></span></div>
</td>
<td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .75pt; mso-border-left-alt: solid black .75pt; mso-border-top-alt: solid black .75pt; padding: 2.25pt 2.25pt 2.25pt 2.25pt;" valign="top"><div class="MsoNormal" style="margin-bottom: 0.0001pt; vertical-align: baseline;">
<span style="border: none 1.0pt; font-family: "courier new"; font-size: 10.0pt; padding: 0in;">l_stats_rollup3_proc_DB.sql</span><span style="font-family: "arial" , "sans-serif"; font-size: 9.0pt;"><o:p></o:p></span></div>
</td>
</tr>
<tr>
<td style="border-top: none; border: solid black 1.0pt; mso-border-alt: solid black .75pt; mso-border-top-alt: solid black .75pt; padding: 2.25pt 2.25pt 2.25pt 2.25pt;" valign="top"><div class="MsoNormal" style="margin-bottom: 0.0001pt; vertical-align: baseline;">
<span style="font-family: "arial" , "sans-serif"; font-size: 9.0pt;">load_stats_proc<o:p></o:p></span></div>
</td>
<td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .75pt; mso-border-left-alt: solid black .75pt; mso-border-top-alt: solid black .75pt; padding: 2.25pt 2.25pt 2.25pt 2.25pt;" valign="top"><div class="MsoNormal" style="margin-bottom: 0.0001pt; vertical-align: baseline;">
<span style="border: none 1.0pt; font-family: "courier new"; font-size: 10.0pt; padding: 0in;">load_stats_proc_DB.sql</span><span style="font-family: "arial" , "sans-serif"; font-size: 9.0pt;"><o:p></o:p></span></div>
</td>
</tr>
<tr>
<td style="border-top: none; border: solid black 1.0pt; mso-border-alt: solid black .75pt; mso-border-top-alt: solid black .75pt; padding: 2.25pt 2.25pt 2.25pt 2.25pt;" valign="top"><div class="MsoNormal" style="margin-bottom: 0.0001pt; vertical-align: baseline;">
<span style="font-family: "arial" , "sans-serif"; font-size: 9.0pt;">load_usage_stats_proc<o:p></o:p></span></div>
</td>
<td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .75pt; mso-border-left-alt: solid black .75pt; mso-border-top-alt: solid black .75pt; padding: 2.25pt 2.25pt 2.25pt 2.25pt;" valign="top"><div class="MsoNormal" style="margin-bottom: 0.0001pt; vertical-align: baseline;">
<span style="border: none 1.0pt; font-family: "courier new"; font-size: 10.0pt; padding: 0in;">load_usage_stats_proc_DB.sql</span><span style="font-family: "arial" , "sans-serif"; font-size: 9.0pt;"><o:p></o:p></span></div>
</td>
</tr>
<tr>
<td style="border-top: none; border: solid black 1.0pt; mso-border-alt: solid black .75pt; mso-border-top-alt: solid black .75pt; padding: 2.25pt 2.25pt 2.25pt 2.25pt;" valign="top"><div class="MsoNormal" style="margin-bottom: 0.0001pt; vertical-align: baseline;">
<span style="font-family: "arial" , "sans-serif"; font-size: 9.0pt;">process_license_snapshot_proc<o:p></o:p></span></div>
</td>
<td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .75pt; mso-border-left-alt: solid black .75pt; mso-border-top-alt: solid black .75pt; padding: 2.25pt 2.25pt 2.25pt 2.25pt;" valign="top"><div class="MsoNormal" style="margin-bottom: 0.0001pt; vertical-align: baseline;">
<span style="border: none 1.0pt; font-family: "courier new"; font-size: 10.0pt; padding: 0in;">process_license_snapshot_DB.sql</span><span style="font-family: "arial" , "sans-serif"; font-size: 9.0pt;"><o:p></o:p></span></div>
</td>
</tr>
<tr>
<td style="border-top: none; border: solid black 1.0pt; mso-border-alt: solid black .75pt; mso-border-top-alt: solid black .75pt; padding: 2.25pt 2.25pt 2.25pt 2.25pt;" valign="top"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "arial" , "sans-serif"; font-size: 9.0pt;">process_performance_data_proc<o:p></o:p></span></div>
</td>
<td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .75pt; mso-border-left-alt: solid black .75pt; mso-border-top-alt: solid black .75pt; padding: 2.25pt 2.25pt 2.25pt 2.25pt;" valign="top"><div class="MsoNormal" style="margin-bottom: 0.0001pt; vertical-align: baseline;">
<span style="border: none 1.0pt; font-family: "courier new"; font-size: 10.0pt; padding: 0in;">process_performance_data_DB.sql</span><span style="font-family: "arial" , "sans-serif"; font-size: 9.0pt;"><o:p></o:p></span></div>
</td>
</tr>
<tr>
<td style="border-top: none; border: solid black 1.0pt; mso-border-alt: solid black .75pt; mso-border-top-alt: solid black .75pt; padding: 2.25pt 2.25pt 2.25pt 2.25pt;" valign="top"><div class="MsoNormal" style="margin-bottom: 0.0001pt; vertical-align: baseline;">
<span style="font-family: "arial" , "sans-serif"; font-size: 9.0pt;">purge_stat2_proc<o:p></o:p></span></div>
</td>
<td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .75pt; mso-border-left-alt: solid black .75pt; mso-border-top-alt: solid black .75pt; padding: 2.25pt 2.25pt 2.25pt 2.25pt;" valign="top"><div class="MsoNormal" style="margin-bottom: 0.0001pt; vertical-align: baseline;">
<span style="border: none 1.0pt; font-family: "courier new"; font-size: 10.0pt; padding: 0in;">purge_stat2_proc_DB.sql</span><span style="font-family: "arial" , "sans-serif"; font-size: 9.0pt;"><o:p></o:p></span></div>
</td>
</tr>
<tr>
<td style="border-top: none; border: solid black 1.0pt; mso-border-alt: solid black .75pt; mso-border-top-alt: solid black .75pt; padding: 2.25pt 2.25pt 2.25pt 2.25pt;" valign="top"><div class="MsoNormal" style="margin-bottom: 0.0001pt; vertical-align: baseline;">
<span style="font-family: "arial" , "sans-serif"; font-size: 9.0pt;">purge_stat3_proc<o:p></o:p></span></div>
</td>
<td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .75pt; mso-border-left-alt: solid black .75pt; mso-border-top-alt: solid black .75pt; padding: 2.25pt 2.25pt 2.25pt 2.25pt;" valign="top"><div class="MsoNormal" style="margin-bottom: 0.0001pt; vertical-align: baseline;">
<span style="border: none 1.0pt; font-family: "courier new"; font-size: 9.0pt; padding: 0in;">purge_stat3_proc_DB.sql</span><span style="border: none 1.0pt; font-family: "arial" , "sans-serif"; font-size: 9.0pt; padding: 0in;"><o:p></o:p></span></div>
</td>
</tr>
<tr>
<td style="border-top: none; border: solid black 1.0pt; mso-border-alt: solid black .75pt; mso-border-top-alt: solid black .75pt; padding: 2.25pt 2.25pt 2.25pt 2.25pt;" valign="top"><div class="MsoNormal" style="margin-bottom: 0.0001pt; vertical-align: baseline;">
<span style="font-family: "arial" , "sans-serif"; font-size: 9.0pt;">purge_usage_stat_proc<o:p></o:p></span></div>
</td>
<td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .75pt; mso-border-left-alt: solid black .75pt; mso-border-top-alt: solid black .75pt; padding: 2.25pt 2.25pt 2.25pt 2.25pt;" valign="top"><div class="MsoNormal" style="margin-bottom: 0.0001pt; vertical-align: baseline;">
<span style="border: none 1.0pt; font-family: "courier new"; font-size: 10.0pt; padding: 0in;">purge_usage_stats_proc_DB.sql</span><span style="font-family: "arial" , "sans-serif"; font-size: 9.0pt;"><o:p></o:p></span></div>
</td>
</tr>
<tr>
<td style="border-top: none; border: solid black 1.0pt; mso-border-alt: solid black .75pt; mso-border-top-alt: solid black .75pt; padding: 2.25pt 2.25pt 2.25pt 2.25pt;" valign="top"><div class="MsoNormal" style="margin-bottom: 0.0001pt; vertical-align: baseline;">
<span style="font-family: "arial" , "sans-serif"; font-size: 9.0pt;">rule_topn1_proc<o:p></o:p></span></div>
</td>
<td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .75pt; mso-border-left-alt: solid black .75pt; mso-border-top-alt: solid black .75pt; padding: 2.25pt 2.25pt 2.25pt 2.25pt;" valign="top"><div class="MsoNormal" style="margin-bottom: 0.0001pt; vertical-align: baseline;">
<span style="border: none 1.0pt; font-family: "courier new"; font-size: 10.0pt; padding: 0in;">rule_topn1_proc_DB.sql</span><span style="font-family: "arial" , "sans-serif"; font-size: 9.0pt;"><o:p></o:p></span></div>
</td>
</tr>
<tr>
<td style="border-top: none; border: solid black 1.0pt; mso-border-alt: solid black .75pt; mso-border-top-alt: solid black .75pt; padding: 2.25pt 2.25pt 2.25pt 2.25pt;" valign="top"><div class="MsoNormal" style="margin-bottom: 0.0001pt; vertical-align: baseline;">
<span style="font-family: "arial" , "sans-serif"; font-size: 9.0pt;">rule_topn2_proc<o:p></o:p></span></div>
</td>
<td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .75pt; mso-border-left-alt: solid black .75pt; mso-border-top-alt: solid black .75pt; padding: 2.25pt 2.25pt 2.25pt 2.25pt;" valign="top"><div class="MsoNormal" style="margin-bottom: 0.0001pt; vertical-align: baseline;">
<span style="border: none 1.0pt; font-family: "courier new"; font-size: 10.0pt; padding: 0in;">rule_topn2_proc_DB.sql</span><span style="font-family: "arial" , "sans-serif"; font-size: 9.0pt;"><o:p></o:p></span></div>
</td>
</tr>
<tr>
<td style="border-top: none; border: solid black 1.0pt; mso-border-alt: solid black .75pt; mso-border-top-alt: solid black .75pt; padding: 2.25pt 2.25pt 2.25pt 2.25pt;" valign="top"><div class="MsoNormal" style="margin-bottom: 0.0001pt; vertical-align: baseline;">
<span style="font-family: "arial" , "sans-serif"; font-size: 9.0pt;">rule_topn3_proc<o:p></o:p></span></div>
</td>
<td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .75pt; mso-border-left-alt: solid black .75pt; mso-border-top-alt: solid black .75pt; padding: 2.25pt 2.25pt 2.25pt 2.25pt;" valign="top"><div class="MsoNormal" style="margin-bottom: 0.0001pt; vertical-align: baseline;">
<span style="border: none 1.0pt; font-family: "courier new"; font-size: 10.0pt; padding: 0in;">rule_topn3_proc_DB.sql</span><span style="font-family: "arial" , "sans-serif"; font-size: 9.0pt;"><o:p></o:p></span></div>
</td>
</tr>
<tr>
<td style="border-top: none; border: solid black 1.0pt; mso-border-alt: solid black .75pt; mso-border-top-alt: solid black .75pt; padding: 2.25pt 2.25pt 2.25pt 2.25pt;" valign="top"><div class="MsoNormal" style="margin-bottom: 0.0001pt; vertical-align: baseline;">
<span style="font-family: "arial" , "sans-serif"; font-size: 9.0pt;">rule_topn4_proc<o:p></o:p></span></div>
</td>
<td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .75pt; mso-border-left-alt: solid black .75pt; mso-border-top-alt: solid black .75pt; padding: 2.25pt 2.25pt 2.25pt 2.25pt;" valign="top"><div class="MsoNormal" style="margin-bottom: 0.0001pt; vertical-align: baseline;">
<span style="border: none 1.0pt; font-family: "courier new"; font-size: 10.0pt; padding: 0in;">rule_topn4_proc_DB.sql</span><span style="font-family: "arial" , "sans-serif"; font-size: 9.0pt;"><o:p></o:p></span></div>
</td>
</tr>
<tr>
<td style="border-top: none; border: solid black 1.0pt; mso-border-alt: solid black .75pt; mso-border-top-alt: solid black .75pt; padding: 2.25pt 2.25pt 2.25pt 2.25pt;" valign="top"><div class="MsoNormal" style="margin-bottom: 0.0001pt; vertical-align: baseline;">
<span style="font-family: "arial" , "sans-serif"; font-size: 9.0pt;">stats_rollup1_proc<o:p></o:p></span></div>
</td>
<td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .75pt; mso-border-left-alt: solid black .75pt; mso-border-top-alt: solid black .75pt; padding: 2.25pt 2.25pt 2.25pt 2.25pt;" valign="top"><div class="MsoNormal" style="margin-bottom: 0.0001pt; vertical-align: baseline;">
<span style="border: none 1.0pt; font-family: "courier new"; font-size: 10.0pt; padding: 0in;">stats_rollup1_proc_DB.sql</span><span style="font-family: "arial" , "sans-serif"; font-size: 9.0pt;"><o:p></o:p></span></div>
</td>
</tr>
<tr>
<td style="border-top: none; border: solid black 1.0pt; mso-border-alt: solid black .75pt; mso-border-top-alt: solid black .75pt; padding: 2.25pt 2.25pt 2.25pt 2.25pt;" valign="top"><div class="MsoNormal" style="margin-bottom: 0.0001pt; vertical-align: baseline;">
<span style="font-family: "arial" , "sans-serif"; font-size: 9.0pt;">stats_rollup2_proc<o:p></o:p></span></div>
</td>
<td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .75pt; mso-border-left-alt: solid black .75pt; mso-border-top-alt: solid black .75pt; padding: 2.25pt 2.25pt 2.25pt 2.25pt;" valign="top"><div class="MsoNormal" style="margin-bottom: 0.0001pt; vertical-align: baseline;">
<span style="border: none 1.0pt; font-family: "courier new"; font-size: 10.0pt; padding: 0in;">stats_rollup2_proc_DB.sql</span><span style="font-family: "arial" , "sans-serif"; font-size: 9.0pt;"><o:p></o:p></span></div>
</td>
</tr>
<tr>
<td style="border-top: none; border: solid black 1.0pt; mso-border-alt: solid black .75pt; mso-border-top-alt: solid black .75pt; padding: 2.25pt 2.25pt 2.25pt 2.25pt;" valign="top"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "arial" , "sans-serif"; font-size: 9.0pt;">stats_rollup3_proc<o:p></o:p></span></div>
</td>
<td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .75pt; mso-border-left-alt: solid black .75pt; mso-border-top-alt: solid black .75pt; padding: 2.25pt 2.25pt 2.25pt 2.25pt;" valign="top"><div class="MsoNormal" style="margin-bottom: 0.0001pt; vertical-align: baseline;">
<span style="border: none 1.0pt; font-family: "courier new"; font-size: 10.0pt; padding: 0in;">stats_rollup3_proc_DB.sql</span><span style="font-family: "arial" , "sans-serif"; font-size: 9.0pt;"><o:p></o:p></span></div>
</td>
</tr>
<tr>
<td style="border-top: none; border: solid black 1.0pt; mso-border-alt: solid black .75pt; mso-border-top-alt: solid black .75pt; padding: 2.25pt 2.25pt 2.25pt 2.25pt;" valign="top"><div class="MsoNormal" style="margin-bottom: 0.0001pt; vertical-align: baseline;">
<span style="font-family: "arial" , "sans-serif"; font-size: 9.0pt;">upsert_last_event_proc<o:p></o:p></span></div>
</td>
<td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .75pt; mso-border-left-alt: solid black .75pt; mso-border-top-alt: solid black .75pt; padding: 2.25pt 2.25pt 2.25pt 2.25pt;" valign="top"><div class="MsoNormal" style="margin-bottom: 0.0001pt; vertical-align: baseline;">
<span style="border: none 1.0pt; font-family: "courier new"; font-size: 10.0pt; padding: 0in;">upsert_last_event_proc_DB.sql</span><span style="font-family: "arial" , "sans-serif"; font-size: 9.0pt;"><o:p></o:p></span></div>
</td>
</tr>
</tbody></table>
<div class="MsoNormal" style="background: white; margin-bottom: 0.0001pt; text-align: left; vertical-align: baseline;">
<div style="text-align: left;">
<br /></div>
</div>
<div class="MsoNormal" style="background: white; margin-bottom: 0.0001pt; text-align: left; vertical-align: baseline;">
<div style="text-align: left;">
<span style="color: #666666; font-family: "arial" , "sans-serif"; font-size: 9.0pt;">Where, </span><i><span style="border: none 1.0pt; color: #666666; font-family: "courier new"; font-size: 9.0pt; padding: 0in;">DB</span></i><span style="color: #666666; font-family: "arial" , "sans-serif"; font-size: 9.0pt;"> is </span><b><span style="border: none 1.0pt; color: #666666; font-family: "inherit" , "serif"; font-size: 9.0pt; padding: 0in;">db2</span></b><span style="color: #666666; font-family: "arial" , "sans-serif"; font-size: 9.0pt;">, </span><b><span style="border: none 1.0pt; color: #666666; font-family: "inherit" , "serif"; font-size: 9.0pt; padding: 0in;">mssql</span></b><span style="color: #666666; font-family: "arial" , "sans-serif"; font-size: 9.0pt;">, or </span><b><span style="border: none 1.0pt; color: #666666; font-family: "inherit" , "serif"; font-size: 9.0pt; padding: 0in;">oracle</span></b><span style="color: #666666; font-family: "arial" , "sans-serif"; font-size: 9.0pt;">. <o:p></o:p></span></div>
</div>
<div class="MsoNormal" style="background: white; margin-bottom: 0.0001pt; vertical-align: baseline;">
</div>
<div style="text-align: left;">
<div style="text-align: justify;">
<span style="color: #666666; font-family: "arial" , sans-serif; font-size: 9pt; text-align: left;">If any of these jobs or stored procedures are missing, you must
install them by running the corresponding </span><span style="border: 1pt none; color: #666666; font-family: "courier new"; font-size: 9pt; padding: 0in; text-align: left;">.sql</span><span style="color: #666666; font-family: "arial" , sans-serif; font-size: 9pt; text-align: left;"> file on the
vCenter Server database using a database management tool such as SQL Management
Studio. For more information on running these </span><span style="color: #666666; font-family: "courier new"; font-size: 9pt; text-align: left;">.sql</span><span style="color: #666666; font-family: "arial" , sans-serif; font-size: 9pt; text-align: left;"> files, see
section</span><b style="text-align: left;"><span style="border: none 1.0pt; color: #666666; font-family: "inherit" , "serif"; font-size: 9.0pt; padding: 0in;">Adding the SQL Server Agent Jobs </span></b><span style="color: #666666; font-family: "arial" , sans-serif; font-size: 9pt; text-align: left;">in </span><a href="http://kb.vmware.com/selfservice/search.do?cmd=displayKC&docType=kc&docTypeID=DT_KB_1_1&externalId=1004382" style="text-align: left;" target="_blank"><span style="border: none 1.0pt; color: #006990; font-family: "inherit" , "serif"; font-size: 9.0pt; padding: 0in;">Updating rollup jobs after the error: Performance data is
currently not available for this entity (1004382)</span></a><span style="color: #666666; font-family: "arial" , sans-serif; font-size: 9pt; text-align: left;">. </span></div>
</div>
<div style="text-align: left;">
<div style="text-align: left;">
<br /></div>
</div>
<div style="text-align: left;">
<div style="text-align: justify;">
<b><b style="text-align: left;"><span style="border: none 1.0pt; color: #666666; font-family: "inherit" , "serif"; font-size: 9.0pt; padding: 0in;">Notes</span></b><span style="color: #666666; font-family: "arial" , sans-serif; font-size: 9pt; text-align: left;">: </span></b></div>
</div>
<b>
</b>
<br />
<ul type="disc">
<li class="MsoNormal" style="background: white; color: #666666; text-align: left; vertical-align: baseline;"><span style="font-family: "arial" , "sans-serif"; font-size: 9.0pt;">The </span><span style="border: none 1.0pt; font-family: "courier new"; font-size: 9.0pt; padding: 0in;">upsert_last_event_proc</span><span style="font-family: "arial" , "sans-serif"; font-size: 9.0pt;"> procedure
is not required for the Oracle database.<o:p></o:p></span></li>
<li class="MsoNormal" style="background: white; vertical-align: baseline;"><div style="color: #666666; text-align: left;">
<div style="text-align: justify;">
<span style="font-family: "arial" , sans-serif; font-size: 9pt; text-align: left;">If
there is a custom schema, the following command also needs to be ran:</span></div>
</div>
<div style="text-align: left;">
<div style="text-align: left;">
<span style="color: #666666; font-family: "arial" , sans-serif; font-size: 12px;"><br /></span></div>
</div>
<span style="color: #666666; font-family: "courier new"; font-size: 9pt;"><div style="text-align: left;">
<div style="text-align: justify;">
<span style="font-size: 9pt; text-align: left;">alter schema </span><i style="text-align: left;"><span style="border: none 1.0pt; font-family: "inherit" , "serif"; font-size: 9.0pt; padding: 0in;">schema_name</span></i><span style="font-size: 9pt; text-align: left;"> transfer dbo.</span><i style="text-align: left;"><span style="border: none 1.0pt; font-family: "inherit" , "serif"; font-size: 9.0pt; padding: 0in;">stored_procedure_name</span></i></div>
</div>
</span></li>
</ul>
<div class="MsoNormal" style="background: white; margin-bottom: 0.0001pt; text-align: left; vertical-align: baseline;">
<div style="text-align: left;">
<span style="color: #666666; font-family: "arial" , "sans-serif"; font-size: 9.0pt;">All SQL scripts are located in the vCenter Server installation
folder:<o:p></o:p></span></div>
</div>
<ul type="disc">
<li class="MsoNormal" style="background: white; color: #666666; text-align: left; vertical-align: baseline;"><span style="font-family: "arial" , "sans-serif"; font-size: 9.0pt;">vCenter
Server 5.1 and 5.5: </span><span style="border: none 1.0pt; font-family: "courier new"; font-size: 9.0pt; padding: 0in;">C:\Program
Files\VMware\Infrastructure\VirtualCenter Server\sql</span><span style="font-family: "arial" , "sans-serif"; font-size: 9.0pt;">. <o:p></o:p></span></li>
<li class="MsoNormal" style="background: white; color: #666666; text-align: left; vertical-align: baseline;"><span style="font-family: "arial" , "sans-serif"; font-size: 9.0pt;">vCenter
Server 6.0: </span><span style="font-family: "courier new"; font-size: 9.0pt;">C:\Program Files\VMware\vCenter
Server\vpxd\sql</span><span style="font-family: "arial" , "sans-serif"; font-size: 9.0pt;"><o:p></o:p></span></li>
</ul>
<div class="MsoNormal" style="background: white; margin-bottom: 0.0001pt; text-align: left; vertical-align: baseline;">
<div style="text-align: left;">
<span style="color: #666666; font-family: "arial" , "sans-serif"; font-size: 9.0pt;">For more information on commonly used vCenter Server installation
paths, see </span><a href="http://kb.vmware.com/selfservice/search.do?cmd=displayKC&docType=kc&docTypeID=DT_KB_1_1&externalId=1028185" target="_blank"><span style="border: none 1.0pt; color: #3399cc; font-family: "inherit" , "serif"; font-size: 9.0pt; padding: 0in;">Common vCenter Server and vSphere Client Windows paths (1028185)</span></a><span style="color: #666666; font-family: "arial" , "sans-serif"; font-size: 9.0pt;">. <o:p></o:p></span></div>
</div>
<div class="MsoNormal" style="background: white; margin-bottom: 0.0001pt; vertical-align: baseline;">
</div>
<div style="text-align: left;">
<div style="text-align: left;">
<span style="color: #666666; font-family: "arial" , sans-serif; font-size: 12px;"><br /></span></div>
</div>
<div style="text-align: left;">
<span style="color: #666666; font-family: "arial" , "sans-serif"; font-size: 9.0pt;"></span><br /></div>
<div style="text-align: left;">
<div style="text-align: justify;">
<span style="color: #666666; font-family: "arial" , "sans-serif"; font-size: 9.0pt;"><span style="font-family: "arial" , sans-serif; font-size: 9pt; text-align: left;">Ensure that the vCenter Server database is the target before executing the SQL
file.</span></span></div>
</div>
<span style="color: #666666; font-family: "arial" , "sans-serif"; font-size: 9.0pt;">
<o:p></o:p></span>
<br />
<div class="MsoNormal" style="text-align: left;">
<div style="text-align: left;">
<br /></div>
</div>
<div class="MsoNormal" style="text-align: left;">
<div style="text-align: left;">
<b><i><u><span style="font-size: 16.0pt; line-height: 115%;">Growth of a Database
</span></u></i></b><b><i><u><span style="color: red; font-size: 18.0pt; line-height: 115%;">(Quarterly)</span></u></i></b></div>
</div>
<h3 style="background: white; margin: 0in 0in 10.5pt; text-align: left; vertical-align: baseline;">
<span style="font-family: "arial" , sans-serif; font-size: 10.5pt; font-weight: normal;">Determining what is growing in the vCenter Server database<o:p></o:p></span></h3>
<div style="background: white; margin: 0in 0in 13.5pt; text-align: left; vertical-align: baseline;">
<div style="text-align: left;">
<span style="color: #666666; font-family: "arial" , "sans-serif"; font-size: 9.0pt;">The vCenter Server database is
a complex database and there are several areas that can cause problems. Out of
the many tables in vCenter Server, there are very few which accumulate data
during regular operation. These tables do accumulate data during regular
operation:<o:p></o:p></span></div>
</div>
<ul type="disc">
<li class="MsoNormal" style="background: white; color: #666666; text-align: left;"><strong><span style="border: none 1.0pt; font-family: "inherit" , "serif"; font-size: 9.0pt; padding: 0in;">vpx_hist_stat1</span></strong><span class="apple-converted-space"><span style="font-family: "arial" , "sans-serif"; font-size: 9.0pt;"> </span></span><span style="font-family: "arial" , "sans-serif"; font-size: 9.0pt;">to<span class="apple-converted-space"> </span></span><strong><span style="border: none 1.0pt; font-family: "inherit" , "serif"; font-size: 9.0pt; padding: 0in;">vpx_hist_stat4</span></strong><span style="font-family: "arial" , "sans-serif"; font-size: 9.0pt;"> in vCenter Server 4.x and </span><strong><span style="border: none 1.0pt; font-family: "inherit" , "serif"; font-size: 9.0pt; padding: 0in;">vpx_hist_stat1_n</span></strong><span style="font-family: "arial" , "sans-serif"; font-size: 9.0pt;"> to </span><strong><span style="border: none 1.0pt; font-family: "inherit" , "serif"; font-size: 9.0pt; padding: 0in;">vpx_hist_stat4_n</span></strong><span class="apple-converted-space"><span style="border: none 1.0pt; font-family: "inherit" , "serif"; font-size: 9.0pt; padding: 0in;"> </span></span><span style="font-family: "arial" , "sans-serif"; font-size: 9.0pt;">in vCenter Server
5.x – These tables store the collected performance data information.<o:p></o:p></span></li>
<li class="MsoNormal" style="background: white; color: #666666; text-align: left;"><strong><span style="border: none 1.0pt; font-family: "inherit" , "serif"; font-size: 9.0pt; padding: 0in;">vpx_sample_time1</span></strong><span class="apple-converted-space"><span style="font-family: "arial" , "sans-serif"; font-size: 9.0pt;"> </span></span><span style="font-family: "arial" , "sans-serif"; font-size: 9.0pt;">to<span class="apple-converted-space"> </span></span><strong><span style="border: none 1.0pt; font-family: "inherit" , "serif"; font-size: 9.0pt; padding: 0in;">vpx_sample_time4</span></strong><span class="apple-converted-space"><span style="font-family: "arial" , "sans-serif"; font-size: 9.0pt;"> </span></span><span style="font-family: "arial" , "sans-serif"; font-size: 9.0pt;">– These tables
store the reference time frames for the performance data in the
vpx_hist_stat tables.<o:p></o:p></span></li>
<li class="MsoNormal" style="background: white; color: #666666; text-align: left;"><strong><span style="border: none 1.0pt; font-family: "inherit" , "serif"; font-size: 9.0pt; padding: 0in;">vpx_event</span></strong><span class="apple-converted-space"><span style="font-family: "arial" , "sans-serif"; font-size: 9.0pt;"> </span></span><span style="font-family: "arial" , "sans-serif"; font-size: 9.0pt;">and<span class="apple-converted-space"> </span></span><strong><span style="border: none 1.0pt; font-family: "inherit" , "serif"; font-size: 9.0pt; padding: 0in;">vpx_event_arg</span></strong><span class="apple-converted-space"><span style="font-family: "arial" , "sans-serif"; font-size: 9.0pt;"> </span></span><span style="font-family: "arial" , "sans-serif"; font-size: 9.0pt;">– These tables
store the event information from the Tasks and Events tab in vCenter
Server.<o:p></o:p></span></li>
<li class="MsoNormal" style="background: white; color: #666666; text-align: left;"><strong><span style="border: none 1.0pt; font-family: "inherit" , "serif"; font-size: 9.0pt; padding: 0in;">vpx_task</span></strong><span class="apple-converted-space"><span style="font-family: "arial" , "sans-serif"; font-size: 9.0pt;"> </span></span><span style="font-family: "arial" , "sans-serif"; font-size: 9.0pt;">– stores the task
information from the Tasks and Events tab in vCenter Server.<o:p></o:p></span></li>
</ul>
<div style="background: white; margin: 0in 0in 0.0001pt; text-align: left; vertical-align: baseline;">
<div style="text-align: left;">
<span style="color: #666666; font-family: "arial" , "sans-serif"; font-size: 9.0pt;">This small subset of the tables in vCenter Server account for
the majority of cases that are showing substantial growth in the database. If
any other table is showing growth, file a support request with VMware Technical
Support and note this KB Article ID in the Problem Description. For more information,
see<span class="apple-converted-space"> </span></span><a href="http://www.vmware.com/support/policies/howto.html" target="_blank"><span style="border: none 1.0pt; color: #006990; font-family: "inherit" , "serif"; font-size: 9.0pt; padding: 0in;">How to Submit a Support Request</span></a><span style="color: #666666; font-family: "arial" , "sans-serif"; font-size: 9.0pt;">.<o:p></o:p></span></div>
</div>
<div style="background: white; margin: 0in 0in 0.0001pt; text-align: left; vertical-align: baseline;">
<div style="text-align: left;">
<strong><span style="border: none 1.0pt; color: #666666; font-family: "inherit" , "serif"; font-size: 9.0pt; padding: 0in;">Microsoft SQL</span></strong><span style="color: #666666; font-family: "arial" , "sans-serif"; font-size: 9.0pt;"><o:p></o:p></span></div>
</div>
<div style="background: white; margin: 0in 0in 13.5pt; text-align: left; vertical-align: baseline;">
<div style="text-align: left;">
<span style="color: #666666; font-family: "arial" , "sans-serif"; font-size: 9.0pt;">If you are using Microsoft SQL,
there are three ways to validate where space is being consumed within a
Microsoft SQL database. Select one method.<o:p></o:p></span></div>
</div>
<ul type="disc">
<li class="MsoNormal" style="background: white; color: #666666; text-align: left;"><span style="font-family: "arial" , "sans-serif"; font-size: 9.0pt;">From
the SQL Management Studio interface, navigate to the database, right-click
the table, and select </span><strong><span style="border: none 1.0pt; font-family: "inherit" , "serif"; font-size: 9.0pt; padding: 0in;">Properties</span></strong><span style="font-family: "arial" , "sans-serif"; font-size: 9.0pt;">. See the Data
space in the Storage section of the screen.<o:p></o:p></span></li>
<li class="MsoNormal" style="background: white;"><div style="color: #666666; text-align: left;">
<div style="text-align: justify;">
<span style="font-family: "arial" , sans-serif; font-size: 9pt; text-align: left;">Manually
run this SQL query against the vCenter Server database:</span></div>
</div>
<div style="text-align: left;">
<div style="text-align: left;">
<span style="color: #666666; font-family: "arial" , sans-serif; font-size: 12px;"><br /></span></div>
</div>
<span style="color: #666666; font-family: "courier new"; font-size: 9pt;"><div style="text-align: left;">
<div style="text-align: justify;">
<span style="font-size: 9pt; text-align: left;">select
object_name(id) [Table Name],</span><span class="apple-converted-space" style="font-size: 9pt; text-align: left;"> </span></div>
</div>
<div style="text-align: left;">
<div style="text-align: justify;">
<span style="font-size: 9pt; text-align: left;">[Table Size] = convert (varchar, dpages * 8 / 1024) + 'MB'</span><span class="apple-converted-space" style="font-size: 9pt; text-align: left;"> </span></div>
</div>
<div style="text-align: left;">
<div style="text-align: justify;">
<span style="font-size: 9pt; text-align: left;">from sysindexes where indid in (0,1)</span><span class="apple-converted-space" style="font-size: 9pt; text-align: left;"> </span></div>
</div>
<div style="text-align: left;">
<div style="text-align: justify;">
<span style="font-size: 9pt; text-align: left;">order by dpages desc</span></div>
</div>
</span><div style="text-align: left;">
<div style="text-align: left;">
<span style="color: #666666; font-family: "arial" , sans-serif; font-size: 12px;"><br /></span></div>
</div>
<span style="color: #666666; font-family: "arial" , sans-serif; font-size: 9pt;"><div style="text-align: left;">
<div style="text-align: justify;">
<span style="font-size: 9pt; text-align: left;">This query lists all tables in the vCenter Server database by table size
in MB.</span></div>
</div>
<o:p></o:p></span></li>
</ul>
<ul type="disc">
<li class="MsoNormal" style="background: white;"><div style="color: #666666; text-align: left;">
<div style="text-align: justify;">
<span style="font-family: "arial" , sans-serif; font-size: 9pt; text-align: left;">Manually
run this SQL query for individual tables:</span></div>
</div>
<div style="text-align: left;">
<div style="text-align: left;">
<span style="color: #666666; font-family: "arial" , sans-serif; font-size: 12px;"><br /></span></div>
</div>
<code style="color: #666666;"><div style="text-align: left;">
<div style="text-align: justify;">
<code style="text-align: left;"><span style="border: none windowtext 1.0pt; font-size: 10.0pt; mso-border-alt: none windowtext 0in; mso-fareast-font-family: Calibri; mso-fareast-theme-font: minor-latin; padding: 0in;">exec sp_spaceused</span></code><span class="apple-converted-space" style="text-align: left;"><span style="border: none 1.0pt; font-family: "courier new"; font-size: 10.0pt; padding: 0in;"> </span></span><em style="text-align: left;"><span style="border: none 1.0pt; font-family: "inherit" , "serif"; padding: 0in;">tablename</span></em><code style="text-align: left;"><span style="border: none windowtext 1.0pt; font-size: 10.0pt; mso-border-alt: none windowtext 0in; mso-fareast-font-family: Calibri; mso-fareast-theme-font: minor-latin; padding: 0in;">;</span></code></div>
</div>
</code><div style="text-align: left;">
<div style="text-align: left;">
<span style="color: #666666; font-family: "arial" , sans-serif; font-size: 12px;"><br /></span></div>
</div>
<span style="color: #666666; font-family: "arial" , sans-serif; font-size: 9pt;"><div style="text-align: left;">
<div style="text-align: justify;">
<span style="font-size: 9pt; text-align: left;">See the data column of the output. For example:</span></div>
</div>
</span>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://4.bp.blogspot.com/-cmR8743t30c/Vdy4Hs4OGwI/AAAAAAAAdMk/hft6stIZ1Ew/s1600/vc-2.jpg" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="37" src="https://4.bp.blogspot.com/-cmR8743t30c/Vdy4Hs4OGwI/AAAAAAAAdMk/hft6stIZ1Ew/s400/vc-2.jpg" width="400" /></a></div>
<div style="text-align: left;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div style="text-align: left;">
<div style="text-align: left;">
<strong><span style="border: none 1.0pt; color: #666666; font-family: "inherit" , "serif"; font-size: 9.0pt; padding: 0in;">Note</span></strong><span style="color: #666666; font-family: "arial" , "sans-serif"; font-size: 9.0pt;">:
Querying the database one table at a time may be time consuming. To query all
tables simultaneously, use this SQL Query:</span></div>
</div>
</li>
</ul>
<div style="background: white; margin: 0in 0in 0.0001pt; text-align: left; vertical-align: baseline;">
<div style="text-align: left;">
<code><span style="border: none 1.0pt; color: #666666; font-size: 10.0pt; padding: 0in;">EXEC sp_MSforeachtable
@command1="EXEC sp_spaceused '?'"</span></code><span style="color: #666666; font-family: "arial" , "sans-serif"; font-size: 9.0pt;"><o:p></o:p></span></div>
</div>
<div class="MsoNormal" style="text-align: left;">
<div style="text-align: left;">
<br /></div>
</div>
<div class="MsoNormal" style="text-align: left;">
<div style="text-align: left;">
<b><i><u><span style="font-size: 18.0pt; line-height: 115%;">Growth of
Transaction Logs <span style="color: red;">(Quarterly)</span><o:p></o:p></span></u></i></b></div>
</div>
<h3 style="background: white; margin: 0in 0in 10.5pt; text-align: left; vertical-align: baseline;">
<span style="font-family: "arial" , sans-serif; font-size: 10.5pt; font-weight: normal;">vCenter Server Transaction log growth when using Microsoft SQL<o:p></o:p></span></h3>
<div style="background: white; margin: 0in 0in 13.5pt; text-align: left; vertical-align: baseline;">
<div style="text-align: left;">
<span style="color: #666666; font-family: "arial" , "sans-serif"; font-size: 9.0pt;">The Transaction log records all
transactions that occur on the database.<o:p></o:p></span></div>
</div>
<div style="background: white; margin: 0in 0in 13.5pt; text-align: left; vertical-align: baseline;">
<div style="text-align: left;">
<span style="color: #666666; font-family: "arial" , "sans-serif"; font-size: 9.0pt;">Depending on the recovery model
that is set on the database, you may notice growth of the transaction log. The
recovery model for the database can dramatically affect database growth for any
database.<o:p></o:p></span></div>
</div>
<div style="background: white; margin: 0in 0in 13.5pt; text-align: left; vertical-align: baseline;">
<div style="text-align: left;">
<span style="color: #666666; font-family: "arial" , "sans-serif"; font-size: 9.0pt;">There are three different
recovery models for Microsoft SQL:<o:p></o:p></span></div>
</div>
<ul type="disc">
<li class="MsoNormal" style="background: white; margin-bottom: 12pt;"><div style="color: #666666; text-align: left;">
<div style="text-align: justify;">
<strong style="text-align: left;"><span style="border: none 1.0pt; font-family: "inherit" , "serif"; font-size: 9.0pt; padding: 0in;">Full Recovery Model</span></strong></div>
</div>
<b><div style="text-align: left;">
<div style="text-align: left;">
<span style="color: #666666; font-family: inherit , serif; font-size: 12px;"><br /></span></div>
</div>
</b><span style="color: #666666; font-family: "arial" , sans-serif; font-size: 9pt;"><div style="text-align: left;">
<div style="text-align: justify;">
<span style="font-size: 9pt; text-align: left;">This
model logs all transactions, which makes full failure recovery possible.
It provides the greatest amount of recovery potential in case of a failure
that impacts the database, but it uses the most disk space of all of the
models.</span></div>
</div>
<o:p></o:p></span></li>
<li class="MsoNormal" style="background: white; margin-bottom: 12pt;"><div style="color: #666666; text-align: left;">
<div style="text-align: justify;">
<b style="text-align: left;"><span style="border: none 1.0pt; font-family: "inherit" , "serif"; font-size: 9.0pt; padding: 0in;">Bulk-Logged Recovery Model</span></b><span class="apple-converted-space" style="text-align: left;"><span style="font-family: "arial" , "sans-serif"; font-size: 9.0pt;"> </span></span></div>
</div>
<div style="text-align: left;">
<div style="text-align: left;">
<span style="color: #666666; font-family: "arial" , sans-serif; font-size: 12px;"><br /></span></div>
</div>
<span style="color: #666666; font-family: "arial" , sans-serif; font-size: 9pt;"><div style="text-align: left;">
<div style="text-align: justify;">
<span style="font-size: 9pt; text-align: left;">This model logs all transactions except for certain large scale operations
such as Index creation or bulk load operations. A full backup is typically
performed after a large insert of information, but this model does not consume
as much disk space.</span></div>
</div>
<o:p></o:p></span></li>
<li class="MsoNormal" style="background: white;"><div style="color: #666666; text-align: left;">
<div style="text-align: justify;">
<b style="text-align: left;"><span style="border: none 1.0pt; font-family: "inherit" , "serif"; font-size: 9.0pt; padding: 0in;">Simple Recovery Model</span></b><span class="apple-converted-space" style="text-align: left;"><span style="font-family: "arial" , "sans-serif"; font-size: 9.0pt;"> </span></span></div>
</div>
<div style="text-align: left;">
<div style="text-align: left;">
<span style="color: #666666; font-family: "arial" , sans-serif; font-size: 12px;"><br /></span></div>
</div>
<span style="color: #666666; font-family: "arial" , sans-serif; font-size: 9pt;"><div style="text-align: left;">
<div style="text-align: justify;">
<span style="font-size: 9pt; text-align: left;">This model logs all transactions, but after the transaction is complete,
it is deleted. It uses the least amount of disk space of all the models,
but it also offers the least amount of recovery. As such, regular full
backups need to be taken.</span></div>
</div>
<o:p></o:p></span></li>
</ul>
<div style="background: white; margin: 0in 0in 13.5pt; text-align: left; vertical-align: baseline;">
<div style="text-align: left;">
<span style="color: #666666; font-family: "arial" , "sans-serif"; font-size: 9.0pt;">By default, Microsoft SQL uses
the full recovery model for the databases. Due to the large number of
transactions with the vCenter Server database, VMware uses a warning during the
installer that indicates the recovery model that is set in the database. For
example:<o:p></o:p></span></div>
</div>
<div class="MsoNormal">
</div>
<div style="text-align: left;">
</div>
<div style="text-align: left;">
<br /></div>
<div style="text-align: left;">
<div style="text-align: justify;">
<span style="background-color: white; color: #666666; font-family: "arial" , sans-serif; font-size: 9pt; line-height: 115%;"><span style="font-size: 9pt; line-height: 115%; text-align: left;">Regardless of the recovery model, VMware
recommends that you take regular backups of the database and that a truncate of
the transaction log is performed at the same time as the backup. This regular maintenance
prevents the size of the transaction logs from posing an issue to the amount of
disk space available to the system. For more information on the transaction
logs and how to shrink them, see:</span></span></div>
</div>
<span style="background-color: white; color: #666666; font-family: "arial" , sans-serif; font-size: 9pt; line-height: 115%;">
</span>
<br />
<ul type="disc">
<li class="MsoNormal" style="background: white; color: #666666; text-align: left;"><span style="color: windowtext;"><a href="http://kb.vmware.com/selfservice/search.do?cmd=displayKC&docType=kc&docTypeID=DT_KB_1_1&externalId=1001046" target="_blank"><span style="border: none 1.0pt; color: #006990; font-family: "inherit" , "serif"; font-size: 9.0pt; padding: 0in;">SQL Server Recovery Model
Affects Transaction Log Disk Space Requirements (1001046)</span></a></span><span style="font-family: "arial" , "sans-serif"; font-size: 9.0pt;"> <o:p></o:p></span></li>
<li class="MsoNormal" style="background: white; color: #666666; text-align: left;"><span style="color: windowtext;"><a href="http://kb.vmware.com/selfservice/search.do?cmd=displayKC&docType=kc&docTypeID=DT_KB_1_1&externalId=1003980" target="_blank"><span style="border: none 1.0pt; color: #006990; font-family: "inherit" , "serif"; font-size: 9.0pt; padding: 0in;">Troubleshooting
transaction logs on a Microsoft SQL database server (1003980)</span></a></span><span style="font-family: "arial" , "sans-serif"; font-size: 9.0pt;"><o:p></o:p></span></li>
</ul>
<div class="MsoNormal" style="text-align: left;">
<div style="text-align: left;">
<br /></div>
</div>
<div class="MsoNormal" style="text-align: left;">
<div style="text-align: left;">
<b><i><u><span style="font-size: 18.0pt; line-height: 115%;">Reducing the size of
SQL Database <span style="color: red;">(Quarterly)<br /></span><o:p></o:p></span></u></i></b></div>
</div>
<div class="MsoNormal" style="background: white; margin-bottom: 10.5pt; text-align: left; vertical-align: baseline;">
<div style="text-align: left;">
<span style="font-family: "arial" , sans-serif; font-size: 10.5pt;">Reducing the size of the vCenter Server
database<o:p></o:p></span></div>
</div>
<div class="MsoNormal" style="background: white; margin-bottom: 0.0001pt; text-align: left; vertical-align: baseline;">
<div style="text-align: left;">
<span style="color: #666666; font-family: "arial" , "sans-serif"; font-size: 9.0pt;">To reduce the size of the vCenter Server database:<o:p></o:p></span></div>
</div>
<div class="MsoNormal" style="background: white; margin-bottom: 0.0001pt; text-align: left; vertical-align: baseline;">
<div style="text-align: left;">
<br /></div>
</div>
<div class="MsoNormal" style="background: white; margin-bottom: 0.0001pt; vertical-align: baseline;">
</div>
<div style="text-align: left;">
<div style="text-align: justify;">
<b style="text-align: left;"><span style="border: none 1.0pt; color: #666666; font-family: "inherit" , "serif"; font-size: 9.0pt; padding: 0in;">Warning</span></b><span style="color: #666666; font-family: "arial" , sans-serif; font-size: 9pt; text-align: left;">: This procedure erases all historical
data. If you want to retain some historical performance data instead of
deleting all of it, see </span><a href="http://kb.vmware.com/selfservice/search.do?cmd=displayKC&docType=kc&docTypeID=DT_KB_1_1&externalId=1025914" style="text-align: left;" target="_blank"><span style="border: none 1.0pt; color: #006990; font-family: "inherit" , "serif"; font-size: 9.0pt; padding: 0in;">Purging old data from the database used by vCenter Server
(1025914)</span></a><span style="color: #666666; font-family: "arial" , sans-serif; font-size: 9pt; text-align: left;"> or </span><a href="http://kb.vmware.com/selfservice/search.do?cmd=displayKC&docType=kc&docTypeID=DT_KB_1_1&externalId=1000125" style="text-align: left;" target="_blank"><span style="border: none 1.0pt; color: #006990; font-family: "inherit" , "serif"; font-size: 9.0pt; padding: 0in;">Purging old data from the database used by VirtualCenter 2.x
(1000125)</span></a><span style="color: #666666; font-family: "arial" , sans-serif; font-size: 9pt; text-align: left;">.</span></div>
</div>
<div style="text-align: left;">
<div style="text-align: left;">
<span style="color: #666666; font-family: "arial" , sans-serif; font-size: 12px;"><br /></span></div>
</div>
<div style="text-align: left;">
<b></b><br /></div>
<div style="text-align: left;">
<div style="text-align: justify;">
<b><b style="text-align: left;"><span style="border: none 1.0pt; color: #666666; font-family: "inherit" , "serif"; font-size: 9.0pt; padding: 0in;">Note</span></b><span style="color: #666666; font-family: "arial" , sans-serif; font-size: 9pt; text-align: left;">: The below steps are
not applicable to vCenter Server 5.1 and 5.5. To truncate performance data on
the vCenter Server 5.1 and 5.5 database see the sections, Truncating all
performance data from vCenter Server 5.1.</span></b></div>
</div>
<b>
</b>
<br />
<div class="MsoNormal" style="text-align: left;">
<div style="text-align: left;">
<br /></div>
</div>
<div class="MsoNormal" style="background: white; margin-bottom: 0.0001pt; text-align: left; vertical-align: baseline;">
<div style="text-align: left;">
<span style="color: #666666; font-family: "arial" , "sans-serif"; font-size: 9.0pt;">To reduce the data perform these steps:<o:p></o:p></span></div>
</div>
<div class="MsoNormal" style="background: white; margin-left: 0.5in; text-align: left; text-indent: -0.25in;">
<div style="text-align: left;">
<!--[if !supportLists]--><span style="color: #666666; font-family: "arial" , "sans-serif"; font-size: 9.0pt;">1.<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal;">
</span></span><!--[endif]--><span style="color: #666666; font-family: "arial" , "sans-serif"; font-size: 9.0pt;">If your database is
Microsoft SQL Server, Oracle or PostgreSQL, obtain the vCenter Server database
password.<o:p></o:p></span></div>
</div>
<div class="MsoNormal" style="background: white; margin: 0in 0in 0.0001pt 0.5in; text-align: left; vertical-align: baseline;">
<div style="text-align: left;">
<span style="color: #666666; mso-bidi-font-family: Arial; mso-fareast-font-family: "Times New Roman";">For information, see the <i><span style="border: none windowtext 1.0pt; mso-border-alt: none windowtext 0in; padding: 0in;">Obtain the vCenter Server database password</span></i> section
in this Knowledge Base article.<o:p></o:p></span></div>
</div>
<div class="MsoNormal" style="background: white; margin-left: 0.5in; text-indent: -0.25in;">
</div>
<div style="text-align: left;">
<div style="text-align: justify;">
<span style="color: #666666; font-family: "arial" , sans-serif; font-size: 9pt; text-align: left; text-indent: -0.25in;">2.<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal;">
</span></span><span style="color: #666666; font-family: "arial" , sans-serif; font-size: 9pt; text-align: left; text-indent: -0.25in;">Stop the vCenter
Server service.</span></div>
</div>
<!--[if !supportLists]--><br />
<div style="text-align: justify;">
<span style="color: #666666; font-family: "courier new"; font-size: 10pt; text-align: left; text-indent: -0.25in;">o<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal;"> </span></span><span style="color: #666666; font-family: "arial" , sans-serif; font-size: 9pt; text-align: left; text-indent: -0.25in;">If you installed vCenter Server on a Windows
machine: </span></div>
<div style="text-align: left;">
<br /></div>
<div style="text-align: left;">
<div style="text-align: justify;">
<a href="https://www.blogger.com/blogger.g?blogID=7539481448228753383" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"></a><a href="https://www.blogger.com/blogger.g?blogID=7539481448228753383" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"></a><b><b style="text-align: left; text-indent: -0.25in;"><span style="border: none 1.0pt; color: #666666; font-family: "inherit" , "serif"; font-size: 9.0pt; padding: 0in;">Note</span></b><span style="color: #666666; font-family: "arial" , sans-serif; font-size: 9pt; text-align: left; text-indent: -0.25in;">: For more
information, see </span><a href="http://kb.vmware.com/selfservice/search.do?cmd=displayKC&docType=kc&docTypeID=DT_KB_1_1&externalId=1003895" style="text-align: left; text-indent: -0.25in;" target="_blank"><span style="border: none 1.0pt; color: #006990; font-family: "inherit" , "serif"; font-size: 9.0pt; padding: 0in;">Stopping, starting, or restarting VMware vCenter Server services
(1003895)</span></a><span style="color: #666666; font-family: "arial" , sans-serif; font-size: 9pt; text-align: left; text-indent: -0.25in;"> and </span><a href="http://kb.vmware.com/selfservice/search.do?cmd=displayKC&docType=kc&docTypeID=DT_KB_1_1&externalId=2109881" style="text-align: left; text-indent: -0.25in;" target="_blank"><span style="border: none 1.0pt; color: #006990; font-family: "inherit" , "serif"; font-size: 9.0pt; padding: 0in;">Stopping, starting, or restarting VMware vCenter Server 6.0
services (2109881)</span></a><span style="color: #666666; font-family: "arial" , sans-serif; font-size: 9pt; text-align: left; text-indent: -0.25in;">.</span></b><br />
<b><span style="color: #666666; font-family: "arial" , sans-serif; font-size: 9pt; text-align: left; text-indent: -0.25in;"><br /></span></b></div>
</div>
<b>
</b>
<br />
<div class="MsoNormal" style="background: white; margin-left: 1.5in; text-align: left; text-indent: -0.25in;">
<div style="text-align: left;">
<!--[if !supportLists]--><span style="color: #666666; font-family: "arial" , "sans-serif"; font-size: 9.0pt;">a.<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal;">
</span></span><!--[endif]--><span style="color: #666666; font-family: "arial" , "sans-serif"; font-size: 9.0pt;">Log in as an
administrator to the Windows machine on which vCenter Server is installed.<o:p></o:p></span></div>
</div>
<div class="MsoNormal" style="background: white; margin-left: 1.5in; text-align: left; text-indent: -0.25in;">
<div style="text-align: left;">
<!--[if !supportLists]--><span style="color: #666666; font-family: "arial" , "sans-serif"; font-size: 9.0pt;">b.<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal;">
</span></span><!--[endif]--><span style="color: #666666; font-family: "arial" , "sans-serif"; font-size: 9.0pt;">Navigate to </span><b><span style="border: none 1.0pt; color: #666666; font-family: "inherit" , "serif"; font-size: 9.0pt; padding: 0in;">Start > Administrative Tools
> Services</span></b><span style="color: #666666; font-family: "arial" , "sans-serif"; font-size: 9.0pt;">.<o:p></o:p></span></div>
</div>
<div class="MsoNormal" style="background: white; margin-bottom: 12pt; margin-left: 1.5in; text-align: left; text-indent: -0.25in;">
<div style="text-align: left;">
<!--[if !supportLists]--><span style="color: #666666; font-family: "arial" , "sans-serif"; font-size: 9.0pt;">c.<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal;">
</span></span><!--[endif]--><span style="color: #666666; font-family: "arial" , "sans-serif"; font-size: 9.0pt;">Right-click </span><b><span style="border: none 1.0pt; color: #666666; font-family: "inherit" , "serif"; font-size: 9.0pt; padding: 0in;">VMware VirtualCenter Server</span></b><span style="color: #666666; font-family: "arial" , "sans-serif"; font-size: 9.0pt;"> and select </span><b><span style="border: none 1.0pt; color: #666666; font-family: "inherit" , "serif"; font-size: 9.0pt; padding: 0in;">Stop</span></b><span style="color: #666666; font-family: "arial" , "sans-serif"; font-size: 9.0pt;">. <o:p></o:p></span></div>
</div>
<div class="MsoNormal" style="background: white; margin-left: 0.5in; text-indent: -0.25in;">
</div>
<div style="text-align: left;">
<div style="text-align: justify;">
<span style="color: #666666; font-family: "arial" , sans-serif; font-size: 9pt; text-align: left; text-indent: -0.25in;">3.<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal;">
</span></span><span style="color: #666666; font-family: "arial" , sans-serif; font-size: 9pt; text-align: left; text-indent: -0.25in;">Back up the vCenter
Server database. </span></div>
</div>
<div style="text-align: left;">
<!--[if !supportLists]--><a href="https://www.blogger.com/blogger.g?blogID=7539481448228753383" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"></a><a href="https://www.blogger.com/blogger.g?blogID=7539481448228753383" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"></a><br /></div>
<div style="text-align: left;">
<div style="text-align: left;">
<span style="color: #666666; font-family: "courier new"; font-size: 10pt; text-align: left; text-indent: -0.25in;">o<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal;"> </span></span><span style="color: #666666; font-family: "arial" , sans-serif; font-size: 9pt; text-align: left; text-indent: -0.25in;">For MS SQL, see your database vendor's
documentation.</span></div>
</div>
<div style="text-align: left;">
<br /></div>
<!--[if !supportLineBreakNewLine]-->
<!--[endif]--><span style="color: #666666; font-family: "arial" , sans-serif; font-size: 9pt;"><o:p></o:p></span>
<br />
<div class="MsoNormal" style="background: white; margin-left: 0.5in; text-align: left; text-indent: -0.25in;">
<div style="text-align: left;">
<!--[if !supportLists]--><span style="color: #666666; font-family: "arial" , "sans-serif"; font-size: 9.0pt;">4.<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal;">
</span></span><!--[endif]--><span style="color: #666666; font-family: "arial" , "sans-serif"; font-size: 9.0pt;">Run the script for
your database.<o:p></o:p></span></div>
</div>
<div class="MsoNormal" style="background: white; margin-bottom: 13.5pt; text-align: left; text-indent: 0.25in; vertical-align: baseline;">
<div style="text-align: left;">
<span style="color: #666666; font-family: "arial" , "sans-serif"; font-size: 9.0pt;">As vCenter Server is installed on a Windows machine:<o:p></o:p></span></div>
</div>
<div class="MsoNormal" style="background: white; margin-left: 0.5in; text-align: left; text-indent: -0.25in;">
<div style="text-align: left;">
<!--[if !supportLists]--><span style="color: #666666; font-family: "arial" , "sans-serif"; font-size: 9.0pt;">1.<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal;">
</span></span><!--[endif]--><span style="color: #666666; font-family: "arial" , "sans-serif"; font-size: 9.0pt;">Log in as an
administrator to the Windows machine on which vCenter Server is installed.<o:p></o:p></span></div>
</div>
<div class="MsoNormal" style="background: white; margin-left: 0.5in; text-align: left; text-indent: -0.25in;">
<div style="text-align: left;">
<!--[if !supportLists]--><span style="color: #666666; font-family: "arial" , "sans-serif"; font-size: 9.0pt;">2.<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal;">
</span></span><!--[endif]--><span style="color: #666666; font-family: "arial" , "sans-serif"; font-size: 9.0pt;">Locate the </span><span style="border: none 1.0pt; color: #666666; font-family: "courier new"; font-size: 10.0pt; padding: 0in;">vcdb.properties</span><span style="color: #666666; font-family: "arial" , "sans-serif"; font-size: 9.0pt;"> file
and open the file by using a text editor.<o:p></o:p></span></div>
</div>
<div class="MsoNormal" style="background: white; margin-left: 1in; text-align: left; text-indent: -0.25in;">
<div style="text-align: left;">
<!--[if !supportLists]--><span style="color: #666666; font-family: "courier new"; font-size: 10.0pt;">o<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal;"> </span></span><!--[endif]--><span style="color: #666666; font-family: "arial" , "sans-serif"; font-size: 9.0pt;">For vCenter Server 5.1 and 5.5, the file is
located in the </span><span style="border: none 1.0pt; color: #666666; font-family: "courier new"; font-size: 10.0pt; padding: 0in;">C:\ProgramData\VMware\VMware
VirtualCenter\</span><span style="color: #666666; font-family: "arial" , "sans-serif"; font-size: 9.0pt;"> folder.<o:p></o:p></span></div>
</div>
<div class="MsoNormal" style="background: white; margin-left: 1in; text-align: left; text-indent: -0.25in;">
<div style="text-align: left;">
<!--[if !supportLists]--><span style="color: #666666; font-family: "courier new"; font-size: 10.0pt;">o<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal;"> </span></span><!--[endif]--><span style="color: #666666; font-family: "arial" , "sans-serif"; font-size: 9.0pt;">For vCenter Server 6.0 the file is located in
the </span><span style="border: none 1.0pt; color: #666666; font-family: "courier new"; font-size: 10.0pt; padding: 0in;">C:\ProgramData\VMware\vCenterServer\cfg\vmware-vpx\</span><span style="color: #666666; font-family: "arial" , "sans-serif"; font-size: 9.0pt;"> folder.<o:p></o:p></span></div>
</div>
<div class="MsoNormal" style="background: white; margin-left: 0.5in; text-align: left; text-indent: -0.25in;">
<div style="text-align: left;">
<!--[if !supportLists]--><span style="color: #666666; font-family: "arial" , "sans-serif"; font-size: 9.0pt;">3.<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal;">
</span></span><!--[endif]--><span style="color: #666666; font-family: "arial" , "sans-serif"; font-size: 9.0pt;">In the </span><span style="border: none 1.0pt; color: #666666; font-family: "courier new"; font-size: 10.0pt; padding: 0in;">vcdb.properties</span><span style="color: #666666; font-family: "arial" , "sans-serif"; font-size: 9.0pt;"> file,
locate the password of the vCenter Server database user and record it.<o:p></o:p></span></div>
</div>
<div class="MsoNormal" style="background: white; margin: 0in 0in 0.0001pt 0.5in; text-align: left; vertical-align: baseline;">
<div style="text-align: left;">
<span style="color: #666666; font-family: "arial" , "sans-serif"; mso-fareast-font-family: "Times New Roman";">For information, see
the </span><i><span style="border: none 1.0pt; color: #666666; font-family: "inherit" , "serif"; padding: 0in;">Run the script for your
database</span></i><span style="color: #666666; font-family: "arial" , "sans-serif"; mso-fareast-font-family: "Times New Roman";"> section in this KB article.<o:p></o:p></span></div>
</div>
<div class="MsoNormal" style="background: white; vertical-align: baseline;">
</div>
<div style="text-align: left;">
<div style="text-align: justify;">
<b style="text-align: left;"> </b><span style="color: #666666; font-family: "arial" , sans-serif; text-align: left;">The scripts contain
three main parameters:</span></div>
</div>
<div style="text-align: left;">
<div style="text-align: left;">
</div>
</div>
<div style="text-align: left;">
<br /></div>
<div style="text-align: left;">
<div style="text-align: justify;">
<span style="color: #666666; font-family: "arial" , "sans-serif"; font-size: 9.0pt; line-height: 115%;"><span style="font-family: "arial" , sans-serif; font-size: 9pt; line-height: 115%; text-align: left;"> For</span><span style="font-family: "arial" , sans-serif; font-size: 9pt; line-height: 115%; text-align: left;"> Microsoft SQL Server:</span></span><br />
<span style="color: #666666; font-family: "arial" , "sans-serif"; font-size: 9.0pt; line-height: 115%;"><span style="font-family: "arial" , sans-serif; font-size: 9pt; line-height: 115%; text-align: left;"><br /></span></span></div>
</div>
<span style="color: #666666; font-family: "arial" , "sans-serif"; font-size: 9.0pt; line-height: 115%;">
</span>
<br />
<div class="MsoNormal" style="background: white; margin-left: 0.5in; text-align: left; text-indent: -0.25in;">
<div style="text-align: left;">
<!--[if !supportLists]--><span style="color: #666666; font-family: "arial" , "sans-serif"; font-size: 9.0pt;">1.<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal;">
</span></span><!--[endif]--><span style="color: #666666; font-family: "arial" , "sans-serif"; font-size: 9.0pt;">Log in to the
Microsoft SQL Server machine as an administrator.<o:p></o:p></span></div>
</div>
<div class="MsoNormal" style="background: white; margin-left: 0.5in; text-align: left; text-indent: -0.25in;">
<div style="text-align: left;">
<!--[if !supportLists]--><span style="color: #666666; font-family: "arial" , "sans-serif"; font-size: 9.0pt;">2.<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal;">
</span></span><!--[endif]--><span style="color: #666666; font-family: "arial" , "sans-serif"; font-size: 9.0pt;">Download and save
the </span><span style="border: none 1.0pt; color: #666666; font-family: "courier new"; font-size: 10.0pt; padding: 0in;">2110031_MS_SQL_task_event_task.sql</span><span style="color: #666666; font-family: "arial" , "sans-serif"; font-size: 9.0pt;"> script attached to this Knowledge Base
article.<o:p></o:p></span></div>
</div>
<div class="MsoNormal" style="background: white; margin-left: 0.5in; text-align: left; text-indent: -0.25in;">
<div style="text-align: left;">
<!--[if !supportLists]--><span style="color: #666666; font-family: "arial" , "sans-serif"; font-size: 9.0pt;">3.<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal;">
</span></span><!--[endif]--><span style="color: #666666; font-family: "arial" , "sans-serif"; font-size: 9.0pt;">Open the command
prompt and run the script:<o:p></o:p></span></div>
</div>
<div class="MsoNormal" style="background: white; margin: 0in 0in 0.0001pt 0.5in; text-align: left; vertical-align: baseline;">
<div style="text-align: left;">
<span style="border: none 1.0pt; color: #666666; font-family: "courier new"; font-size: 10.0pt; padding: 0in;">sqlcmd -S </span><i><span style="border: none 1.0pt; color: #666666; font-family: "inherit" , "serif"; font-size: 10.0pt; padding: 0in;">IP-address-or-FQDN-of-the-database-machine\instance_name</span></i><span style="border: none 1.0pt; color: #666666; font-family: "courier new"; font-size: 10.0pt; padding: 0in;"> -U </span><i><span style="border: none 1.0pt; color: #666666; font-family: "inherit" , "serif"; font-size: 10.0pt; padding: 0in;">vCenter-Server-database-user</span></i><span style="border: none 1.0pt; color: #666666; font-family: "courier new"; font-size: 10.0pt; padding: 0in;"> -P </span><i><span style="border: none 1.0pt; color: #666666; font-family: "inherit" , "serif"; font-size: 10.0pt; padding: 0in;">password</span></i><span style="border: none 1.0pt; color: #666666; font-family: "courier new"; font-size: 10.0pt; padding: 0in;">-d </span><i><span style="border: none 1.0pt; color: #666666; font-family: "inherit" , "serif"; font-size: 10.0pt; padding: 0in;">database-name</span></i><span style="border: none 1.0pt; color: #666666; font-family: "courier new"; font-size: 10.0pt; padding: 0in;"> -v TaskMaxAgeInDays=</span><i><span style="border: none 1.0pt; color: #666666; font-family: "inherit" , "serif"; font-size: 10.0pt; padding: 0in;">task-days</span></i><span style="border: none 1.0pt; color: #666666; font-family: "courier new"; font-size: 10.0pt; padding: 0in;"> -v EventMaxAgeInDays=</span><i><span style="border: none 1.0pt; color: #666666; font-family: "inherit" , "serif"; font-size: 10.0pt; padding: 0in;">event-days</span></i><span style="border: none 1.0pt; color: #666666; font-family: "courier new"; font-size: 10.0pt; padding: 0in;"> -v StatMaxAgeInDays=</span><i><span style="border: none 1.0pt; color: #666666; font-family: "inherit" , "serif"; font-size: 10.0pt; padding: 0in;">stat-days</span></i><span style="border: none 1.0pt; color: #666666; font-family: "courier new"; font-size: 10.0pt; padding: 0in;"> -i </span><i><span style="border: none 1.0pt; color: #666666; font-family: "inherit" , "serif"; font-size: 10.0pt; padding: 0in;">download-path</span></i><span style="border: none 1.0pt; color: #666666; font-family: "courier new"; font-size: 10.0pt; padding: 0in;">\2110031_MS_SQL_task_event_stat.sql</span><span style="color: #666666; font-family: "arial" , "sans-serif"; font-size: 12.0pt;"><o:p></o:p></span></div>
</div>
<div style="background: white; margin: 0in 0in 13.5pt; text-align: left; vertical-align: baseline;">
<div style="text-align: left;">
</div>
</div>
<ul type="disc">
<li class="MsoNormal" style="background: white; color: #666666; text-align: left;"><b><span style="border: none 1.0pt; font-family: "inherit" , "serif"; padding: 0in;">TaskMaxAgeInDays</span></b><span style="font-family: "arial" , "sans-serif"; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></li>
</ul>
<div class="MsoNormal" style="background: white; margin: 0in 0in 13.5pt 0.5in; text-align: left; vertical-align: baseline;">
<div style="text-align: left;">
<span style="color: #666666; font-family: "arial" , "sans-serif"; mso-fareast-font-family: "Times New Roman";">All tasks older than TaskMaxAgeInDays day are deleted.<o:p></o:p></span></div>
</div>
<ul type="disc">
<li class="MsoNormal" style="background: white; color: #666666; text-align: left;"><b><span style="border: none 1.0pt; font-family: "inherit" , "serif"; padding: 0in;">EventMaxAgeInDays</span></b><span style="font-family: "arial" , "sans-serif"; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></li>
</ul>
<div class="MsoNormal" style="background: white; margin: 0in 0in 13.5pt 0.5in; text-align: left; vertical-align: baseline;">
<div style="text-align: left;">
<span style="color: #666666; font-family: "arial" , "sans-serif"; mso-fareast-font-family: "Times New Roman";">All events older than EventMaxAgeInDays day are deleted.<o:p></o:p></span></div>
</div>
<ul type="disc">
<li class="MsoNormal" style="background: white; color: #666666; text-align: left;"><b><span style="border: none 1.0pt; font-family: "inherit" , "serif"; padding: 0in;">StatMaxAgeInDays</span></b><span style="font-family: "arial" , "sans-serif"; mso-fareast-font-family: "Times New Roman";"><o:p></o:p></span></li>
</ul>
<div class="MsoNormal" style="background: white; margin: 0in 0in 13.5pt 0.5in; text-align: left; vertical-align: baseline;">
<div style="text-align: left;">
<span style="color: #666666; font-family: "arial" , "sans-serif"; mso-fareast-font-family: "Times New Roman";">All statistics older than StatMaxAgeInDays day are deleted.<o:p></o:p></span></div>
</div>
<div class="MsoNormal" style="background: white; margin-bottom: 12pt; text-align: left; vertical-align: baseline;">
<div style="text-align: left;">
<span style="color: #666666; font-family: "arial" , "sans-serif"; font-size: 9.0pt;">The possible values
for all of the parameters are:<o:p></o:p></span></div>
</div>
<table border="0" cellpadding="0" cellspacing="0" class="MsoNormalTable" style="border-collapse: collapse; mso-padding-alt: 0in 0in 0in 0in; mso-yfti-tbllook: 1184; width: 735px;">
<tbody>
<tr>
<td style="border: solid black 1.0pt; mso-border-alt: solid black .75pt; padding: 2.25pt 2.25pt 2.25pt 2.25pt;" valign="top"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "arial" , "sans-serif"; font-size: 9.0pt;">-1<o:p></o:p></span></div>
</td>
<td style="border-left: none; border: solid black 1.0pt; mso-border-alt: solid black .75pt; mso-border-left-alt: solid black .75pt; padding: 2.25pt 2.25pt 2.25pt 2.25pt; width: 510.75pt;" valign="top" width="681"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "arial" , "sans-serif"; font-size: 9.0pt;">Skips the respective historical
data deletion. For example, TaskMaxAgeInDays = -1, means that no task records
will be deleted.<o:p></o:p></span></div>
</td>
</tr>
<tr>
<td style="border-top: none; border: solid black 1.0pt; mso-border-alt: solid black .75pt; mso-border-top-alt: solid black .75pt; padding: 2.25pt 2.25pt 2.25pt 2.25pt;" valign="top"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "arial" , "sans-serif"; font-size: 9.0pt;">0<o:p></o:p></span></div>
</td>
<td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .75pt; mso-border-left-alt: solid black .75pt; mso-border-top-alt: solid black .75pt; padding: 2.25pt 2.25pt 2.25pt 2.25pt; width: 510.75pt;" valign="top" width="681"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "arial" , "sans-serif"; font-size: 9.0pt;">Deletes all historical data for
the respective component. For example, TaskMaxAgeInDays = 0, deletes all task
records.<o:p></o:p></span></div>
</td>
</tr>
<tr>
<td style="border-top: none; border: solid black 1.0pt; mso-border-alt: solid black .75pt; mso-border-top-alt: solid black .75pt; padding: 2.25pt 2.25pt 2.25pt 2.25pt;" valign="top"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: "arial" , "sans-serif"; font-size: 9.0pt;">1 and more<o:p></o:p></span></div>
</td>
<td style="border-bottom: solid black 1.0pt; border-left: none; border-right: solid black 1.0pt; border-top: none; mso-border-alt: solid black .75pt; mso-border-left-alt: solid black .75pt; mso-border-top-alt: solid black .75pt; padding: 2.25pt 2.25pt 2.25pt 2.25pt; width: 510.75pt;" valign="top" width="681"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<a href="https://www.blogger.com/blogger.g?blogID=7539481448228753383" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"></a><a href="https://www.blogger.com/blogger.g?blogID=7539481448228753383" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"></a><span style="font-family: "arial" , "sans-serif"; font-size: 9.0pt;">Deletes data older than the number
you enter, in days. For example, TaskMaxAgeInDays = 10, leaves the task
records gathered within the last 10 days and deletes all of the records
gathered before that.<o:p></o:p></span></div>
</td>
</tr>
</tbody></table>
<div class="MsoNormal" style="background: white; margin-bottom: 13.5pt; text-align: left; vertical-align: baseline;">
<div style="text-align: left;">
<br /></div>
</div>
<h2 style="background: white; margin-top: 0in; text-align: left; vertical-align: baseline;">
<i><u><span style="border: none 1.0pt; font-family: "inherit" , "serif"; font-size: 18.0pt; line-height: 115%; padding: 0in;">Rebuilding indexes</span></u></i><span class="apple-converted-space"><i><u><span style="border: none 1.0pt; color: #387c2c; font-family: "inherit" , "serif"; font-size: 18.0pt; line-height: 115%; padding: 0in;"> </span></u></i></span><i><u><span style="color: red; font-size: 18.0pt; line-height: 115%;">(Quarterly)</span></u></i></h2>
<div class="MsoNormal" style="text-align: left;">
<div style="text-align: left;">
<span style="background-color: white; color: #666666; font-family: "arial" , sans-serif; font-size: 9pt;">To
rebuild the vCenter Server database indexes:</span></div>
</div>
<div class="MsoNormal" style="background: white; margin-bottom: 12pt; margin-left: 0.5in; text-indent: -0.25in;">
</div>
<div style="text-align: left;">
<div style="text-align: justify;">
<span style="color: #666666; font-family: "arial" , sans-serif; font-size: 9pt; text-align: left; text-indent: -0.25in;">1.<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal;">
</span></span><span style="color: #666666; font-family: "arial" , sans-serif; font-size: 9pt; text-align: left; text-indent: -0.25in;">Download and extract
the </span><span style="border: 1pt none; color: #666666; font-family: "courier new"; font-size: 10pt; padding: 0in; text-align: left; text-indent: -0.25in;">.sql</span><span style="color: #666666; font-family: "arial" , sans-serif; font-size: 9pt; text-align: left; text-indent: -0.25in;"> files from the </span><a href="http://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=2009918" style="text-align: left; text-indent: -0.25in;"><span style="border: none 1.0pt; font-family: "courier new"; font-size: 10.0pt; padding: 0in;">2009918_rebuild.zip</span></a><span style="border: 1pt none; color: #666666; font-family: "courier new"; font-size: 10pt; padding: 0in; text-align: left; text-indent: -0.25in;"> </span><span style="color: #666666; font-family: "arial" , sans-serif; font-size: 9pt; text-align: left; text-indent: -0.25in;">file attached to this
article. </span></div>
</div>
<div style="text-align: left;">
<!--[if !supportLists]--><br /></div>
<div style="text-align: left;">
<div style="text-align: justify;">
<b style="text-align: justify;"><b style="text-align: left; text-indent: -0.25in;"><span style="border: none 1.0pt; color: #666666; font-family: "inherit" , "serif"; font-size: 9.0pt; padding: 0in;">Note</span></b><span style="color: #666666; font-family: "arial" , sans-serif; font-size: 9pt; text-align: left; text-indent: -0.25in;">: For a vCenter Server
5.1 and 5.5 databases, download and extract the </span><span style="border: 1pt none; color: #666666; font-family: "courier new"; font-size: 10pt; padding: 0in; text-align: left; text-indent: -0.25in;">.sql</span><span style="color: #666666; font-family: "arial" , sans-serif; font-size: 9pt; text-align: left; text-indent: -0.25in;"> files from
the </span><span style="color: #666666; font-family: "courier new"; font-size: 9pt; text-align: left; text-indent: -0.25in;">2009918_rebuild_51.zip</span><span style="color: #666666; font-family: "arial" , sans-serif; font-size: 9pt; text-align: left; text-indent: -0.25in;"> file attached to this article.</span></b></div>
</div>
<b>
</b>
<br />
<div class="MsoNormal" style="background: white; margin-left: 0.5in; text-align: left; text-indent: -0.25in;">
<div style="text-align: left;">
<!--[if !supportLists]--><span style="color: #666666; font-family: "arial" , "sans-serif"; font-size: 9.0pt;">2.<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal;">
</span></span><!--[endif]--><span style="color: #666666; font-family: "arial" , "sans-serif"; font-size: 9.0pt;">Connect to the vCenter
Server database, for example using Management Studio for SQL Server or SQL*Plus
for Oracle.<o:p></o:p></span></div>
</div>
<div class="MsoNormal" style="background: white; margin-left: 0.5in; text-indent: -0.25in;">
</div>
<div style="text-align: left;">
<div style="text-align: justify;">
<span style="color: #666666; font-family: "arial" , sans-serif; font-size: 9pt; text-align: left; text-indent: -0.25in;">3.<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal;">
</span></span><span style="color: #666666; font-family: "arial" , sans-serif; font-size: 9pt; text-align: left; text-indent: -0.25in;">Execute the </span><span style="border: 1pt none; color: #666666; font-family: "courier new"; font-size: 10pt; padding: 0in; text-align: left; text-indent: -0.25in;">.sql</span><span style="color: #666666; font-family: "arial" , sans-serif; font-size: 9pt; text-align: left; text-indent: -0.25in;"> file to create
the </span><span style="color: #666666; font-family: "courier new"; font-size: 9pt; text-align: left; text-indent: -0.25in;">REBUILD_INDEX</span><span style="color: #666666; font-family: "arial" , sans-serif; font-size: 9pt; text-align: left; text-indent: -0.25in;"> stored procedure:</span></div>
<div style="text-align: justify;">
<span style="color: #666666; font-family: "arial" , sans-serif; font-size: 9pt; text-align: left; text-indent: -0.25in;"><br /></span></div>
</div>
<div style="text-align: justify;">
<span style="color: #666666; font-family: "courier new"; font-size: 10.0pt;">o<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal;"> </span></span><span style="color: #666666; font-family: "arial" , "sans-serif"; font-size: 9.0pt;">Oracle: </span><span style="border: none 1.0pt; color: #666666; font-family: "courier new"; font-size: 10.0pt; padding: 0in;">rebuild_indexes_oracle.sql</span><span style="color: #666666; font-family: "arial" , "sans-serif"; font-size: 9.0pt;"> or </span><span style="border: none 1.0pt; color: #666666; font-family: "courier new"; font-size: 10.0pt; padding: 0in;">rebuild_indexes_oracle_51.sql</span></div>
<div class="MsoNormal" style="background: white; margin-left: 1in; text-indent: -0.25in;">
</div>
<div style="text-align: left;">
<div style="text-align: justify;">
<span style="color: #666666; font-family: "courier new"; font-size: 10pt; text-align: left; text-indent: -0.25in;">o<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal;"> </span></span><span style="color: #666666; font-family: "arial" , sans-serif; font-size: 9pt; text-align: left; text-indent: -0.25in;">SQL Server: </span><span style="border: 1pt none; color: #666666; font-family: "courier new"; font-size: 10pt; padding: 0in; text-align: left; text-indent: -0.25in;">rebuild_indexes_sql.sql</span><span style="color: #666666; font-family: "arial" , sans-serif; font-size: 9pt; text-align: left; text-indent: -0.25in;"> or </span><span style="border: 1pt none; color: #666666; font-family: "courier new"; font-size: 10pt; padding: 0in; text-align: left; text-indent: -0.25in;">rebuild_indexes_sql_51.sql</span></div>
</div>
<div style="text-align: left;">
<br /></div>
<span style="border: 1pt none windowtext; padding: 0in;">
<!--[if !supportLineBreakNewLine]-->
<!--[endif]--></span><span style="color: #666666; font-family: "arial" , "sans-serif"; font-size: 9.0pt;"><o:p></o:p></span><br />
<div class="MsoNormal" style="background: white; margin-left: 0.5in; text-indent: -0.25in;">
</div>
<div style="text-align: left;">
<div style="text-align: justify;">
<span style="color: #666666; font-family: "arial" , sans-serif; font-size: 9pt; text-align: left; text-indent: -0.25in;">4.<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal;">
</span></span><span style="color: #666666; font-family: "arial" , sans-serif; font-size: 9pt; text-align: left; text-indent: -0.25in;">Execute the stored
procedure for either Oracle or SQL Server that was created in the previous
step:</span></div>
</div>
<div style="text-align: justify;">
<span style="color: #666666; font-family: "courier new"; font-size: 10pt; text-align: left; text-indent: -0.25in;"><br /></span></div>
<div style="text-align: justify;">
<span style="color: #666666; font-family: "courier new"; font-size: 10pt; text-align: left; text-indent: -0.25in;">execute REBUILD_INDEX</span></div>
<div style="text-align: justify;">
<br /></div>
<span style="border: none 1.0pt; color: #666666; font-family: "courier new"; font-size: 10.0pt; padding: 0in;">
</span>
<br />
<div class="MsoNormal" style="text-align: left;">
<div style="text-align: left;">
<b><i><u><span style="font-size: 18.0pt; line-height: 115%;">Backup of vCenter
SSL Certificates <span style="color: red;">(Yearly) </span><o:p></o:p></span></u></i></b></div>
</div>
<div class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: left;">
<div style="text-align: left;">
<span style="font-family: "symbol"; font-size: 12.0pt;">·</span><span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;"> Windows 2003: </span><span style="border: none 1.0pt; font-family: "courier new"; font-size: 10.0pt; padding: 0in;">%ALLUSERSPROFILE%\Application
Data\VMware\VMware VirtualCenter</span><span style="font-family: "times new roman" , "serif"; font-size: 12.0pt;"><o:p></o:p></span></div>
</div>
<div class="MsoNormal" style="text-align: left;">
<div style="text-align: left;">
<span style="font-family: "symbol"; font-size: 12.0pt; line-height: 115%;">·</span><span style="font-family: "times new roman" , "serif"; font-size: 12.0pt; line-height: 115%;"> Windows Vista and 2008 Server: </span><span style="border: none 1.0pt; font-family: "courier new"; font-size: 10.0pt; line-height: 115%; padding: 0in;">%ALLUSERSPROFILE%\VMWare\VMware VirtualCenter</span><b><o:p></o:p></b></div>
</div>
<div class="MsoNormal" style="text-align: left;">
<div style="text-align: left;">
<br /></div>
</div>
<div class="MsoNormal" style="text-align: left;">
<div style="text-align: left;">
<br /></div>
</div>
<div class="MsoNormal" style="text-align: left;">
<div style="text-align: left;">
<b><i><u><span style="font-size: 20.0pt; line-height: 115%;">Windows OS Patches <span style="color: red;">(Monthly)<o:p></o:p></span></span></u></i></b></div>
</div>
<div class="MsoNormal" style="text-align: left;">
<div style="text-align: left;">
<span style="font-size: 12.0pt; line-height: 115%;">Windows
Critical and Security Patches are installed after taking the snapshot of the
Virtual machine.<o:p></o:p></span></div>
</div>
<div class="MsoNormal" style="text-align: left;">
<div style="text-align: left;">
<span style="font-size: 12.0pt; line-height: 115%;">Test all the
functionalities of vCenter Server machine and see if any other impact occurred
due to the recent patches. If yes, then roll back the patches installed
recently and or uninstall them from Add Remove Programs.<o:p></o:p></span></div>
</div>
<div class="MsoNormal" style="text-align: left;">
<div style="text-align: left;">
<span style="font-size: 12.0pt; line-height: 115%;">Once the
verification is finished, and all the application/s runs without an issue then
remove the Snapshot from the vCenter Server.</span><span style="font-size: 12.0pt; line-height: 115%;"><br /><b>Change Request is required to put the patches
and having maintenance on the vCenter Server.</b></span></div>
</div>
<div class="MsoNormal" style="text-align: left;">
<div style="text-align: left;">
<br /></div>
</div>
<div class="MsoNormal" style="text-align: left;">
<div style="text-align: left;">
<b><i><u><span style="font-size: 20.0pt; line-height: 115%;">Upgrade to the new version
release with same build or patch/es <span style="color: red;">(3-6 months)<o:p></o:p></span></span></u></i></b></div>
</div>
<div class="MsoNormal">
</div>
<div style="text-align: left;">
<div style="text-align: left;">
<span style="line-height: 18.3999996185303px;"><br /></span></div>
</div>
<div style="text-align: left;">
<span style="font-size: 12.0pt; line-height: 115%;"></span><br /></div>
<div style="text-align: left;">
<div style="text-align: justify;">
<span style="font-size: 12.0pt; line-height: 115%;"><span style="font-size: 12pt; line-height: 115%; text-align: left;">Every six months check the VMware’s web site for any new updates available for
vCenter Server and download them and have a maintenance window with a Change request to
put those patch/es or update/s.</span></span></div>
</div>
<span style="font-size: 12.0pt; line-height: 115%;">
<o:p></o:p></span>
<br />
<div class="MsoNormal" style="text-align: left;">
<div style="text-align: left;">
<span style="font-size: 12.0pt; line-height: 115%;">Major
version upgrade is not discussed here as it requires the whole environment
upgrade.<o:p></o:p></span></div>
</div>
<div class="MsoNormal" style="text-align: left;">
<div style="text-align: left;">
<span style="font-size: 12.0pt; line-height: 115%;">As usual
take the snapshot of the virtual machine and also make sure that a full backup
of vCenter is taken along with necessary database/s before applying the
patch/update.<o:p></o:p></span></div>
</div>
<div class="MsoNormal" style="text-align: left;">
<div style="text-align: left;">
<span style="font-size: 12.0pt; line-height: 115%;">One can
verify on the download site for any critical issue which got resolved by VMware
from security stand point or other critical areas which are flagged as Bug with
the product, then, it’s very important to apply such patch/es or update/s with
an Emergency Change Request to avoid any impact on the existing environment e.g. SSL issue
or some other security flaw/s.<o:p></o:p></span></div>
</div>
<div class="MsoNormal" style="text-align: left;">
<div style="text-align: left;">
<span style="font-size: 12.0pt; line-height: 115%;">Keep
checking </span><a href="http://kb.vmware.com/kb/"><span style="font-size: 12.0pt; line-height: 115%;">http://kb.vmware.com/kb/</span></a><span style="font-size: 12.0pt; line-height: 115%;"> and </span><a href="http://blogs.vmware.com/"><span style="font-size: 12.0pt; line-height: 115%;">http://blogs.vmware.com/</span></a><span style="font-size: 12.0pt; line-height: 115%;"> site frequently and look for
recently modified/created articles for vCenter Server which will have similar
information about any known issue/s which got taken care with a single
patch/update or multiple patches/updates. <o:p></o:p></span></div>
</div>
<div class="MsoNormal" style="text-align: left;">
<div style="text-align: left;">
<br /></div>
</div>
<div class="MsoNormal" style="text-align: left;">
<div style="text-align: left;">
<b><i><u><span style="font-size: 18.0pt; line-height: 115%;">vCenter Server
Service Restart <span style="color: red;">(as needed)</span><o:p></o:p></span></u></i></b></div>
</div>
<div class="MsoNormal" style="text-align: left;">
<div style="text-align: left;">
<span style="font-size: 12.0pt; line-height: 115%;">Sometimes
due to the nature of the issues, you may just restart the vCenter Server
Service rather than restarting the whole vCenter Server. In such cases, please
make sure that you verify all the other dependent application/s, service/s and
other components which are heavily rely and integrated to the vCenter Server
service and to avoid any disruption to the existing production workload in
Private Cloud, you need to inform the necessary stake holders about the
possible impact on the functionalities and availability of services offered by
whole vRealize suite and vCenter Server combination. This should be done only
with </span><span style="font-size: 16px; line-height: 18.4px;">Change Request</span><span style="font-size: 12pt; line-height: 115%;"> during after hours.</span></div>
</div>
<div style="background: white; line-height: 15pt; margin: 7.5pt 0in 0.0001pt; text-align: left;">
<div style="text-align: left;">
For more information
refer <span style="color: #333333; font-family: "arial" , "sans-serif"; font-size: 10.5pt;"><a href="http://kb.vmware.com/kb/1003895"><span style="color: #326ca6;">http://kb.vmware.com/kb/1003895</span></a><o:p></o:p></span></div>
</div>
<div class="MsoNormal" style="text-align: start;">
<div style="text-align: left;">
<br /></div>
</div>
<div class="MsoNormal" style="text-align: left;">
<div style="text-align: left;">
<b><i><u><span style="font-size: 20.0pt; line-height: 115%;">Resource
Availability on ESXi <span style="color: red;">(upon scheduling maintenance)</span><o:p></o:p></span></u></i></b></div>
</div>
<div class="MsoNormal" style="text-align: left;">
<br />
<div style="text-align: left;">
<span style="line-height: 18.4px;"><br /></span></div>
<span style="font-size: 12.0pt; line-height: 115%;"></span><br />
<div style="text-align: left;">
<span style="font-size: 12.0pt; line-height: 115%;"><span style="font-size: 12pt; line-height: 115%;">Make sure we
have enough resources on ESXi where the vCenter Server will be powering on and
running (in case disaster occurred and the vCenter Server was shut down).</span></span></div>
<span style="font-size: 12.0pt; line-height: 115%;">
<o:p></o:p></span></div>
<div class="MsoNormal" style="text-align: left;">
<div style="text-align: left;">
<span style="font-size: 12.0pt; line-height: 115%;">Verify if
any resource pools or memory/cpu reservation configured at the cluster level,
then make sure such resources are available to the vCenter Server virtual
machine. <o:p></o:p></span></div>
</div>
<div class="MsoNormal" style="text-align: left;">
<div style="text-align: left;">
<br /></div>
</div>
<div class="MsoNormal" style="text-align: left;">
<div style="text-align: left;">
<b><i><u><span style="font-size: 18.0pt; line-height: 115%;">vCenter Server and
vRealize Automation Center portal </span></u></i></b><b><i><u><span style="color: red; font-family: "arial" , "sans-serif"; font-size: 18.0pt; line-height: 115%;">(as and when
required)</span></u></i></b><b><i><u><span style="font-size: 18.0pt; line-height: 115%;"><o:p></o:p></span></u></i></b></div>
</div>
<div class="MsoNormal" style="text-align: left;">
<div style="text-align: left;">
<span style="background: white; color: #333333; font-family: "arial" , "sans-serif"; font-size: 10.5pt; line-height: 115%;"><span style="color: #333333;">During the maintenance of
vCenter Server the console to the virtual machines are not available and also
the Access to the vRA portal</span><span class="apple-converted-space"><span style="color: #333333;"> </span><span style="color: #326ca6;">(if you are using vRA)</span></span></span><span class="apple-converted-space"><span style="background: white; color: #333333; font-family: "arial" , "sans-serif"; font-size: 10.5pt; line-height: 115%;"><span style="text-align: start;"> </span></span><span style="background: white; color: #333333; font-family: "arial" , "sans-serif"; font-size: 10.5pt; line-height: 115%;">is not available to deploy any of the virtual machine</span><o:p></o:p></span></div>
</div>
<div class="MsoNormal" style="text-align: left;">
<div style="text-align: left;">
<br /></div>
</div>
<div class="MsoNormal" style="text-align: left;">
<br />
<div style="text-align: left;">
<b><i><u><span style="background: white; color: #333333; font-size: 18.0pt; line-height: 115%;">Changing IP address of Vcenter Server
virtual machine</span></u></i></b><b><i><u><span style="color: red; font-family: "arial" , "sans-serif"; font-size: 18.0pt; line-height: 115%;">(as and when required)</span></u></i></b></div>
<span style="color: #333333; font-family: "arial" , sans-serif; font-size: 10.5pt; line-height: 15pt;"></span><br />
<div style="text-align: left;">
<span style="color: #333333; font-family: "arial" , sans-serif; font-size: 10.5pt; line-height: 15pt;"><span style="font-size: 10.5pt; line-height: 15pt;">Whenever you need ot change the IP address of
the vCenter Server please proceed very carefully as so many other components
are involved and dependent on vCenter Server e.g. Plugins, vRA, vRO etc.</span></span></div>
<span style="color: #333333; font-family: "arial" , sans-serif; font-size: 10.5pt; line-height: 15pt;">
</span></div>
<div style="text-align: left;">
<div style="text-align: left;">
<span style="color: #333333; font-family: "arial" , sans-serif; font-size: 14px; line-height: 20px;"><br /></span></div>
</div>
<div style="text-align: left;">
<span style="color: #333333; font-family: "arial" , sans-serif; font-size: 10.5pt; line-height: 15pt;"></span><br /></div>
<div style="text-align: left;">
<div style="text-align: justify;">
<span style="color: #333333; font-family: "arial" , sans-serif; font-size: 10.5pt; line-height: 15pt;"><span style="font-size: 10.5pt; line-height: 15pt; text-align: left;">First of all, create backups of the vCenter Server VM and underlying SQL
database.</span></span></div>
</div>
<span style="color: #333333; font-family: "arial" , sans-serif; font-size: 10.5pt; line-height: 15pt;">
<o:p></o:p></span>
<br />
<div class="MsoListParagraphCxSpFirst" style="background: white; line-height: 15pt; margin-left: 0.25in; text-align: left; text-indent: -0.25in;">
<!--[if !supportLists]--><span style="color: #333333; font-family: "symbol"; font-size: 10.5pt;"></span><br />
<div style="text-align: left;">
<span style="color: #333333; font-family: "symbol"; font-size: 10.5pt;"><span style="color: #333333; font-family: "symbol"; font-size: 10.5pt;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">
</span></span><span style="color: #333333; font-family: "arial" , "sans-serif"; font-size: 10.5pt;">Set DRS to manual mode
to avoid anything moving around (optional as it depends on the configuration in
place at Cluster level).</span></span></div>
</div>
<div class="MsoListParagraphCxSpMiddle" style="background: white; line-height: 15pt; margin-left: 0.25in; text-align: left; text-indent: -0.25in;">
<div style="text-align: left;">
<!--[if !supportLists]--><span style="color: #333333; font-family: "symbol"; font-size: 10.5pt;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">
</span></span><!--[endif]--><span style="color: #333333; font-family: "arial" , "sans-serif"; font-size: 10.5pt;">Identified the ESXi
host running the vCenter VM and connected directly to the host with the vSphere
Client.<o:p></o:p></span></div>
</div>
<div class="MsoListParagraphCxSpMiddle" style="background: white; line-height: 15pt; margin-left: 0.25in; text-align: left; text-indent: -0.25in;">
<div style="text-align: left;">
<!--[if !supportLists]--><span style="color: #333333; font-family: "symbol"; font-size: 10.5pt;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">
</span></span><!--[endif]--><span style="color: #333333; font-family: "arial" , "sans-serif"; font-size: 10.5pt;">Close any sessions you
have open to the vCenter Server (Web Client, vSphere Client, etc.)<o:p></o:p></span></div>
</div>
<div class="MsoListParagraphCxSpMiddle" style="background: white; line-height: 15pt; margin-left: 0.25in; text-align: left; text-indent: -0.25in;">
<div style="text-align: left;">
<!--[if !supportLists]--><span style="color: #333333; font-family: "symbol"; font-size: 10.5pt;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">
</span></span><!--[endif]--><span style="color: #333333; font-family: "arial" , "sans-serif"; font-size: 10.5pt;">Open a console window
to the vCenter Server by way of the ESXi host.<o:p></o:p></span></div>
</div>
<div class="MsoListParagraphCxSpMiddle" style="background: white; line-height: 15pt; margin-left: 0.25in; text-align: left; text-indent: -0.25in;">
<div style="text-align: left;">
<!--[if !supportLists]--><span style="color: #333333; font-family: "symbol"; font-size: 10.5pt;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">
</span></span><!--[endif]--><span style="color: #333333; font-family: "arial" , "sans-serif"; font-size: 10.5pt;">Stop all VMware
services.<o:p></o:p></span></div>
</div>
<div class="MsoListParagraphCxSpMiddle" style="background: white; line-height: 15pt; margin-left: 0.25in; text-align: left; text-indent: -0.25in;">
<div style="text-align: left;">
<!--[if !supportLists]--><span style="color: #333333; font-family: "symbol"; font-size: 10.5pt;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">
</span></span><!--[endif]--><span style="color: #333333; font-family: "arial" , "sans-serif"; font-size: 10.5pt;">Changed the IPv4
address and IPv4 gateway.<o:p></o:p></span></div>
</div>
<div class="MsoListParagraphCxSpMiddle" style="background: white; line-height: 15pt; margin-left: 0.25in; text-align: left; text-indent: -0.25in;">
<div style="text-align: left;">
<!--[if !supportLists]--><span style="color: #333333; font-family: "symbol"; font-size: 10.5pt;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">
</span></span><!--[endif]--><span style="color: #333333; font-family: "arial" , "sans-serif"; font-size: 10.5pt;">Ping the new Default
Gateway for Test and also try pinging other ESXi hosts in the same cluster and
other clusters, do some more ping test with other virtual machine in same
Datacenter and other Datacenter as well and to the Internet for making sure end
to end connectivity.<o:p></o:p></span></div>
</div>
<div class="MsoListParagraphCxSpMiddle" style="background: white; line-height: 15pt; margin-left: 0.25in; text-align: left; text-indent: -0.25in;">
<div style="text-align: left;">
<!--[if !supportLists]--><span style="color: #333333; font-family: "symbol"; font-size: 10.5pt;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">
</span></span><!--[endif]--><span style="color: #333333; font-family: "arial" , "sans-serif"; font-size: 10.5pt;">Restarted the vCenter
Server.<o:p></o:p></span></div>
</div>
<div class="MsoListParagraphCxSpLast" style="background: white; line-height: 15pt; margin-left: 0.25in; text-align: left; text-indent: -0.25in;">
<div style="text-align: left;">
<!--[if !supportLists]--><span style="color: #333333; font-family: "symbol"; font-size: 10.5pt;">·<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">
</span></span><!--[endif]--><span style="color: #333333; font-family: "arial" , "sans-serif"; font-size: 10.5pt;">Put DRS back to fully
automated (optional based on your setup)<o:p></o:p></span></div>
<div style="text-align: left;">
<span style="color: #333333; font-family: "arial" , "sans-serif"; font-size: 10.5pt;"><br /></span></div>
</div>
<div class="MsoNormal" style="background: white; text-align: left;">
<br />
<div style="text-align: left;">
<b><i><u><span style="color: #333333; font-size: 18pt;">Changing FQDN of vCenter
Server virtual machine</span></u></i></b><b><i><u><span style="color: red; font-family: "arial" , "sans-serif"; font-size: 18.0pt;">(as and when required)</span></u></i></b></div>
<span style="background-color: transparent; color: #333333; font-family: "arial" , sans-serif; font-size: 10.5pt; line-height: 15pt;"></span><br />
<div style="text-align: left;">
<span style="background-color: transparent; color: #333333; font-family: "arial" , sans-serif; font-size: 10.5pt; line-height: 15pt;"><span style="background-color: transparent; font-size: 10.5pt; line-height: 15pt;">The
same recommendation as of changing the IP address will apply for FQDN of the
vCenter Server virtual machine. Also make sure the Active Directory is
reflecting the new name and all the DNS records get updated upon the change.
Check with the Server Team if needs any help on updating the DNS records.</span></span></div>
<span style="background-color: transparent; color: #333333; font-family: "arial" , sans-serif; font-size: 10.5pt; line-height: 15pt;">
</span></div>
<div style="text-align: left;">
<div style="text-align: left;">
<span style="color: #333333; font-family: "arial" , sans-serif; font-size: 14px; line-height: 20px;"><br /></span></div>
</div>
<div style="text-align: left;">
<div style="text-align: left;">
<b style="line-height: 15pt;"><b style="line-height: 15pt; text-align: left;"><i><u><span style="color: #333333; font-family: "arial" , "sans-serif"; font-size: 18.0pt;">Plugins and other Extensions of vCenter Server </span></u></i></b><b style="line-height: 15pt; text-align: left;"><i><u><span style="color: red; font-family: "arial" , "sans-serif"; font-size: 18.0pt;">(as and
when required)</span></u></i></b></b></div>
</div>
<b style="line-height: 15pt;">
</b>
<br />
<div style="text-align: left;">
<div style="text-align: left;">
<span style="color: #333333; font-family: "arial" , sans-serif; font-size: 14px; line-height: 20px;"><br /></span></div>
</div>
<div style="text-align: left;">
<span style="color: #333333; font-family: "arial" , sans-serif; font-size: 10.5pt; line-height: 15pt;"></span><br /></div>
<div style="text-align: left;">
<div style="text-align: justify;">
<span style="color: #333333; font-family: "arial" , sans-serif; font-size: 10.5pt; line-height: 15pt;"><span style="font-size: 10.5pt; line-height: 15pt; text-align: left;">Check and verify all the plugin operations e.g. Storage plugin or Update
Manager or External Backup solution plugin or #vRealize Orchestrator as and
when vCenter Server got patched/updated/upgraded from one version to another.
Major version always requires to update the plugins and then test the
functionality.</span></span></div>
</div>
<span style="color: #333333; font-family: "arial" , sans-serif; font-size: 10.5pt; line-height: 15pt;">
<o:p></o:p></span>
<br />
<div class="MsoNormal" style="background: white; text-align: start;">
<div style="text-align: left;">
<b><i><u><span style="color: #333333; font-size: 18.0pt;">Backup of vCenter server </span></u></i></b><b><i><u><span style="color: red; font-size: 18.0pt;">(monthly)</span></u></i></b><b><i><u><span style="color: #333333; font-size: 18.0pt;"> <o:p></o:p></span></u></i></b></div>
<div style="text-align: left;">
<b><i><u><span style="color: red; font-size: 18.0pt;"><br /></span></u></i></b></div>
</div>
<div class="MsoNormal" style="background: white; line-height: 15pt; text-align: left;">
<div style="text-align: left;">
<span style="color: #333333; font-family: "arial" , sans-serif; font-size: 10.5pt;">Make sure the Backup is
done and includes a full back up of the vCenter Virtual machine each month.
Verify with Backup Team about the same.</span><span style="color: #333333; font-family: "arial" , "sans-serif"; font-size: 10.5pt;"><o:p></o:p></span></div>
</div>
<div style="background: white; line-height: 15.0pt; margin-bottom: .0001pt; margin: 0in;">
</div>
<div style="text-align: left;">
<div style="text-align: justify;">
<span style="color: #333333; font-family: "arial" , sans-serif; font-size: 10.5pt; line-height: 15pt; text-align: left;"><br /></span></div>
<div style="text-align: justify;">
<span style="color: #333333; font-family: "arial" , sans-serif; font-size: 10.5pt; line-height: 15pt; text-align: left;">1)
In case of troubleshooting / maintenance only you can try restarting vCenter
Service first and see if the issue gets resolved or not and if not then you can
shut down the service and restart the virtual machine</span></div>
</div>
<div style="text-align: left;">
<span style="color: #333333; font-family: "arial" , "sans-serif"; font-size: 10.5pt;"></span><br /></div>
<div style="text-align: left;">
<div style="text-align: justify;">
<span style="color: #333333; font-family: "arial" , "sans-serif"; font-size: 10.5pt;"><span style="font-family: "arial" , sans-serif; font-size: 10.5pt; line-height: 15pt; text-align: left;">For more information please refer</span></span></div>
</div>
<span style="color: #333333; font-family: "arial" , "sans-serif"; font-size: 10.5pt;">
<o:p></o:p></span>
<br />
<div style="background: white; line-height: 15pt; margin: 7.5pt 0in 0.0001pt; text-align: start;">
<div style="text-align: left;">
<span style="color: #333333; font-family: "arial" , "sans-serif"; font-size: 10.5pt;"> <a href="http://kb.vmware.com/kb/1003895"><span style="color: #326ca6;">http://kb.vmware.com/kb/1003895</span></a><o:p></o:p></span></div>
</div>
<div style="background: white; line-height: 15pt; margin: 7.5pt 0in 0.0001pt; text-align: start;">
<div style="text-align: left;">
<span style="color: #333333; font-family: "arial" , "sans-serif"; font-size: 10.5pt;">2)
Make sure you have enough resources on the ESXi host in case of Disaster
occurred and the vCenter server was shut down<o:p></o:p></span></div>
</div>
<div style="background: white; line-height: 15pt; margin: 7.5pt 0in 0.0001pt; text-align: start;">
<div style="text-align: left;">
<span style="color: #333333; font-family: "arial" , "sans-serif"; font-size: 10.5pt;">3)
For Patching you need to have a maintenance window scheduled with a proper </span><span style="font-size: 16px; line-height: 18.4px;">Change Request</span><span style="color: #333333; font-family: "arial" , sans-serif; font-size: 10.5pt; line-height: 15pt;"> request and then patch the VM with specific OS related critical and important
patches</span></div>
<div style="text-align: left;">
<span style="color: #333333; font-family: "arial" , sans-serif; font-size: 10.5pt; line-height: 15pt;"><br /></span></div>
<div style="text-align: left;">
<span style="color: #333333; font-family: "arial" , sans-serif; font-size: 10.5pt; line-height: 15pt;">4)
For Database maintenance refer the following KB and make sure you have the Full
Backup done before you proceed</span></div>
</div>
<div style="background: white; line-height: 15pt; margin: 7.5pt 0in 0.0001pt; text-align: start;">
<div style="text-align: left;">
<span style="color: #333333; font-family: "arial" , "sans-serif"; font-size: 10.5pt;"><a href="http://kb.vmware.com/kb/1007453"><span style="color: #326ca6;">http://kb.vmware.com/kb/1007453</span></a><o:p></o:p></span></div>
</div>
<div style="background: white; line-height: 15pt; margin: 7.5pt 0in 0.0001pt; text-align: start;">
<div style="text-align: left;">
<span style="color: #333333; font-family: "arial" , "sans-serif"; font-size: 10.5pt;">5)
For purging old Data from the vCenter Database please refer to<span class="apple-converted-space"> </span><span style="color: #326ca6;"><a href="http://kb.vmware.com/kb/1025914">http://kb.vmware.com/kb/1025914</a></span></span></div>
</div>
<div style="background: white; line-height: 15pt; margin: 7.5pt 0in 0.0001pt; text-align: start;">
<div style="text-align: left;">
<span style="color: #333333; font-family: "arial" , "sans-serif"; font-size: 10.5pt;"><span style="color: #333333; font-family: "arial" , sans-serif; font-size: 10.5pt; line-height: 15pt;">6)
During the maintenance of vCenter Server the console to the virtual machines
are not available and also the Access to the vRA portal</span><span class="apple-converted-space" style="font-family: "arial" , sans-serif; font-size: 10.5pt; line-height: 15pt;"><span style="color: #333333;"> </span><span style="color: #326ca6;">(if using to deploy VMs) </span></span><span style="color: #333333; font-family: "arial" , sans-serif; font-size: 10.5pt; line-height: 15pt;">is not available to deploy any of the
virtual machine</span></span><span style="color: #333333; font-family: "arial" , sans-serif; font-size: 10.5pt; line-height: 15pt;"><br />7)
Whenever you need to change the IP address of the vCenter Server please proceed
very carefully as so many other components are involved and dependent on
vCenter Server e.g. Plugins, vRA, vRO etc.</span></div>
</div>
<div style="background: white; line-height: 15pt; margin: 7.5pt 0in 0.0001pt; text-align: start;">
<span style="color: #333333; font-family: "arial" , "sans-serif"; font-size: 10.5pt;"></span><br />
<div style="text-align: left;">
<span style="color: #333333; font-family: "arial" , sans-serif; font-size: 10.5pt; line-height: 15pt;">First of all, create backups of the vCenter
Server VM and underlying SQL database.</span></div>
<span style="color: #333333; font-family: "arial" , "sans-serif"; font-size: 10.5pt;"><span style="font-size: 10.5pt; line-height: 15pt;">
<o:p></o:p></span></span></div>
<div class="MsoNormal" style="background: white; line-height: 15pt; margin-left: 0in; text-align: left; text-indent: -0.25in;">
<div style="text-align: left;">
<!--[if !supportLists]--><span style="color: #333333; font-family: "arial" , "sans-serif"; font-size: 10.5pt;">1.<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">
</span></span><!--[endif]--><span style="color: #333333; font-family: "arial" , "sans-serif"; font-size: 10.5pt;">Set DRS to manual mode to avoid anything moving around (optional
as it depends on the configuration in place at Cluster level).<o:p></o:p></span></div>
</div>
<div class="MsoNormal" style="background: white; line-height: 15pt; margin-left: 0in; text-align: left; text-indent: -0.25in;">
<div style="text-align: left;">
<!--[if !supportLists]--><span style="color: #333333; font-family: "arial" , "sans-serif"; font-size: 10.5pt;">2.<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">
</span></span><!--[endif]--><span style="color: #333333; font-family: "arial" , "sans-serif"; font-size: 10.5pt;">Identified the ESXi host running the vCenter VM and connected
directly to the host with the vSphere Client.<o:p></o:p></span></div>
</div>
<div class="MsoNormal" style="background: white; line-height: 15pt; margin-left: 0in; text-align: left; text-indent: -0.25in;">
<div style="text-align: left;">
<!--[if !supportLists]--><span style="color: #333333; font-family: "arial" , "sans-serif"; font-size: 10.5pt;">3.<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">
</span></span><!--[endif]--><span style="color: #333333; font-family: "arial" , "sans-serif"; font-size: 10.5pt;">Close any sessions you have open to the vCenter Server (Web
Client, vSphere Client, RDP etc.)<o:p></o:p></span></div>
</div>
<div class="MsoNormal" style="background: white; line-height: 15pt; margin-left: 0in; text-align: left; text-indent: -0.25in;">
<div style="text-align: left;">
<!--[if !supportLists]--><span style="color: #333333; font-family: "arial" , "sans-serif"; font-size: 10.5pt;">4.<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">
</span></span><!--[endif]--><span style="color: #333333; font-family: "arial" , "sans-serif"; font-size: 10.5pt;">Open a console window to the vCenter Server by way of the ESXi
host.<o:p></o:p></span></div>
</div>
<div class="MsoNormal" style="background: white; line-height: 15pt; margin-left: 0in; text-align: left; text-indent: -0.25in;">
<div style="text-align: left;">
<!--[if !supportLists]--><span style="color: #333333; font-family: "arial" , "sans-serif"; font-size: 10.5pt;">5.<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">
</span></span><!--[endif]--><span style="color: #333333; font-family: "arial" , "sans-serif"; font-size: 10.5pt;">Stop all VMware services.<o:p></o:p></span></div>
</div>
<div class="MsoNormal" style="background: white; line-height: 15pt; margin-left: 0in; text-align: left; text-indent: -0.25in;">
<div style="text-align: left;">
<!--[if !supportLists]--><span style="color: #333333; font-family: "arial" , "sans-serif"; font-size: 10.5pt;">6.<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">
</span></span><!--[endif]--><span style="color: #333333; font-family: "arial" , "sans-serif"; font-size: 10.5pt;">Changed the IPv4 address and IPv4 gateway.<o:p></o:p></span></div>
</div>
<div class="MsoNormal" style="background: white; line-height: 15pt; margin-left: 0in; text-align: left; text-indent: -0.25in;">
<div style="text-align: left;">
<!--[if !supportLists]--><span style="color: #333333; font-family: "arial" , "sans-serif"; font-size: 10.5pt;">7.<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">
</span></span><!--[endif]--><span style="color: #333333; font-family: "arial" , "sans-serif"; font-size: 10.5pt;">Ping the new Default Gateway for Test and also try pinging other
ESXi hosts in the same cluster and other clusters, do some more ping test with
other virtual machine in same Datacenter and other Datacenter as well and to
the Internet for making sure end to end connectivity.<o:p></o:p></span></div>
</div>
<div class="MsoNormal" style="background: white; line-height: 15pt; margin-left: 0in; text-align: left; text-indent: -0.25in;">
<div style="text-align: left;">
<!--[if !supportLists]--><span style="color: #333333; font-family: "arial" , "sans-serif"; font-size: 10.5pt;">8.<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">
</span></span><!--[endif]--><span style="color: #333333; font-family: "arial" , "sans-serif"; font-size: 10.5pt;">Restart the vCenter Server.<o:p></o:p></span></div>
</div>
<div class="MsoNormal" style="background: white; line-height: 15pt; margin-left: 0in; text-align: left; text-indent: -0.25in;">
<div style="text-align: left;">
<!--[if !supportLists]--><span style="color: #333333; font-family: "arial" , "sans-serif"; font-size: 10.5pt;">9.<span style="font-family: "times new roman"; font-size: 7pt; font-stretch: normal; line-height: normal;">
</span></span><!--[endif]--><span style="color: #333333; font-family: "arial" , "sans-serif"; font-size: 10.5pt;">Put DRS back to fully automated (optional based on your setup)<o:p></o:p></span></div>
</div>
<div style="background: white; line-height: 15pt; margin: 7.5pt 0in 0.0001pt; text-align: start;">
<div style="text-align: left;">
<span style="color: #333333; font-family: "arial" , "sans-serif"; font-size: 10.5pt;">8)
The same recommendation as per Item #7 goes for changing the FQDN of the vCenter Server
virtual machine. Also make sure the Active Directory is reflecting the new
name and all the DNS records get updated upon the change.<o:p></o:p></span></div>
</div>
<div style="background: white; line-height: 15pt; margin: 7.5pt 0in 0.0001pt; text-align: start;">
<div style="text-align: left;">
<a href="https://www.blogger.com/blogger.g?blogID=7539481448228753383" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"></a><a href="https://www.blogger.com/blogger.g?blogID=7539481448228753383" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"></a><span style="color: #333333; font-family: "arial" , "sans-serif"; font-size: 10.5pt;">9)
Check all the Templates’ registration and do a test deployment of a virtual
machine from the template/s to see if any error occurs<o:p></o:p></span></div>
</div>
<div style="background: white; line-height: 15pt; margin: 7.5pt 0in 0.0001pt; text-align: start;">
<div style="text-align: left;">
<span style="color: #333333; font-family: "arial" , "sans-serif"; font-size: 10.5pt;">10)
Check and verify all the plugin operations e.g. Storage plugin or Update
Manager or External Backup solution plugin or #vRealize Orchestrator<o:p></o:p></span></div>
</div>
<div style="background: white; line-height: 15pt; margin: 7.5pt 0in 0.0001pt; text-align: start;">
<div class="separator" style="clear: both; text-align: center;">
<a href="https://www.blogger.com/blogger.g?blogID=7539481448228753383" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"></a></div>
<div style="text-align: left;">
<span style="color: #333333; font-family: "arial" , "sans-serif"; font-size: 10.5pt;">11)
Make sure the Backup is done and includes a full back up of the
vCenter Virtual machine each month. Verify with Backup Team about the same.<o:p></o:p></span></div>
</div>
<div style="background: white; line-height: 15pt; margin: 7.5pt 0in 0.0001pt; text-align: start;">
<div style="text-align: left;">
Hope you will find the above useful in your environment and as vCenter Server is a crucial core components, necessary steps needs to be taken to make sure it runs smoothly without any issues.</div>
<div style="text-align: left;">
<br /></div>
<div style="text-align: left;">
I have not included anything about VCSA but you can use the same information for Windows based vCenter and just replace the services portion accordingly and add ssh to the connection list.</div>
<div style="text-align: left;">
<br /></div>
<div style="text-align: left;">
If you have any Feedback then do let me know please. </div>
<div style="text-align: left;">
<br /></div>
<div style="text-align: left;">
Please share and care ! </div>
<div style="text-align: left;">
<br /></div>
<div style="text-align: left;">
Enjoy !!</div>
</div>
<div style="text-align: left;">
<br /></div>
<div class="MsoNormal" style="text-align: left;">
<div style="text-align: justify;">
<br /></div>
</div>
</div>
<div class="MsoNormal">
<span style="font-size: 12.0pt; line-height: 115%;"><o:p></o:p></span></div>
</div>
mandivshttp://www.blogger.com/profile/00901843395280966609noreply@blogger.com0tag:blogger.com,1999:blog-7539481448228753383.post-76635439468213629162015-10-22T15:52:00.002-04:002015-10-22T15:52:42.667-04:00EMC Networker v/s vCenter Templates<a href="http://virtualpatel.blogspot.com/2015/10/emc-networker-vs-vcenter-templates.html?spref=bl">virtualpatel.blogspot.com: EMC Networker v/s vCenter Templates</a>: Hi, Recently I was part of the discussion and found few interesting things when discussing the automation and backup of the critical envi...mandivshttp://www.blogger.com/profile/00901843395280966609noreply@blogger.com0tag:blogger.com,1999:blog-7539481448228753383.post-80228451713946866232015-10-22T15:52:00.000-04:002015-10-22T15:52:20.124-04:00EMC Networker v/s vCenter Templates <div dir="ltr" style="text-align: left;" trbidi="on">
Hi,<br />
<br />
Recently I was part of the discussion and found few interesting things when discussing the automation and backup of the critical environmental components.<br />
<br />
Infrastructure contains vRA 6.2.x and vRO and all the virtual machines are using the Templates situated on vCenter Server.<br />
<br />
Now the backup solution in use is EMC Networker which replaced Veeam recently.<br />
<br />
Due to left over snapshots and not regular clean up were the main reasons to change the backup solution.<br />
<br />
After having discussion with the Backup Team they sent the list of the permission the backup user needed on vCenter Server as follows.<br />
<br />
As per <a href="https://www.blogger.com/https://community.emc.com/docs/DOC-42154">NetWorker-8.2-SP1-VMware-Integration-Guide</a> (Refer Page 44)<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://4.bp.blogspot.com/-dKOWrUDxlT0/VdHR4oxpJEI/AAAAAAAAdK4/S6X7i4CSez4/s1600/nw-1.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="260" src="http://4.bp.blogspot.com/-dKOWrUDxlT0/VdHR4oxpJEI/AAAAAAAAdK4/S6X7i4CSez4/s320/nw-1.jpg" width="320" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://4.bp.blogspot.com/-zqdxoRcSOdM/VdHR4nekYFI/AAAAAAAAdK8/w46GrypiFQg/s1600/nw-2.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="640" src="http://4.bp.blogspot.com/-zqdxoRcSOdM/VdHR4nekYFI/AAAAAAAAdK8/w46GrypiFQg/s640/nw-2.jpg" width="300" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://2.bp.blogspot.com/-CnH_SHDqXIA/VdHR4mdfAMI/AAAAAAAAdLA/B69BjaigPu4/s1600/nw-3.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="640" src="http://2.bp.blogspot.com/-CnH_SHDqXIA/VdHR4mdfAMI/AAAAAAAAdLA/B69BjaigPu4/s640/nw-3.jpg" width="326" /></a></div>
<br />
Now the above permission were assigned the service account which was created on vCenter Server.<br />
<br />
But when the Backup Team tried to register the service they were getting an error.<br />
<br />
I have assigned the Full Administrator Role in vCenter to that Service Account then the registration was successful.<br />
<br />
Now I am not sure what exact permissions are required just to register the extension/service with vCenter Server. So asked the same question back to the Backup Team and they in turn asked to EMC support the same question and the answer received was to go through the above permissions only.<br />
<br />
Now my question is WHY the EMC Networker service account user needs Administrator Role on vCenter Server to do the Backup and Restore of the VMs ??<br />
<br />
As from Security perspective this is clearly a risk to assign the Admin Role level access to vCenter Server as it has enough rights to do any kind of destruction in vCenter Server.<br />
<br />
I have looked at the other permission for restore and from the documentation found out the following.<br />
<br />
<span style="font-family: Courier New, Courier, monospace;"><i>"permissions requirements</i></span><br />
<span style="font-family: Courier New, Courier, monospace;"><i>· The account used to log into the "EMC Data Protection Restore Client" login page must have Administrator rights in vCenter (or the user must be assigned to the role that contains the minimum vCenter user account permissions for EMC Backup and Recovery).</i></span><br />
<span style="font-family: Courier New, Courier, monospace;"><i>· The Account and role with the minimum vCenter account permissions must be assigned to the root of the vCenter and the option to propagate must be selected. (Add to root, not through a group)· </i></span><br />
<span style="font-family: Courier New, Courier, monospace;"><i>· The user account being used must also be part of the Local Administrators group on the server that is performing the file level recovery - it cannot be an AD account, (explicitly add the account to the Local Administrator group on the recovery virtual machine)</i></span><br />
<span style="font-family: Courier New, Courier, monospace;"><i>· This is required for the File Level recovery process to access the local resources on the virtual machine performing the recovery.</i></span><br />
<span style="font-family: Courier New, Courier, monospace;"><i>· Ensure that the virtual machine performing the file level recovery is part of the same vCenter server as the source virtual machine.</i></span><br />
<span style="font-family: Courier New, Courier, monospace;"><i>· The File Level recovery also interacts with the virtual machine VMware Tools, so ensure the VMware tools are installed and up to date."</i></span><br />
<br />
So even we need to create a local user on the vCenter Server which must have the Admin privilege.<br />
<br />
Again a security concern there. Now to get the backup going for the templates, such compromised was needed as I have tried assigning different role to the vCenter Service Account (with Backup role, and also tried changing permission on specific components from the table) but none worked.<br />
<br />
The biggest challenge with Networker we found is to backup Templates.<br />
<br />
EMC Network CAN'T Backup Templates. (on page 82 of the same guide). BOOOOMMM .....<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://4.bp.blogspot.com/-07zugHt1DJA/VdHVYkY_QuI/AAAAAAAAdLU/LIpV42Wgmrw/s1600/templates.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="260" src="http://4.bp.blogspot.com/-07zugHt1DJA/VdHVYkY_QuI/AAAAAAAAdLU/LIpV42Wgmrw/s640/templates.jpg" width="640" /></a></div>
<br />
This was the biggest surprise to us as we have the vRA/vRO components backed up using the same solution but what about Templates. As the vRA blueprints relies on the vCenter Templates they needs to be backed up regularly in case of a disaster.<br />
<br />
We got few options on our hand to backup the Templates<br />
<br />
a) Convert the Templates into VMs a day before the scheduled Backup and after the backup successfully run then convert them back to Templates<br />
<br />
Downside/s of doing that are<br />
<br />
1) The whole automation platform is not available to the DevOps community internally during that time<br />
<br />
2) If the backup fails for X reason we might have to attempt one mote time and it will be a down time for the end user and keeping track of such missed backup and then schedule them again and again is a simple Pain.<br />
<br />
3) Put a change request each time when we convert the templates and one person has to stay late to make sure all the Templates are converted to VMs properly and none left out which is more man hours on each window.<br />
<br />
b) 2nd option was to use the Linked clone/s for vRA which is/are nothing but powered off VM/s with a snapshot on it and that DO NOT have a .vmtx format so for EMC Networker, its easy to Backup the same.<br />
<br />
Downside of doing this<br />
<br />
1) Each VM has a snapshot for not reason and every change to the template will grow the snapshot and we are unnecessarily occupying the space on the SSD storage (yes Xtreme IO) on the back which is not advisable when the matter comes to SLA.<br />
<br />
2) Management to differentiate between the actual Linked clones which we are using to serve other Team (such as Server Team and Database Team) to give them ready made VMs with necessary OS/Applications loaded based on the blue print selection and they will change the IP/DNS entries based on the type of VM and the person who requested (yes IPAM solution is Work-in-progress :-))<br />
<br />
c) The last option was to not use any of the above but just dedicate a separate LUN where we can store the Templates and then replicate the LUN<br />
<br />
Downside of doing this<br />
<br />
1) We need an additional LUN which is not cost effective<br />
<br />
2) More manageability from storage perspective<br />
<br />
As option C was more effective apart from the cost involved, we had no other choice as it was easy for time being till EMC come up with an actual fix to resolve such issue in any future release.<br />
<br />
Now not having such functionality is totally a down hill in the whole backup plan and such dilemma was resolved by putting the templates on a specific LUN and then replicate that LUN on to a DR Site using EMC Recover Point.<br />
<br />
Eventually we took care of the Backup for Templates but could not understand the reason why such support is not provided. Is it Technical ly not possible which is hard to believe or some other gotchas involved (which I dont have any idea about).<br />
<br />
<br />
Hopefully this will help people running in to the same situation and gives a better option to decide which solution to go with.<br />
<span style="background-color: white; color: #494848; font-family: inherit; font-size: 9pt; line-height: 13.5pt; text-indent: -0.25in;"><br /></span>
<br />
<div style="text-indent: 0px;">
<span style="background-color: white; font-family: inherit; text-indent: -0.25in;">Please share and Care !!</span><span style="background-color: white; color: #494848; font-family: inherit; font-size: 9pt; line-height: 13.5pt; text-indent: -0.25in;"> </span></div>
<div class="MsoNormal" style="background: white; line-height: 13.5pt; margin-bottom: 3.0pt; margin-left: 0in; margin-right: 0in; margin-top: 3.0pt; mso-list: l0 level1 lfo2; tab-stops: list .5in; text-indent: -.25in; vertical-align: baseline;">
<br /></div>
</div>
mandivshttp://www.blogger.com/profile/00901843395280966609noreply@blogger.com0tag:blogger.com,1999:blog-7539481448228753383.post-18372309669502329602015-09-11T17:16:00.001-04:002015-09-11T17:16:03.736-04:00Journey to the Land of Fahrenheit and Miles<a href="http://virtualpatel.blogspot.com/2015/09/journey-to-land-of-fahrenheit-and-miles.html?spref=bl">virtualpatel.blogspot.com: Journey to the Land of Fahrenheit and Miles</a>: Hi, Since my journey ended up with VMware early this year, I was thinking and planning to move to US from Canada. So many friends and fam...mandivshttp://www.blogger.com/profile/00901843395280966609noreply@blogger.com0tag:blogger.com,1999:blog-7539481448228753383.post-61703800917368412252015-09-11T17:10:00.001-04:002015-09-11T17:31:31.723-04:00Journey to the Land of Fahrenheit and Miles <div dir="ltr" style="text-align: left;" trbidi="on">
Hi,<br />
<br />
Since my journey ended up with VMware early this year, I was thinking and planning to move to US from Canada. So many friends and family members have an idea about my current location as Toronto, Canada. But today, as promised to many of you on Twitter and other social media, I will be demystifying the mystery and share my experience about the change I have experienced within last 6-8 months which is HUGE. Currently I am in North Carolina and enjoying the Weather after the cold winters of Canada. So technically its a halfway of the journey.<br />
<br />
My journey from North to south brought the following items in our life including my family members'. As they say Change is Good so been through the following in one shot. :-)<br />
<br />
City - New<br />
State - New<br />
Country - New<br />
Community - New<br />
People - New<br />
Work place - New<br />
Residential place - New<br />
Neighbors - New<br />
Friends and Relatives - New<br />
Work culture - New<br />
Colleagues - New<br />
Policies - New<br />
Rules - New<br />
Government - New<br />
Currency - New<br />
Boss - New<br />
Grocery Store/s - New<br />
Measurements - New<br />
Weather - New<br />
Environment - New<br />
Culture - New<br />
Food Habits - New<br />
<br />
Only some of my friends from school and this community are old :-) and I wish they should be there as they are. Loving them and this community with the deepest gratitude from my heart.<br />
<br />
In April I joined a Customer of VMware as VMware Cloud Engineer and exposed to many products to work with which mainly includes vRA, vRO, vROPS, vCM, Hyperic and helped standing up their private cloud with UCS and Xtreme IO as their backend Infrastructure. it was very heavy on DevOps side so touched and learned little bit of Docker, Core OS, Github, Chef and other unknown :-) technologies such as UC4, Jenkins etc. Most of you must have seen an update about that. When it comes to a solution for Network Virtualization, the decision was made to use some other solution than VMware NSX. Now before departing VMware, NSX was the main/crucial component I was heavily involved in, so a thought of moving away from the product kept me thinking about my future and career path I chosen.<br />
<br />
At the right moment this opportunity came in and I could not resist it in any way. It is a Global Solution Architect (Network Virtualization and Security) Role with one of the Top organization in IT security and a Security Partner of VMware in the area of DC Security - <a href="http://www.trendmicro.com/us/enterprise/index.html">TrendMicro</a>. Now with the goal of SDDC of VMware, and use of NSX in the whole Data Center, TM solutions are working in the following area and providing Optimized Security for VMware, Data Center Security, VDI Security, Cloud Computing, Securing the Software-Defined Data Center and Security and Operations Visibility.<br />
<br />
In this capacity I need to architect and provide solutions to the customers which has a mix of Trend's "D" level of Security product solutions and VMware NSX as Network Virtualization in their Infrastructure. This is like a heavenly made pair when it comes to a pure security for SDDC and using the Micro-Segmentation based security. This combo protects the DC with all other possibilities such as Malware, DDoS, IPS/IDS which can be done only using enterprise level security solutions of TrendMicro. The role is based in Texas (where I will eventually move) so my journey will be complete from North to South :-). <br />
<br />
So many people I have to thank for their support and I am really grateful to this community for their continued "unconditional" help whenever its needed.Truly amazing experience I am having every day when I spend time among this community where people are ready to help each other, however they can. This is not something you see every where and I am sure all of you will agree on this.<br />
<br />
Hope to continue with my regular blogging but now with more on TrendMicro/VMware NSX solutions.<br />
<br />
Cheers !! <br />
<br /></div>
mandivshttp://www.blogger.com/profile/00901843395280966609noreply@blogger.com1tag:blogger.com,1999:blog-7539481448228753383.post-14564469343944488572015-08-16T16:51:00.001-04:002015-08-16T16:51:28.298-04:00REST while using CURL for vRA<a href="http://virtualpatel.blogspot.com/2015/08/rest-while-using-curl-for-vra.html?spref=bl">irtualpatel.blogspot.com: REST while using CURL for vRA</a>: DevOps needs REST :-) In DevOps world users are mostly using the command line and APIs to do almost all of their work. So for the foll...mandivshttp://www.blogger.com/profile/00901843395280966609noreply@blogger.com0tag:blogger.com,1999:blog-7539481448228753383.post-21457977082795504962015-08-16T16:49:00.001-04:002015-08-16T16:49:55.992-04:00REST while using CURL for vRA <div dir="ltr" style="text-align: left;" trbidi="on">
<div>
<span style="background-color: white;"><b>DevOps needs REST :-)</b></span></div>
<div>
<span style="background-color: white;"><br /></span></div>
<div>
<span style="background-color: white;">In DevOps world users are mostly using the command line and APIs to do almost all of their work. So for the following example you’re going to need curl as the usage was done keeping in mind the universal tool and just not focusing other available large number of REST client or such, and as this is inside a Lab encryption is not needed bu you will need the version that supports SSL for end-to-end encryption ! </span></div>
<div>
<span style="background-color: white;"><br /></span></div>
<div>
<span style="background-color: white;">Use of jq, ( a new parsing tool for JSON) is used here, which does everything thro' command-line, and being portable (zero install) and open source, it runs on Windows and Linux both, so all of the developers out there can use it irrespective of the platform they’re using. I saved both utilities in C:\curl, and put my .bat file and .json files there too. You can decide the best way to do that, Token is required.</span></div>
<div>
<span style="background-color: white;"><br /></span></div>
<div>
<span style="background-color: white;">So what is Token or a Bearer Token? Putting it simply, its an authentication token. First thing you’ll need is to get a bearer token and parse it. You’ll need a .json file with your authentication details; the basic format is<span style="font-family: Courier New, Courier, monospace;"> </span></span><br />
<span style="background-color: white;"><span style="font-family: Courier New, Courier, monospace;"><br /></span></span>
<span style="background-color: white;"><span style="font-family: Courier New, Courier, monospace;">{“username”:”domain\\myusername“, “password”:”mypassword“, “tenant”:”vsphere.local”}. </span></span></div>
<div>
<span style="background-color: white;"><br /></span></div>
<div>
<span style="background-color: white;">Fill in your username, password, and if you’re not using the default tenant, then save it to C:\curl\hellotoken.json and you’re good to go. </span></div>
<div>
<span style="background-color: white;"><br /></span></div>
<div>
<span style="background-color: white;">Use the following curl command to submit your request:</span></div>
<div>
<span style="background-color: white;"><br /></span>
<span style="background-color: white; font-family: Courier New, Courier, monospace;">curl –insecure -H “Accept: application/json” -H “Content-Type: </span></div>
<div>
<span style="background-color: white; font-family: Courier New, Courier, monospace;">application/json” –data @hellotoken.json https://vra-fqdn/identity/api/tokens > identity.json</span></div>
<div>
<span style="background-color: white;"><br /></span></div>
<div>
<span style="background-color: white;">Please note I used –insecure because my vRA environment is still using self-signed SSL certs. If you have actual SSL certs that will validate, please drop the –insecure option. This command will drop a .json file named identity.json in the current folder (c:\curl if you’ve been following along), the file looks a little like this:</span><br />
<span style="background-color: white;"><br /></span></div>
<div>
<span style="background-color: white; font-family: Courier New, Courier, monospace;">{“expires”:”2015-07-08T18:47:58.963Z”,”id”:”long-token-goes-here“,”tenant”:”vsphere.local”}</span></div>
<div>
<span style="background-color: white;"><br /></span></div>
<div>
<span style="background-color: white;">So it has an expiry, an id, and a tenant. Bearer tokens are good for 24 hours, and what's not obvious is a user can only have one at a time; if you ask for a new bearer token, that invalidates all previous bearer token/s. These two facts means, it’s very difficult to manually get and use a bearer token. What we want to do is extract that ID in such a way that we can automatically use it in subsequent curl calls.</span></div>
<div>
<span style="background-color: white;"><br /></span></div>
<div>
<span style="background-color: white;">For this I will be using jq:</span></div>
<div>
<span style="background-color: white;"><br /></span></div>
<div>
<span style="background-color: white; font-family: Courier New, Courier, monospace;">jq .id -r < identity.json > bearer.txtset /p btoken=</span></div>
<div>
<span style="background-color: white; font-family: Courier New, Courier, monospace;">)</span></div>
<div>
<span style="background-color: white;"><br /></span></div>
<div>
<span style="background-color: white;">Let’s look into what it consists of:</span></div>
<div>
<span style="background-color: white;"><br /></span></div>
<div>
<span style="background-color: white;">jq .id -r parse out the id field from the json. Print it to stdout in raw mode (i.e. no surrounding quotes or symbols)</span></div>
<div>
<span style="background-color: white;"><br /></span></div>
<div>
<span style="background-color: white;">< identity.json use the previously generated identity.json file as input to jq</span></div>
<div>
<span style="background-color: white;"><br /></span></div>
<div>
<span style="background-color: white;">> bearer.txt output the parsed id field to a file bearer.txt</span></div>
<div>
<span style="background-color: white;"><br /></span></div>
<div>
<span style="background-color: white;">use bearer.txt as the input file for the following command</span></div>
<div>
<span style="background-color: white;"><br /></span></div>
<div>
<span style="background-color: white;">set /p btoken= set the environment variable btoken to the input. The /p normally means to prompt for the environment variable, but in this case since we provided a stdin pipe, the contents of bearer.txt will be used instead of prompting the user</span></div>
<div>
<span style="background-color: white;"><br /></span></div>
<div>
<span style="background-color: white;">) Close the section using bearer.txt as input. Yes I know it is required to do it here. </span></div>
<div>
<span style="background-color: white;"><br /></span></div>
<div>
<span style="background-color: white;">To use the bearer token add the following HTTP Header to all future curl calls:</span></div>
<div>
<span style="background-color: white;"><br /></span></div>
<div>
<span style="background-color: white; font-family: Courier New, Courier, monospace;">-H “Authorization: Bearer %btoken%”</span></div>
<div>
<span style="background-color: white;"><br /></span>
<span style="background-color: white;"><b>Machine Request</b></span><br />
<span style="background-color: white;"><br /></span></div>
<div>
<span style="background-color: white;">Now you can request the catalog item you want from the vRA console and note the request ID. After the request has completed, you can use curl to look at the request with the following command:</span></div>
<div>
<span style="background-color: white;"><br /></span></div>
<div>
<span style="background-color: white; font-family: Courier New, Courier, monospace;">curl –insecure -H “Accept: application/json” -H “Authorization: Bearer %btoken%” https://vra-fqdn/catalog-service/api/consumer/resources/?$filter=request/requestNumber+eq+myReqNumber > myreqOutput.json</span></div>
<div>
<span style="background-color: white;"><br /></span></div>
<div>
<span style="background-color: white;">This will create a file myreqOutput.json with details of your request. The item you care most about is the catalog ID which you will be able to find at <span style="font-family: Courier New, Courier, monospace;">.content.0.catalogItem.id</span> Note that ID, then request the entitled catalog item with the following:</span></div>
<div>
<span style="background-color: white;"><br /></span></div>
<div>
<span style="background-color: white; font-family: Courier New, Courier, monospace;">curl –insecure -H “Accept: application/json” -H “Authorization: Bearer %btoken%”https://vra-fqdn/catalog-service/api/consumer/entitledCatalogItems/?$filter=id+eq+&#8217;catalogItemId‘ > catalogItem.json</span></div>
<div>
<span style="background-color: white;"><br /></span></div>
<div>
<span style="background-color: white;">This time, note the provider binding at .<span style="font-family: Courier New, Courier, monospace;">content.0.catalogItem.providerBinding.bindingId.</span> Also note the tenant ID specified here.</span></div>
<div>
<span style="background-color: white;"><br /></span></div>
<div>
<span style="background-color: white;">Now you have the information you need to format the machineRequest.json file:</span></div>
<div>
<span style="background-color: white;"><br /></span></div>
<div>
<span style="background-color: white; font-family: Courier New, Courier, monospace;">{</span></div>
<div>
<span style="background-color: white; font-family: Courier New, Courier, monospace;">“@type”: “CatalogItemRequest”,</span></div>
<div>
<span style="background-color: white; font-family: Courier New, Courier, monospace;">“catalogItemRef”: {</span></div>
<div>
<span style="background-color: white; font-family: Courier New, Courier, monospace;">“id”: “catalogItemId”</span></div>
<div>
<span style="background-color: white; font-family: Courier New, Courier, monospace;">},</span></div>
<div>
<span style="background-color: white; font-family: Courier New, Courier, monospace;">“organization”: {</span></div>
<div>
<span style="background-color: white; font-family: Courier New, Courier, monospace;">“tenantRef”: “vsphere.local”,</span></div>
<div>
<span style="background-color: white; font-family: Courier New, Courier, monospace;">“subtenantRef”: “TenantId”</span></div>
<div>
<span style="background-color: white; font-family: Courier New, Courier, monospace;">},</span></div>
<div>
<span style="background-color: white; font-family: Courier New, Courier, monospace;">“requestedFor”: “myUserName@domain“,</span></div>
<div>
<span style="background-color: white; font-family: Courier New, Courier, monospace;">“state”: “SUBMITTED”,</span></div>
<div>
<span style="background-color: white; font-family: Courier New, Courier, monospace;">“requestNumber”: 0,</span></div>
<div>
<span style="background-color: white; font-family: Courier New, Courier, monospace;">“requestData”: {</span></div>
<div>
<span style="background-color: white; font-family: Courier New, Courier, monospace;">“entries”: [{</span></div>
<div>
<span style="background-color: white; font-family: Courier New, Courier, monospace;">“key”: “provider-blueprintId”,</span></div>
<div>
<span style="background-color: white; font-family: Courier New, Courier, monospace;">“value”: {</span></div>
<div>
<span style="background-color: white; font-family: Courier New, Courier, monospace;">“type”: “string”,</span></div>
<div>
<span style="background-color: white; font-family: Courier New, Courier, monospace;">“value”: “Provider-binding”</span></div>
<div>
<span style="background-color: white; font-family: Courier New, Courier, monospace;">}</span></div>
<div>
<span style="background-color: white; font-family: Courier New, Courier, monospace;">},</span></div>
<div>
<span style="background-color: white; font-family: Courier New, Courier, monospace;">{</span></div>
<div>
<span style="background-color: white; font-family: Courier New, Courier, monospace;">“key”: “provider-VirtualMachine.Network0.NetworkProfileName”,</span></div>
<div>
<span style="background-color: white; font-family: Courier New, Courier, monospace;">“value”: {</span></div>
<div>
<span style="background-color: white; font-family: Courier New, Courier, monospace;">“type”: “string”,</span></div>
<div>
<span style="background-color: white; font-family: Courier New, Courier, monospace;">“value”: “Network Profile Name”</span></div>
<div>
<span style="background-color: white; font-family: Courier New, Courier, monospace;">}</span></div>
<div>
<span style="background-color: white; font-family: Courier New, Courier, monospace;">},</span></div>
<div>
<span style="background-color: white; font-family: Courier New, Courier, monospace;">{</span></div>
<div>
<span style="background-color: white; font-family: Courier New, Courier, monospace;">“key”: “provider-Variable1″,</span></div>
<div>
<span style="background-color: white; font-family: Courier New, Courier, monospace;">“value”: {</span></div>
<div>
<span style="background-color: white; font-family: Courier New, Courier, monospace;">“type”: “string”,</span></div>
<div>
<span style="background-color: white; font-family: Courier New, Courier, monospace;">“value”: “value”</span></div>
<div>
<span style="background-color: white; font-family: Courier New, Courier, monospace;">}</span></div>
<div>
<span style="background-color: white; font-family: Courier New, Courier, monospace;">}]</span></div>
<div>
<span style="background-color: white; font-family: Courier New, Courier, monospace;">}</span></div>
<div>
<span style="background-color: white; font-family: Courier New, Courier, monospace;">}</span></div>
<div>
<span style="background-color: white;"><br /></span></div>
<div>
<span style="background-color: white;">Note the key: provider-name section above; this is how you specify any custom properties for the blueprint, I provided a couple samples above but what you put here will really depend on the blueprint configuration. Basically just add provider- to the start of any custom property (or even VM property, see<span style="font-family: Courier New, Courier, monospace;"> provider-VirtualMachine.Network0.NetworkProfileName</span> above) to submit it with your request… so the next step is to…</span></div>
<div>
<span style="background-color: white;"><br /></span>
<span style="background-color: white;"><b>Submit a Request</b></span></div>
<div>
<span style="background-color: white;"><br /></span>
<span style="background-color: white;">The curl command to submit a request is:</span></div>
<div>
<span style="background-color: white;"><br /></span></div>
<div>
<span style="background-color: white; font-family: Courier New, Courier, monospace;">curl -X POST –insecure -H “Content-Type: application/json” -H “Authorization: Bearer %btoken%” https://vra-fqdn/catalog-service/api/consumer/requests –data @machineRequest.json</span></div>
<div>
<span style="background-color: white;"><br /></span></div>
<div>
<span style="background-color: white;">And now you can see under Infrastructure --> Recent Events or under Requests that new VM getting deployed in vRA. You can also verify under vSphere client session that the VM is getting cloned and deployed.</span></div>
<div>
<span style="background-color: white;"><br /></span></div>
<div>
<span style="background-color: white;">Hope you find this useful.</span></div>
<div>
<span style="background-color: white;"><br /></span></div>
<div>
<span style="background-color: white;">Please share and care.</span></div>
<div>
<span style="background-color: white;"><br /></span></div>
<div>
<span style="background-color: white;"><br /></span></div>
<div>
<span style="background-color: white;"><br /></span></div>
<div>
<br /></div>
</div>
mandivshttp://www.blogger.com/profile/00901843395280966609noreply@blogger.com0tag:blogger.com,1999:blog-7539481448228753383.post-41531423367180067112015-08-15T07:05:00.001-04:002015-08-15T07:05:52.950-04:00Request to extend a chance for VCDX5<a href="http://virtualpatel.blogspot.com/2015/08/request-to-extend-chance-for-vcdx5.html?spref=bl">virtualpatel.blogspot.com: Request to extend a chance for VCDX5</a>: Hi, I am taking the Liberty here to request VMware Education to extend the chance for Appearing a VCDX 5 Defense after the schedule of Oc...mandivshttp://www.blogger.com/profile/00901843395280966609noreply@blogger.com0tag:blogger.com,1999:blog-7539481448228753383.post-45347036029403756062015-08-15T07:00:00.001-04:002016-05-13T15:25:20.828-04:00Request to extend a chance for VCDX5<div dir="ltr" style="text-align: left;" trbidi="on">
Hi,<br />
<br />
I am taking the Liberty here to request VMware Education to extend the chance for Appearing a VCDX 5 Defense after the schedule of Oct 2015.<br />
<br />
Now for me, there are reasons behind it which includes personal and work related that I could not prepare on time for this and now dead line is just 10 days away.<br />
<br />
I have put lot of time individually to attain the required certifications (VCAP5-DCA and VCAP5-DCD) with the support of my Family and this is over few years of time which covers the time of a new born and a Toddler in the house. With other factors (e.g. work changes and family - main two factors for anyone in any industry) its very difficult to manage the whole planning of preparing an Application and then Defend the same, and to prepare the application alone requires lot of dedication and time, as this is just do or die situation (being optimistic but one never knows) which I wants to attempt and experience this dangerously beautiful journey. Now I am not sure how much important it is, for you to bother about my reasons, I guess not much, but still look at this situation from the other side of the Fence and try to realize the situation from a stand point of a professional, a common man, a family member, a community contributor. and a Father.<br />
<br />
So here is my <b>profound Request,</b> to all the decision makers to give the VMware Community one more chance to defend after Oct 2015, which may fall into next year, as I am sure there are others in the community who are under the same condition as me and can stand with me for the above request.<br />
<br />
Now one thing I want to make it clear here that, this will be 1st request so far of such kind, and while thinking about it a lot, I decided to echo my thoughts through this post, and its not my intent to take this in any negative way.<br />
<br />
With all respect, I will definitely honor the decision, taken by the program authorities and will hope other would do the same. One thing I have learned that, to achieve something you need to put the effort first, so I am considering this step as an effort rather than sitting idle.<br />
<br />
This is no way to avoid any future plan on attaining the certifications to attain VCDX, but just a simple request to give one more chance to over all VMware community enthusiasts out there, who are dedicated, focused and being professional to attain this Elite certification which has a tremendous value.<br />
<br />
I'm leaving this post here in your capable hands to decide about this Request and urge to give a second thought before making a decision, which infact, can change so many lives (including the person/s and their family).<br />
<br />
<b><u><span style="color: red;">Update: (As of 13th May 2016)</span></u></b><br />
<br />VMware just <a href="http://blogs.vmware.com/education/2016/05/vcap5-exam-retirements-suspended-registration-remains-open.html">announced today</a> that the VCAP5 Exam Retirements are suspended and the Registration remains open for now. So now this will give chance to the candidates who wants to do the VCAP5/DCA-DCD based on vSphere 5.0/5.5 versions and also prepare for their VCDX.<br /><br />Here are the exams still available to appear for.<br />
<br />
<div style="background-color: white; border: 0px; color: #666666; font-family: proxima-nova, Arial, sans-serif; font-size: 16px; font-stretch: inherit; line-height: 18px; margin-bottom: 1rem; padding: 0px; vertical-align: baseline;">
<strong style="border: 0px; font-family: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">VCAP5 Design Exams:</strong></div>
<ul style="background-color: white; border: 0px; color: #444444; font-family: proxima-nova, Arial, sans-serif; font-size: 16px; line-height: 27.4286px; list-style-position: outside; margin: 0px 0px 1.71429rem; padding: 0px; vertical-align: baseline;">
<li style="border: 0px; line-height: normal !important; margin: 0px 0px 0px 2.57143rem; padding: 0px; vertical-align: baseline;"><a href="https://mylearn.vmware.com/mgrReg/plan.cfm?plan=30484&ui=www_cert" style="border: 0px; color: #006990; font-family: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; outline: none; padding: 0px; text-decoration: none !important; vertical-align: baseline;">VMware Certified Advanced Professional 5 — Data Center Design (VCAP5-DCD)<br />Exam #VDCD550</a></li>
</ul>
<div style="background-color: white; border: 0px; color: #666666; font-family: proxima-nova, Arial, sans-serif; font-size: 16px; font-stretch: inherit; line-height: 18px; margin-bottom: 1rem; padding: 0px; vertical-align: baseline;">
<strong style="border: 0px; font-family: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">VCAP Lab Exams:</strong></div>
<ul style="background-color: white; border: 0px; color: #444444; font-family: proxima-nova, Arial, sans-serif; font-size: 16px; line-height: 27.4286px; list-style-position: outside; margin: 0px 0px 1.71429rem; padding: 0px; vertical-align: baseline;">
<li style="border: 0px; line-height: normal !important; margin: 0px 0px 0px 2.57143rem; padding: 0px; vertical-align: baseline;"><a href="https://mylearn.vmware.com/mgrReg/plan.cfm?plan=30483&ui=www_cert" style="border: 0px; color: #0095d3; font-family: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; outline: dotted thin; padding: 0px; text-decoration: none !important; vertical-align: baseline;">VMware Certified Advanced Professional 5 — Data Center Administration (VCAP5-DCA)<br />Exam #VDCA550</a></li>
<li style="border: 0px; line-height: normal !important; margin: 0px 0px 0px 2.57143rem; padding: 0px; vertical-align: baseline;"><a href="https://mylearn.vmware.com/mgrReg/plan.cfm?plan=52165&ui=www_cert" style="border: 0px; color: #006990; font-family: inherit; font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; line-height: inherit; margin: 0px; outline: none; padding: 0px; text-decoration: none !important; vertical-align: baseline;">VMware Certified Implementation Expert — Network Virtualization (VCIX-NV)<br />Exam #VCXN610</a></li>
</ul>
So wish you all the very best !<br />
<br />Crossing my fingers !<br />
<br />
Please Share and Care !!<br />
<br />
<br /></div>
mandivshttp://www.blogger.com/profile/00901843395280966609noreply@blogger.com0