Topic
IC4NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
9 replies Latest Post - ‏2013-02-24T14:12:07Z by oper
oper
oper
11 Posts
ACCEPTED ANSWER

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
    ACCEPTED ANSWER

    Re: Event action SSM tasks with mysql

    ‏2013-02-04T15:16:34Z  in response to oper
    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
    ACCEPTED ANSWER

    Re: Event action SSM tasks with mysql

    ‏2013-02-05T09:02:28Z  in response to oper
    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
      ACCEPTED ANSWER

      Re: Event action SSM tasks with mysql

      ‏2013-02-06T18:17:34Z  in response to oper
      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
    ACCEPTED ANSWER

    Re: Event action SSM tasks with mysql

    ‏2013-02-19T22:25:43Z  in response to oper
    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
      ACCEPTED ANSWER

      Re: Event action SSM tasks with mysql

      ‏2013-02-20T01:42:26Z  in response to oper
      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
    ACCEPTED ANSWER

    Re: Event action SSM tasks with mysql

    ‏2013-02-22T07:10:38Z  in response to oper
    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
      ACCEPTED ANSWER

      Re: Event action SSM tasks with mysql

      ‏2013-02-22T17:02:08Z  in response to oper
      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
    ACCEPTED ANSWER

    Re: Event action SSM tasks with mysql

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

    Re: Event action SSM tasks with mysql

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