Mssql Powershell

* PS C:\Users\Administrator.CSOEC> Import-Module SQLPS

* PS C:\Users\Administrator.CSOEC> ls sqlserver:

Name            Root                           Description
----            ----                           -----------
DAC             SQLSERVER:\DAC                 SQL Server Data-Tier Application
                                               Component
DataCollection  SQLSERVER:\DataCollection      SQL Server Data Collection
SQLPolicy       SQLSERVER:\SQLPolicy           SQL Server Policy Management
Utility         SQLSERVER:\Utility             SQL Server Utility
SQLRegistration SQLSERVER:\SQLRegistration     SQL Server Registrations
SQL             SQLSERVER:\SQL                 SQL Server Database Engine
SSIS            SQLSERVER:\SSIS                SQL Server Integration Services
XEvent          SQLSERVER:\XEvent              SQL Server Extended Events
DatabaseXEvent  SQLSERVER:\DatabaseXEvent      SQL Server Extended Events


* PS C:\Users\Administrator.CSOEC> cd SQLSERVER:\SQL

* PS SQLSERVER:\SQL> ls

MachineName
-----------
PARSQL01B


* PS SQLSERVER:\SQL> cd PARSQL01B
* PS SQLSERVER:\SQL\PARSQL01B> ls

Instance Name
-------------
INSTPROD

* PS SQLSERVER:\SQL\PARSQL01B> cd INSTPROD

* PS SQLSERVER:\SQL\PARSQL01B\INSTPROD> ls
Audits
AvailabilityGroups
BackupDevices
Credentials
CryptographicProviders
Databases
Endpoints
JobServer
Languages
LinkedServers
Logins
Mail
ResourceGovernor
Roles
ServerAuditSpecifications
SystemDataTypes
SystemMessages
Triggers
UserDefinedMessages
PS SQLSERVER:\SQL\PARSQL01B\INSTPROD> ls
Audits
AvailabilityGroups
BackupDevices
Credentials
CryptographicProviders
Databases
Endpoints
JobServer
Languages
LinkedServers
Logins
Mail
ResourceGovernor
Roles
ServerAuditSpecifications
SystemDataTypes
SystemMessages
Triggers
UserDefinedMessages


* PS SQLSERVER:\SQL\PARSQL01B\INSTPROD> ls  Databases