Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Gurus,
I would like build a Power Bi dashboard to display windows schedular details. Want to display schedular data such as Scheduled task name, who has scheduled it, when it will be run next time, what is a batch file or executable being used in scheudled task etc.
I tried Windows Powershell script to get details in .csv file which can be used as a source for my dashboard. But Powershell allows only to get limited details of windows schedular.
Does Power Bi has a support to get access windows schedular data? or if there are other ways to get this details, please share your ideas.
Any help would be really appreciated.
Best regards,
Anbu
HI @Anonymous
Power Bi doesn't support to get access windows schedular data.
Hope it resolves your issue? Did I answer your question? Mark my post as a solution! Appreciate your Kudos, Press the thumbs up button!! Linkedin Profile |
@Anonymous , refer if this can help
https://www.windowscentral.com/how-export-and-import-scheduled-tasks-windows-10
@Anonymous Maybe:
schtasks /query /S SERVERNAME /FO CSV /V > exportedjobs.csv
You can not use /S SERVERNAME for the local computer.
You get these fields:
HostName TaskName Next Run Time Status Logon Mode Last Run Time Last Result Author Task To Run Start In Comment Scheduled Task State Idle Time Power Management Run As User Delete Task If Not Rescheduled Stop Task If Runs X Hours and X Mins Schedule Schedule Type Start Time Start Date End Date Days Months Repeat: Every Repeat: Until: Time Repeat: Until: Duration Repeat: Stop If Still Running
Thanks Greg.
It's helped me a lot.
best regards,
Anbu
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |