Skip to content
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

sp_Blitz output table order different than onscreen table order #2937

Closed
parlevjo2 opened this issue Jun 12, 2021 · 4 comments · Fixed by #2940
Closed

sp_Blitz output table order different than onscreen table order #2937

parlevjo2 opened this issue Jun 12, 2021 · 4 comments · Fixed by #2940
Assignees

Comments

@parlevjo2
Copy link
Contributor

Not really an bug, but some cosmetic

Version of the script
@Version = '8.04', @VersionDate = '20210530'

The order of the records in the output table is not consistent with the order of the records in SQL Server Management Studio on the screen.
There are total of 5 lines where the ORDER BY should be changed from

      1 x	         CheckID FROM ##BlitzResults ORDER BY Priority , FindingsGroup, Finding, Details;
      4 x	QueryPlanFiltered FROM #BlitzResults ORDER BY Priority , FindingsGroup , Finding , Details';

to
... ORDER BY Priority , FindingsGroup , Finding , DatabaseName , Details

@BrentOzar
Copy link
Member

OK, if that's important to you, you're welcome to submit a pull request with the change as described here:
https://github.com/BrentOzarULTD/SQL-Server-First-Responder-Kit/blob/main/CONTRIBUTING.md

If not, let me know or I'll close this issue in a few days. Thanks!

@BrentOzar BrentOzar changed the title Order by not consistent when output to eq table sp_Blitz order by not consistent when output to eq table Jun 26, 2021
@BrentOzar BrentOzar changed the title sp_Blitz order by not consistent when output to eq table sp_Blitz output table order different than onscreen table order Jun 26, 2021
@parlevjo2
Copy link
Contributor Author

parlevjo2 commented Jun 27, 2021

Ok. I wil do a Pull Request. It will take me some time beacuse that github program drives me crazy every time

@parlevjo2
Copy link
Contributor Author

I have created a Pull Request #2940 "Update sp_Blitz.sql change order in output table same as onscreen"

@BrentOzar
Copy link
Member

Merged, thanks!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
2 participants