Skip to main content

Hello All,

 

We have one discovery scan job running from long time. We are looking for option from background (possibly from DB query) to stop running scan job.

We tried to stop from UI but it seems it's still running.

Any help will be appreciated.

 

Thanks,

Prasad

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

 


Reply