Skip to content

PowerBI and Powershell script to drill into BP-check results file(s)

Notifications You must be signed in to change notification settings

Petar-T/BP_check_Reporter

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

29 Commits
 
 
 
 
 
 
 
 

Repository files navigation

BP_Check-To-Excel & BP_Check-Reporter

  • BP_Check_To_Excel os Powershell utility to run BP_Check (and any simmilar) and get results into Excel.
    Excel is created in user's temporary folder , and all plans detected during execution are extracted to physical files so they can be opened in SSMS during analysis
  • BP_Check_Reporter is Powershell script to drill into BP-check results file(s), it also provides PowerBi file
**Requirements** :
  • To run BP_Check_To_Excel ImportExcel Module is required, downloadable from https://www.powershellgallery.com/packages/ImportExcel
  • To excute BP_Check_Reporter you need output of bp_check script from SQL server in format Servername.rpt. There might be unlimited outputs in same batch

Result:
results.csv and correlating PowerBI report

Process Run Poweshell script , it will create results.csv, change source on PowerBI file , that is it!


![image](https://github.com/Petar-T/BP_check_Reporter/assets/47648550/506eb4a0-c2fb-4503-9705-2d8ad039e755)
![PowerBI demo page](https://github.com/Petar-T/BP_check_Reporter/assets/47648550/4651cd60-29be-48e0-bab0-499157b4732c)

About

PowerBI and Powershell script to drill into BP-check results file(s)

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published