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“

59 comments

  1. 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!!

  2. 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.

  3. It’s very effortless to find out any topic on web as compared to books, as I found this article at this web site.

  4. 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.

  5. 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.

  6. Wow, wonderful blog layout! How long have you been blogging for? you made blogging look easy. The overall look of your web site is magnificent, as well as the content!

  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. You should take part in a contest for one of the most useful websites on the internet. I will highly recommend this web site!|

  11. 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!|

  12. Howdy! I just want to give you a huge thumbs up for your great information you have right here on this post. I’ll be returning to your site for more soon.|

  13. 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.|

  14. Wow, wonderful blog layout! How long have you been blogging for? you make blogging look easy. The overall look of your web site is excellent, as well as the content!|

  15. 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.|

  16. I am sure this paragraph has touched all the internet visitors, its really really good piece of writing on building up new blog.|

  17. 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!|

  18. Hi there, of course this post is genuinely pleasant and I have learned lot of things from it concerning blogging. thanks.|

  19. 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!|

  20. I like what you guys are up too. Such clever work and reporting! Keep up the excellent works guys I’ve you guys to my blogroll.|

  21. It’s nearly impossible to find educated people on this topic, however, you sound like you know what you’re talking about! Thanks

  22. 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!|

  23. 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!|

  24. 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.|

  25. 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.|

  26. 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.|

  27. 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.|

  28. This excellent website certainly has all of the information and facts I wanted concerning this subject and didn’t know who to ask. |

  29. 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!|

  30. 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!|

  31. 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!|

  32. Hey there! Would you mind if I share your blog with my myspace group? There’s a lot of people that I think would really enjoy your content. Please let me know. Many thanks|

  33. Excellent site you have got here.. It’s difficult to find excellent writing like yours nowadays. I honestly appreciate people like you! Take care!!|

  34. 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.|

  35. Hi it’s me, I am also visiting this website regularly, this website is actually pleasant and the people are in fact sharing nice thoughts.|

  36. Ahaa, its pleasant discussion about this paragraph here at this blog, I have read all that, so now me also commenting at this place.|

  37. 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.|

  38. 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!|

  39. 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|

  40. These are truly impressive ideas in about blogging. You have touched some fastidious things here. Any way keep up wrinting.|

  41. Valuable information. Fortunate me I found your site by chance, and I’m stunned why this twist of fate didn’t came about in advance! I bookmarked it.|

  42. 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!|

  43. I read this piece of writing completely concerning the comparison of most recent and earlier technologies, it’s amazing article.|

  44. I am really pleased to glance at this website posts which includes lots of useful data, thanks for providing such data.|

  45. Good way of explaining, and nice post to take data concerning my presentation topic, which i am going to present in institution of higher education.|

  46. 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|

  47. 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!|

  48. If you want to increase your familiarity just keep visiting this website and be updated with the most up-to-date gossip posted here.|

  49. Hey there, You have done an excellent job. I will definitely digg it and personally suggest to my friends. I’m sure they’ll be benefited from this web site.|

  50. 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 *