Tuesday, 1 December 2015

SQL Query to list the Entity & Display Name in Microsoft Dynamics CRM

It is just a brief post since I need this in my current project and want to share to you and also in case I forgot where I did save it.

So here is the SQL Query as per mentioned in the Title

The Query

select en.Name, en.LogicalName, displayname.ObjectColumnName, displayname.Label, IsCustomEntity from 

entityview en
inner join LocalizedLabelLogicalView displayname
on en.EntityId = displayname.ObjectId
and displayname.ObjectColumnName = 'LocalizedName'
where IsCustomEntity = 1 -- remove this if you want to show the system entities as well
--and add the isActivity = 0 if you want to filter out the Activity entity
--if you want to remove like post album, filter, etc
--and en.Name not like '%msdyn%'
order by label

Result


image

If you have multiple language for display name then I believe you need to join to the language ID as well.

Hope this helps! Thanks

17 comments:

  1. Great blog. If you want to buy a good CRM Software for all purposes, please contact us from the links below

    The web based crm software topic of discussion here is very much serious as well as they are all counting regarding the online lead management CRM tool as well as its advantages. Make this a must for your all custom crm solutions possibilities and within quick time you will start feeling up the change. Business as well as all related aspects is carefully managed by this new custom built crm tool.

    ReplyDelete
  2. I really appreciate information shared above. It’s of great help. If someone want to learn Online (Virtual) instructor lead live training in Microsoft CRM, kindly contact us http://www.maxmunus.com/contact
    MaxMunus Offer World Class Virtual Instructor led training on Microsoft CRM. We have industry expert trainer. We provide Training Material and Software Support. MaxMunus has successfully conducted 100000+ trainings in India, USA, UK, Australlia, Switzerland, Qatar, Saudi Arabia, Bangladesh, Bahrain and UAE etc.
    For Demo Contact us.
    Nitesh Kumar
    MaxMunus
    E-mail: nitesh@maxmunus.com
    Skype id: nitesh_maxmunus
    Ph:(+91) 8553912023
    http://www.maxmunus.com/



    ReplyDelete
  3. This is very nice blog,and it is helps for student's.Thanks for sharing..
    MS SQL Server 2016

    ReplyDelete
  4. Nice information thank you,if you want more information please visit our link salesforce Online Training Bangalore

    ReplyDelete
  5. Apply online for Microsoft Recruitment. Get the information about the current and upcoming vacancies here.

    ReplyDelete
  6. Exactly the function I needed, thanks!

    ReplyDelete
  7. Great post I would like to thank you for the efforts you have made in writing this interesting and knowledgeable article. We are top CRM Software | CRM Software Mumbai | CRM Software Provider | CRM Software Pune | Field Management Software | CRM Software India

    ReplyDelete
  8. Nice blog has been shared by you. it will be really helpful to many peoples who are all working under the technology.thank you for sharing this blog.

    Best CRM System

    ReplyDelete
  9. I was very happy to find this site. I really enjoyed reading this article today and think it might be one of the best articles I have read so far. I wanted to thank you for this excellent reading !! I really enjoy every part and have bookmarked you to see the new things you post. Well done for this excellent article. Please keep this work of the same quality.
    Data Science Course in Bangalore

    ReplyDelete
  10. Truly incredible blog found to be very impressive due to which the learners who ever go through it will try to explore themselves with the content to develop the skills to an extreme level. Eventually, thanking the blogger to come up with such an phenomenal content. Hope you arrive with the similar content in future as well.
    Digital Marketing training

    ReplyDelete
  11. EventTitans is the hybrid event management software where Event Interactions made Ever Powerful and Highly Flexible.Satisfy all of your event management needs with EventTitans, the comprehensive and innovative hybrid solution.
    virtual event platform
    event management software
    event engagement platform
    event website builder
    online event ticketing
    hybrid event platform
    event registration platforms

    ReplyDelete
  12. Thanks for the valuable Content. I really learned a lot here. Do share more like this.
    Advantages Of Salesforce
    Benefits Of Salesforce CRM

    ReplyDelete
  13. Wonderful blog found to be very impressive to come across such an awesome blog. I should really appreciate the blogger for the efforts they have put in to develop such an amazing content for all the curious readers who are very keen of being updated across every corner. Ultimately, this is an awesome experience for the readers. Anyways, thanks a lot and keep sharing the content in future too.

    Data Science Course in Bhilai

    ReplyDelete
  14. Impressive blog to be honest definitely this post will inspire many more upcoming aspirants. Eventually, this makes the participants to experience and innovate themselves through knowledge wise by visiting this kind of a blog. Once again excellent job keep inspiring with your cool stuff.

    Data Science Training in Bhilai

    ReplyDelete

My Name is..