Skip to content

Implement additional tool to support exceptions and continuous improvements #2

@SlavaChristin

Description

@SlavaChristin

+Config parameter: FileName (UNC)
+Config parameter: email

  1. Check if file exists
    1.a If file exists - save a copy with datename
    1.b if file doesn't exists and parameter is not empty - create file as a output result
  2. Excel will have extra columns (Status + Notes) in the end
  3. Load "saved data" from excel with status and notes
  4. Run best practices and merge results with excel based on the key: Server, Check ID, Object Type, Object Name
  5. Status
    when records is not found in "Excel" set status to "New"
    when records is not found in "BP" set value in "Status" columns to "AutoClosed" if status<>"Closed"
    update excel fields when records found in both "Excel" and "BP" (e.g. value of metric changed)
  6. Save new excel file
  7. Calculate "score" as a number of open issues (Status <> "Ignore", "AutoClosed", "Closed")
  8. Calculate "diff" from previous "score"
  9. Send email with "Score" with a link to file (UNC)

Metadata

Metadata

Assignees

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions