Sign in
 
HomeLibraryLearnDownloadsRepositoryCommunityForumsBlog
Script Center >
> 
> 
Tracking alerts-response time using Powershell - Outlook 2007

已答覆 Tracking alerts-response time using Powershell - Outlook 2007

  • Wednesday, October 10, 2012 9:55 PM
     
     
    Sign In to Vote
    0

    The challenge I am facing is this.

    --> Alerts from various servers are sent to the mailboxes of the monitoring agents.

    --> Agents respond to such alerts.

    --> I wish to have a script in place, running under a rule. This will be executed in every agent's mailbox. 

    The purpose of the script will be, it will calculate the time difference between the time at which an agent receives an alert and till which he responds to it. This difference should then be exported to a .txt file (or) .xlsx file. 

    My questions are, can this be done at the client's end using a script in a rule?

    Any examples of such script? How should I go forward? should I use message subject or should i use message body and try to extract the time-stamp from the header.

    Ravi ------ Sanity is a socially acceptable level of Insanity.

     

All Replies

  • Wednesday, October 10, 2012 10:13 PM
     
     
    Sign In to Vote
    0

    Agents are not clients.  An agent does not run OUtlook but is a part of a service.

    Much of this is dependent on what version of exchange and exactly what you mean by 'agents'.

    If you mean realestate aqents then maybe this is doable.  We might even be able to do it with secret agents.  We cannot do it with proxy agents or agents of change.

    As you can see your use of the term 'agents' is ambiguous.  Give us a definition of what you mean by agents.

    If you meann 'Software Agents' then we probably cannot do a client side because there is no client session with an agent:

    Read this: http://en.wikipedia.org/wiki/Software_agent

    ¯\_(ツ)_/¯

     
  • Wednesday, October 10, 2012 10:20 PM
     
     
    Sign In to Vote
    0

    Correction: agents=clients=guys who monitor. Not services.

    Can we not have a script which runs as part of a rule in outlook 2007?

    If ye ..  Can we have this script to calculate the time difference and export it to excel/notepad as mentioned above?

    Ravi ------ Sanity is a socially acceptable level of Insanity.



    • Edited by RamaRavikanth Wednesday, October 10, 2012 10:22 PM
    •  
     
  • Wednesday, October 10, 2012 11:08 PM
     
     Answered
    Sign In to Vote
    0

    Correction: agents=clients=guys who monitor. Not services.

    Can we not have a script which runs as part of a rule in outlook 2007?

    If ye ..  Can we have this script to calculate the time difference and export it to excel/notepad as mentioned above?

    Ravi ------ Sanity is a socially acceptable level of Insanity.



    So you are talking about human beings logged into a console.

    You can create a rule in Outlook and export it.  It can then be imported into Outlook.

    You should post in the Outlook/Office forum for instructions on how to create rules in Outlook.  This is an admin scripting forum.  What you want to do requires user side VBA or just user interaction to accomplish.

    You can  use PowerShell: http://dandarache.wordpress.com/2011/07/25/using-powershell-to-create-rules-in-outlook/

    In the end you will need to design your own rule and test it.  Once designed you can export it or use PowerShell or VBScript to create the rule in script.

    The full question you are asking is one if what we call 'workflow"  we can design workflows to process messages.  A workflow can summarize an agents response time.  That is one thing a work flow does.

    This of workflow as a database of messages and actions/responses.  We can query this database to get a report of how a user (agent) processes requests in the queue.

    Many of us are proficient in creating workflow systems.  Look around and find a consultant in your area to help you design and deploy a workflow system.

    PowerShell V3 has excellent support for Workflow. Exchange supports workflow.  There are many bits in the Platform SDK to assist in designing Exchange based workflows.

    TO do what you propose in Outlook alone would be very difficult becuase Outlook has no concept of processing.  A rule is t5riggerd and does one thging.  To get the time difference would require a second rule that captured the agents respnse.  Outlook cannot easily do this.  Workflow can.

    ¯\_(ツ)_/¯


     
  • Thursday, October 11, 2012 12:40 AM
     
     
    Sign In to Vote
    0

    Thanks man, 

    I got it, I`ll have to use outlook VBA for it.

    Ravi ------ Sanity is a socially acceptable level of Insanity.

     
  • Thursday, October 11, 2012 1:48 AM
     
     
    Sign In to Vote
    0

    Thanks man, 

    I got it, I`ll have to use outlook VBA for it.

    Ravi ------ Sanity is a socially acceptable level of Insanity.

    I do npt see hopw even VBA can do what you are asking.  It is a workflow issue.

    Two events.  1) receive messaeg. 2) resond ro messaeg.

    What links these events?  There is no real link between them unless you over ride the 'Reply' mechanixm and use that event to calculate response time.  It can be done but it is not a simple script.

    Post in the Outlook/Office developer forum for assistance with how to do this.

    ¯\_(ツ)_/¯

     
  • Thursday, October 11, 2012 4:31 PM
     
     
    Sign In to Vote
    0

    jrv,

    I`ll update this thread once I am done with the project.

    Thanks

    Ravi ------ Sanity is a socially acceptable level of Insanity.