Windows 2003 export scheduled task names

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

when looking at the scheduled task window, is it possible to export this
information to an excel spreadsheet? i don't need the task per say, just the
name and the scheduled times.
--
Mike
 
schtasks /query /FO CSV /V >output.csv

should do the trick

--
Cordialement,
Mathieu CHATEAU
http://lordoftheping.blogspot.com


"Mike" <Mike@discussions.microsoft.com> wrote in message
news:00A82092-9526-43E3-825C-C3D2A2E296D4@microsoft.com...
> when looking at the scheduled task window, is it possible to export this
> information to an excel spreadsheet? i don't need the task per say, just
> the
> name and the scheduled times.
> --
> Mike
 
"Mike" <Mike@discussions.microsoft.com> wrote in message
news:00A82092-9526-43E3-825C-C3D2A2E296D4@microsoft.com...
> when looking at the scheduled task window, is it possible to export this
> information to an excel spreadsheet? i don't need the task per say, just
> the
> name and the scheduled times.
> --
> Mike

Open a Command Prompt, then run this command:

schtasks > c:\Tasks.xls{Enter}
 
This is not a great way... Excel will complaint that it's not a real XLS and
he won't get the scheduled time.

The "clean" way is:
schtasks /query /FO CSV /V >output.csv

then open excel, import the csv and set "," as a separator


--
Cordialement,
Mathieu CHATEAU
http://lordoftheping.blogspot.com


"Pegasus (MVP)" <I.can@fly.com> wrote in message
news:%23c$3YWT2HHA.4584@TK2MSFTNGP03.phx.gbl...
>
> "Mike" <Mike@discussions.microsoft.com> wrote in message
> news:00A82092-9526-43E3-825C-C3D2A2E296D4@microsoft.com...
>> when looking at the scheduled task window, is it possible to export this
>> information to an excel spreadsheet? i don't need the task per say, just
>> the
>> name and the scheduled times.
>> --
>> Mike
>
> Open a Command Prompt, then run this command:
>
> schtasks > c:\Tasks.xls{Enter}
>
 
Agreed: the CSV option is much better. On the other
hand he would get the scheduled time with either of these:

schtasks
schtasks /query


"Mathieu CHATEAU" <gollum123@free.fr> wrote in message
news:%23rVnacT2HHA.4584@TK2MSFTNGP03.phx.gbl...
> This is not a great way... Excel will complaint that it's not a real XLS
> and he won't get the scheduled time.
>
> The "clean" way is:
> schtasks /query /FO CSV /V >output.csv
>
> then open excel, import the csv and set "," as a separator
>
>
> --
> Cordialement,
> Mathieu CHATEAU
> http://lordoftheping.blogspot.com
>
>
> "Pegasus (MVP)" <I.can@fly.com> wrote in message
> news:%23c$3YWT2HHA.4584@TK2MSFTNGP03.phx.gbl...
>>
>> "Mike" <Mike@discussions.microsoft.com> wrote in message
>> news:00A82092-9526-43E3-825C-C3D2A2E296D4@microsoft.com...
>>> when looking at the scheduled task window, is it possible to export this
>>> information to an excel spreadsheet? i don't need the task per say,
>>> just the
>>> name and the scheduled times.
>>> --
>>> Mike
>>
>> Open a Command Prompt, then run this command:
>>
>> schtasks > c:\Tasks.xls{Enter}
>>
>
 
schtasks /query /FO CSV /V >output.csv
worked like a charm. brought everything in regarding the tasks, scheduled
times, next run time, etc. Thank you very much.
--
Mike


"Pegasus (MVP)" wrote:

> Agreed: the CSV option is much better. On the other
> hand he would get the scheduled time with either of these:
>
> schtasks
> schtasks /query
>
>
> "Mathieu CHATEAU" <gollum123@free.fr> wrote in message
> news:%23rVnacT2HHA.4584@TK2MSFTNGP03.phx.gbl...
> > This is not a great way... Excel will complaint that it's not a real XLS
> > and he won't get the scheduled time.
> >
> > The "clean" way is:
> > schtasks /query /FO CSV /V >output.csv
> >
> > then open excel, import the csv and set "," as a separator
> >
> >
> > --
> > Cordialement,
> > Mathieu CHATEAU
> > http://lordoftheping.blogspot.com
> >
> >
> > "Pegasus (MVP)" <I.can@fly.com> wrote in message
> > news:%23c$3YWT2HHA.4584@TK2MSFTNGP03.phx.gbl...
> >>
> >> "Mike" <Mike@discussions.microsoft.com> wrote in message
> >> news:00A82092-9526-43E3-825C-C3D2A2E296D4@microsoft.com...
> >>> when looking at the scheduled task window, is it possible to export this
> >>> information to an excel spreadsheet? i don't need the task per say,
> >>> just the
> >>> name and the scheduled times.
> >>> --
> >>> Mike
> >>
> >> Open a Command Prompt, then run this command:
> >>
> >> schtasks > c:\Tasks.xls{Enter}
> >>
> >
>
>
>
 
Back
Top