• State Verified Answer
  • Locked Locked
  • Replies 4 replies
  • Subscribers 39 subscribers
  • Views 9279 views
  • Users 0 members are here
Options
Related
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Add IP Address to reports

Robert Byrne
over 7 years ago

Hi,

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?

 

thanks,

Rob.

  • 0 over 7 years ago
    Hi Rob,

    Password Manager does not collect any data on the device that a user uses to perform an activity. Therefore in its present form, the reports cannot be configured to include information on ip addresses.
    If this is something that is important to you or your organisation then I would suggest that you open a service request through the support portal and request this as a product enhancement. As with all enhancement requests this will then be reviewed by our product manager for possible inclusion in a future release of the product.

    Regards,

    Jim C.
  • +1 over 7 years ago

    Hi,

    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[1]/IPAddress[1]', '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

    Rob.

     

  • 0 over 6 years ago
    Hey Robert,
    that is exactly what i am looking for. But i am not a sql specialist. Could you please explain it step by step how to to that?
    That would be perfect!
    Thank you so much in advanced.
    Frank
  • 0 over 6 years ago
    OK, i got it.
    Do you know if it is possible to to the same for the logged on user on the machine with that ip address?
    Frank