Can we track the machine name from which user's access PowerPivot models??

Question

Hello All,

I am trying to find out if we can track the host name of user's computer when ever he/she connects to the Power Pivot Services externally (Machines outside the SharePoint Farm)

Specs: SQL Server 2012 (Denali)

Power Pivot for SharePoint 2010

Regards,

Sam

Answer 1

Hi Salman,

A PowerPivot for SharePoint deployment that runs within a SharePoint 2010 farm uses the authentication subsystem and authorization model provided by SharePoint servers. For better support, I suggest you post the question that how to track user account information in SharePoint deployment.
SharePoint Products and Technologies: http://social.technet.microsoft.com/Forums/en-US/category/sharepoint/

In addition, here is an article about PowerPivot Authentication and Authorization for your reference. Please see:
http://technet.microsoft.com/en-us/library/ee210621.aspx

Regards,
Bin Long

---

Bin Long

TechNet Community Support

Answer 2

Thanks Bin,

We were trying to find those machine names who are hitting PowerPivot Services who are RAS connected.

We deployed a script with which we were able to track IP Address and locations of the users. However unable to track machine names out side domains.

Thanks for the suggestion :-).

Regards,

Salman

Answer 3

Hi Salman,

To be honest, I'm not familiar with track machine names out side domains. For this issue, I would suggest opening a case with Microsoft Customer Support Services (CSS) (http://support.microsoft.com), so that a dedicated Support Professional can assist you in a more efficient manner.

Thanks,
Bin Long

---

Bin Long

TechNet Community Support