Fighting the Machine

Axosoft OnTime get a list of all contact with company name, email, phone using Axosoft OnTime SDK and Powershell

2012-02-09T23:48:00.000-05:00

clear

$securityToken="your guid here"

$customerUrl="http://[your url here]/ontimesdk/customerservice.asmx"

$onTimeCustomer = New-WebServiceProxy $customerUrl -Namespace customers

$customerHandler = New-Object customers.CustomerHandler

$dataset2 = $customerHandler.GetAllCustomerContacts($securityToken)

foreach ($contactRow in $dataset2.Tables[0].Rows)
{
if ($contactRow.CanLogin)
{
$contactRow.CompanyName
" " + $contactRow.FirstName + " " + $contactRow.LastName
" " + $contactRow.Email + " " + $contactRow.Phone
" "
}
}

Axosoft Ontime Getting all projects using Powershell and Axosoft Ontime SDK

2012-02-08T21:08:00.000-05:00

clear
$securityToken="[your guid here]"

$projectUrl="http://[your url here]/ontimesdk/projectservice.asmx"

$onTimeProject = New-WebServiceProxy $projectUrl -Namespace projects

$projectHandler = New-Object projects.ProjectHandler

$dataset = $projectHandler.GetAllProjects($securityToken)

foreach ($row in $dataset.Tables[0].Rows)
{
''+$row.ProjectId + ' - ' + $row.Name
}

Axosoft OnTime Web Event Provider – Create Incidents Automatically with WebEventProvider OnTimeWebEventProvider

2012-01-31T23:16:00.000-05:00

Prerequisites:

Make sure you have installed your OnTime SDK on a Web Server and that it is functional/tested

Make sure you have your Security GUID Ready to talking to the OnTime SDK

Create a project (C#) and create a web reference that points to
“http://your sdk server url goes here/OnTimeSdk/IncidentService.asmx?op=AddIncident”
and call it “OnTime”

Make sure you have the following references:

Here is the source code for the actual WebEventProvider:

using System;
using System.Collections.Specialized;
using System.Web.Management;
using OnTimeWebEventProvider.Properties;

namespace OnTimeWebEventProvider
{
    public class OnTimeWebEventProvider : BufferedWebEventProvider
    {
        private const string StrOnTimeWebEventProvider = "OnTimeWebEventProvider";
        private const string StrDescription = "description";
        private const string StrProjectId = "ProjectID";
        private const string StrCreatedById = "CreatedByID";
        private const string StrWorkflowStepId = "WorkflowStepID";
        private const string StrPriorityId = "PriorityID";
        private const string StrStatusId = "StatusID";
        private const string StrAssignedToId = "AssignedToID";
        private const string StrSeverityId = "SeverityID";
        private const string StrReportedById = "ReportedByID";
        private const string StrEscalationLevelId = "EscalationLevelID";
        private const string StrCustomerById = "CustomerByID";
        private const string StrOnTimeGuid = "OnTimeGuid";
        private const string StrMessage = "Message";

        private Guid _providerSecurityToken;
        private int _providerProjectId;
        private int _providerCreatedById;
        private int _providerWorkflowStepId;
        private int _providerPriorityId;
        private int _providerStatusId;
        private int _providerAssignedToId;
        private int _providerSeverityId;
        private int _providerReportedById;
        private int _providerEscalationLevelId;
        private int _providerCustomerById;
        private String _providerMessage;

        public override void Initialize(string name, NameValueCollection config)
        {
            if (config == null)
                throw new ArgumentNullException(Resources.NullConfig);

            if (string.IsNullOrEmpty(name))
                name = StrOnTimeWebEventProvider;

            if (string.IsNullOrEmpty(config[StrDescription]))
            {
                config.Remove(StrDescription);
                config.Add(StrDescription, Resources.DefaultDescription);
            }

            if (!string.IsNullOrEmpty(config[StrOnTimeGuid]))
            {
                this._providerSecurityToken = new Guid(config[StrOnTimeGuid]);
                config.Remove(StrOnTimeGuid);
            }

            VerifyAndSetConfigSetting(config, StrProjectId, out this._providerProjectId);

            VerifyAndSetConfigSetting(config, StrCreatedById, out this._providerCreatedById);

            VerifyAndSetConfigSetting(config, StrWorkflowStepId, out this._providerWorkflowStepId);

            VerifyAndSetConfigSetting(config, StrPriorityId, out this._providerPriorityId);

            VerifyAndSetConfigSetting(config, StrStatusId, out this._providerStatusId);

            VerifyAndSetConfigSetting(config, StrAssignedToId, out this._providerAssignedToId);

            VerifyAndSetConfigSetting(config, StrSeverityId, out this._providerSeverityId);

            VerifyAndSetConfigSetting(config, StrReportedById, out this._providerReportedById);

            VerifyAndSetConfigSetting(config, StrEscalationLevelId, out this._providerEscalationLevelId);

            VerifyAndSetConfigSetting(config, StrCustomerById, out this._providerCustomerById);

            if (!string.IsNullOrEmpty(config[StrMessage]))
            {
                this._providerMessage = config[StrMessage];
                config.Remove(StrMessage);
            }
            else
            {
                this._providerMessage = String.Empty;
            }

            base.Initialize(name, config);
        }

        private static void VerifyAndSetConfigSetting(NameValueCollection config, string strConfigId, out int intProviderProjectId)
        {
            intProviderProjectId = 0;
            if (!string.IsNullOrEmpty(config[strConfigId]))
                if (int.TryParse(config[strConfigId], out intProviderProjectId))
                    config.Remove(strConfigId);
        }

        public override void ProcessEventFlush(WebEventBufferFlushInfo flushInfo)
        {
            foreach (WebBaseEvent anEvent in flushInfo.Events)
            {
                OnTime.Incident incident =
                    new OnTime.Incident
                        {
                            CreatedById = this._providerCreatedById,
                            WorkflowStepId = this._providerWorkflowStepId,
                            ProjectId = this._providerProjectId,
                            Name =
                                String.Format("Exception in Application: {0} {1}",
                                              anEvent.EventSource, this._providerMessage),
                            Description = anEvent.ToString(),
                            ReportedDate = DateTime.Now,
                            PriorityTypeId = this._providerPriorityId,
                            StatusTypeId = this._providerStatusId,
                            AssignedToId = this._providerAssignedToId,
                            SeverityTypeId = this._providerSeverityId,
                            ReportedById = this._providerReportedById,
                            EscalationLevelId = this._providerEscalationLevelId,
                            ReportedByCustomerContactId = this._providerCustomerById
                        };

                OnTime.IncidentHandler incidentHandler = new OnTime.IncidentHandler();

                incidentHandler.AddIncident(this._providerSecurityToken, incident);
            }
        }
    }
}

Here is an example use of the OnTimeWebEventProvider:

Make sure that you have a reference to the OnTimeWebEventProvider assembly (project or compiled assembly) so that it is properly copied to the ASP.NET’s directory to run the example.

(ASP.NET HTML)

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="TestOnTimeWebEventProvider._Default" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="Button" />
    </div>
    </form>
</body>
</html>

(ASP.NET .ASPX)

using System;

namespace TestOnTimeWebEventProvider
{
    public partial class _Default : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        { }

        protected void Button1_Click(object sender, EventArgs e)
        {
            throw new Exception("Wow, something really bad just blew up!");
        }
    }
}

(ASP.NET web.config)

<?xml version="1.0"?>
<configuration>
  <appSettings/>
  <connectionStrings/>
  <system.web>
    <healthMonitoring>
      <providers>
        <add name="OnTimeWebEventProvider"
             type="OnTimeWebEventProvider.OnTimeWebEventProvider"
             bufferMode="Notification"
             buffer="true"
             OnTimeGuid="your OnTime SDK guid goes here"
             ProjectID="24"
             WorkflowStepID="13"
             CreatedByID="1"
             PriorityID="1"
             StatusID="1"
             AssignedToID="2"
             SeverityID="2"
             ReportedByID="2"
             EscalationLevelID="0"
             CustomerByID="0"
             Message="TEST"/>
      </providers>
      <rules>
        <add name="LogAllEvents" eventName="All Errors" provider="OnTimeWebEventProvider"/>
      </rules>
    </healthMonitoring>
    <compilation debug="false" targetFramework="4.0"/>
    <authentication mode="Windows"/>
    <pages controlRenderingCompatibilityVersion="3.5" clientIDMode="AutoID"/>
  </system.web>
</configuration>

That’s all folks, feedback welcome

Axosoft Ontime retrieve all worklog types using PowerShell and OnTime SDK

2012-01-30T21:05:00.000-05:00

clear
$securityToken="your guid here"

$typeUrl="http://your url here/ontimesdk/typeservice.asmx"

$onTimeTypeServer = New-WebServiceProxy $typeUrl -Namespace types

$typeHandler = New-Object types.TypeHandler

$dataset = $typeHandler.GetWorkLogTypes($securityToken)

foreach ($row in $dataset.Tables[0].Rows)
{
"" + $row.Name + " - " + $row.WorkLogTypeId
}

Axosoft OnTime retrieve all workflow statuses for a single workflow using PowerShell and OnTime SDK

2012-01-29T22:28:00.000-05:00

clear

$securityToken="your guid here"
$workflowId=1

$workflowUrl="http://your url here/ontimesdk/workflowservice.asmx"

$onTimeWorkflow = New-WebServiceProxy $workflowUrl -Namespace workflows

$workflowHandler = New-Object workflows.WorkflowHandler

$dataset = $workflowHandler.GetStepsByWorkflowId($securityToken,$workflowId)

foreach ($row in $dataset.Tables[0].Rows)
{
foreach ($field in $row)
{
$field
}
}

Axosoft OnTime Retrieve all incidents using PowerShell and OnTime SDK

2012-01-28T22:23:00.000-05:00

clear

$securityToken="your guid here"

$incidentUrl="http://your url here/ontimesdk/incidentservice.asmx"

$onTimeServerIncident = New-WebServiceProxy $incidentUrl -Namespace incidents

$incidentHandler = New-Object incidents.IncidentHandler

$dataset = $incidentHandler.GetAllIncidents($securityToken)

foreach ($row in $dataset.Tables[0].Rows)
{
foreach ($field in $row)
{
$field
}
}

Axosoft OnTime Retrieve all customer contacts in the system using PowerShell and OnTime SDK

2012-01-28T01:19:00.000-05:00

clear

$securityToken="your guid here"

$customerUrl="http://your url here/ontimesdk/customerservice.asmx"

$onTimeCustomer = New-WebServiceProxy $customerUrl -Namespace customers

$customerHandler = New-Object customers.CustomerHandler

$dataset = $customerHandler.GetAllCustomerContacts($securityToken)

foreach ($row in $dataset.Tables[0].Rows)
{
foreach ($field in $row)
{
$field
}
}

AxoSoft OnTime Retrieve All Customers through PowerShell and OnTime SDK

2012-01-27T02:16:00.000-05:00

clear

$securityToken="your guid here"

$customerUrl="http://your url here/ontimesdk/customerservice.asmx"

$onTimeCustomer = New-WebServiceProxy $customerUrl -Namespace customers

$customerHandler = New-Object customers.CustomerHandler

$dataset = $customerHandler.GetAllCustomers($securityToken)

foreach ($row in $dataset.Tables[0].Rows)
{
foreach ($field in $row)
{
$field
}
}

AxoSoft OnTime SDK Creating an Incident, Worklog and Closing the Incident through PowerShell

2012-01-25T22:30:00.000-05:00

clear
$incidentName="Management and Restructuring of OnTime Request System"
$incidentDescription="Re-did how releases stage/prod are handled"
$workTimeMinutes=30
$projectId=37
$worklogDescription="Moving Items in OnTime"
$durationMinutes=30
$workflowInitialId=161
$isClose=1
$finalWorkflowId=75

$securityToken="your guid goes here"
$UserId_karell=2
$TimeUnitTypeId_minutes=1
$workflowId=4

$incidentUrl="http://[your server url goes here]/ontimesdk/incidentservice.asmx"
$worklogUrl="http://[your server url goes here]/ontimesdk/worklogservice.asmx"
$typeUrl="http://[your server url goes here]/ontimesdk/typeservice.asmx"
$workflowUrl="http://[your server url goes here]/ontimesdk/workflowservice.asmx"
$customerUrl="http://[your server url goes here]/ontimesdk/customerservice.asmx"
$projectUrl="http://[your server url goes here]/ontimesdk/projectservice.asmx"

$onTimeServerIncident = New-WebServiceProxy $incidentUrl -Namespace incidents
$onTimeWorklogServer = New-WebServiceProxy $worklogUrl -Namespace worklogs
$onTimeTypeServer = New-WebServiceProxy $typeUrl -Namespace types
$onTimeWorkflow = New-WebServiceProxy $workflowUrl -Namespace workflows
$onTimeCustomer = New-WebServiceProxy $customerUrl -Namespace customers
$onTimeProject = New-WebServiceProxy $projectUrl -Namespace projects

$incidentHandler = New-Object incidents.IncidentHandler
$incident = New-Object incidents.incident
$worklogHandler = New-Object worklogs.WorkLogHandler
$worklog = New-Object worklogs.worklog
$typeHandler = New-Object types.TypeHandler
$workflowHandler = New-Object workflows.WorkflowHandler
$customerHandler = New-Object customers.CustomerHandler
$projectHandler = New-Object projects.ProjectHandler

#$dataset = $typeHandler.GetTimeUnitTypes($securityToken)
#$dataset = $workflowHandler.GetStepsByWorkflowId($securityToken,$workflowId)
#$dataset = $customerHandler.GetAllCustomerContacts($securityToken)
#$dataset = $projectHandler.GetAllProjects($securityToken)

$incident.Name=$incidentName
$incident.Description=$incidentDescription
$incident.ReportedDate=Get-Date
$incident.SeverityTypeId=0
$incident.ProjectId=$projectId
$incident.ReportedById=$UserId_karell
$incident.EstimatedDuration=$durationMinutes
$incident.DurationUnitTypeId=1
$incident.LastUpdatedById=$UserId_karell
$incident.RemainingDuration=$durationMinutes
$incident.RemainingUnitTypeId=1
$incident.DueDate=Get-Date
$incident.CreatedById=$UserId_karell
$incident.AssignedToId=$UserId_karell
$incident.PercentComplete=0
$incident.WorkflowStepId=$workflowInitialId

$resultIncidentId = $incidentHandler.AddIncident($securityToken,$incident)

$worklog.Description="Created Request"
$worklog.ItemType="Incident"
$worklog.UserId=$UserId_karell
$worklog.WorkDateTime=Get-Date
$worklog.ItemId=$resultIncidentId
$worklog.WorkDone=5
$worklog.WorkUnitTypeId=1
$worklog.WorkLogTypeId=4

$worklogResult = $worklogHandler.AddWorkLog($securityToken,$worklog)

$worklog.Description=$worklogDescription
$worklog.ItemType="Incident"
$worklog.UserId=$UserId_karell
$worklog.WorkDateTime=Get-Date
$worklog.ItemId=$resultIncidentId
$worklog.WorkDone=$workTimeMinutes
$worklog.WorkUnitTypeId=1
$worklog.WorkLogTypeId=4

$worklogResult = $worklogHandler.AddWorkLog($securityToken,$worklog)

$worklog.Description="Closing Request"
$worklog.ItemType="Incident"
$worklog.UserId=$UserId_karell
$worklog.WorkDateTime=Get-Date
$worklog.ItemId=$resultIncidentId
$worklog.WorkDone=5
$worklog.WorkUnitTypeId=1
$worklog.WorkLogTypeId=4

$worklogResult = $worklogHandler.AddWorkLog($securityToken,$worklog)

$incident = $incidentHandler.GetByIncidentId($securityToken,$resultIncidentId)
"Request created " + $incident.IncidentId + " - " + $incident.IncidentNumber

if ($isClose)
{
$incident.WorkflowStepId=$finalWorkflowId
$incident.Archived=$isClose
$incident.PercentComplete=100
$incident.RemainingDuration=0
$incident.ActualDuration=$workTimeMinutes
$incident.StartDate=Get-Date
$incident.CompletionDate=Get-Date

$result = $incidentHandler.UpdateIncident($securityToken,$incident)
"Closed and Archived Request"
}

Astronomy Picture

2011-02-21T10:09:00.000-05:00

Astronomy Picture

2011-02-20T12:23:00.000-05:00

Astronomy Picture

2011-02-19T08:00:00.000-05:00

Picture: Montreal la ronde fireworks 2009

2010-09-02T07:00:00.000-04:00

Picture: Niagara falls close up

2010-08-31T10:00:00.000-04:00

Picture: Duck close up

2010-08-30T10:00:00.000-04:00

Picture: Marineland black bear

2010-08-29T10:00:00.000-04:00

Picture: Frozen stream

2010-08-28T07:00:00.000-04:00

Picture: rusty dirty fence

2010-08-27T07:00:00.000-04:00

Picture: Fireworks

2010-08-26T07:00:00.000-04:00

Picture: Niagara falls portal tunnel

2010-08-25T07:00:00.000-04:00

Picture: Duck close up

2010-08-24T07:00:00.000-04:00

Picture: Marineland black bear

2010-08-23T07:00:00.000-04:00

Picture: Marineland beluga whale

2010-08-21T07:00:00.000-04:00

Picture: Niagara falls rainbow

2010-08-20T07:00:00.000-04:00

Picture: Wishing well

2010-08-19T10:00:00.000-04:00