How Can I Determine Whether Resources Exist in the Recycle Bin of ServiceCenter

【Product�?
ManageOne ServiceCenter

【Version�?
3.0.5, 3.0.7, 3.0.8, and 3.0.9

【Question�?
How can I determine whether resources exist in the recycle bin of ServiceCenter?

【Answer�?
If there are a large number of VDCs on ServiceCenter, you cannot determine whether resources in each VDC exist in the recycle bin. You can run the database query command to check whether resources exist in the recycle bin.

Step 1 Log in to the ServiceCenter active node as user galaxmanager.

Step 2 Run the following command to enter the engineering mode:
gotoEngineerMode

Step 3 Run the following command to check whether the resources exist in the recycle bin:
su -l dbadmin -c "gsql -W Manager@123 -c \"select * from ssp.tbl_recover_resource;\""
Check the command output. If the command output contains 0 records, no resource is in the recycle bin.

----End

Scroll to top