Adding Colons to LUN IDs

There comes a time where every vi admin will need to create a report which aggregates data from both the virtualization perspective, as well as from a storage perspective. VMware likes do display the unique LUN IDs one way, and EMC chooses to list the LUN IDs in a slightly different format. This makes mapping datastores to LUNs more time consuming and challenging.

Example of LUN ID from the vSphere Perspective:

naa.6006016094602800e07ff528b73ae011

 

Example of LUN ID from EMC storage perspective:

60:06:01:60:94:60:28:00:e0:7f:f5:28:b7:3a:e0:11

 

To simplify this I take the output from vSphere (whether using something like RVtools, PowerCLI, etc…) and the ouptut from EMC (somthing like CAP report generated from SP Collects) and get them both into Excel.

Next, I use find and replace in Excel to remove the “naa.” from the LUN UUID collected from VMware. I apply the following Excel formula to the string that is left after removing “naa.”

=LEFT(T181,2)&":"&MID(T181,3,2)&":"&MID(T181,5,2)&":"&MID(T181,7,2)&":"&MID(T181,9,2)&":"&MID(T181,11,2)&":"&MID(T181,13,2)&":"&MID(T181,15,2)&":"&MID(T181,17,2)&":"&MID(T181,19,2)&":"&MID(T181,21,2)&":"&MID(T181,23,2)&":"&MID(T181,25,2)&":"&MID(T181,27,2)&":"&MID(T181,29,2)&":"&RIGHT(T181,2)

 

Now it is very easy to do some vLookups between the two datasets!

5 thoughts on “Adding Colons to LUN IDs”

  1. ООО «ТД Авантпак» — это динамично и эффективно развивающаяся производственная компания в области полимерной пленки различных марок и упаковки из полиэтилена.
    За время работы успела зарекомендовать себя как надежный поставщик, снабжает огромную аудиторию потребителей качественной продукцией.
    https://rnd.avantpack.ru/catalog

  2. https://www.youtube.com/watch?v=1FlhQrxL5QY

    – bikes for losing weight
    – bike to lose weight
    – riding bicycle
    – riding bikes for beginners
    – how to wheele
    How so much ought to I Ride?
    If you’re athletics to thin, period (the time you pay biking) matters over the particular distance you travel. meaning that you simply do not essentially got to ride the complete Tour First State France course to shed a number of pounds. Relieved? smart. however do not place away the meter.

    As you get snug defrayment longer within the saddle, schedule longer rides throughout the week. If you are doing 3 athletics workouts hebdomadally, complete one short ride (30 minutes), create one ride a moderate period (45 minutes), and set a goal to ride one long tour (60 to a hundred and twenty minutes) hebdomadally.

    How Fast ought to I Cycle?
    If weight loss is your primary goal, exercise intensity matters over speed. A higher-intensity ride can burn a lot of calories than a lower-intensity ride. the kind of motorbike you ride and also the path you decide on can have an effect on each your intensity (how exhausting you work) and your speed (how quick you travel).

    For example, if you’re riding an important bicycle on muddy, cross-country trails at twelve miles per hour, you’ll likely got to work terribly exhausting. however if you’re on a road bike pedaling down a hill, you’ll be able to reach that pace with nearly no effort the least bit.

    Your best bet? Learn to use a vital sign monitor. The device provides associate degree correct measure of however exhausting you’re operating. Aim to figure at seventy to seventy fifth of your most vital sign for many rides.

    If you do not wish to take a position during a monitor, used the perceived labour scale instead. On a scale of one to ten (with ten being most exertion), you ought to want you’re performing at A level seven. you ought to be respiratory deeply, however not exhausted or out of breath.

    Where ought to I Go?
    The course you decide on could have the largest impact on the amount of calories you burn as a result of it’ll have an effect on each period and intensity. For best results, you wish to settle on a course that enables you to pedal systematically while not taking too several breaks at stoplights or intersections. These short breaks cause your vital sign to drop, take up an excessive amount of sweat time, and reduce the calorie-burning potential of your ride.

    Many cities have dedicated continuous bike trails. particularly once you square measure initial beginning out, decide on these safe routes instead of riding on the road. If you do not have access to a motorbike path, it should be value it slow to drive to a location wherever a protracted stretch of quiet road is on the market.

    Best Bike for Weight Loss
    The best bike to assist you thin is that the one that you simply can ride on a daily basis. It’s essential that you simply attempt many designs and notice the one that matches your body.

    Road Bike
    Some bike riders like a road bike with skinny tires and a sleeker frame. A road bike is lighter and needs less effort once you ride quick.

    Road bikes square measure best for sealed surfaces and long, uninterrupted stretches of road.

    But some riders do not feel steady on this type of bike. A road bike needs that you simply lean slightly forward whereas you ride. If you’ve got back problems or considerations regarding safety, this could not be the bike for you.

    Cruiser, Mountain or Cross Bike
    You may like the comfort and easy a cruiser or a bicycle that has significant, thick tires. These bikes typically supply some suspension and artefact to form the ride easier.

    And you’re typically ready to maintain a a lot of upright posture once you ride this bike vogue. Also, the thicker tires offer a lot of stability therefore riders usually feel safer on these bikes, particularly if they’re unaccustomed athletics.

    Electric Bike
    If you’re unaccustomed athletics or if you intend to use your bike for associate degree extended daily commute, an electrical bike (also known as associate degree e-bike) could be the proper choice for you. Brands like Trek create cycles that you simply ride sort of a normal bike, however you get a lift of help once you would like it.

    For example, Trek’s Super Commuter provides a snug upright ride with the choice to use eight completely different speeds. If you hit a hill or would like a prospect from strenuous pedaling, you’ll be able to interact the Jerom Bos pedal-assist system that helps you sustain speeds of up to twenty seven miles per hour (45 km/h).

    Recumbent Bike
    Some exercisers use accumbent bikes at the gymnasium, preferring the reclined body position to associate degree upright position that’s typical in normal cycles. However, some riders opt for a accumbent bike for his or her outside ride.

  3. Новый тип облицовки можно получить путем комбинирования разного сырья.
    Этот способ применяют изготовители стройматериалов для расширения ассортимента товаров, которые выпускают композитные панели.
    Композитными панелями называют наружную стеновую отделку разной формы, размеров и цветов, которая состоит из однослойной металлической матрицы или двух слоев из металла, наклеенными на вспененный полистирол или другой полимер.
    Для изготовления основы панели применяют легированную, нержавеющую сталь, алюминиевые сплавы, цинк.
    Отдельные элементы облицовки производят в виде панелей, сайдинга или кассет.
    Композитная панель отличается от аналога без утеплителя более повышенными потребительскими свойствами – звукоизоляцией и теплоизоляцией.
    К минусам стальных и алюминиевых композитных панелей относят горючесть, способность поддерживать открытое пламя и выделение продуктов горения.

  4. Особенности инфракрасного теплого пола. Какие критерии нужно знать, чтобы правильно рассчитать. Читайте статью от electrotorg.ru

Leave a Reply

Your email address will not be published. Required fields are marked *