MODULE 4 - PROTECT SQL DATABASES

LESSON 1 - DISCOVER SQL DATABASES

Review the Agent Registration Status.

Get-PPDMagent_registration_status

The Command will output all Agents Registrations

Agents can be approved via the Update-PPDMWhitelist Function, either from ID or from Pipeline

Get-PPDMWhitelist | Update-PPDMWhitelist -state APPROVED

Lets start a discover for host sql-02.demo.local

Get-PPDMhosts -filter 'name eq"sql-02.demo.local"' | Start-PPDMdiscoveries -level HOSTFULL -start hosts

Get-PPDMactivities -taskid <Use TaskID from you discover to check the activity>

Now lets have a look at the Discovered Databases

Get-PPDMassets -type MICROSOFT_SQL_DATABASE -filter 'details.database.clusterName eq "sql-02.demo.local"' | ft