Get data according to date filter in sqlServer 2008:

/****** Script for SelectTopNRows command from SSMS  ******/

SELECT [Log_JobNoPMS],[Log_PMJobStatus] ,[Log_PMUser]

  FROM [PMTABS_SS].[dbo].[JobStatusLog]

  where

-- month(Log_Time)=10 and year(log_time)=2015

   (Log_time between  '2015-10-01 00:01:00' and  '2015-10-31 21:11:00')

  --log_jobnopms='HU_151026-15_F1'

  Group by [Log_JobNoPMS],[Log_PMJobStatus] ,[Log_PMUser]

  order by log_jobnopms