Windows schedular data in power bi

[Anonymous]

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

[Anonymous]

HI @Anonymous 

Power Bi doesn't support to get access windows schedular data.

[amitchandak]

@Anonymous , refer if this can help

https://www.windowscentral.com/how-export-and-import-scheduled-tasks-windows-10

[Greg_Deckler]

@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

[Anonymous]

Thanks Greg. 

It's helped me a lot.

best regards,

Anbu