Topic
7 replies Latest Post - ‏2013-03-19T20:44:37Z by SystemAdmin
SystemAdmin
SystemAdmin
24948 Posts
ACCEPTED ANSWER

Pinned topic [clearquest] How can we trigger an email alert from CQ after one hour of defect submission

‏2008-09-16T11:09:37Z |
Hi All,

How can we trigger an email alert from ClearQuest after one hour of
defect submission (ie Escalation if no action changes after one hour of
defect submission)

Please assist me

Regards,

Sneha Reddy R
Please do not print this email unless it is absolutely necessary.

The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments.

WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email.

www.wipro.com
_______________________________________________
clearquest mailing list
clearquest@lists.ca.ibm.com
Unsubscribe:clearquest-leave@lists.ca.ibm.com
Updated on 2013-03-19T20:44:37Z at 2013-03-19T20:44:37Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    24948 Posts
    ACCEPTED ANSWER

    RE: [clearquest] How can we trigger an email alert from CQ after onehour of defect submission

    ‏2008-09-16T11:39:32Z  in response to SystemAdmin
    You can not.
    Run a script (every 10 minutes) that will fetch records (base on a
    query?) and analyze the data
    like submit ion date, state, history etc... and decide if an Email will
    be sent.
    The Email should be sent by the script!
    Best Regards,
    Yossi Sidi
    Corrigent Systems Ltd.
    126 Yig'al Allon St.
    Tel Aviv 67443 Israel
    E-mail: mailto:yossis@corrigent.com
    Web Site: http://www.corrigent.com <http://www.corrigent.com/>
    Office: +972 3 6948 612
    Fax: +972 3 695 3222
    Mobile: +972 54 4748 795
    Home: +972 8 971 4786

    ________________________________

    From: clearquest-bounces@lists.ca.ibm.com
    mailto:clearquest-bounces@lists.ca.ibm.com On Behalf Of
    sneha.reddy@wipro.com
    Sent: 08/09/16 14:10 PM
    To: clearquest@lists.ca.ibm.com
    Subject: clearquest How can we trigger an email alert from CQ
    after onehour of defect submission

    Hi All,

    How can we trigger an email alert from ClearQuest after one hour
    of defect submission (ie Escalation if no action changes after one hour
    of defect submission)

    Please assist me

    Regards,

    Sneha Reddy R

    Please do not print this email unless it is absolutely
    necessary.

    The information contained in this electronic message and any
    attachments to this message are intended for the exclusive use of the
    addressee(s) and may contain proprietary, confidential or privileged
    information. If you are not the intended recipient, you should not
    disseminate, distribute or copy this e-mail. Please notify the sender
    immediately and destroy all copies of this message and any attachments.

    WARNING: Computer viruses can be transmitted via email. The
    recipient should check this email and any attachments for the presence
    of viruses. The company accepts no liability for any damage caused by
    any virus transmitted by this email.

    www.wipro.com

    _______________________________________________
    clearquest mailing list
    clearquest@lists.ca.ibm.com
    Unsubscribe:clearquest-leave@lists.ca.ibm.com
    • SystemAdmin
      SystemAdmin
      24948 Posts
      ACCEPTED ANSWER

      RE: [clearquest] How can we trigger an email alert from CQ after onehour of defect submission

      ‏2008-09-16T13:54:29Z  in response to SystemAdmin
      Hi,

      Please could you be able to provide a sample script?

      Regards,

      Sneha Reddy R





      Project Engineer | Wipro Technologies | Hyderabad | Ph no:30797268

      ________________________________

      From: Yossi Sidi mailto:Yossis@corrigent.com
      Sent: Tuesday, September 16, 2008 5:10 PM
      To: Sneha Reddy r (WT01 - Computing and Storage IPG);
      clearquest@lists.ca.ibm.com
      Subject: RE: clearquest How can we trigger an email alert from CQ
      after onehour of defect submission

      You can not.

      Run a script (every 10 minutes) that will fetch records (base on a
      query?) and analyze the data

      like submit ion date, state, history etc... and decide if an Email will
      be sent.

      The Email should be sent by the script!
      Best Regards,
      Yossi Sidi
      Corrigent Systems Ltd.
      126 Yig'al Allon St.
      Tel Aviv 67443 Israel
      E-mail: mailto:yossis@corrigent.com
      Web Site: http://www.corrigent.com <http://www.corrigent.com/>
      Office: +972 3 6948 612
      Fax: +972 3 695 3222
      Mobile: +972 54 4748 795
      Home: +972 8 971 4786
      ________________________________
      From: clearquest-bounces@lists.ca.ibm.com
      mailto:clearquest-bounces@lists.ca.ibm.com On Behalf Of
      sneha.reddy@wipro.com
      Sent: 08/09/16 14:10 PM
      To: clearquest@lists.ca.ibm.com
      Subject: clearquest How can we trigger an email alert from CQ
      after onehour of defect submission

      Hi All,

      How can we trigger an email alert from ClearQuest after one hour
      of defect submission (ie Escalation if no action changes after one hour
      of defect submission)

      Please assist me

      Regards,

      Sneha Reddy R

      Please do not print this email unless it is absolutely
      necessary.

      The information contained in this electronic message and any
      attachments to this message are intended for the exclusive use of the
      addressee(s) and may contain proprietary, confidential or privileged
      information. If you are not the intended recipient, you should not
      disseminate, distribute or copy this e-mail. Please notify the sender
      immediately and destroy all copies of this message and any attachments.

      WARNING: Computer viruses can be transmitted via email. The
      recipient should check this email and any attachments for the presence
      of viruses. The company accepts no liability for any damage caused by
      any virus transmitted by this email.

      www.wipro.com
      Please do not print this email unless it is absolutely necessary.

      The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments.

      WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email.

      www.wipro.com
      _______________________________________________
      clearquest mailing list
      clearquest@lists.ca.ibm.com
      Unsubscribe:clearquest-leave@lists.ca.ibm.com

      Attachments

      • SystemAdmin
        SystemAdmin
        24948 Posts
        ACCEPTED ANSWER

        RE: [clearquest] How can we trigger an email alert from CQ after onehour of defect submission

        ‏2008-09-16T14:39:18Z  in response to SystemAdmin
        You have an example of query,
        VB script that fetch info (base on a query) and send Email.
        I run it every night.

        Just modify it according to your needs and have fun :)
        Quoted from an old mail of mine:-
        =============================
        I attached an example of CQ API + Email + Excel + chart + print format

        two sheets in a book,
        Sheet1 contains a report in A3 format, margin and column wide setting,
        Sheet2 contains a Pivot table and chart in A4 format.
        The script is not a "best VBS practice" but it gives an example of how
        to
        set
        print formatting features like selecting A3 for sheet 1 and A4 for
        sheet2,
        page margin, column wide ... (use print preview)
        charts, automatic Email, dates comparison etc.

        Attached:-
        the script CQ_Epstat2Zvikam.vbs.txt
        and Excel CQ_Epstat2ZvikaM.xls.txt
        REMOVE the ".txt" extension from files name.
        Best Regards,
        Yossi Sidi
        Corrigent Systems Ltd.
        126 Yig'al Allon St.
        Tel Aviv 67443 Israel
        E-mail: mailto:yossis@corrigent.com
        Web Site: http://www.corrigent.com <http://www.corrigent.com/>
        Office: +972 3 6948 612
        Fax: +972 3 695 3222
        Mobile: +972 54 4748 795
        Home: +972 8 971 4786

        ________________________________

        From: sneha.reddy@wipro.com mailto:sneha.reddy@wipro.com
        Sent: 08/09/16 16:54 PM
        To: Yossi Sidi; clearquest@lists.ca.ibm.com
        Subject: RE: clearquest How can we trigger an email alert from
        CQ after onehour of defect submission

        Hi,

        Please could you be able to provide a sample script?

        Regards,

        Sneha Reddy R





        Project Engineer | Wipro Technologies | Hyderabad | Ph
        no:30797268
        ________________________________
        From: Yossi Sidi mailto:Yossis@corrigent.com
        Sent: Tuesday, September 16, 2008 5:10 PM
        To: Sneha Reddy r (WT01 - Computing and Storage IPG);
        clearquest@lists.ca.ibm.com
        Subject: RE: clearquest How can we trigger an email alert from
        CQ after onehour of defect submission

        You can not.

        Run a script (every 10 minutes) that will fetch records (base on
        a query?) and analyze the data

        like submit ion date, state, history etc... and decide if an
        Email will be sent.

        The Email should be sent by the script!
        Best Regards,
        Yossi Sidi
        Corrigent Systems Ltd.
        126 Yig'al Allon St.
        Tel Aviv 67443 Israel
        E-mail: mailto:yossis@corrigent.com
        Web Site: http://www.corrigent.com <http://www.corrigent.com/>
        Office: +972 3 6948 612
        Fax: +972 3 695 3222
        Mobile: +972 54 4748 795
        Home: +972 8 971 4786
        ________________________________
        From: clearquest-bounces@lists.ca.ibm.com
        mailto:clearquest-bounces@lists.ca.ibm.com On Behalf Of
        sneha.reddy@wipro.com
        Sent: 08/09/16 14:10 PM
        To: clearquest@lists.ca.ibm.com
        Subject: clearquest How can we trigger an email alert
        from CQ after onehour of defect submission

        Hi All,

        How can we trigger an email alert from ClearQuest after
        one hour of defect submission (ie Escalation if no action changes after
        one hour of defect submission)

        Please assist me

        Regards,

        Sneha Reddy R

        Please do not print this email unless it is absolutely
        necessary.

        The information contained in this electronic message and
        any attachments to this message are intended for the exclusive use of
        the addressee(s) and may contain proprietary, confidential or privileged
        information. If you are not the intended recipient, you should not
        disseminate, distribute or copy this e-mail. Please notify the sender
        immediately and destroy all copies of this message and any attachments.

        WARNING: Computer viruses can be transmitted via email.
        The recipient should check this email and any attachments for the
        presence of viruses. The company accepts no liability for any damage
        caused by any virus transmitted by this email.

        www.wipro.com

        Please do not print this email unless it is absolutely
        necessary.

        The information contained in this electronic message and any
        attachments to this message are intended for the exclusive use of the
        addressee(s) and may contain proprietary, confidential or privileged
        information. If you are not the intended recipient, you should not
        disseminate, distribute or copy this e-mail. Please notify the sender
        immediately and destroy all copies of this message and any attachments.

        WARNING: Computer viruses can be transmitted via email. The
        recipient should check this email and any attachments for the presence
        of viruses. The company accepts no liability for any damage caused by
        any virus transmitted by this email.

        www.wipro.com

        _______________________________________________
        clearquest mailing list
        clearquest@lists.ca.ibm.com
        Unsubscribe:clearquest-leave@lists.ca.ibm.com

        Attachment not added (too many attachments): "display-editor.JPG"
        Attachment not added (too many attachments): "query-editor.JPG"
        Attachment not added (too many attachments): "CQ_Epstat-demo.xls.txt"
        • SystemAdmin
          SystemAdmin
          24948 Posts
          ACCEPTED ANSWER

          Re: RE: [clearquest] How can we trigger an email alert from CQ after onehour of defect submission

          ‏2013-03-19T20:44:37Z  in response to SystemAdmin
          Hi Yossi,

          I am unable to find the excel in the attachment. Please let me know how to download the same.

          Thanks
          Revathi Vijayaraghavan
  • alan_scm
    alan_scm
    61 Posts
    ACCEPTED ANSWER

    Re: [clearquest] How can we trigger an email alert from CQ after one hour of defect submission

    ‏2008-09-16T16:28:54Z  in response to SystemAdmin
    Hi Yossi,

    How to execute the give script , i know about the perl , from command line you can execute, but i am not aware of VB can you please tell how you execute it.

    Thanks,
    Alan.
    • SystemAdmin
      SystemAdmin
      24948 Posts
      ACCEPTED ANSWER

      RE: [clearquest] How can we trigger an email alert from CQ afterone hour of defect submission

      ‏2008-09-16T16:33:51Z  in response to alan_scm
      Hi,
      If you run it from the DOS prompt just type the
      DRIVE:\PATH\SCRIPT_NAME.vbs

      or from a scheduler, for example:
      "C:\WINNT\System32\WScript.exe" D:\gdaily\CQ_Equery.vbs
      Best Regards,
      Yossi Sidi
      Corrigent Systems Ltd.
      126 Yig'al Allon St.
      Tel Aviv 67443 Israel
      E-mail: mailto:yossis@corrigent.com
      Web Site: http://www.corrigent.com
      Office: +972 3 6948 612
      Fax: +972 3 695 3222
      Mobile: +972 54 4748 795
      Home: +972 8 971 4786
      >-----Original Message-----
      >From: clearquest-bounces@lists.ca.ibm.com
      >mailto:clearquest-bounces@lists.ca.ibm.com On Behalf Of clearquest
      >Sent: 08/09/16 19:29 PM
      >To: clearquest@lists.ca.ibm.com
      >Subject: Re: clearquest How can we trigger an email alert
      >from CQ afterone hour of defect submission
      >
      >Hi Yossi,
      >
      >
      >
      >How to execute the give script , i know about the perl , from
      >command line you can execute, but i am not aware of VB can you
      >please tell how you execute it.
      >
      >
      >
      >Thanks,
      >
      >Alan.
      >

      _______________________________________________
      clearquest mailing list
      clearquest@lists.ca.ibm.com
      Unsubscribe:clearquest-leave@lists.ca.ibm.com
      • alan_scm
        alan_scm
        61 Posts
        ACCEPTED ANSWER

        Re: RE: [clearquest] How can we trigger an email alert from CQ afterone hour of defect submission

        ‏2008-09-16T17:35:10Z  in response to SystemAdmin
        Thanks yossi,

        for the information.
        Alan.