dell-democenter

MODULE 4 - PROTECT SQL DATABASES

Review the Agent Registration Status.

Get-PPDMagent_registration_status

The Command will output all Agents Registrations

Alt text

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

Get-PPDMWhitelist | Update-PPDMWhitelist -state APPROVED

Alt text

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

Alt text

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

Alt text

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

Alt text