Jcurve Support Articles / Business Intelligence

Show User Who Logged in Using at Least 2 Different IP Addresses in a Day Via Login Audit Trail

Written by
Pattranit Lakhan
Published on
January 26, 2024 at 8:26:28 AM PST January 26, 2024 at 8:26:28 AM PSTth, January 26, 2024 at 8:26:28 AM PST

Scenario

User wants to have a saved search where they can see who logged in using at least two different IP addresses in a day.

Solution

  1. Navigate toLists>Search>Saved Searches>New
  2. New Saved Search:SelectLogin Audit Trail
  3. Search Title:EnterTitle
  4. Criteria:ClickSummary
    • Summary Type:SelectCount
    • Field:SelectIP Address
      • IP Address:SelectGreater Than
      • Value:Enter1
      • ClickSet
  5. ClickAdd
  6. ClickStandard
  7. Filter:SelectDate
    • Date:Selectwithin Today
  8. ClickSet
  9. ClickResults
  10. Field:SelectFormula (Date)
    • Formula:EnterTO_DATE({date})
  11. ClickAdd
  12. ClickSave & Run
#ip address
#Saved Search
#Login Audit Trail
#user access
Jcurve Support Articles / Business Intelligence