{"action":"created","issue":{"url":"https://api.github.com/repos/sqlcollaborative/dbatools/issues/2318","repository_url":"https://api.github.com/repos/sqlcollaborative/dbatools","labels_url":"https://api.github.com/repos/sqlcollaborative/dbatools/issues/2318/labels{/name}","comments_url":"https://api.github.com/repos/sqlcollaborative/dbatools/issues/2318/comments","events_url":"https://api.github.com/repos/sqlcollaborative/dbatools/issues/2318/events","html_url":"https://github.com/sqlcollaborative/dbatools/pull/2318","id":260628278,"number":2318,"title":"Get database restore information","user":{"login":"Zhunya","id":14327077,"avatar_url":"https://avatars1.githubusercontent.com/u/14327077?v=4","gravatar_id":"","url":"https://api.github.com/users/Zhunya","html_url":"https://github.com/Zhunya","followers_url":"https://api.github.com/users/Zhunya/followers","following_url":"https://api.github.com/users/Zhunya/following{/other_user}","gists_url":"https://api.github.com/users/Zhunya/gists{/gist_id}","starred_url":"https://api.github.com/users/Zhunya/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Zhunya/subscriptions","organizations_url":"https://api.github.com/users/Zhunya/orgs","repos_url":"https://api.github.com/users/Zhunya/repos","events_url":"https://api.github.com/users/Zhunya/events{/privacy}","received_events_url":"https://api.github.com/users/Zhunya/received_events","type":"User","site_admin":false},"labels":[{"id":173004249,"url":"https://api.github.com/repos/sqlcollaborative/dbatools/labels/Type:%20Enhancement","name":"Type: Enhancement","color":"84b6eb","default":false}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":2,"created_at":"2017-09-26T13:42:39Z","updated_at":"2017-09-26T14:00:30Z","closed_at":null,"author_association":"MEMBER","pull_request":{"url":"https://api.github.com/repos/sqlcollaborative/dbatools/pulls/2318","html_url":"https://github.com/sqlcollaborative/dbatools/pull/2318","diff_url":"https://github.com/sqlcollaborative/dbatools/pull/2318.diff","patch_url":"https://github.com/sqlcollaborative/dbatools/pull/2318.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 - [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\nSometimes its useful to know when and from which file database was restored and when that backup was taken and by whom.\r\n\r\n### Commands to test\r\nGet-DbaDatabase -SqlInstance SERVER -ExcludeDatabase master,model,tempdb,msdb | Select-Object -Property SqlInstance,Name,BackupFinishDate,RestoredDate,RestoredBy,RestoredFrom | OGV\r\n"},"comment":{"url":"https://api.github.com/repos/sqlcollaborative/dbatools/issues/comments/332207593","html_url":"https://github.com/sqlcollaborative/dbatools/pull/2318#issuecomment-332207593","issue_url":"https://api.github.com/repos/sqlcollaborative/dbatools/issues/2318","id":332207593,"user":{"login":"potatoqualitee","id":8278033,"avatar_url":"https://avatars1.githubusercontent.com/u/8278033?v=4","gravatar_id":"","url":"https://api.github.com/users/potatoqualitee","html_url":"https://github.com/potatoqualitee","followers_url":"https://api.github.com/users/potatoqualitee/followers","following_url":"https://api.github.com/users/potatoqualitee/following{/other_user}","gists_url":"https://api.github.com/users/potatoqualitee/gists{/gist_id}","starred_url":"https://api.github.com/users/potatoqualitee/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/potatoqualitee/subscriptions","organizations_url":"https://api.github.com/users/potatoqualitee/orgs","repos_url":"https://api.github.com/users/potatoqualitee/repos","events_url":"https://api.github.com/users/potatoqualitee/events{/privacy}","received_events_url":"https://api.github.com/users/potatoqualitee/received_events","type":"User","site_admin":false},"created_at":"2017-09-26T14:00:30Z","updated_at":"2017-09-26T14:00:30Z","author_association":"OWNER","body":"Not necessarily - this is a db centric point of view - Get-DbaRestoreHistory will show all history even if the db is dropped after (and the person doesnt delete the history)"}}
{"actor":{"display_login":"potatoqualitee"}}