Export Win Tasks List to CSV

If you want to check all of Windows Task Schedulers at a glance, you can do this by using schtasks.exe which is a Windows default system program in C:\Windows\System32\.

C:\> schtasks.exe /Query /FO CSV /V > %COMPUTERNAME%_%DATE%_schtasks.csv

Once you set /FO option as CSV format, you can read this result by Excel. And you can see the title of each column if you use a /NH option.  Here is a sample about the columns.

1. TaskName
2. Next Run Time
3. Status
4. Logon Mode
5. Last Run Time
6. Last Result
7. Author
8. Task To Run
9. Start In
10. Comment
11. Scheduled Task State
12. Idle Time
13. Power Management
14. Run As User
15. Delete Task If Not Rescheduled
16. Stop Task If Runs X Hours and X Mins
17. Schedule
18. Schedule Type
19. Start Time
20. Start Date
21. End Date
22. Days
23. Months
24. Repeat: Every
25. Repeat: Until: Time
26. Repeat: Until: Duration
27. Repeat: Stop If Still Running

Especially, I focus two columns, “3. Status” and “14. Run As User” in terms of incident response.