Topic
  • 9 replies
  • Latest Post - ‏2013-02-24T14:12:07Z by oper
oper
oper
11 Posts

Pinned topic Event action SSM tasks with mysql

‏2013-01-31T18:56:40Z |
Is there any way put registered task by Service and Support Manager to IBM to mysql database?
Is Event action (Automation plans) supports this feature? Mysql is running on a different server.

Most important keys:
1. Serial Number
2. Fault
3. Service Status
4. Service Requests

Registration request should trigger event action which stores data to mysql database.

Thanks for the replies.
Updated on 2013-02-24T14:12:07Z at 2013-02-24T14:12:07Z by oper
  • SystemAdmin
    SystemAdmin
    13279 Posts

    Re: Event action SSM tasks with mysql

    ‏2013-02-04T15:16:34Z  
    I haven't memorized the contents of the events that get generated by SSM. Take a look in the Event Log and see if the event that gets logged contains the data you are looking for. If the data is there, then it is possible to use an Event Automation Plan to launch a script to write the data to MySQL.

    ----
    Craig Elliott
    IBM Advanced Technical Skills
  • oper
    oper
    11 Posts

    Re: Event action SSM tasks with mysql

    ‏2013-02-05T09:02:28Z  
    The data is logged in the Event Log, I can send email with the same data, but I'm wondering how this script should look like and how to start.
    Mysql database is running on a different server. I haven't found documentation for explanations
  • SystemAdmin
    SystemAdmin
    13279 Posts

    Re: Event action SSM tasks with mysql

    ‏2013-02-06T18:17:34Z  
    • oper
    • ‏2013-02-05T09:02:28Z
    The data is logged in the Event Log, I can send email with the same data, but I'm wondering how this script should look like and how to start.
    Mysql database is running on a different server. I haven't found documentation for explanations
    The data from the Event gets mapped into variables as defined in the InfoCenter at http://pic.dhe.ibm.com/infocenter/director/pubs/topic/com.ibm.director.automation.helps.doc/fqm0_c_ea_event_data_substitution_variables.html.

    So basically, you would call your script using something like 'myscript.sh &severity &system'. Then, your script would pass these arguments to variables, then write it to a MySQL database. Your script would also have to handle connecting to the database, etc.

    ----
    Craig Elliott
    IBM Advanced Technical Skills
  • oper
    oper
    11 Posts

    Re: Event action SSM tasks with mysql

    ‏2013-02-19T22:25:43Z  
    I found those variables on source code:

    ElectronicService.ErrorReporting
    Detail.ElectronicService.ErrorReporting.SSM_SERV_REQ_NUMBER
    Detail.ElectronicService.ErrorReporting.SSM_SERV_ERROR_DESC
    Detail.ElectronicService.ErrorReporting.SSM_AFFECTED_SYS

    Can I use them to event action SSM by "&prop:file_name#property_name" or "&sysvar:variable_name"?
  • SystemAdmin
    SystemAdmin
    13279 Posts

    Re: Event action SSM tasks with mysql

    ‏2013-02-20T01:42:26Z  
    • oper
    • ‏2013-02-19T22:25:43Z
    I found those variables on source code:

    ElectronicService.ErrorReporting
    Detail.ElectronicService.ErrorReporting.SSM_SERV_REQ_NUMBER
    Detail.ElectronicService.ErrorReporting.SSM_SERV_ERROR_DESC
    Detail.ElectronicService.ErrorReporting.SSM_AFFECTED_SYS

    Can I use them to event action SSM by "&prop:file_name#property_name" or "&sysvar:variable_name"?
    When you look at the event in the Event Log, if you see these variables, then yes you an use them (generally by specifying &variable_name). If they are not displayed in the details section of the Event Log, you will most likely not be able to use them.

    ----
    Craig Elliott
    IBM Advanced Technical Skills
  • oper
    oper
    11 Posts

    Re: Event action SSM tasks with mysql

    ‏2013-02-22T07:10:38Z  
    This is one from event log (filtered through Eletronic Service Request -> Electronic Service.Error Reporting)

    Date and Time: 22 lut 2013 02:16:54
    Component Type: Error Reporting
    Component Category: Electronic Service
    Component Instance:
    Condition: Operational Condition
    Condition Value: Service Request Open Successful
    Source: xxx
    Category: Alert
    Sender Name: Service and Support Manager
    Time Event Occurred: 22 lut 2013 02:16:54
    Time Event Received: 22 lut 2013 02:16:54
    Event ID: 200
    Service Request Number: 82001SXXXX
    Service Error Description: A DIMM has failed.
    Affected System: IBM 8853G3G 99XXXXX
    Affected System GUID: XXXX
    Problem ID: 1539267519
    Service Request This URI: https://www-945.ibm.com:443/...
    Service Request Number: 82001SXXXX -> mumber from IBM Supoort. I want to use it as a variable.
    Which one is correct? &number? &service_request_number?
  • SystemAdmin
    SystemAdmin
    13279 Posts

    Re: Event action SSM tasks with mysql

    ‏2013-02-22T17:02:08Z  
    • oper
    • ‏2013-02-22T07:10:38Z
    This is one from event log (filtered through Eletronic Service Request -> Electronic Service.Error Reporting)

    Date and Time: 22 lut 2013 02:16:54
    Component Type: Error Reporting
    Component Category: Electronic Service
    Component Instance:
    Condition: Operational Condition
    Condition Value: Service Request Open Successful
    Source: xxx
    Category: Alert
    Sender Name: Service and Support Manager
    Time Event Occurred: 22 lut 2013 02:16:54
    Time Event Received: 22 lut 2013 02:16:54
    Event ID: 200
    Service Request Number: 82001SXXXX
    Service Error Description: A DIMM has failed.
    Affected System: IBM 8853G3G 99XXXXX
    Affected System GUID: XXXX
    Problem ID: 1539267519
    Service Request This URI: https://www-945.ibm.com:443/...
    Service Request Number: 82001SXXXX -> mumber from IBM Supoort. I want to use it as a variable.
    Which one is correct? &number? &service_request_number?
    Looks like you should be able to use it. I can't remember if the spaces are replaced with a '_', or the spaces are just removed. You can try one of the following:

    &Service_Request_Number
    &ServiceRequestNumber

    ----
    Craig Elliott
    IBM Advanced Technical Skills
  • oper
    oper
    11 Posts

    Re: Event action SSM tasks with mysql

    ‏2013-02-23T07:20:53Z  
    These variables unfortuntely don't return correct value. Return null. Mapping variables may be different.
  • oper
    oper
    11 Posts

    Re: Event action SSM tasks with mysql

    ‏2013-02-24T14:12:07Z  
    I solved by use of variable "&text" which contains all information and then parse text in perl.
    Thanks for your help