#credit : Martin Nielsen $dps = @" dps2000 dps2001 dps2002 dps2003 dps2004 dps2005 dps2006 dps2007 dps2008 dps2009 dps2010 dps2011 dps2012 dps2013 dps2014 dps2015 dps2016 dps2017 dps2018 dps2019 dps2020 dps2021 dps2022 dps2023 dps2024 dps2025 dps2026 dps2027 dps2028 dps2029 dps2030 dps2031 dps2032 dps2033 dps2034 dps2035 dps2036 dps2037 dps2038 dps2039 dps2040 dps2041 dps2042 dps2043 dps2044 dps2045 dps2046 dps2047 dps2048 dps2049 dps2050 dps2051 dps2052 dps2053 dps2054 dps2055 dps2056 dps2057 dps2058 dps2059 dps2060 dps2061 dps2062 dps2063 dps2064 dps2065 dps2066 dps2067 dps2068 dps2069 dps2070 dps2071 dps2072 dps2073 dps2074 dps2075 dps2076 dps2077 dps2078 dps2079 dps2080 dps2081 dps2082 dps2083 dps2084 dps2085 dps2086 dps2087 dps2088 dps2089 dps2090 dps2091 dps2092 dps2093 dps2094 dps2095 dps2096 dps2097 dps2098 dps2099 dps2100 dps2101 dps2102 dps2103 dps2104 dps2105 dps2106 dps2107 dps2108 dps2109 dps2110 dps2111 dps2112 dps2113 dps2114 dps2115 dps2116 dps2117 dps2118 dps2119 dps2120 dps2121 dps2122 dps2123 dps2124 dps2125 dps2126 dps2127 dps2128 dps2129 dps2130 dps2131 dps2132 dps2133 dps2134 dps2135 dps2136 dps2137 dps2138 dps2139 dps2140 dps2141 dps2142 dps2143 dps2144 dps2145 dps2146 dps2147 dps2148 dps2149 dps2150 dps2151 dps2152 dps2153 dps2154 dps2155 dps2156 dps2157 dps2158 dps2159 dps2160 dps2161 dps2162 dps2163 dps2164 dps2165 dps2166 dps2167 dps2168 dps2169 dps2170 dps2171 dps2172 dps2173 dps2174 dps2175 dps2176 dps2177 dps2178 dps2179 dps2180 dps2181 dps2182 dps2183 dps2184 dps2185 dps2186 dps2187 dps2188 dps2189 dps2190 dps2191 dps2192 dps2193 dps2194 dps2195 dps2196 dps2197 dps2198 dps2199 dps2200 dps2201 dps2202 dps2203 dps2204 dps2205 dps2206 dps2207 dps2208 dps2209 dps2210 dps2211 dps2212 dps2213 dps2214 dps2215 dps2216 dps2217 dps2218 dps2219 dps2220 dps2221 dps2222 dps2223 dps2224 dps2225 dps2226 dps2227 dps2228 dps2229 dps2230 dps2231 dps2232 dps2233 dps2234 dps2235 dps2236 dps2237 dps2238 dps2239 dps2240 dps2241 dps2242 dps2243 dps2244 dps2245 dps2246 dps2247 dps2248 dps2249 dps2250 dps2251 dps2252 dps2253 dps2254 dps2255 dps2256 dps2257 dps2258 dps2259 dps2260 dps2261 dps2262 dps2263 dps2264 dps2265 dps2266 dps2267 dps2268 dps2269 dps2270 dps2271 dps2272 dps2273 dps2274 dps2275 dps2276 dps2277 dps2278 dps2279 dps2280 dps2281 dps2282 dps2283 dps2284 dps2285 dps2286 dps2287 dps2288 dps2289 dps2290 dps2291 dps2292 dps2293 dps2294 dps2295 dps2296 dps2297 dps2298 dps2299 dps2300 dps2301 dps2302 dps2303 dps2304 dps2305 dps2306 dps2307 dps2308 dps2309 dps2310 dps2311 dps2312 dps2313 dps2314 dps2315 dps2316 dps2317 dps2318 dps2319 dps2320 dps2321 dps2322 dps2323 dps2324 dps2325 dps2326 dps2327 dps2328 dps2329 dps2330 dps2331 dps2332 dps2333 dps2334 dps2335 dps2336 dps2337 dps2338 dps2339 dps2340 dps2341 dps2342 dps2343 dps2344 dps2345 dps2346 dps2347 dps2348 dps2349 dps2350 dps2351 dps2352 dps2353 dps2354 dps2355 dps2356 dps2357 dps2358 dps2359 dps2360 dps2361 dps2362 dps2363 dps2364 dps2365 dps2366 dps2367 dps2368 dps2369 dps2370 dps2371 dps2372 dps2373 dps2374 dps2375 dps2376 dps2377 dps2378 dps2379 dps2380 dps2381 dps2382 dps2383 dps2384 dps2385 dps2386 dps2387 dps2388 dps2389 dps2390 dps2391 dps2392 dps2393 dps2394 dps2395 dps2396 dps2397 dps2398 dps2399 dps2400 dps2401 dps2402 dps2403 dps2404 dps2405 dps2406 dps2407 dps2408 dps2409 dps2410 dps2411 dps2412 dps2413 dps2414 dps2415 dps2416 dps2417 dps2418 dps2419 dps2420 dps2421 dps2422 dps2423 dps2424 dps2425 dps2426 dps2427 dps2428 dps2429 dps2430 dps2431 dps2432 dps2433 dps2434 dps2435 dps2436 dps2437 dps2438 dps2439 dps2440 dps2441 dps2442 dps2443 dps2444 dps2445 dps2446 dps2447 dps2448 dps2449 dps2450 dps2451 dps2452 dps2453 dps2454 dps2455 dps2456 dps2457 dps2458 dps2459 dps2460 dps2461 dps2462 dps2463 dps2464 dps2465 dps2466 dps2467 dps2468 dps2469 dps2470 dps2471 dps2472 dps2473 dps2474 dps2475 dps2476 dps2477 dps2478 dps2479 dps2480 dps2481 dps2482 dps2483 dps2484 dps2485 dps2486 dps2487 dps2488 dps2489 dps2490 dps2491 dps2492 dps2493 dps2494 dps2495 dps2496 dps2497 dps2498 dps2499 dps2500 dps2501 dps2502 dps2503 dps2504 dps2505 dps2506 dps2507 dps2508 dps2509 dps2510 dps2511 dps2512 dps2513 dps2514 dps2515 dps2516 dps2517 dps2518 dps2519 dps2520 dps2521 dps2522 dps2523 dps2524 dps2525 dps2526 dps2527 dps2528 dps2529 dps2530 dps2531 dps2532 dps2533 dps2534 dps2535 dps2536 dps2537 dps2538 dps2539 dps2540 dps2541 dps2542 dps2543 dps2544 dps2545 dps2546 dps2547 dps2548 dps2549 dps2550 dps2551 dps2552 dps2553 dps2554 dps2555 dps2556 dps2557 dps2558 dps2559 dps2560 dps2561 dps2562 dps2563 dps2564 dps2565 dps2566 dps2567 dps2568 dps2569 dps2570 dps2571 dps2572 dps2573 dps2574 dps2575 dps2576 dps2577 dps2578 dps2579 dps2580 dps2581 dps2582 dps2583 dps2584 dps2585 dps2586 dps2587 dps2588 dps2589 dps2590 dps2591 dps2592 dps2593 dps2594 dps2595 dps2596 dps2597 dps2598 dps2599 dps2600 dps2601 dps2602 dps2603 dps2604 dps2605 dps2606 dps2607 dps2608 dps2609 dps2610 dps2611 dps2612 dps2613 dps2614 dps2615 dps2616 dps2617 dps2618 dps2619 dps2620 dps2621 dps2622 dps2623 dps2624 dps2625 dps2626 dps2627 dps2628 dps2629 dps2630 dps2631 dps2632 dps2633 dps2634 dps2635 dps2636 dps2637 dps2638 dps2639 dps2640 dps2641 dps2642 dps2643 dps2644 dps2645 dps2646 dps2647 dps2648 dps2649 dps2650 dps2651 dps2652 dps2653 dps2654 dps2655 dps2656 dps2657 dps2658 dps2659 dps2660 dps2661 dps2662 dps2663 dps2664 dps2665 dps2666 dps2667 dps2668 dps2669 dps2670 dps2671 dps2672 dps2673 dps2674 dps2675 dps2676 dps2677 dps2678 dps2679 dps2680 dps2681 dps2682 dps2683 dps2684 dps2685 dps2686 dps2687 dps2688 dps2689 dps2690 dps2691 dps2692 dps2693 dps2694 dps2695 dps2696 dps2697 dps2698 dps2699 dps2700 dps2701 dps2702 dps2703 dps2704 dps2705 dps2706 dps2707 dps2708 dps2709 dps2710 dps2711 dps2712 dps2713 dps2714 dps2715 dps2716 dps2717 dps2718 dps2719 dps2720 dps2721 dps2722 dps2723 dps2724 dps2725 dps2726 dps2727 dps2728 dps2729 dps2730 dps2731 dps2732 dps2733 dps2734 dps2735 dps2736 dps2737 dps2738 dps2739 dps2740 dps2741 dps2742 dps2743 dps2744 dps2745 dps2746 dps2747 dps2748 dps2749 dps2750 dps2751 dps2752 dps2753 dps2754 dps2755 dps2756 dps2757 dps2758 dps2759 dps2760 dps2761 dps2762 dps2763 dps2764 dps2765 dps2766 dps2767 dps2768 dps2769 dps2770 dps2771 dps2772 dps2773 dps2774 dps2775 dps2776 dps2777 dps2778 dps2779 dps2780 dps2781 dps2782 dps2783 dps2784 dps2785 dps2786 dps2787 dps2788 dps2789 dps2790 dps2791 dps2792 dps2793 dps2794 dps2795 dps2796 dps2797 dps2798 dps2799 dps2800 dps2801 dps2802 dps2803 dps2804 dps2805 dps2806 dps2807 dps2808 dps2809 dps2810 dps2811 dps2812 dps2813 dps2814 dps2815 dps2816 dps2817 dps2818 dps2819 dps2820 dps2821 dps2822 dps2823 dps2824 dps2825 dps2826 dps2827 dps2828 dps2829 dps2830 dps2831 dps2832 dps2833 dps2834 dps2835 dps2836 dps2837 dps2838 dps2839 dps2840 dps2841 dps2842 dps2843 dps2844 dps2845 dps2846 dps2847 dps2848 dps2849 dps2850 dps2851 dps2852 dps2853 dps2854 dps2855 dps2856 dps2857 dps2858 dps2859 dps2860 dps2861 dps2862 dps2863 dps2864 dps2865 dps2866 dps2867 dps2868 dps2869 dps2870 dps2871 dps2872 dps2873 dps2874 dps2875 dps2876 dps2877 dps2878 dps2879 dps2880 dps2881 dps2882 dps2883 dps2884 dps2885 dps2886 dps2887 dps2888 dps2889 dps2890 dps2891 dps2892 dps2893 dps2894 dps2895 dps2896 dps2897 dps2898 dps2899 dps2900 dps2901 dps2902 dps2903 dps2904 dps2905 dps2906 dps2907 dps2908 dps2909 dps2910 dps2911 dps2912 dps2913 dps2914 dps2915 dps2916 dps2917 dps2918 dps2919 dps2920 dps2921 dps2922 dps2923 dps2924 dps2925 dps2926 dps2927 dps2928 dps2929 dps2930 dps2931 dps2932 dps2933 dps2934 dps2935 dps2936 dps2937 dps2938 dps2939 dps2940 dps2941 dps2942 dps2943 dps2944 dps2945 dps2946 dps2947 dps2948 dps2949 dps2950 dps2951 dps2952 dps2953 dps2954 dps2955 dps2956 dps2957 dps2958 dps2959 dps2960 dps2961 dps2962 dps2963 dps2964 dps2965 dps2966 dps2967 dps2968 dps2969 dps2970 dps2971 dps2972 dps2973 dps2974 dps2975 dps2976 dps2977 dps2978 dps2979 dps2980 dps2981 dps2982 dps2983 dps2984 dps2985 dps2986 dps2987 dps2988 dps2989 dps2990 dps2991 dps2992 dps2993 dps2994 dps2995 dps2996 dps2997 dps2998 dps2999 dps3000 "@.Replace("`r","").split("`n") $domains = @{ 'rjktesta.rjktest.local' = 'rejtesta.local' 'rjktestc.rjktest.local' = 'rejtestc.local' 'rjktrain.local' = 'rejtrain.local' 'rjkpreprod.local' = 'rejpreprod.local' 'rjkprod.local' = 'rejprod.local' } $output = foreach($suffix in $domains.Keys) { $dc = $domains[$suffix] foreach($server in $dps) { $lookup = "$server.$suffix" try { $result = Resolve-DnsName -Name $lookup -Server $dc -ErrorAction Stop Write-Output ([pscustomobject]@{ Lookup = $lookup Result = $result[0].Address }) } catch { Write-Output ([pscustomobject]@{ Lookup = $lookup Result = $null }) } } } #$output | Export-Csv -Path C:\Users\****\Documents\csv4.csv -NoTypeInformation #$output | where result -eq $result.Address | Export-Csv -Path C:\Users\****\Documents\csv3.csv -NoTypeInformation