For the user actions Report would it be possible to add a column with the ipaddress of the user's machine form which the action was performed?
I believe I was able to add the IPAddress of the client to the PM reports as follows:
- copying and modifying the OOTB PM database view called 'vw_report_Actions' to include the IPAddress which is logged in the Data tables in the xml entries. We retrieve in addition this atribute in the view: t.n.value('Principal/IPAddress', 'nvarchar(max)') as [PrincipalIPAddress].
<Record xmlns:i="http://www.w3.org/2001/XMLSchema-instance"><Instance>demoapp.demolab.com</Instance><Operation>Captcha</Operation><OperationName>Enter CAPTCHA</OperationName><Principal><DisplayName>Hunter Patrick</DisplayName><Domain>demolab.com</Domain><Id>PATRICK.HUNTER</Id><IPAddress>10.0.0.6</IPAddress>
<Role>User</Role></Principal><Time>2015-11-24T17:44:01.8880721Z</Time><RequestID>5ed74919-dfe3-4742-94fc-1e9fc0d25a12</RequestID><Result>Success</Result><ResultName>Execution successful</ResultName><User><DisplayName>Hunter Patrick</DisplayName><Domain>demolab.com</Domain><Id>PATRICK.HUNTER</Id></User></Record>
- copying and modifying the OOTB User Actions report so that it's DataSet references the new view and IPAddress attribute
- adding this newly available attribute to the report layout
And what IP addresses would you recommend? I need them for England, the United States, and China. By the way, have you ever been asked to enter a postcode for them? I don’t understand why, on the contrary, they hide the location. in general, I usually do not indicate my postcode and take it from here postcodefinder.net/.../sheffield. and how did you solve this problem if you had it?