The intent of this project is to Search, Select and Purge Report Processes along with their associated references.
The Project is built on ServiceDesk 7.5 SP1 and is dependent on the associated Database Schema.
The Project includes a method for discerning the ProcessManager ConnectionString. If this fails, you can define the ConnectionString in the Project Properties.
The following is a description of the Project features:
The 'Search ReportProcess' feature uses plain text pattern matching against the ReportProcessID, ProcessTitle and ProcessDescription data.
Found ReportProcesses will display in the 'Purge Candidates' section of the Form.
If the 'Description' scope is included with the Search, the text used for the search will be prepended to the ProcessTitle and enclosed with '{...}'.
This provides feedback that the search text was found in the ProcessDescription.
The 'Select Range by Type' feature uses a 'Start:' and 'End:' item from a pull-down list.
This will perform a range type of search with the following conditions:
1) The ReportProcess Type is the same. For example: IM-
2) A 'Start:' and an 'End:' are selected.
The 'Cut Off DateTime' feature selects any ReportProcess with a ProcessStarted date that is less than the defined DateTime.
The 'Keep Articles' switch allows for the retention of Knowledge Base articles.
Knowledge Base articles that are created using the 'Submit Knowledge Base Entry' form are ReportProcesses and will be purged if they are selected.
However, if the Knowledge Base process is Closed and the 'Keep Articles' option is checked, the KB Article will remain untouched in the Knowledge Base tab.
Begin the Purge...
Once confirmed, the Purge begins and will eventually end with a Count summary of the purged items.
One can 'Go Back', which starts over with a fresh copy of the remaining ReportProcesses.
———————–
PERFORMANCE
———————–
In an under performing test environment, one can expect approximately 1,000 items purged every 10 minutes.
The Progress Bar (SD_Purge_Utility_75SP1_pbar.package) version is significantly slower.
This is due to the granularity (1 second) of the 'Auto Exit Page On Timer' component.
———
FIXES ( Posted: Monday, April 25, 2016 )
———
- Selecting a single item in the Search List moves all of the items to the Purge List.
- Duplicate items occur in the Search List when the same item is removed from the Purge List.
- The project bombs when used in an environment without Change Management.
- The project bombs when used in an environment without Incident Management.
- The project exits unexpectedly when the database is SQL Server 2005.
- Rebuilt the SQL_Purge_Utilities Integration Components. (The SD_Purge_Utility_75SP1_pbar.package Workflow contained broken SQL)
- When this project is used with large data sets (1,000+), disable the 'Get_All_ReportProcessIDs' component and create (1) mapped value. This prevents the 'Select Range by Type' list from crashing the form.
For example:
---------------------------
ENHANCEMENTS ( Posted: Sun, Jan 17, 2016 )
---------------------------
- Added a Progress Bar for Purged Items. (SD_Purge_Utility_75SP1_pbar.package)
The graphical element (Include HTML) is hidden behind the 'Undo All' button.
NOTE: Page flicker on Progress Bar updates seems to be unavoidable.
- Added SQL_Purge_Utilities Integration package.
- Added source SQL and Purge validation scripts.