Discovery Wizard Vulnerability Check Video

This video shows how to run vulnerability tests to detect SQL Server instances with unsafe passwords or no password.

PowerShell

The next Discovery Wizard version supports PowerShell. We have only 11 commands by now, but we are planning to populate this list of commands soon.

Get-qssdBaseline - returns collection containing information for each server in the baseline.
Get-qssdCompare - executes, and compares the results with saved baseline. This command is similar to Get-qssdBaseline, the only difference is that it scans before returning servers collection.
Get-qssdOptions - reads Discovery Wizard options from the configuration file and returns collections of SQL logins, WMI loggins and search options.
Get-qssdScan - scans network for SQL Servers. It uses Domain Name or IP Addresses list as the input parameter.
Join-qssdBaseline - applies changes to baseline.
New-qssdBaseline - creates new baseline from the input object taken from the pipeline.
Out-qssdCsv, Out-qssdLitespeed, Out-qssdXml, Out-qssdToad - export to the specified format
Set-qssdOptions - sets Discovery Wizard options.

Sometimes our customers ask us about automation of some process: for example, discovery and export tasks. The possible solution is to use PowerShell commands available in the next Discovery Wizard version. Something like this:

Get-qssdScan -DomainNames MyDomain | Out-qssdXml -Output "C:\\Results.xml"

Export to...

The Quest cares about a close interaction between its products! Therefore in the next version of Quest Discovery Wizard for SQL Server you will be able to export a list of found instances to the Quest Toad for SQL Server


and Quest LiteSpeed

No errors, no results...

Yesterday, I tried to collect data for my server. The collect operation processed without errors, but I still could see the big Collect Data button. No errors, no results. A reason of this situation is that my server was shutdown. My bad, but I would prefer to see an error message…

Server Baseline

Hi everyone,

I would like to tell you about Server Baseline - one of the Quest Discovery features. Having found necessary servers you can add them to the baseline list:
1) Right-click an item from the grid
2) Select "Add To Baseline" (if a baseline list already exists, you can overwrite this list or append new collection)

On the "Server Baseline" tab you can see a snapshot of your servers. When you click Update, Discovery searches for servers using baseline search parameters and compares this list with the snapshot.



Now, you can see the status of each server and summary info on the left panel.

• Unchanged instances - Number of instances without changes


• Changed instances - Number of instances, for which Discovery Wizard collected new information


• New instance - Number of new instances, which appeared on the network since the time you last updated the baseline


• Instances lost - Number of instances, which disappeared from the network since the last time you updated the baseline
  

Filter the list by clicking a status link.
Server Baseline is a good feature helping to monitor your servers statuses.

Good Luck!

New to my blog...

I have added a group of interesting links into my blog - "Interesting resources", and blogs of Bryan Oliver and Brent Ozar are the first in this list. Bryan and Brent are SQL Server experts and you can find a lot of useful information about SQL Server in their blogs!

"Collect Data" feature

Customers are generally interested in “Collect Data” feature so I have decided to write about it.

You can collect data from instances for which you know access credentials.
- select some instances in the grid
- click the "Collect Data" button under the grid or select corresponding item from right-click menu
- specify connection details
- click Save

Now, you can use additional information for selected instances:

• General - general information about SQL Server instance
• Databases - information about all databases in the instance
• Logins - information about registered logins in the instance
• Applications - information about application which are working with the instance