Looking for PowerObjects? Don’t worry, you’re in the right place! We’ve been part of HCL for several years, and we’ve now taken the final step in our acquisition journey: moving our website to the HCL domain. Nothing else is changing – we are still fanatically focused on Microsoft Business Applications!

PowerObjects Blog 

for Microsoft Business Applications


Where are users logging in from into Microsoft Dynamics CRM?

Post Author: Joe D365 | July 9th, 2010

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!

Joe CRM
By 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.

4 comments on “Where are users logging in from into Microsoft Dynamics CRM?”

  1. you mention:
    >>began logging in a central database the ip address and correlated location of the ip address for all successful and failed logins.

    Are you doing this from within CRM?
    How are you getting the IP address of the client from within CRM?

    Thanks!

    1. powerobjects.comHi Robert -- we subscribe to a database that correlates ip to city/state/isp. As for getting the ip address of the client we use our own tool -- powerLog. It is currenlty crm 4 only, but shortly we will have a crm 2011 version. PowerLog

  2. We are using CRM 2011, on premise, is the IP address of the users logging in being tracked anywhere in the application.

    1. Hi Giri - yes the ip address of all users is being stored in the IIS log files. THis logs all interactions that the users do. However, if you are using ADFS, then you stll have the user's ip address but not the user name due to the authentication type in IIS.

PowerObjects Recommends