shimpark blogs

//create the profile object and set the versionTrackingProfile profile = new TrackingProfile();profile.Version = new Version(1, 0, 0);//define a tracking pointWorkflowTrackPoint wfTrack = new WorkflowTrackPoint();//create a list of events we are interested inList<TrackingWorkflowEvent> events = new List<TrackingWorkflowEvent>();events.Add(TrackingWorkflowEvent.Aborted);events.Add(TrackingWorkflowEvent.Terminated);events.Add(TrackingWorkflowEvent.Exception);//create a tracking location to indicate which events should be trackedWorkflowTrackingLocation wfLocation =     new WorkflowTrackingLocation(events);//set the matching location on the track pointwfTrack.MatchingLocation = wfLocation;//add the track point to the profileprofile.WorkflowTrackPoints.Add(wfTrack);

ActivityTrackPoint actTrack = new ActivityTrackPoint();ActivityTrackingLocation actMatch = new ActivityTrackingLocation(    typeof(SendEmail), false, new ActivityExecutionStatus[] {         ActivityExecutionStatus.Closed });ActivityTrackingCondition condition =     new ActivityTrackingCondition("Priority", "High");actMatch.Conditions.Add(condition);actTrack.MatchingLocations.Add(actMatch);profile.ActivityTrackPoints.Add(actTrack);

SqlTrackingQueryOptions options = new SqlTrackingQueryOptions();options.WorkflowStatus = WorkflowStatus.Terminated;SqlTrackingQuery query = new SqlTrackingQuery(connectionString);IList<SqlTrackingWorkflowInstance> workflows =     query.GetWorkflows(options);foreach (SqlTrackingWorkflowInstance workflow in workflows){    foreach(WorkflowTrackingRecord workflowEvent in         workflow.WorkflowEvents)    {        TrackingWorkflowTerminatedEventArgs args =             workflowEvent.EventArgs as                 TrackingWorkflowTerminatedEventArgs;        if (args != null)        {            Console.WriteLine(                "workflow {0} terminated with exception: {1}",             workflow.WorkflowInstanceId, args.Exception.Message);        }                      }}