{"action":"created","issue":{"url":"https://api.github.com/repos/sqlcollaborative/dbatools/issues/3461","repository_url":"https://api.github.com/repos/sqlcollaborative/dbatools","labels_url":"https://api.github.com/repos/sqlcollaborative/dbatools/issues/3461/labels{/name}","comments_url":"https://api.github.com/repos/sqlcollaborative/dbatools/issues/3461/comments","events_url":"https://api.github.com/repos/sqlcollaborative/dbatools/issues/3461/events","html_url":"https://github.com/sqlcollaborative/dbatools/pull/3461","id":310693835,"number":3461,"title":"First version of Invoke-DbaAgentJobHistoryGantt","user":{"login":"MrBell67","id":37604986,"avatar_url":"https://avatars0.githubusercontent.com/u/37604986?v=4","gravatar_id":"","url":"https://api.github.com/users/MrBell67","html_url":"https://github.com/MrBell67","followers_url":"https://api.github.com/users/MrBell67/followers","following_url":"https://api.github.com/users/MrBell67/following{/other_user}","gists_url":"https://api.github.com/users/MrBell67/gists{/gist_id}","starred_url":"https://api.github.com/users/MrBell67/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/MrBell67/subscriptions","organizations_url":"https://api.github.com/users/MrBell67/orgs","repos_url":"https://api.github.com/users/MrBell67/repos","events_url":"https://api.github.com/users/MrBell67/events{/privacy}","received_events_url":"https://api.github.com/users/MrBell67/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":14,"created_at":"2018-04-03T04:54:14Z","updated_at":"2018-04-10T17:37:47Z","closed_at":null,"author_association":"NONE","pull_request":{"url":"https://api.github.com/repos/sqlcollaborative/dbatools/pulls/3461","html_url":"https://github.com/sqlcollaborative/dbatools/pull/3461","diff_url":"https://github.com/sqlcollaborative/dbatools/pull/3461.diff","patch_url":"https://github.com/sqlcollaborative/dbatools/pull/3461.patch"},"body":"<!-- Below information IS REQUIRED with every PR -->\r\n## Type of Change\r\n<!-- What type of change does your code introduce -->\r\n - [ ] Bug fix (non-breaking change, fixes #<enter issue number>)\r\n - [X] New feature (non-breaking change, adds functionality)\r\n - [ ] Breaking change (effects multiple commands or functionality)\r\n - [ ] Ran manual Pester test and has passed (`.\\tests\\manual.pester.ps1)\r\n - [ ] Adding code coverage to existing functionality\r\n - [ ] Pester test is included\r\n - [ ] Nunit test is included\r\n - [ ] Documentation\r\n - [ ] Build system\r\n \r\n<!-- Below this line you can erase anything that is not applicable -->\r\n### Purpose\r\nTo introduce new function 'Invoke-DbaAgentJobHistoryGantt'.\r\nIt reads SQL agent job history using the existing dbatools function 'Get-DbaAgentJobHistory', \r\nand then produces a graphical timeline.\r\nThe timeline is rendered, via a temporary .html file, invoking the free [google timeline visualization](https://developers.google.com/chart/interactive/docs/gallery/timeline) api.\r\n\r\nThe .html file is launched in a new window in your default browser.\r\n\r\n### Approach\r\nBy adding file Invoke-DbaAgentJobHistoryGantt.ps1\r\n\r\n### Commands to test\r\nExamples in the help.\r\nFor a quick run covering 6pm prior day to 6am current day:\r\nInvoke-DbaAgentJobHistoryGantt -SqlInstance 'myinstance'\r\n\r\n### Screenshots\r\nExample\r\n![2018-04-03_12h42_46](https://user-images.githubusercontent.com/37604986/38229747-b0c45960-373c-11e8-8286-765a7beaa797.png)\r\n\r\n\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/sqlcollaborative/dbatools/issues/comments/380185857","html_url":"https://github.com/sqlcollaborative/dbatools/pull/3461#issuecomment-380185857","issue_url":"https://api.github.com/repos/sqlcollaborative/dbatools/issues/3461","id":380185857,"user":{"login":"nvarscar","id":30303784,"avatar_url":"https://avatars3.githubusercontent.com/u/30303784?v=4","gravatar_id":"","url":"https://api.github.com/users/nvarscar","html_url":"https://github.com/nvarscar","followers_url":"https://api.github.com/users/nvarscar/followers","following_url":"https://api.github.com/users/nvarscar/following{/other_user}","gists_url":"https://api.github.com/users/nvarscar/gists{/gist_id}","starred_url":"https://api.github.com/users/nvarscar/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/nvarscar/subscriptions","organizations_url":"https://api.github.com/users/nvarscar/orgs","repos_url":"https://api.github.com/users/nvarscar/repos","events_url":"https://api.github.com/users/nvarscar/events{/privacy}","received_events_url":"https://api.github.com/users/nvarscar/received_events","type":"User","site_admin":false},"created_at":"2018-04-10T17:37:47Z","updated_at":"2018-04-10T17:37:47Z","author_association":"CONTRIBUTOR","body":"This is very cool 😍 Especially, if that can somehow be used as Out-DbaGannt and we could pipeline things into it, like backups and job history (I don't think there is anything else that can benefit from this yet?). There probably could be optional parameters (eg. -StartTimeProperty, -DurationProperty) that would control which columns will be treated as time-related; output from the History commands can be recognized as specific datatype and all such control parameters will be defined automatically based on that type.\r\nPS It might be more readable if you were to put the HTML template somewhere (like /bin/gannt_template.html) instead of typing it in inside the powershell script, but that's totally up to you."}}
{"actor":{"display_login":"nvarscar"}}