:::Patch Name:::
SAPP_5006-1

:::Patch Description:::
5.x Point Patch (SAPP_5006-1)

:::Patch Type:::
Point

:::Release Date:::
20210908

:::Checksum:::
829b5b6b131a31d2d614644f5f01ece9 (MD5)

:::Defect Records:::
DREC17499 DREC17485 DREC17435 DREC17612 DREC17564 DREC17763 DREC17793 DREC17804
DREC17828 DREC17829 DREC17843 DREC17851 DREC17852 DREC17905 DREC17914 DREC17425
DREC17916 DREC16353 DREC16906 DREC17613 DREC17074 DREC17650 DREC17920 DREC17506
DREC17410 DREC17583 DREC17875

:::Database Records:::
DREC17905 DREC17905 DREC17828 DREC17828 DREC17499#7 DREC17499#7 DREC17506#1
DREC17506#1 DREC17435#1 DREC17435#1 DREC16353 DREC16353 DREC16906 DREC16906
DREC17410 DREC17410 DREC17425#1 DREC17425#1

:::Patch Notes:::
DREC17499:
Defect Fixed

DREC17485:
Advance report Multi tenant upgrade issue resolved

DREC17435:
Asset Import Issues related to link with inventory is mandatory and Asset
import is not throwing bad record when asset number generation is disabled and
asset number is empty handled

DREC17612:
Following issues are handled
1)  If interface instance name has double slash and double quotes then
performance chart are not displaying
2) Search option in the product health is not working

DREC17564:
Broken CMDB issues has been fixed 

DREC17763:
User import not happening if user's contains special characters using Cloud
Connector Plugin issue resolved 

DREC17793:
Map View Performance 

DREC17804:
Defect Fixed

DREC17828:
Physical memory - bank label, Manufacturer, Speed, Model inventory view issue
is resolved

DREC17829:
When SapphireIMS setup with more than 1000 agents runs continuously for more
number of days, it is causing performance degrade with high CPU utilization.
This scenario is handled.

DREC17843:
System Performance Enable/Disable configuration is not working properly because
of the improper order in the SQL query. It is observed in MySQL 8.0. This issue
fixed.

DREC17851:
Mobile App security details not configured alert message not displayed when
user is not updated security questions issue resolved  

DREC17852:
Excel User import issue resolved

DREC17905:
Blank page issue in the Product Health Page is handled.

DREC17914:
An issue in rejecting a ticket under multi-approval state has been handled.

DREC17425:
Issues found in Software Metering, Patch Management, Automation Task, File
Inventory,  Agent Upgrade features are handled.

DREC17916:
An issue in email based state change has been fixed.

DREC16353:
USB Whitelisting feature is not working when the profile is configured with All
Hosts. This scenario is handled.

DREC16906:
USB Whitelisting cosmetic changes taken care

DREC17613:
Agent consumer exception is resolved when agent is pushing the data collection
type as 0

DREC17074:
Log Analyzer 

DREC17650:
Duplicate data upload from agent to server is resolved

DREC17920:
Resolved

DREC17506:
AD User authentication and OU listing issue resolved

DREC17410:
Data archival issue is resolved

DREC17583:
Resolved

DREC17875:
RPA Event not getting trigger from Mobile app

:::Patch Notes from Previous Patches:::

:::Dependent Patches:::
SAPP_5006

:::Superseding Patches:::
None

:::Patch Files:::
ConsoleManagement/Database/GetBSMRoleBasedSystems.sql
ConsoleManagement/Database/GetConfigIDforSystem.sql
ConsoleManagement/Database/GetITRuleBasedSystemIDs.sql
ConsoleManagement/Database/OUandMasterAgentMapper.sql
ConsoleManagement/Database/PopulateAssetBadRecords.sql
ConsoleManagement/Database/PopulateAssetBadRecords_NewUI.sql
ConsoleManagement/Database/Populate_software_meter_frequency.sql
ConsoleManagement/Database/ReportTables.sql
ConsoleManagement/Database/Rolebasedsystemsaddition.sql
ConsoleManagement/Database/Sapphire_self_health_monitoring.sql
ConsoleManagement/Database/ServiceDesk.sql
ConsoleManagement/Database/Submitpatchdeployjobs.sql
ConsoleManagement/Database/ims.sql
ConsoleManagement/Database/postsoftwaredeploymentjob.sql
ConsoleManagement/Database/runserver.bat
ConsoleManagement/ExternalWar/SoftwareRepository.war/!CUSTOMERNAME!/SapphireIMSAgent-5.0-Setup.exe
ConsoleManagement/ExternalWar/SoftwareRepository.war/!CUSTOMERNAME!/SapphireIMSAgent.zip
ConsoleManagement/ExternalWar/SoftwareRepository.war/SapphireIMSAgent-5.0-Setup.exe
ConsoleManagement/ExternalWar/SoftwareRepository.war/SapphireIMSAgent.zip
ConsoleManagement/SapphireIMS_Script/sapphire_cksum.txt
ConsoleManagement/SapphireIMS_Script/sapphire_scripts.tar.gz
ConsoleManagement/bin/DBI.dll
ConsoleManagement/bin/GenericPoller.dll
ConsoleManagement/bin/HttpPost.dll
ConsoleManagement/bin/IntelAMT.dll
ConsoleManagement/bin/NodeDiscover.dll
ConsoleManagement/bin/SIMS_AssetImport.exe
ConsoleManagement/bin/SIMS_BSMPoller.exe
ConsoleManagement/bin/SIMS_ConfResync.exe
ConsoleManagement/bin/SIMS_EncryptUtil.dll
ConsoleManagement/bin/SIMS_GenericApps.exe
ConsoleManagement/bin/SIMS_JobHandler.exe
ConsoleManagement/bin/SIMS_LANDISCOVERY.exe
ConsoleManagement/bin/SIMS_LDAPAuth.dll
ConsoleManagement/bin/SIMS_LDAPClient.exe
ConsoleManagement/bin/SIMS_LDAPUserManagement.exe
ConsoleManagement/bin/SIMS_LogMon.exe
ConsoleManagement/bin/SIMS_LoginTest.exe
ConsoleManagement/bin/SIMS_NodeScanner.exe
ConsoleManagement/bin/SIMS_PatchMonLib.dll
ConsoleManagement/bin/SIMS_PollerManager.exe
ConsoleManagement/bin/SIMS_ProbeScheduler.exe
ConsoleManagement/bin/SIMS_RemoteLog.exe
ConsoleManagement/bin/SIMS_ReplDiag.exe
ConsoleManagement/bin/SIMS_Resync.exe
ConsoleManagement/bin/SIMS_SNMP.exe
ConsoleManagement/bin/SIMS_SNMPInterface.dll
ConsoleManagement/bin/SIMS_SSHCommandParser.dll
ConsoleManagement/bin/SIMS_SSHDataCollector.exe
ConsoleManagement/bin/SIMS_SSHInterface.dll
ConsoleManagement/bin/SIMS_SelfHealth.exe
ConsoleManagement/bin/SIMS_ServiceMon.exe
ConsoleManagement/bin/SIMS_ServiceStatusEmail.exe
ConsoleManagement/bin/SIMS_SiteReg.exe
ConsoleManagement/bin/SIMS_StorageCollector.exe
ConsoleManagement/bin/SIMS_Task.exe
ConsoleManagement/bin/SIMS_UserAuth.exe
ConsoleManagement/bin/SIMS_UserDump.exe
ConsoleManagement/bin/SIMS_WBEMCollect.exe
ConsoleManagement/bin/SIMS_WMICollect.exe
ConsoleManagement/bin/SIMS_XMPPInformer.exe
ConsoleManagement/bin/SIMS_XMPPInterface.dll
ConsoleManagement/bin/SapphireIMS.exe
ConsoleManagement/bin/TaskAgent.db
ConsoleManagement/bin/WBEMDataCollector.dll
ConsoleManagement/bin/WMIDataCollector.dll
ConsoleManagement/lib/VMachineMon.jar
ConsoleManagement/lib/agentWS-consumer-1.0-SNAPSHOT.jar
WebManagement/standalone/deployments/MobileApp.war/ModifyState.jsp
WebManagement/standalone/deployments/MobileApp.war/WEB-INF/classes/com/sapphire/AssetBarcode/Dao/AssetBarcodeDao.class
WebManagement/standalone/deployments/MobileApp.war/WEB-INF/classes/com/sapphire/SapphireConstatnts.class
WebManagement/standalone/deployments/MobileApp.war/WEB-INF/classes/com/sapphire/login/controller/LoginController.class
WebManagement/standalone/deployments/MobileApp.war/WEB-INF/classes/com/sapphire/login/dao/LoginDAO.class
WebManagement/standalone/deployments/MobileApp.war/WEB-INF/classes/com/sapphire/login/service/LoginService.class
WebManagement/standalone/deployments/MobileApp.war/WEB-INF/classes/com/sapphire/login/service/OTPService.class
WebManagement/standalone/deployments/MobileApp.war/WEB-INF/classes/com/sapphire/login/service/SMTPService.class
WebManagement/standalone/deployments/MobileApp.war/WEB-INF/classes/com/sapphire/modernAuthEmail/ModernAuthentication.class
WebManagement/standalone/deployments/MobileApp.war/WEB-INF/classes/com/sapphire/modernAuthEmail/ModernAuthenticationGoogle.class
WebManagement/standalone/deployments/MobileApp.war/WEB-INF/classes/com/sapphire/rest/jobprocessor/CloudConnectorOperation.class
WebManagement/standalone/deployments/MobileApp.war/WEB-INF/classes/com/sapphire/security/CustomAuthenticationProvider.class
WebManagement/standalone/deployments/MobileApp.war/WEB-INF/classes/com/sapphireims/itsm/eventlistener/rpamobile/service/impl/MobileTicketEventImpl$1.class
WebManagement/standalone/deployments/MobileApp.war/WEB-INF/classes/com/sapphireims/itsm/eventlistener/rpamobile/service/impl/MobileTicketEventImpl.class
WebManagement/standalone/deployments/MobileApp.war/WEB-INF/classes/sapphire/reports/Sapphire.class
WebManagement/standalone/deployments/SapphireIMS.war/AI_PackagesList.jsp
WebManagement/standalone/deployments/SapphireIMS.war/AddProfile_ExtJS.jsp
WebManagement/standalone/deployments/SapphireIMS.war/AgentListing.jsp
WebManagement/standalone/deployments/SapphireIMS.war/AgentTaskHealth.jsp
WebManagement/standalone/deployments/SapphireIMS.war/AgentTaskListing.jsp
WebManagement/standalone/deployments/SapphireIMS.war/Application_Discovery_List.jsp
WebManagement/standalone/deployments/SapphireIMS.war/AssetImport.jsp
WebManagement/standalone/deployments/SapphireIMS.war/DashBoardViewr.jsp
WebManagement/standalone/deployments/SapphireIMS.war/DashBoardViewr_IE.jsp
WebManagement/standalone/deployments/SapphireIMS.war/EXTJSIncludes-4.jsp
WebManagement/standalone/deployments/SapphireIMS.war/Edit_LdapConfig.jsp
WebManagement/standalone/deployments/SapphireIMS.war/ITComplianceListView.jsp
WebManagement/standalone/deployments/SapphireIMS.war/Ldap_Config.jsp
WebManagement/standalone/deployments/SapphireIMS.war/Manage_Unmana_Host.jsp
WebManagement/standalone/deployments/SapphireIMS.war/NotificationTemplate.jsp
WebManagement/standalone/deployments/SapphireIMS.war/OUAddMAgentMappingRule.jsp
WebManagement/standalone/deployments/SapphireIMS.war/OUMAgentMappingRule.jsp
WebManagement/standalone/deployments/SapphireIMS.war/PerformanceResourceManagement.jsp
WebManagement/standalone/deployments/SapphireIMS.war/PerformanceViewChart.jsp
WebManagement/standalone/deployments/SapphireIMS.war/ProfileList1.jsp
WebManagement/standalone/deployments/SapphireIMS.war/ResourceViewList.jsp
WebManagement/standalone/deployments/SapphireIMS.war/SWBlackList.jsp
WebManagement/standalone/deployments/SapphireIMS.war/Settings.jsp
WebManagement/standalone/deployments/SapphireIMS.war/SoftwareBlacklistPolicy.jsp
WebManagement/standalone/deployments/SapphireIMS.war/SoftwareComplianceListView.jsp
WebManagement/standalone/deployments/SapphireIMS.war/SoftwareComplianceSettingsListView.jsp
WebManagement/standalone/deployments/SapphireIMS.war/SoftwareGroupFileEdit.jsp
WebManagement/standalone/deployments/SapphireIMS.war/SoftwareMappingRules.jsp
WebManagement/standalone/deployments/SapphireIMS.war/SoftwareMeter.jsp
WebManagement/standalone/deployments/SapphireIMS.war/SoftwareMeterDetails.jsp
WebManagement/standalone/deployments/SapphireIMS.war/SoftwareMeterSummary.jsp
WebManagement/standalone/deployments/SapphireIMS.war/Software_Executable_Normalization.jsp
WebManagement/standalone/deployments/SapphireIMS.war/StandaloneAgentListing.jsp
WebManagement/standalone/deployments/SapphireIMS.war/SwitchView.jsp
WebManagement/standalone/deployments/SapphireIMS.war/USBListing.jsp
WebManagement/standalone/deployments/SapphireIMS.war/UnUsedSoftwares.jsp
WebManagement/standalone/deployments/SapphireIMS.war/VNCConfig.jsp
WebManagement/standalone/deployments/SapphireIMS.war/VNCSettings.jsp
WebManagement/standalone/deployments/SapphireIMS.war/ViewSoftwareListing.jsp
WebManagement/standalone/deployments/SapphireIMS.war/WEB-INF/classes/PatchManagement/PatchScanOperations.class
WebManagement/standalone/deployments/SapphireIMS.war/WEB-INF/classes/ajax/servlet/LdapConfig_TreeStructure.class
WebManagement/standalone/deployments/SapphireIMS.war/WEB-INF/classes/ajax/servlet/TaskDropdown.class
WebManagement/standalone/deployments/SapphireIMS.war/WEB-INF/classes/com/sapphire/bsm/capacity/controller/CPThresholdController.class
WebManagement/standalone/deployments/SapphireIMS.war/WEB-INF/classes/com/sapphire/bsm/capacity/controller/CapacityController.class
WebManagement/standalone/deployments/SapphireIMS.war/WEB-INF/classes/com/sapphire/bsm/controller/NotificationTemplateController.class
WebManagement/standalone/deployments/SapphireIMS.war/WEB-INF/classes/com/sapphire/bsm/dao/ProductHealthDAO.class
WebManagement/standalone/deployments/SapphireIMS.war/WEB-INF/classes/com/sapphire/itam/controller/PatchManagementController.class
WebManagement/standalone/deployments/SapphireIMS.war/WEB-INF/classes/com/sapphire/itam/service/AgentConfigurationService.class
WebManagement/standalone/deployments/SapphireIMS.war/WEB-INF/classes/com/sapphire/itam/service/ApplicationDiscoveryService.class
WebManagement/standalone/deployments/SapphireIMS.war/WEB-INF/classes/com/sapphire/itam/service/NodeRuleEngineServiceImpl.class
WebManagement/standalone/deployments/SapphireIMS.war/WEB-INF/classes/com/sapphire/itam/service/NormalizationService.class
WebManagement/standalone/deployments/SapphireIMS.war/WEB-INF/classes/com/sapphire/itam/service/PatchManagementServiceImpl.class
WebManagement/standalone/deployments/SapphireIMS.war/WEB-INF/classes/com/sapphire/itam/util/MasterAgentMappingUtil.class
WebManagement/standalone/deployments/SapphireIMS.war/WEB-INF/classes/com/sapphire/itam/util/PatchManagementUtil.class
WebManagement/standalone/deployments/SapphireIMS.war/WEB-INF/classes/com/sapphire/login/dao/LoginDAO.class
WebManagement/standalone/deployments/SapphireIMS.war/WEB-INF/classes/com/sapphire/login/service/LoginService.class
WebManagement/standalone/deployments/SapphireIMS.war/WEB-INF/classes/com/sapphire/rest/jobprocessor/CloudConnectorOperation.class
WebManagement/standalone/deployments/SapphireIMS.war/WEB-INF/classes/com/sapphire/security/CustomAuthenticationProvider.class
WebManagement/standalone/deployments/SapphireIMS.war/WEB-INF/classes/com/sapphire/tkd/dao/ExcelUserImportDAO.class
WebManagement/standalone/deployments/SapphireIMS.war/WEB-INF/classes/com/sapphire/tkd/dao/SapphireConstantsInterface.class
WebManagement/standalone/deployments/SapphireIMS.war/WEB-INF/classes/com/sapphire/tkd/model/OuTreeModel.class
WebManagement/standalone/deployments/SapphireIMS.war/WEB-INF/classes/com/sapphire/tkd/service/ExcelUserImportService.class
WebManagement/standalone/deployments/SapphireIMS.war/WEB-INF/classes/com/sapphire/tkd/service/LDAPOuListService.class
WebManagement/standalone/deployments/SapphireIMS.war/WEB-INF/classes/com/sapphire/tkd/service/SMTPService.class
WebManagement/standalone/deployments/SapphireIMS.war/WEB-INF/classes/com/sapphire/tkd/service/SapphireService.class
WebManagement/standalone/deployments/SapphireIMS.war/WEB-INF/classes/com/sapphire/tkd/service/UserManagementService.class
WebManagement/standalone/deployments/SapphireIMS.war/WEB-INF/classes/com/sapphireims/cmdb/service/AssetExcelImportOperationService.class
WebManagement/standalone/deployments/SapphireIMS.war/WEB-INF/classes/com/sapphireims/cmdb/service/AssetTemplateService.class
WebManagement/standalone/deployments/SapphireIMS.war/WEB-INF/classes/com/sapphireims/itsm/controller/TicketOperationsController.class
WebManagement/standalone/deployments/SapphireIMS.war/WEB-INF/classes/com/sapphireims/itsm/dao/TicketOperationsDao$1.class
WebManagement/standalone/deployments/SapphireIMS.war/WEB-INF/classes/com/sapphireims/itsm/dao/TicketOperationsDao.class
WebManagement/standalone/deployments/SapphireIMS.war/WEB-INF/classes/com/sapphireims/itsm/dao/TicketPersistOperationsDao.class
WebManagement/standalone/deployments/SapphireIMS.war/WEB-INF/classes/com/sapphireims/itsm/service/CalendarService.class
WebManagement/standalone/deployments/SapphireIMS.war/WEB-INF/classes/com/tecknodreams/emailtorequest/EMailToTicket$1.class
WebManagement/standalone/deployments/SapphireIMS.war/WEB-INF/classes/com/tecknodreams/emailtorequest/EMailToTicket.class
WebManagement/standalone/deployments/SapphireIMS.war/WEB-INF/classes/com/tecknodreams/emailtorequest/EMailToTicket_EWS$RedirectionUrlCallback.class
WebManagement/standalone/deployments/SapphireIMS.war/WEB-INF/classes/com/tecknodreams/emailtorequest/EMailToTicket_EWS.class
WebManagement/standalone/deployments/SapphireIMS.war/WEB-INF/classes/com/tecknodreams/emailtorequest/ModernAuthentication.class
WebManagement/standalone/deployments/SapphireIMS.war/WEB-INF/classes/com/tecknodreams/emailtorequest/ModernAuthenticationGoogle$OAuth2Provider.class
WebManagement/standalone/deployments/SapphireIMS.war/WEB-INF/classes/com/tecknodreams/emailtorequest/ModernAuthenticationGoogle.class
WebManagement/standalone/deployments/SapphireIMS.war/WEB-INF/classes/com/tecknodreams/emailtorequest/ModernAuthenticationIMAP.class
WebManagement/standalone/deployments/SapphireIMS.war/WEB-INF/classes/sapphire/performance/MapViewAction.class
WebManagement/standalone/deployments/SapphireIMS.war/WEB-INF/classes/sapphire/reports/AIPackageconfiguration.class
WebManagement/standalone/deployments/SapphireIMS.war/WEB-INF/classes/sapphire/reports/AgentMapping.class
WebManagement/standalone/deployments/SapphireIMS.war/WEB-INF/classes/sapphire/reports/AgentScheduler.class
WebManagement/standalone/deployments/SapphireIMS.war/WEB-INF/classes/sapphire/reports/GetJsonObject.class
WebManagement/standalone/deployments/SapphireIMS.war/WEB-INF/classes/sapphire/reports/GetSystemsJson.class
WebManagement/standalone/deployments/SapphireIMS.war/WEB-INF/classes/sapphire/reports/InventoryViewList.class
WebManagement/standalone/deployments/SapphireIMS.war/WEB-INF/classes/sapphire/reports/NodeOperations.class
WebManagement/standalone/deployments/SapphireIMS.war/WEB-INF/classes/sapphire/reports/PackageDownloader.class
WebManagement/standalone/deployments/SapphireIMS.war/WEB-INF/classes/sapphire/reports/ResourceViewList.class
WebManagement/standalone/deployments/SapphireIMS.war/WEB-INF/classes/sapphire/reports/SaveMailProfile.class
WebManagement/standalone/deployments/SapphireIMS.war/WEB-INF/classes/sapphire/reports/Save_Ticket.class
WebManagement/standalone/deployments/SapphireIMS.war/WEB-INF/classes/sapphire/reports/UpdateMail.class
WebManagement/standalone/deployments/SapphireIMS.war/WEB-INF/classes/sapphire/reports/VMInventoryView.class
WebManagement/standalone/deployments/SapphireIMS.war/WEB-INF/classes/sapphire/reports/validateAgentUploadFile.class
WebManagement/standalone/deployments/SapphireIMS.war/WEB-INF/classes/sapphire/softwaremanagement/ITAMDAO.class
WebManagement/standalone/deployments/SapphireIMS.war/WEB-INF/classes/sapphire/ui/ApplicationScope.class
WebManagement/standalone/deployments/SapphireIMS.war/WEB-INF/sapphireSecurity.xml
WebManagement/standalone/deployments/SapphireIMS.war/addMasterAgentMappingRule.jsp
WebManagement/standalone/deployments/SapphireIMS.war/addMasterAgentMappingRuleJS.jsp
WebManagement/standalone/deployments/SapphireIMS.war/agentDetails.jsp
WebManagement/standalone/deployments/SapphireIMS.war/agentInfo.jsp
WebManagement/standalone/deployments/SapphireIMS.war/assets/css/cmdbResponsive.min.css
WebManagement/standalone/deployments/SapphireIMS.war/assets/js/AssetList.min.js
WebManagement/standalone/deployments/SapphireIMS.war/assets/js/CMDBFilterOperations.min.js
WebManagement/standalone/deployments/SapphireIMS.war/assets/js/SdAllProjectSummary.min.js
WebManagement/standalone/deployments/SapphireIMS.war/changeHostName.jsp
WebManagement/standalone/deployments/SapphireIMS.war/conflictedSystems.jsp
WebManagement/standalone/deployments/SapphireIMS.war/displayMap.jsp
WebManagement/standalone/deployments/SapphireIMS.war/downloadOption.jsp
WebManagement/standalone/deployments/SapphireIMS.war/mapViewer/jsp/getTreeData.jsp
WebManagement/standalone/deployments/SapphireIMS.war/selfHealthPopup.jsp
WebManagement/standalone/deployments/SapphireIMS.war/toptable.jsp
WebManagement/standalone/deployments/SapphireReplication.war/WEB-INF/classes/sapphire/webservice/ExecuteJSONFile.class
WebManagement/standalone/deployments/SapphireWS.war/WEB-INF/classes/com/tkd/sims/Discovery/Discovery.class
WebManagement/standalone/deployments/SapphireWS.war/WEB-INF/classes/com/tkd/sims/Discovery/JobsMasterConstant.class
WebManagement/standalone/deployments/SapphireWS.war/WEB-INF/classes/com/tkd/sims/agent/genericagenttask/PopulateJobsWorkerThread.class
WebManagement/standalone/deployments/SapphireWS.war/WEB-INF/classes/com/tkd/sims/agent/jobprocessing/JobSchedularEngineWorkerThread$MasterAgentInfo.class
WebManagement/standalone/deployments/SapphireWS.war/WEB-INF/classes/com/tkd/sims/agent/jobprocessing/JobSchedularEngineWorkerThread.class
WebManagement/standalone/deployments/SapphireWS.war/WEB-INF/classes/com/tkd/sims/agent/utils/ConfigurationPullPopulation.class
WebManagement/standalone/deployments/SapphireWS.war/WEB-INF/classes/com/tkd/sims/rest/webservice/AgentInfoesResource.class