SQL Secure uses audit snapshots to capture SQL Server user and object permission settings. These snapshots are listed in Explore Permissions tree. A snapshot is a set of audit data that SQLsecure has collected from a specific SQL Server instance. You can configure snapshot filters to select which SQL Server objects you want to audit. You can take snapshots manually, as you need fresh data, or schedule snapshots to be taken at regular intervals.
The Snapshot Summary tab provides detailed information about your snapshot, including the time it was taken, the collection statistics, audit filter information, and a listing of any Suspect Windows accounts or unavailable databases that were encountered while the Snapshot was being taken. For more information on unresolved Windows accounts, see Identify Suspect Windows accounts. For more information on unavailable databases, see Identify Unavailable Databases.
To collect and review data about the password health of your SQL logins, enable weak password detection.
Data located on the Snapshot Summary
The Snapshot Summary contains the following types of information:
Snapshot Properties
Provides the basic status of the selected snapshot, the time it was collected, how long the collection took to complete, whether or not it has been selected as a baseline, and any comments associated with it.
Audit Summary
Lists the statistics of the snapshot. These statistics include the number of objects, permissions, databases, logins, Windows accounts, and Windows well-known groups associated with the snapshot.
Windows Accounts
Provides a partial list of the Windows users and groups that have access to the selected SQL Server instance.
OS Windows Accounts
Provides a partial list of the Windows users and groups that have access to OS objects but do not interact with SQL Server objects.
Filters
Provides the filter information associated with the selected snapshot. For more information, see Add new filter.
Suspect Windows Accounts
Lists the Accounts that SQL Secure was unable to collect data on. This can occur when SQL Secure does not have the proper rights to collect information on these users, or if the account was deleted. For more information, see Identify suspect Windows accounts.
Suspect OS Windows Accounts
Lists the Accounts that SQL Secure was unable to collect data on. This can occur when SQL Secure does not have the proper rights to collect information on these users, or if the account was deleted. For more information, see Identify suspect Windows accounts.
Unavailable Databases
Lists the databases that SQL Secure was unable to collect SQL Server security data on. This can happen when a database is unavailable during SQL Secure data collection. For more information, see Identify unavailable databases.