Guest User

Untitled

a guest
Jan 23rd, 2019
75
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.82 KB | None | 0 0
  1. EXEC dbo.sp_BlitzFirst
  2. @OutputDatabaseName = 'tempdb'-- change here !!
  3. , @OutputSchemaName = 'dbo'
  4. , @OutputTableName = 'BlitzFirst'
  5. , @OutputTableNameFileStats = 'BlitzFirst_FileStats'
  6. , @OutputTableNamePerfmonStats = 'BlitzFirst_PerfmonStats'
  7. , @OutputTableNameWaitStats = 'BlitzFirst_WaitStats'
  8. , @OutputTableNameBlitzCache = 'BlitzCache'
  9. , @OutputServerName ='--YourServerName--'-- change here !!
  10.  
  11. $tableName = "BlitzFirst_FileStats"
  12. $query = "select * from [dbo].[BlitzFirst_FileStats]"
  13. $results = Invoke-DbaQuery -SqlInstance 'yourserverName,port' -SqlCredential $Cred -Database tempdb -Query $query
  14. $results = Write-DbaDataTable -SqlInstance 'yourTargetInstance,portNo' -SqlCredential $Cred -Database CentralDBName -Table BlitzFirst_FileStats -Schema dbo -AutoCreateTable
Add Comment
Please, Sign In to add comment