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