Sql String that shows for the month of January 2008
SELECT LD_TASK.TASK_NAME, LD_TASK.NEXT_START, ConsoleUser.UserName, LD_TASK.TASK_STATUS, LD_TASK.LD_TASK_IDN
FROM LD_TASK (nolock) INNER JOIN ConsoleUser (nolock) ON LD_TASK.CONSOLEUSER_IDN = ConsoleUser.ConsoleUser_Idn
WHERE Next_Start < '1/1/2008' and Next_Start > '1/31/2008' Order by Next_Start DESC
Thanks for your reply. I ran that query and I"m getting 0 rows back. I am using landesk 8.7 SP3.
First let me preface this post by saying that my SQL skills SUCK bad. Here is what I've been using:
DECLARE @start datetime,@finish datetime SET @start = '2007-12-01 12:29:00' SET @finish = '2007-12-31 12:29:00' SELECT LD_TASK.TASK_NAME, LD_TASK_MACHINE.STATUS_TIME, LD_TASK_MACHINE.MAC_RETCODE FROM LD_TASK LD_TASK, LD_TASK_MACHINE LD_TASK_MACHINE WHERE LD_TASK_MACHINE.LD_TASK_IDN = LD_TASK.LD_TASK_IDN AND LD_TASK_MACHINE.MAC_RETCODE <> 1110 AND LD_TASK_MACHINE.MAC_RETCODE <> 1101 AND LD_TASK_MACHINE.MAC_RETCODE <> 1001 AND((LD_TASK_MACHINE.STATUS_TIME Is Not Null And LD_TASK_MACHINE.STATUS_TIME>= @start And LD_TASK_MACHINE.STATUS_TIME<= @finish)) ORDER BY LD_TASK.TASK_NAME
Thanks alot .
That worked perfectly.
I was pretty shocked we had around 9000 tasks that ran in febraury alone.
Anyways, Thanks to both of you for all your help.
I am not a SQL person but I would like to know the steps in order to run this report. Is this run in the slq enterprise manager or in landesk. I am not sure where this is to be typed in.
Run this in SQL Query Manager