Transcript LCH-ProdMgr_2011-08-19

LCH.Clearnet – Sysgem AG
Automated Production Manager Requests
Discussion, 24 Aug 2011
WebEx Conference
1
Automated Production Manager
Requestor
Request
Form
Request
DB
Process
Requests
Multi-platform
Servers
2
Possible Life Cycle Scenario
•
User makes request via a web based form on LCH Intranet
•
LCH web application writes the request into Sysgem “Web Access Request” DB
(Record Status = “Submitted”)
•
Automated Sysgem “Process Requests” task running on Sysgem Server (sgmpr1)
reads DB; e.g, once every minute, searching for “Submitted” records
•
“Submitted” record status changed to “Processing” and transaction submitted to
remote SEM Agent on target server
•
Script on Target server takes action as in current procedures when the “Prod
Manager” menu option is invoked manually by Service Desk
•
Results normally displayed to Service Desk operator are transmitted back to “PostProcessing” script on sgmpr1, which:
- updates the record with the “results”
- changes record status to “Finished” (or “Finished with Errors / Warnings” )
- if required, sends email to requestor giving results
•
User checks “Results” window in web application (and/or receives confirmation by
email), this would normally be available after about a minute from making the request
3
Web Access Request DB
Three Tables:
– Command Table
– Param Table
– Results Table
4
Command Table
5
Command Table
#
#
Command Table
#
@columns = ();
push(@columns, "RequestID=VARCHAR=64");
push(@columns, "Command=VARCHAR=32");
push(@columns, "Source=VARCHAR=32");
push(@columns, "RequestDate=VARCHAR=23");
push(@columns, "RequestStatus=VARCHAR=32");
6
Param table
7
Param table
#
#
Param table.
#
@columns = ();
push(@columns, "RequestID=VARCHAR=64");
push(@columns, "ParamName=VARCHAR=32");
push(@columns, "ParamValue=VARCHAR=255");
8
Results table
9
Results table
#
#
Results table.
#
@columns = ();
push(@columns, "RequestID=VARCHAR=64");
push(@columns, "ResultSequence=INTEGER");
push(@columns, "ResultAgent=VARCHAR=255");
push(@columns, "ResultContext=VARCHAR=255");
push(@columns, "ResultFieldName=VARCHAR=32");
push(@columns, "ResultValue=VARCHAR=255");
10
Example Use of Tables
11
Example Use of Tables
12
Example Use of Tables
13
SEM Installed Components
Managed Agents on
Target Systems
Authorization Server
Management Console
(Windows GUI)
14