eoStar Security

1. eoStar Security Thu Schoenberg Sean Berens

2. Topics • Audit Logs • Mobile Device Session Logs • User Passwords • Reporting • Report Automation

3. Audit Logs What are Audit Logs? • Audit Logs = Alogs • AlogCustomers, AlogBrands, AlogItems, etc. • Audit Logs are tables that are used to track changes to records • Audit Log tables can be used for reporting purposes Design contributions for Audit Logs? • Andrews Distributing • J.J. Taylor Companies • Summit Beverage

4. Audit Logs What do we track? • Primary record changes on 133 Tables • Field that was changed • New and prior values • Employee performing the change • Date/Time change was made

5. Audit Logs What do we partially track? • Partial Tracking • Tracking data changes w/o employee • Data changed via SQL Trigger(s) • Tracking date/time changes w/o prior data or employee • Data stored in SQL Blobs and/or updated via SQL Trigger(s)

6. Audit Logs What we currently don’t’ track? • Data who's RecNid lives outside the primary table • Examples: • Customer’s product set payment terms • Customer’s contacts • Product Alt-packs • Warehouse substitutions

7. Audit Logs – Wiki Forum

8. Mobile Device Session Logs What are Mobile Device Session Logs? • Logs collected on mobile devices throughout the work day • What type of tracking is available? • Session logs • Explicit (step-by-step) actions performed on mobile devices • Visible on handheld, tablet, and eoStar client • Route Analyzer • Customer based actions performed on mobile devices • Daily Delivery Stop Analysis • Back office analysis of employee deliveries/pre-sells

9. Mobile Device Session Logs • Start Presell order • Populate Order • Save order • Non-service visit • Save Tap survey • Reopen Tap survey • View Data Metrics • Start POS Request • Cancel POS Request • Start POS Removal • Cancel POS Removal • Start Off truck order • Overcommit alert • Disregard freebies alert • Edit Shelf Sequence • Start Off invoice Payment • Save off invoice payment • Start delivery • Open order • Record customer signature • Void signature • Edit place with • Edit PO • Void order • Push off order • Start survey • Save survey • Start POS Survey • Start Checkout • Print Checkout receipt • Void checkout • Star checkout • Truck cuts • Truck reload • Receive transfer • Pre-order • Write-offs • View out of stocks • Warehouse count • Warehouse write off • Zapped all barcodes • Save barcodes • New purchase • Set supplier • Change user • Save Backup • Restore backup What mobile events do we track?

10. Mobile Device Session Logs What mobile events we don’t track • Changes to connection information • Viewing standard and qualified promotions • Retrieving and viewing goals • Taking UX surveys

11. User Passwords Types of User passwords • Connecting to the eoStar database • Integrated Security (Windows) • SQL • Logging into the eoStar client application • User Logins • Clearing user passwords within eoStar • Handheld passwords • Viewing and changing passwords within eoStar • SQL Script(s) to bulk change passwords

12. Reporting Where is the data? • Audit Logs • “dbo.Alog” + TableName (i.e. dbo.AlogCustomers, dbo.AlogItems) • Mobile Device Session Logs – Session Logs • dbo.Sessions.SessionNid <-> dbo.HandheldLog.SessionNid • Mobile Device Session Logs – Route Analyzer • dbo.Sessions.SessionNid <-> dbo.RouteAnalyzerEvents.SessionNid

13. Report Automation What is Report Automation? • The ability to schedule Ion, DX, & SQL Reports How do I automate my reports? • eoStar Scheduler • Automated reports can be useful for auditing and notification purposes • For more in depth coverage of the eoStar Scheduler visit the “Ion in Action” forum tomorrow.

14. Discuss | Ask | Suggest ! • Thu Schoenberg thu@eostar.com • Sean Berens sean@eostar.com ? * • Discussions online at www.wiki-eostar.com