Guest Mike Posted August 7, 2007 Posted August 7, 2007 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
Guest Mathieu CHATEAU Posted August 7, 2007 Posted August 7, 2007 Re: export scheduled task names 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
Guest Pegasus \(MVP\) Posted August 7, 2007 Posted August 7, 2007 Re: export scheduled task names "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}
Guest Mathieu CHATEAU Posted August 7, 2007 Posted August 7, 2007 Re: export scheduled task names 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} >
Guest Pegasus \(MVP\) Posted August 7, 2007 Posted August 7, 2007 Re: export scheduled task names 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} >> >
Guest Mike Posted August 8, 2007 Posted August 8, 2007 Re: export scheduled task names 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} > >> > > > > >
Recommended Posts