Page Comparison

...

select ipar.IPAddressRangeId, ipar.Name, ipart.Name as TargetSetType, 
       StartIPAddress, EndIPAddress, 
       jobs.convertBinaryToIP(aip.Start) as ActiveIPRangesStart,
	   jobs.convertBinaryToIP(aip.Finish) as ActiveIPRangesFinish,
       aip.LocationID,
       ProjectID,
       case jobs.convertBinaryToIP(aip.Finish) when EndIPAddress then 'Fully Expanded'
                                               else 'In Progress'
       end as [State]
 from [jobs].[t_ActiveIPRanges] aip with (nolock)
inner join config.t_IPAddressRange ipar with (nolock) on aip.IPAddressRangeID = ipar.IPAddressRangeID
inner join config.t_IPAddressRangeType ipart with (nolock) on iparipart.IPAddressRangeTypeID = ipar.IPAddressRangeTypeID 

...

Are there Jobs Queued?

Run the Job Stats script  script here.

• Does the Queue By State query show queued items?
• Does the Queue By State and Project show that there are items queued for projects which are running?

...

• What states are the queued items in - do they indicate what's happening? (e.g. project not started, exclusion scan window in effect).
• Review the jobs.QueueStep2_SetJobStatus code to determine why jobs aren't reaching a state of Queued.

If yes - but the rate of job throughput is slow...

• Run the Queued Job Analysis script here.
• This will record how many jobs are being added and removed from the queue.
• Do the scan engine servers have free capacity?
• Can the queued items only be picked up by a server which is currently maxed out.

Is the job serving proc running...

...