How to remove the ServiceDeskPlus details in OpManager?

How to remove the ServiceDeskPlus details in OpManager?

ISSUE: To remove the ServiceDeskPlus details in the Add-On settings page and from the device snapshot page.
SOLUTION:
We need to delete entries in the three tables in the database.
1. Connect to the database using this command,
C:\\..\\OpManager\\mysql\\bin>mysql -u root -P 13306 OpManagerDB
Please Note: If some other parameter is deleted, OpManager will not work properly. Delete the entries in database after checking it carefully.
2. Execute the following commands to delete the database entries,
a. select * from feed_login_params;
get the LOGIN_ID from the above command output in the 2nd row. It will look like this,
LOGIN_ID: 1087719270
PRODUCT_NAME: ServiceDeskPlus
b. delete from feed_login_params where LOGIN_ID=<the id from the above query>;
c. select * from feed_url;
get the FEED_ID from the above command output in the 2nd row. It will look like this,
FEED_ID: 411118580
d. delete from feed_url where FEED_ID=<the id from the above query>;
e. select * from servicedesk_config;
f. delete from servicedesk_config where TO_EMAIL like "%<email id without the domain name>%";
After this restart OpManager.
          • Related Articles

          • Details of tables storing performance data in OpManager

            Details of tables: The performance data tables in OpManager 7 and above are quite distributed, enabling better reporting. Here is a quick summary of the tables that you will need to take custom reports 1. ElementsAvailabilityHourly - Every day device ...
          • Remove or Hide tabs in OpManager (version 11.0)

            Question :  How do I remove/hide tabs from OpManager? Solution : OpManager has a built-in feature to customize tabs where you can hide  unwanted tabs,  to  hide any tab , click on admin option on the top right corner >  Edit tab > click on the ...
          • Vulnerabilities in OpManager 12.0

            VULNERABILITY DETAILS(found in build 12000) Vulnerability 1: Unrestricted File Upload:  OpManager fails to validate or improperly validates files before uploading to the system. As a result an attacker might be able to upload arbitrary JSP file and ...
          • How to uninstall and reinstall OpManager Service?

            1)Stop OpManager service 2)Go to OpManager  command prompt with Run as administrator Option 3)Change directory to OpManager/bin  and execute " opmanagerservice.bat -r "    Ex: C:\ManageEngine\OpManager\bin>OpManagerService.bat -r    (The above ...
          • Pre-Requisites For OpManager Implementation

            Here are some of the pre-requisites for OpManager implementation : ​ 1. Server (Physical\Virtual) to install OpManager application (One server for a standalone and multiple servers for Enterprise edition) according to the hardware requirement below, ...