Create authentication stat graph

[outsmain]

• Run PROC_AUTHACCT_SUM() to create summary data into table NE_AUTHSUM
• On page "Auth. Log > Device" show line graph for each node when user click on each row of node, using data from NE_AUTHSUM
• Filtering plot data as same as shown DataTable
  • Range of "Start Date" and "End Date"
  • "Summary Type"
  • "Node Name"
• Graph parameters are
  • Graph plot by Flot library
  • Graph size 800x480px.
  • Title "Node NE_AUTHSUM.node_name/NE_AUTHSUM.node_ip Authentication Statistics" (replace NE_AUTHSUM.node_name and NE_AUTHSUM.node_ip by node name and node IP or selected node, respectively)
  • X axis label is "Last Login Date / Time" use data from NE_AUTHSUM.last_login range between last_login - 12 hours and last_login + 12 hours

There are 4 types of graphs depend on which column is clicked by a user

1. "Node Name" or "Node IP"
   • Primary Y axis label is "% Success"
   • Secondary Y axis label is "Transaction #"
   • 4 Data series are
   • NE_AUTHSUM.success_rate (primary)
   • NE_AUTHSUM.accept_num (secondary)
   • NE_AUTHSUM.reject_num (secondary)
   • NE_AUTHSUM.cmd_num (secondary)
2. "Login Num (Acp / Rej)" or "Success Rate (%)"
   • Primary Y axis label is "% Success"
   • Secondary Y axis label is "Login #"
   • 3 Data series are
   • NE_AUTHSUM.success_rate (primary)
   • NE_AUTHSUM.accept_num (secondary)
   • NE_AUTHSUM.reject_num (secondary)
3. "Login Req. /s"
   • Primary Y axis label is "Login /s"
   • Secondary Y axis label is "Login #"
   • 2 Data series are
   • NE_AUTHSUM.login_rate (primary)
   • NE_AUTHSUM.accept_num + NE_AUTHSUM.reject_num (secondary)
4. "Cmd Num" or "Cmd /s"
   • Primary Y axis label is "Cmd /s "
   • Secondary Y axis label is "Cmd #"
   • 2 Data series are
   • NE_AUTHSUM.cmd_rate (primary)
   • NE_AUTHSUM.cmd_num (secondary)

[outsmain]

Change Log

• Data source field from NE_AUTHSUM.update_date to NE_AUTHSUM.last_login
• Graph X axis label from "Update Date / Time" to "Last Login Date / Time"

[tanikul]

ไม่เข้าใจตรงนี้ครับ

There are 4 types of graphs depend on which column is clicked by a user

1. "Node Name" or "Node IP"

Primary Y axis label is "% Success" Secondary Y axis label is "Transaction #" 4 Data series are NE_AUTHSUM.success_rate (primary) NE_AUTHSUM.accept_num (secondary) NE_AUTHSUM.reject_num (secondary) NE_AUTHSUM.cmd_num (secondary) "Login Num (Acp / Rej)" or "Success Rate (%)" Primary Y axis label is "% Success" Secondary Y axis label is "Login #" 3 Data series are NE_AUTHSUM.success_rate (primary) NE_AUTHSUM.accept_num (secondary) NE_AUTHSUM.reject_num (secondary) "Login Req. /s" Primary Y axis label is "Login /s" Secondary Y axis label is "Login #" 2 Data series are NE_AUTHSUM.login_rate (primary) NE_AUTHSUM.accept_num + NE_AUTHSUM.reject_num (secondary) "Cmd Num" or "Cmd /s" Primary Y axis label is "Cmd /s " Secondary Y axis label is "Cmd #" 2 Data series are NE_AUTHSUM.cmd_rate (primary) NE_AUTHSUM.cmd_num (secondary)