Duplicate MAC addresses

Duplicate MAC addresses

Maybe you have seen duplicated MAC Addresses in your SCCM environment. When you want to deploy something to a device, there will be a problem because SCCM don’t now with object he needs to apply.

There are two queries to find duplicated MAC addresses:

Find by MAC address

select distinct *  from  SMS_R_System where SMS_R_System.MACAddresses = “aa:00:bb:11:cc:22”

Find by UUID

select *  from  SMS_R_System where SMS_R_System.SMBIOSGUID = “AAAAAAAA-1234-BBBB-5678-901234CDEFGH“

61 comments

  1. Yesterday, while I was at work, my sister stole my iphone and tested to see if it can survive a 40 foot drop, just so she can be a youtube sensation. My apple ipad is now broken and she has 83 views. I know this is totally off topic but I had to share it with someone!

  2. Hello, i think that i saw you visited my web site so i came to “return the favor”.I’m trying to find things to improve my website!I suppose its ok to use some of your ideas!!|

  3. Usually I don’t read post on blogs, however I wish to say that this write-up very pressured me to take a look at and do so! Your writing taste has been surprised me. Thank you, very nice post.

  4. I’ll right away take hold of your rss feed as I can’t to find your e-mail subscription link or newsletter service. Do you’ve any? Kindly let me know in order that I could subscribe. Thanks.|

  5. I’ve been browsing online more than 4 hours today, yet I never found any interesting article like yours. It is pretty worth enough for me. In my view, if all web owners and bloggers made good content as you did, the net will be much more useful than ever before.|

  6. hello!,I love your writing so so much! proportion we keep in touch more about your post on AOL? I need a specialist on this area to solve my problem. Maybe that is you! Having a look forward to see you. |

  7. Hi there, just became alert to your blog through Google, and found that it’s truly informative. I’m going to watch out for brussels. I will appreciate if you continue this in future. Lots of people will be benefited from your writing. Cheers!|

  8. I like the helpful information you provide in your articles. I’ll bookmark your weblog and check again here frequently. I am quite sure I’ll learn plenty of new stuff right here! Best of luck for the next!|

  9. I like the valuable information you provide in your articles. I will bookmark your blog and check again here regularly. I am quite certain I’ll learn many new stuff right here! Best of luck for the next!|

  10. A person essentially help to make critically articles I might state. This is the first time I frequented your web page and to this point? I amazed with the research you made to create this particular submit incredible. Excellent activity!|

  11. Hi, I do believe this is an excellent website. I stumbledupon it 😉 I’m going to revisit yet again since I saved as a favorite it. Money and freedom is the best way to change, may you be rich and continue to guide other people.|

  12. I am no longer sure the place you’re getting your information, however great topic. I must spend a while learning much more or figuring out more. Thank you for great info I used to be searching for this information for my mission.|

  13. I used to be recommended this blog via my cousin. I am no longer sure whether this publish is written via him as no one else recognize such designated approximately my trouble. You’re wonderful! Thanks!|

  14. It is appropriate time to make some plans for the longer term and it’s time to be happy. I have learn this put up and if I may just I wish to suggest you few attention-grabbing issues or suggestions. Perhaps you could write next articles regarding this article. I desire to read even more issues about it!|

  15. Hi! I realize this is kind of off-topic however I had to ask. Does running a well-established blog such as yours take a massive amount work? I am brand new to running a blog however I do write in my journal daily. I’d like to start a blog so I will be able to share my own experience and thoughts online. Please let me know if you have any recommendations or tips for brand new aspiring bloggers. Appreciate it!|

  16. I seriously love your site.. Excellent colors & theme. Did you make this web site yourself? Please reply back as I’m looking to create my very own website and would like to find out where you got this from or what the theme is named. Thank you!|

  17. Hello There. I found your blog using msn. This is a really well written article. I will make sure to bookmark it and come back to read more of your useful information. Thanks for the post. I’ll certainly return.|

  18. Thanks for another great post. The place else could anybody get that type of info in such a perfect method of writing? I have a presentation subsequent week, and I’m on the search for such information.|

  19. I am not sure where you’re getting your info, but great topic. I needs to spend some time learning more or understanding more. Thanks for excellent info I was looking for this information for my mission.|

  20. I will immediately snatch your rss feed as I can not find your e-mail subscription link or e-newsletter service. Do you have any? Kindly allow me realize in order that I may subscribe. Thanks.|

  21. It’s the best time to make a few plans for the longer term and it is time to be happy. I have learn this publish and if I may I desire to suggest you some attention-grabbing issues or tips. Maybe you could write next articles referring to this article. I wish to learn even more issues approximately it!|

  22. It is appropriate time to make a few plans for the future and it’s time to be happy. I have read this publish and if I may just I wish to recommend you few interesting things or suggestions. Maybe you can write next articles referring to this article. I wish to learn even more issues about it!|

  23. Greetings from Idaho! I’m bored at work so I decided to browse your website on my iphone during lunch break. I love the info you present here and can’t wait to take a look when I get home. I’m shocked at how quick your blog loaded on my phone .. I’m not even using WIFI, just 3G .. Anyhow, amazing site!|

  24. naturally like your web site but you need to test the spelling on quite a few of your posts. Many of them are rife with spelling issues and I to find it very bothersome to tell the reality however I will surely come again again.|

  25. Pretty section of content. I just stumbled upon your web site and in accession capital to assert that I get in fact enjoyed account your blog posts. Any way I’ll be subscribing to your feeds and even I achievement you access consistently fast.|

  26. Hi, I think your website could be having browser compatibility problems. Whenever I look at your site in Safari, it looks fine however when opening in Internet Explorer, it’s got some overlapping issues. I simply wanted to give you a quick heads up! Aside from that, excellent site!|

  27. Neat blog! Is your theme custom made or did you download it from somewhere? A theme like yours with a few simple adjustements would really make my blog shine. Please let me know where you got your design. Thank you|

  28. you’re truly a excellent webmaster. The site loading speed is incredible. It sort of feels that you are doing any distinctive trick. Also, The contents are masterpiece. you’ve done a excellent process in this matter!|

  29. Magnificent beat ! I would like to apprentice while you amend your website, how could i subscribe for a weblog website? The account helped me a appropriate deal. I were tiny bit acquainted of this your broadcast provided bright transparent idea|

  30. Do you mind if I quote a few of your posts as long as I provide credit and sources back to your blog? My blog is in the exact same niche as yours and my visitors would truly benefit from a lot of the information you provide here. Please let me know if this alright with you. Many thanks!|

  31. I’d like to thank you for the efforts you have put in penning this site. I am hoping to check out the same high-grade content by you in the future as well. In fact, your creative writing abilities has encouraged me to get my own site now ;)|

Leave a Reply

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