Skip to main content

Auditing

User activity and access auditing in NetSuite.


Learning Objectives

After this module, you will be able to:

  • Access and interpret login audit trails
  • Track role and permission changes
  • Monitor record-level changes
  • Create audit reports and alerts

Audit Types

AUDIT CAPABILITIES
===============================================================================

┌───────────────────┐ ┌───────────────────┐ ┌───────────────────┐
│ LOGIN AUDIT │ │ ROLE AUDIT │ │ RECORD AUDIT │
├───────────────────┤ ├───────────────────┤ ├───────────────────┤
│ ├─ Login attempts │ │ ├─ Role changes │ │ ├─ Field changes │
│ ├─ Failed logins │ │ ├─ Permission mod │ │ ├─ Who changed │
│ ├─ IP addresses │ │ ├─ Who modified │ │ ├─ When changed │
│ ├─ Session length │ │ └─ When changed │ │ └─ Old/new values │
│ └─ Role at login │ └───────────────────┘ └───────────────────┘
└───────────────────┘

Login Audit Trail

Setup > Users/Roles > View Login Audit Trail

Information Captured

FieldDescriptionUse Case
Date/TimeWhen login occurredTimeline analysis
UserWho logged inUser activity tracking
RoleWhich role usedPermission analysis
IP AddressSource IPLocation verification
StatusSuccess/FailureSecurity monitoring
DetailReason for failureTroubleshooting

Filtering Options

LOGIN AUDIT FILTERS
===============================================================================

Filter By:
├── Date Range: Last 7 days, Last 30 days, Custom
├── User: Specific user or all
├── Status: Success, Failure, All
├── Role: Specific role or all
└── IP Address: Contains/equals

Export Options:
├── CSV download
├── Print
└── Save as report

Common Failure Reasons

Failure TypeMeaningAction
Invalid PasswordWrong password enteredUser education or reset
Account LockedToo many failuresAdmin unlock needed
IP RestrictedOutside allowed rangeVerify legitimate access
2FA FailedWrong verification codeVerify device setup
Session ExpiredTimeoutNormal behavior

Role Audit Trail

Setup > Users/Roles > Role Audit Trail

What's Tracked

ROLE CHANGES TRACKED
===============================================================================

Role Modifications:
├── Permission level changes
├── New permissions added
├── Permissions removed
├── Restriction changes
├── Form assignments
└── Dashboard changes

Metadata Captured:
├── Date/Time of change
├── User who made change
├── Old value
├── New value
└── Role affected

Monitoring Role Changes

Change TypeRisk LevelReview Frequency
Permission added to AdminHighImmediate
New role createdMediumWeekly
Restriction removedHighImmediate
Form assignmentLowMonthly

Record-Level Audit

System Notes

Every record has a System Notes subtab showing:

SYSTEM NOTES EXAMPLE
===============================================================================

Record: Customer ABC Corporation

Date/Time User Field Old Value New Value
─────────────────────────────────────────────────────────────────────────────
3/15/2024 10:30 John Smith Credit Limit $10,000 $25,000
3/14/2024 15:45 Jane Doe Payment Terms Net 30 Net 15
3/10/2024 09:00 System Created - -

Enabling Field History

For custom fields, enable audit trail:

FIELD HISTORY CONFIGURATION
===============================================================================

Navigation: Customization > [Field Type] > [Field] > Edit

Settings:
├── Store Value: ✓ (required)
└── Store Value History: ✓ (enables audit)

Result:
├── All changes logged
├── Visible in System Notes
├── Searchable in saved searches
└── Available in reports

Standard Field Tracking

These standard fields are automatically tracked:

  • Created By / Created Date
  • Last Modified By / Last Modified Date
  • Status changes
  • Approval changes

Audit Saved Searches

Creating Audit Reports

AUDIT SAVED SEARCH EXAMPLES
===============================================================================

Search 1: Failed Logins This Week
├── Type: Login Audit
├── Criteria: Status = Failed, Date = This Week
├── Columns: Date, User, IP, Reason
└── Alert: Email if > 10 failures/day

Search 2: Role Permission Changes
├── Type: System Notes on Role records
├── Criteria: Field Changed contains "Permission"
├── Columns: Date, User, Role, Old/New Value
└── Schedule: Weekly email to IT

Search 3: High-Value Transactions Modified
├── Type: System Notes
├── Criteria: Amount field changed, Amount > $10,000
├── Columns: Record, User, Old Amount, New Amount
└── Alert: Real-time email

Audit Best Practices

Review Schedule

Audit TypeFrequencyReviewer
Failed loginsWeeklyIT Security
Role changesMonthlyAdministrator
Admin actionsMonthlyIT Manager
Full access reviewQuarterlyCompliance

Red Flags to Watch

PatternConcernAction
Many failed logins same IPBrute force attemptBlock IP, investigate
Login from new locationAccount compromiseVerify with user
Permission escalationUnauthorized accessReview immediately
Off-hours admin activitySuspicious behaviorVerify legitimate
Bulk record changesData manipulationAudit transaction

Key Takeaways

  1. Regular Review: Check login audit weekly at minimum
  2. Alert on Critical: Set up alerts for admin/permission changes
  3. Enable Field History: Track important custom fields
  4. Document Anomalies: Record and investigate unusual patterns
  5. Compliance Ready: Maintain audit evidence for regulators