We recently began logging in a central database the ip address and correlated location of the ip address for all successful and failed logins. Using report builder 3.0 we then quickly created a parameterized report where we can easily search by user login, success/failed logins, and last x number of days. We can easily set this up for hosted Microsoft crm clients or ISV’s that we are doing their xRM hosting.


This is really neat as we can easily query where logins are coming in for a certain user or all failed logins during x number of days. Here is a screen shot of all unique locations that I have logged into crm during the past 30 days.
crm 4.0 user login tracking

Going a step further we then created a second report to graphically plot where all logins for a certain server are coming from. This too, is using an out of the box map wizard that is part of Report Builder 3.0. or we can create other types of CRM reporting with this data.

Next week we’ll have a step by step blog on creating one of these map reports plotting a count of customer accounts in a crm system in a map of the USA.

Do you have what it takes to be a Microsoft CRM superhero? Well now you do with PowerObjects PowerPack CRM add-ons! The PowerPack tools are designed to help enhance the capabilities of Microsoft Dynamics CRM, while providing even greater functionality and efficiency. All for just $1-2 per user, per month.

Happy CRM’ing!

Avatar for Joe D365

Joe D365

Joe D365 is a Microsoft Dynamics 365 superhero who runs on pure Dynamics adrenaline. As the face of PowerObjects, Joe D365’s mission is to reveal innovative ways to use Dynamics 365 and bring the application to more businesses and organizations around the world.