Enumeration

beacon> powershell Get-SQLInstanceDomain
beacon> powershell Get-SQLConnectionTest -Instance srv-1.dev.cyberbotic.io
beacon> powershell Get-SQLServerInfo -Instance srv-1.dev.cyberbotic.io

beacon> powershell Get-SQLInstanceDomain | Get-SQLConnectionTest | ? { $_.Status -eq "Accessible" } | Get-SQLServerInfo
powershell Get-SQLQuery -Instance srv-1.dev.cyberbotic.io -Query "select name from sys.databases"

powershell Get-SQLQuery -Instance srv-1.dev.cyberbotic.io -Query "select * from master.information_schema.tables where table_type='base table'"

powershell Get-SQLQuery -Instance srv-1.dev.cyberbotic.io -Query "select table_name,column_name from master.information_schema.columns"

powershell Get-SQLQuery -Instance srv-1.dev.cyberbotic.io -Query "use msdb; select * from msdb_version"

Last updated