Hi Prasad,

Below is an SQL query that updates the scan status in the database. First, of course, it's best to perform a select * from the pmm.PmmSMSession table, where the status is 1.

UPDATE pmm.PmmSMSession SET status = 2 WHERE startdate BETWEEN '2024-12-22 00:01' AND '2025-02-24 23:55' AND status = 1

Hi Jack,

With select * from the pmm.PmmSMSession I am not able to find that problematic scan job, though it's still showing up on UI that its running.

Thanks,

Prasad

Hi Prasad,

Sorry, I forgot to add that you need to search for sessions with status 1 (pending scan job) and then change this status to 2 so that the job is not visible in the web console. Below you have the correct select, which should show you only active jobs.

select * from pmm.PmmSMSession where status = 1;

Jack, I would open up a support ticket, messing in the database can have unforeseen consequences and BT will not help you sort those out. I have been having the same issues for years and BT support is aware of them. 

Hey Frank and Jack,

I was able to resolve this issue with help of BeyondTrust Engineer. As Frank mentioned in previous reply, I raised support ticket, and they helped me with all troubleshooting and then DB query execution.

Thanks for replies.

Regards,

Prasad