The schedule activity report gives a color-coded round-up of recent schedule activity including step duration. This report is filtered using a mandatory Timespan parameter and may be appropriate.
Because it relates schedule records to history records the schedule activity report is very environment agnostic. It does not require field modification after upload. The following customizations are suggested:
- Change the default time range filter of 6 hours based on schedule frequency
- Customize the durations that display as green, yellow, and red. Default is:
- Green <= 240 (4 minutes)
- Yellow <= 480 (8 minutes)
- Red > 480 (more than 8 minutes)
When adding this report to a dashboard, download, or email you MUST specify the Time report parameter.
JSON Definition
Copy the following JSON into a text file, and upload to report settings.
Version 3.4 or Higher
{
"Data": [
{
"$type": "SoftwareIDM.ReportingModule.Models.Report, SoftwareIDM.ReportingModule",
"Id": "9558334a-26c0-4126-96bb-069bbe5803f2",
"Name": "Schedule Activity",
"UserId": "S-1-5-21-850135195-118180008-1618035785-1040440",
"UserProfile": false,
"Tags": null,
"Roles": null,
"CacheExpiration": "00:05:00",
"Description": "",
"Parameters": [
{
"$type": "SoftwareIDM.ReportingModule.Models.TextReportParameter, SoftwareIDM.ReportingModule",
"Name": "Time",
"Description": "",
"Required": true,
"Validation": "TimeSpan",
"DefaultValue": "01:00:00"
},
{
"$type": "SoftwareIDM.ReportingModule.Models.TextReportParameter, SoftwareIDM.ReportingModule",
"Name": "AvgTime",
"Description": "",
"Required": true,
"Validation": "TimeSpan",
"DefaultValue": "1.00:00:00"
},
{
"$type": "SoftwareIDM.ReportingModule.Models.TextReportParameter, SoftwareIDM.ReportingModule",
"Name": "Environment",
"Description": "Filter based on schedule name",
"Required": false,
"Validation": "",
"DefaultValue": ""
}
],
"DataSets": [],
"ReportSets": [
{
"$type": "SoftwareIDM.ReportingModule.Models.ReportData, SoftwareIDM.ReportingModule",
"Name": "Schedule",
"Report": "e6de1976-cc48-48b4-9da8-fc064802d9dc",
"Aliases": null,
"MemoRules": []
},
{
"$type": "SoftwareIDM.ReportingModule.Models.ReportData, SoftwareIDM.ReportingModule",
"Name": "Average",
"Report": "0f80839b-8114-4b84-8092-6dbcfb65a1f4",
"Aliases": null,
"MemoRules": []
}
],
"Relations": [
{
"$type": "SoftwareIDM.ReportingModule.Models.Relation, SoftwareIDM.ReportingModule",
"Name": "Schedule - Average",
"LeftSet": "Schedule",
"RightSet": "Average",
"LeftRule": "Data.Step Name + Data.Schedule Name",
"RightRule": "Data.Step Name + Data.Schedule Name",
"AllowLeftOuter": false,
"AllowRightOuter": true
}
],
"FieldProjections": [
{
"$type": "SoftwareIDM.ReportingModule.Models.Projection, SoftwareIDM.ReportingModule",
"Name": "Schedule Name",
"RelationName": "Schedule - Average",
"RelationSide": "Left",
"ValueRule": "Data.Schedule Name"
},
{
"$type": "SoftwareIDM.ReportingModule.Models.Projection, SoftwareIDM.ReportingModule",
"Name": "Step Name",
"RelationName": "Schedule - Average",
"RelationSide": "Left",
"ValueRule": "Data.Step Name"
},
{
"$type": "SoftwareIDM.ReportingModule.Models.Projection, SoftwareIDM.ReportingModule",
"Name": "Started",
"RelationName": "Schedule - Average",
"RelationSide": "Left",
"ValueRule": "If(Data.Started, DateTimeFormat(Data.Started, \"hh:mm:ss on MMM dd\"), DateTimeFormat(Data.StartedInstance, \"hh:mm:ss on MMM dd\"))"
},
{
"$type": "SoftwareIDM.ReportingModule.Models.Projection, SoftwareIDM.ReportingModule",
"Name": "Step Duration",
"RelationName": "Schedule - Average",
"RelationSide": "Left",
"ValueRule": "If(Data.Step Duration, Data.Step Duration.TotalSeconds, null)"
},
{
"$type": "SoftwareIDM.ReportingModule.Models.Projection, SoftwareIDM.ReportingModule",
"Name": "Run Duration",
"RelationName": "Schedule - Average",
"RelationSide": "Left",
"ValueRule": "If(Data.Run Duration, Data.Run Duration.TotalSeconds, null)"
},
{
"$type": "SoftwareIDM.ReportingModule.Models.Projection, SoftwareIDM.ReportingModule",
"Name": "Avg Run Duration",
"RelationName": "Schedule - Average",
"RelationSide": "Right",
"ValueRule": "Data.Run Duration"
},
{
"$type": "SoftwareIDM.ReportingModule.Models.Projection, SoftwareIDM.ReportingModule",
"Name": "Run Result",
"RelationName": "Schedule - Average",
"RelationSide": "Left",
"ValueRule": "Data.Run Result"
},
{
"$type": "SoftwareIDM.ReportingModule.Models.Projection, SoftwareIDM.ReportingModule",
"Name": "Error Count",
"RelationName": "Schedule - Average",
"RelationSide": "Left",
"ValueRule": "Data.Error Count"
},
{
"$type": "SoftwareIDM.ReportingModule.Models.Projection, SoftwareIDM.ReportingModule",
"Name": "Avg Error Count",
"RelationName": "Schedule - Average",
"RelationSide": "Right",
"ValueRule": "Data.Error Count"
},
{
"$type": "SoftwareIDM.ReportingModule.Models.Projection, SoftwareIDM.ReportingModule",
"Name": "Run Count",
"RelationName": "Schedule - Average",
"RelationSide": "Right",
"ValueRule": "$\"{Data.Step Count} in {Memo(\"AvgTime\")}\""
},
{
"$type": "SoftwareIDM.ReportingModule.Models.Projection, SoftwareIDM.ReportingModule",
"Name": "Max Count",
"RelationName": "Schedule - Average",
"RelationSide": "Right",
"ValueRule": "Data.Max Count"
},
{
"$type": "SoftwareIDM.ReportingModule.Models.Projection, SoftwareIDM.ReportingModule",
"Name": "Repeat Interval",
"RelationName": "Schedule - Average",
"RelationSide": "Right",
"ValueRule": "Data.Repeat Interval"
}
],
"Transformations": [],
"Styles": [
{
"$type": "SoftwareIDM.ReportingModule.Models.RowStyle, SoftwareIDM.ReportingModule",
"Fields": [
"Error Count"
],
"ConditionRule": "Data.Error Count == 0",
"Bold": false,
"Italic": false,
"Hide": false,
"TextColor": "g",
"CellColor": "g"
},
{
"$type": "SoftwareIDM.ReportingModule.Models.RowStyle, SoftwareIDM.ReportingModule",
"Fields": [
"Error Count"
],
"ConditionRule": "And(Data.Error Count > 0, Data.Error Count <= Data.Avg Error Count)",
"Bold": false,
"Italic": false,
"Hide": false,
"TextColor": "y",
"CellColor": "y"
},
{
"$type": "SoftwareIDM.ReportingModule.Models.RowStyle, SoftwareIDM.ReportingModule",
"Fields": [
"Error Count"
],
"ConditionRule": "Data.Error Count > Data.Avg Error Count",
"Bold": false,
"Italic": false,
"Hide": false,
"TextColor": "r",
"CellColor": "r"
},
{
"$type": "SoftwareIDM.ReportingModule.Models.RowStyle, SoftwareIDM.ReportingModule",
"Fields": [
"Step Name"
],
"ConditionRule": "Contains(Data.Step Name, \"Executing\")",
"Bold": false,
"Italic": false,
"Hide": false,
"TextColor": "p",
"CellColor": "p"
},
{
"$type": "SoftwareIDM.ReportingModule.Models.RowStyle, SoftwareIDM.ReportingModule",
"Fields": [
"Step Name",
"Run Duration"
],
"ConditionRule": "If(And(Data.Run Duration, Data.Avg Run Duration),\nData.Run Duration > Data.Avg Run Duration, false)",
"Bold": false,
"Italic": false,
"Hide": false,
"TextColor": "y",
"CellColor": "y"
},
{
"$type": "SoftwareIDM.ReportingModule.Models.RowStyle, SoftwareIDM.ReportingModule",
"Fields": [
"Step Name",
"Run Duration"
],
"ConditionRule": "If(And(Data.Run Duration, Data.Avg Run Duration),\nData.Run Duration > MultiplyDouble(Data.Avg Run Duration, 2), false)",
"Bold": false,
"Italic": false,
"Hide": false,
"TextColor": "r",
"CellColor": "r"
}
],
"Sort": {
"Field": "Started",
"Direction": "Descending"
}
},
{
"$type": "SoftwareIDM.ReportingModule.Models.Report, SoftwareIDM.ReportingModule",
"Id": "0f80839b-8114-4b84-8092-6dbcfb65a1f4",
"Name": "Schedule Activity Average",
"UserId": "S-1-5-21-850135195-118180008-1618035785-1040440",
"UserProfile": false,
"Tags": null,
"Roles": null,
"CacheExpiration": "00:05:00",
"Description": "",
"Parameters": [
{
"$type": "SoftwareIDM.ReportingModule.Models.TextReportParameter, SoftwareIDM.ReportingModule",
"Name": "AvgTime",
"Description": "",
"Required": true,
"Validation": "TimeSpan",
"DefaultValue": "01:00:00"
},
{
"$type": "SoftwareIDM.ReportingModule.Models.TextReportParameter, SoftwareIDM.ReportingModule",
"Name": "Environment",
"Description": "Filter based on schedule name",
"Required": true,
"Validation": "",
"DefaultValue": "*"
}
],
"DataSets": [
{
"$type": "SoftwareIDM.ReportingModule.Models.QueryData, SoftwareIDM.ReportingModule",
"Clauses": [
{
"$type": "SoftwareIDM.PanelModel.Models.FilterClause, SoftwareIDM.PanelModel",
"Field": "StartDate",
"Operation": "Gte",
"Value": "AddTime(Now(), \"-\" + Memo(\"AvgTime\"))"
}
],
"SubQueries": [],
"MapRule": "Filter(\n Steps,\n And(\n Started,\n AddTime(Started, Duration) >= AddTime(Now(), \"-\" + Memo(\"AvgTime\"))\n )\n)",
"MemoRules": [
{
"$type": "SoftwareIDM.ReportingModule.Models.MemoRule, SoftwareIDM.ReportingModule",
"Name": "ScheduleHistory",
"Rule": "Child.HistoryId"
}
],
"Aliases": null,
"Name": "Schedule",
"Type": "SoftwareIDM.PanelModel.Models.ScheduleRecord, SoftwareIDM.PanelModel"
},
{
"$type": "SoftwareIDM.ReportingModule.Models.QueryData, SoftwareIDM.ReportingModule",
"Clauses": [
{
"$type": "SoftwareIDM.PanelModel.Models.FilterClause, SoftwareIDM.PanelModel",
"Field": "Id",
"Operation": "In",
"Value": "Memo(\"ScheduleHistory\")"
}
],
"SubQueries": [],
"MapRule": "",
"MemoRules": [],
"Aliases": null,
"Name": "History",
"Type": "SoftwareIDM.PanelModel.Models.HistoryRecord, SoftwareIDM.PanelModel"
},
{
"$type": "SoftwareIDM.ReportingModule.Models.QueryData, SoftwareIDM.ReportingModule",
"Clauses": [],
"SubQueries": [],
"MapRule": "",
"MemoRules": [],
"Aliases": null,
"Name": "ScheduleDefinition",
"Type": "SoftwareIDM.PanelModel.Models.Schedule, SoftwareIDM.PanelModel"
}
],
"ReportSets": [],
"Relations": [
{
"$type": "SoftwareIDM.ReportingModule.Models.Relation, SoftwareIDM.ReportingModule",
"Name": "Schedule - History",
"LeftSet": "Schedule",
"RightSet": "History",
"LeftRule": "Child.HistoryId",
"RightRule": "Id",
"AllowLeftOuter": false,
"AllowRightOuter": true
},
{
"$type": "SoftwareIDM.ReportingModule.Models.Relation, SoftwareIDM.ReportingModule",
"Name": "Schedule - Definition",
"LeftSet": "Schedule",
"RightSet": "ScheduleDefinition",
"LeftRule": "Parent.Argument",
"RightRule": "Name",
"AllowLeftOuter": false,
"AllowRightOuter": false
}
],
"FieldProjections": [
{
"$type": "SoftwareIDM.ReportingModule.Models.Projection, SoftwareIDM.ReportingModule",
"Name": "Schedule Name",
"RelationName": "Schedule - History",
"RelationSide": "Left",
"ValueRule": "Parent.Argument"
},
{
"$type": "SoftwareIDM.ReportingModule.Models.Projection, SoftwareIDM.ReportingModule",
"Name": "Step Name",
"RelationName": "Schedule - History",
"RelationSide": "Left",
"ValueRule": "Child.Name"
},
{
"$type": "SoftwareIDM.ReportingModule.Models.Projection, SoftwareIDM.ReportingModule",
"Name": "Started",
"RelationName": "Schedule - History",
"RelationSide": "Left",
"ValueRule": "Child.Started"
},
{
"$type": "SoftwareIDM.ReportingModule.Models.Projection, SoftwareIDM.ReportingModule",
"Name": "Step Duration",
"RelationName": "Schedule - History",
"RelationSide": "Left",
"ValueRule": "Child.Duration.TotalSeconds"
},
{
"$type": "SoftwareIDM.ReportingModule.Models.Projection, SoftwareIDM.ReportingModule",
"Name": "Run Duration",
"RelationName": "Schedule - History",
"RelationSide": "Right",
"ValueRule": "SubtractDate(EndDate, StartDate).TotalSeconds"
},
{
"$type": "SoftwareIDM.ReportingModule.Models.Projection, SoftwareIDM.ReportingModule",
"Name": "Status",
"RelationName": "Schedule - History",
"RelationSide": "Left",
"ValueRule": "CoerceString(Child.Result)"
},
{
"$type": "SoftwareIDM.ReportingModule.Models.Projection, SoftwareIDM.ReportingModule",
"Name": "Run Result",
"RelationName": "Schedule - History",
"RelationSide": "Right",
"ValueRule": "Result"
},
{
"$type": "SoftwareIDM.ReportingModule.Models.Projection, SoftwareIDM.ReportingModule",
"Name": "Error Count",
"RelationName": "Schedule - History",
"RelationSide": "Right",
"ValueRule": "Sum(\n Counters.special.History Counter.Sync Error,\n Counters.special.History Counter.Discovery Error,\n Counters.special.History Counter.Export Error,\n Counters.special.History Counter.Export Failure,\n Counters.special.History Counter.Retry Error\n)"
},
{
"$type": "SoftwareIDM.ReportingModule.Models.Projection, SoftwareIDM.ReportingModule",
"Name": "Repeat Interval",
"RelationName": "Schedule - Definition",
"RelationSide": "Right",
"ValueRule": "Times.0.Interval"
}
],
"Transformations": [
{
"$type": "SoftwareIDM.ReportingModule.Models.Transform, SoftwareIDM.ReportingModule",
"FilterRule": "Or(Memo(\"Environment\") == \"*\", Contains(Memo(\"Environment\"), Data.Schedule Name))",
"GroupingRule": "",
"TransformRules": []
},
{
"$type": "SoftwareIDM.ReportingModule.Models.Transform, SoftwareIDM.ReportingModule",
"FilterRule": "",
"GroupingRule": "Data.Step Name + Data.Schedule Name",
"TransformRules": [
{
"$type": "SoftwareIDM.ReportingModule.Models.TransformField, SoftwareIDM.ReportingModule",
"Field": "Schedule Name",
"Name": "",
"Operator": "None",
"TransformRule": ""
},
{
"$type": "SoftwareIDM.ReportingModule.Models.TransformField, SoftwareIDM.ReportingModule",
"Field": "Step Name",
"Name": "",
"Operator": "None",
"TransformRule": ""
},
{
"$type": "SoftwareIDM.ReportingModule.Models.TransformField, SoftwareIDM.ReportingModule",
"Field": "Step Duration",
"Name": "",
"Operator": "Mean",
"TransformRule": ""
},
{
"$type": "SoftwareIDM.ReportingModule.Models.TransformField, SoftwareIDM.ReportingModule",
"Field": "Run Duration",
"Name": "",
"Operator": "Mean",
"TransformRule": ""
},
{
"$type": "SoftwareIDM.ReportingModule.Models.TransformField, SoftwareIDM.ReportingModule",
"Field": "Error Count",
"Name": "",
"Operator": "Mean",
"TransformRule": ""
},
{
"$type": "SoftwareIDM.ReportingModule.Models.TransformField, SoftwareIDM.ReportingModule",
"Field": "Step Name",
"Name": "Step Count",
"Operator": "Count",
"TransformRule": ""
},
{
"$type": "SoftwareIDM.ReportingModule.Models.TransformField, SoftwareIDM.ReportingModule",
"Field": "Repeat Interval",
"Name": "",
"Operator": "None",
"TransformRule": ""
}
]
},
{
"$type": "SoftwareIDM.ReportingModule.Models.Transform, SoftwareIDM.ReportingModule",
"FilterRule": "",
"GroupingRule": "",
"TransformRules": [
{
"$type": "SoftwareIDM.ReportingModule.Models.TransformField, SoftwareIDM.ReportingModule",
"Field": "Schedule Name",
"Name": "",
"Operator": "None",
"TransformRule": ""
},
{
"$type": "SoftwareIDM.ReportingModule.Models.TransformField, SoftwareIDM.ReportingModule",
"Field": "Step Name",
"Name": "",
"Operator": "None",
"TransformRule": ""
},
{
"$type": "SoftwareIDM.ReportingModule.Models.TransformField, SoftwareIDM.ReportingModule",
"Field": "Step Duration",
"Name": "",
"Operator": "None",
"TransformRule": ""
},
{
"$type": "SoftwareIDM.ReportingModule.Models.TransformField, SoftwareIDM.ReportingModule",
"Field": "Run Duration",
"Name": "",
"Operator": "None",
"TransformRule": ""
},
{
"$type": "SoftwareIDM.ReportingModule.Models.TransformField, SoftwareIDM.ReportingModule",
"Field": "Error Count",
"Name": "",
"Operator": "None",
"TransformRule": ""
},
{
"$type": "SoftwareIDM.ReportingModule.Models.TransformField, SoftwareIDM.ReportingModule",
"Field": "Step Count",
"Name": "",
"Operator": "None",
"TransformRule": ""
},
{
"$type": "SoftwareIDM.ReportingModule.Models.TransformField, SoftwareIDM.ReportingModule",
"Field": "Step Count",
"Name": "Max Count",
"Operator": "None",
"TransformRule": "If(CoerceTimeSpan(Data.Repeat Interval).TotalSeconds,\nDivide(CoerceTimeSpan(Memo(\"AvgTime\")).TotalSeconds, CoerceTimeSpan(Data.Repeat Interval).TotalSeconds), \"1\")"
},
{
"$type": "SoftwareIDM.ReportingModule.Models.TransformField, SoftwareIDM.ReportingModule",
"Field": "Repeat Interval",
"Name": "",
"Operator": "None",
"TransformRule": ""
}
]
}
],
"Styles": [],
"Sort": {
"Field": "Started",
"Direction": "Ascending"
}
},
{
"$type": "SoftwareIDM.ReportingModule.Models.Report, SoftwareIDM.ReportingModule",
"Id": "e6de1976-cc48-48b4-9da8-fc064802d9dc",
"Name": "Schedule Activity Base",
"UserId": "S-1-5-21-850135195-118180008-1618035785-1040440",
"UserProfile": false,
"Tags": null,
"Roles": null,
"CacheExpiration": "00:05:00",
"Description": "",
"Parameters": [
{
"$type": "SoftwareIDM.ReportingModule.Models.TextReportParameter, SoftwareIDM.ReportingModule",
"Name": "Time",
"Description": "",
"Required": true,
"Validation": "TimeSpan",
"DefaultValue": "01:00:00"
},
{
"$type": "SoftwareIDM.ReportingModule.Models.TextReportParameter, SoftwareIDM.ReportingModule",
"Name": "Environment",
"Description": "Filter based on schedule name",
"Required": true,
"Validation": "",
"DefaultValue": "*"
}
],
"DataSets": [
{
"$type": "SoftwareIDM.ReportingModule.Models.QueryData, SoftwareIDM.ReportingModule",
"Clauses": [
{
"$type": "SoftwareIDM.PanelModel.Models.FilterClause, SoftwareIDM.PanelModel",
"Field": "StartDate",
"Operation": "Gte",
"Value": "AddTime(Now(), \"-\" + Memo(\"Time\"))"
}
],
"SubQueries": [],
"MapRule": "Filter(\n Steps,\n Or(\n Not(Started), \n And(Started, AddTime(Started, Duration) >= AddTime(Now(), \"-\" + Memo(\"Time\")))\n )\n)",
"MemoRules": [
{
"$type": "SoftwareIDM.ReportingModule.Models.MemoRule, SoftwareIDM.ReportingModule",
"Name": "Schedule",
"Rule": "Child.HistoryId"
}
],
"Aliases": null,
"Name": "Schedule",
"Type": "SoftwareIDM.PanelModel.Models.ScheduleRecord, SoftwareIDM.PanelModel"
},
{
"$type": "SoftwareIDM.ReportingModule.Models.QueryData, SoftwareIDM.ReportingModule",
"Clauses": [
{
"$type": "SoftwareIDM.PanelModel.Models.FilterClause, SoftwareIDM.PanelModel",
"Field": "Id",
"Operation": "In",
"Value": "Memo(\"Schedule\")"
}
],
"SubQueries": [],
"MapRule": "",
"MemoRules": [],
"Aliases": null,
"Name": "History",
"Type": "SoftwareIDM.PanelModel.Models.HistoryRecord, SoftwareIDM.PanelModel"
},
{
"$type": "SoftwareIDM.ReportingModule.Models.QueryData, SoftwareIDM.ReportingModule",
"Clauses": [],
"SubQueries": [],
"MapRule": "",
"MemoRules": [],
"Aliases": null,
"Name": "Steps",
"Type": "SoftwareIDM.PanelModel.Models.StepInstance, SoftwareIDM.PanelModel"
}
],
"ReportSets": [],
"Relations": [
{
"$type": "SoftwareIDM.ReportingModule.Models.Relation, SoftwareIDM.ReportingModule",
"Name": "Schedule - History",
"LeftSet": "Schedule",
"RightSet": "History",
"LeftRule": "Child.HistoryId",
"RightRule": "Id",
"AllowLeftOuter": false,
"AllowRightOuter": true
},
{
"$type": "SoftwareIDM.ReportingModule.Models.Relation, SoftwareIDM.ReportingModule",
"Name": "Schedule - Step",
"LeftSet": "Schedule",
"RightSet": "Steps",
"LeftRule": "Child.Id",
"RightRule": "Id",
"AllowLeftOuter": false,
"AllowRightOuter": true
}
],
"FieldProjections": [
{
"$type": "SoftwareIDM.ReportingModule.Models.Projection, SoftwareIDM.ReportingModule",
"Name": "Schedule Name",
"RelationName": "Schedule - History",
"RelationSide": "Left",
"ValueRule": "Parent.Argument"
},
{
"$type": "SoftwareIDM.ReportingModule.Models.Projection, SoftwareIDM.ReportingModule",
"Name": "Step Name",
"RelationName": "Schedule - History",
"RelationSide": "Left",
"ValueRule": "If(Not(Child.Duration), Child.Name + \" - Executing\", Child.Name)"
},
{
"$type": "SoftwareIDM.ReportingModule.Models.Projection, SoftwareIDM.ReportingModule",
"Name": "Started",
"RelationName": "Schedule - History",
"RelationSide": "Left",
"ValueRule": "Child.Started"
},
{
"$type": "SoftwareIDM.ReportingModule.Models.Projection, SoftwareIDM.ReportingModule",
"Name": "Step Duration",
"RelationName": "Schedule - History",
"RelationSide": "Left",
"ValueRule": "Child.Duration"
},
{
"$type": "SoftwareIDM.ReportingModule.Models.Projection, SoftwareIDM.ReportingModule",
"Name": "Status",
"RelationName": "Schedule - History",
"RelationSide": "Left",
"ValueRule": "CoerceString(Child.Result)"
},
{
"$type": "SoftwareIDM.ReportingModule.Models.Projection, SoftwareIDM.ReportingModule",
"Name": "Run Result",
"RelationName": "Schedule - History",
"RelationSide": "Right",
"ValueRule": "Result"
},
{
"$type": "SoftwareIDM.ReportingModule.Models.Projection, SoftwareIDM.ReportingModule",
"Name": "Error Count",
"RelationName": "Schedule - History",
"RelationSide": "Right",
"ValueRule": "Sum(\n Counters.special.History Counter.Sync Error,\n Counters.special.History Counter.Discovery Error,\n Counters.special.History Counter.Export Error,\n Counters.special.History Counter.Export Failure,\n Counters.special.History Counter.Retry Error\n)"
},
{
"$type": "SoftwareIDM.ReportingModule.Models.Projection, SoftwareIDM.ReportingModule",
"Name": "Run Duration",
"RelationName": "Schedule - History",
"RelationSide": "Right",
"ValueRule": "SubtractDate(EndDate, StartDate)"
},
{
"$type": "SoftwareIDM.ReportingModule.Models.Projection, SoftwareIDM.ReportingModule",
"Name": "InProcess",
"RelationName": "Schedule - Step",
"RelationSide": "Right",
"ValueRule": "InProcess"
},
{
"$type": "SoftwareIDM.ReportingModule.Models.Projection, SoftwareIDM.ReportingModule",
"Name": "StartedInstance",
"RelationName": "Schedule - Step",
"RelationSide": "Right",
"ValueRule": "Started"
}
],
"Transformations": [
{
"$type": "SoftwareIDM.ReportingModule.Models.Transform, SoftwareIDM.ReportingModule",
"FilterRule": "Or(Memo(\"Environment\") == \"*\", Contains(Data.Schedule Name, Memo(\"Environment\")))",
"GroupingRule": "",
"TransformRules": []
},
{
"$type": "SoftwareIDM.ReportingModule.Models.Transform, SoftwareIDM.ReportingModule",
"FilterRule": "Or(\"NotStarted\" != Data.Status, Data.InProcess)",
"GroupingRule": "",
"TransformRules": []
}
],
"Styles": [],
"Sort": {
"Field": "Started",
"Direction": "Ascending"
}
}
],
"Count": 3
}
Comments
0 comments
Please sign in to leave a comment.