New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Export dbachecks results to a database (and SSRS report?) #270

Closed
SQLDBAWithABeard opened this Issue Feb 17, 2018 · 5 comments

Comments

Projects
None yet
3 participants
@SQLDBAWithABeard
Copy link
Collaborator

SQLDBAWithABeard commented Feb 17, 2018

It would be good to be able to export the results to a database and potentially create an SSRS report (maybe that should be another issue?)

I think I could see it as being done in this way with the database instance, name and table held in the config and using Write-DbaDataTable

@potatoqualitee

This comment has been minimized.

Copy link
Member

potatoqualitee commented Feb 17, 2018

yeah i think ssrs should be another issue. should we invest in creating an SSRS report or just enable others to do it? i see SSRS as powershell v3 - skippable in this project. It could potentially take away the love we could invest into the prettier and more powerful powerbi dashboards.

@SQLDBAWithABeard

This comment has been minimized.

Copy link
Collaborator

SQLDBAWithABeard commented Feb 17, 2018

I agree. Its a good issue for someone to take forward if it will help them to use dbachecks. I am hoping someone will come forward and take up the baton with it :-)

@michalporeba

This comment has been minimized.

Copy link
Collaborator

michalporeba commented Feb 23, 2018

The simple export of the results to a database table would be as simple as piping the output to Out-DbaDataTable. Wouldn't that be prefered to adding a new set of parameters?

However, I would see value in configurable table output which then can be set in an environment configuration file making sure that checks for a specific environment will always go to a specific table, automatically.

@SQLDBAWithABeard

This comment has been minimized.

Copy link
Collaborator

SQLDBAWithABeard commented Feb 26, 2018

Yes yes yes @michalporeba that is definitely the way forward

@SQLDBAWithABeard

This comment has been minimized.

Copy link
Collaborator

SQLDBAWithABeard commented Mar 31, 2018

I like the idea of doing this but I'm going to close this issue for now. I think we should handle any resulting action on the output of the checks via seperate commands rather than within dbachecks - If need be we can have an additional module dbachecks-actions forexample

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment