Monday, July 20, 2015

How to Easily Get Record Counts for Entitys in Microsoft Dynamics CRM

You can quickly get record counts for all of your entities if you need to using the RecordCountShapshot table in Dynamics CRM.  You aren't supposed to do select queries against  tables so I wouldn't recommend doing this in an integration or something like that.  But if you need a quick ball park of how many records are in each table, it's not a bad option.


SELECT TOP 1000 [Count]

,[RecordCountSnapshotId]

,entityview.ObjectTypeCode, Name

FROM [TESTCRM_MSCRM].[dbo].[RecordCountSnapshot] , EntityView where entityview.ObjectTypeCode = RecordCountSnapshot.ObjectTypeCode

and count > 0 order by count desc

Here is what the results look like:



-Happy Monday!!

Wednesday, May 27, 2015

Microsoft Dynamics CRM 2015 Online is Scheduling Product Upgrades to Update 1

A week ago I was getting frustrated because I love the new features that are coming down the pipe in Update 1 and my sandbox orgs are already upgraded, but I couldn't schedule my Update 1 for my production org.

Yesterday I finally was able to get it scheduled.  The dates are already pushed out into July so you might want to get on that though!



-Happy Wednesday!

Friday, April 24, 2015

Goodbye Lync.. Hello Skype for Business 2015!!

Installed Visio from office 365 yesterday and got a surprise. It updated Lync, but Lync isn't Lync anymore.

Lync is now Skype for Business 2015!!


All said and done they have made some asthetic changes to Lync, but it's a pretty similiar experience.

Still waiting for easy phone integration without Lync Server or without hosting.


-

Thursday, April 16, 2015

2013 CRM Field Guide is Now Available!!

Written by a number of MVP's it is a great source of knowledge on just about everything you could encounter in working with the product.  It's nearly 1000 pages of greatness.

Get your copy HERE:  http://www.crmfieldguide.com/

Monday, March 23, 2015

Surface Pro 3 Giveaway and New Branding Release for TechAir Group!

Techair is very excited to have released their new site and branding last week and we are giving away a Surface Pro 3 to celebrate!


Check out our site at www.techairgroup.com and get registered for our SURFACE PRO 3 GIVEAWAY by filling out the form on our website!



- Happy Monday!