-
Notifications
You must be signed in to change notification settings - Fork 15
Changelog
SheepReaper edited this page Jun 25, 2017
·
2 revisions
- Added version for SQL 2014
- Modified Import-GzCliXml, Export-GzCliXml, ConvertFrom-GzCliXml, and ConvertTo-GzCliXml
- Fixed bug introduced in Windows 8.1 where a new method overload appeared and sometimes borked serialization/deserialization
- Modified Get-SqlServerInventoryDatabaseEngineAssessment
- Updated check for missing alerts on sev 19-25 to try and explictly convert severity values to INT when evaluating their range
- Added specific check for Priority Boost Enabled
- Fixed check for torn page detection - previous versions recommended TORN_PAGE_DETECTION for SQL 2000 but that wasn't an option
- Modified Export-SqlServerInventoryDatabaseEngineConfigToExcel
- Updated Worksheet 13 (Server Security - Logins) to limit display of a Windows Group login's member list to 5000 characters
- Added version for SQL 2014
- Changed ad-hoc queries to use whatever database ConnectionContext object is connected to for executing ad-hoc queries instead of explicitly using master database
- Modified Get-ServerConfigurationInformation to consolidate code for enumerating server and server object permissions
- Modified Get-SqlServerSecurityInformation to note that the list AD group members is incomplete if an error enumerating membership occurs but we can still resolve some members
- Modified Get-DatabaseInformation to include permissions for Assemblies, Asymmetric Keys, Certificates, Database Principals, Fulltext Catalogs, Fulltext Stoplists, Message Types, Remote Service Bindings, Routes, Schemas, Services, Service Contracts, Symmetric Keys, Types, and XML Schema Collections in addition to object permissions
- Added additional service name pattern to check for when looking in a machine's registry for SQL Server instances
- Modified Find-SqlServerService
- Fixed an issue with properly identifying the name of a named instance using only the shared memory protocol. (This affetected a lot of people running developer edition as a named instance on their local machine since developer edition uses only shared memory by default)
- Now collecting more information about service protocol configuration
- Added Get-NTGroupMemberList
- Wrapper to Win32 API calls to resolve members of a machine or domain NT group
- Added Get-FailoverClusterMemberList
- Code called in multiple places so the logic was moved to a function to eliminate cut and paste codin
- Modified Get-ServerConfigurationInformation
- Consolidated code to call Get-FailoverClusterMemberList
- Added logic to retrieve shared drive information only if the instance is clustered
- Added logic to resolve AlwaysOn failover cluster members only if the instance is an AlwaysOn replica
- Added logic to resolve AlwaysOn Subnet information only if the instance is an AlwaysOn replica
- Added logic to recursively resolve the members of a Windows group login
- Fixed bug with retrieving the Mapped Class Type for Credentials (not always present depending on version of SMO)
- Fixed bug with retrieving the Workload Group Importance for Resource Governer Resource Pools (not always present depending on version of SMO
- Modified Get-DatabaseMailInformation
- Added logic to skip retrieving configuration values for SQL Express instance
- Modified Get-SqlServerDatabaseEngineInformation
- Added logic to skip retrieving SQL Agent information for SQL Express instances
- Modified Get-SqlServerInventoryDatabaseEngineAssessment
- Fixed bug when checking Server public Permissions
- Modified Export-SqlServerInventoryDatabaseEngineConfigToExcel
- Added column and logic to show the definition for server permissions (e.g. GRANT, DENY)
- Added column to show the members of a Windows Group server login
- Added column and logic to show the definition for Server Roles
- Fixed bug with displaying all Linked Server Logins
- Added column and logic to show the definition for Database Permissions
- Added debug output for worksheet formatting time
- Modified Export-WindowsInventoryToExcel
- Fixed a cosmetic issue with writing progress when retrieving hotfix titles
- Updated output to be sorted by logical disk caption in Logical Drives column
- Updated sorting for Worksheet 7 (Disk Drives) to sort by logical disk caption
- Added debug output for worksheet formatting time
- Modified Get-ApplicationInformationFromRegistry
- Updated condition to validate contents of Install Date value from registry (should match YYYYMMDD)
- Updated SqlServerInventory and WindowsInventory Readme files to match documentation on CodePlex
- Bug fix: Service IP Address and port were not properly reported under some very specific circumstances. Now they are.
- Modified Find-IPv4Device
- Added TimeoutSeconds parameter to specify timeout value for WMI connectivity test
- Added logic to bail out of WMI connectivity check if TimeoutSeconds is exceeded
- Modified Get-SqlConnection
- Added optional IpAddress parameter to specify the IP address to use for connecting to an instance
- Modified Get-SqlServerDatabaseEngineInformation
- Added optional IpAddress parameter to specify the IP address to use when connecting to the instance
- Added logic to detect lowest version of SMO assembly currently loaded when module loads to avoid errors that result from calling methods in newer versions of SMO that don't exist in the lowest version loaded
- Modified Get-SqlServerInventory
- Added optional IP Address parameter to specify the IP address to use when connecting to the instance
- Semantic change from "Error" to "Failure" when referring to scan failures in logging messages
- Renamed property DatabaseServerScanErrorCount to DatabaseServerScanFailCount in inventory object returned by function
- Added logic to skip gathering SQL Agent information for Express edition instances (since Express has no Agent)
- Modified Get-SqlServerInventoryDatabaseEngineAssessment
- Fixed bug with checks for Nonaligned partitions and Partition Allocation Unit Size that sometimes resulted in a divide by zero error
- Fixed bug with check for Server public Permissions that was incorrectly identifying default permissions as a potential issue
- Modified Get-DatabaseMailInformation
- Added logic to skip gathering configuration values for Express edition instances (since Express doesn't have Database Mail)
- Modified Get-ResourceGovernorInformation
- Fixed bug gathering information from instances that don't have Resource Governor
- Modified Export-SqlServerInventoryDatabaseEngineConfigToExcel
- Fixed bug that was excluding showing linked server logins that didn't have a local login
- Modified Get-WindowsInventory
- Semantic change from "Error" to "Failure" when referring to scan failures in logging messages
- Renamed property ScanErrorCount to ScanFailCount in inventory object returned by function
- Added parameter for parent progress ID when calling Get-HotFixTitle so progress bars appear nested properly on console
- Modified Write-Log function to force writing warning messages if logging to a file is disabled
- Get-SqlServerInventoryDatabaseEngineAssessment
- Updated check for Non-Default Config Values to exclude values with a null or empty configuration name
- Updated check for Server public permissions to exclude CONNECT on default endpoints (granted by default so it's OK)
- Added check for low disk space (5\10\15% thresholds)
- Added check for Trustworthy Bit and db owner is a member of the sysadmin fixed server role
- Added check for sp_configure option 'Network Packet Size' exceeding 8060 bytes
- Added check for Weak Symmetric Keys In User Databases
- Added check for User Created Symmetric Keys In System Databases
- Updated check for Guest Access To User Databases
- Added check for Asymmetric Key Encryption Strength
- Added check for Affinity Mask Overlap
- Updated URL for Lightweight Pooling Enabled check
- Added check for Password Policy Not Enforced
- Added check for Password Expiration Not Enabled
- Added check for Password Policy Not Supported
- Added check for Password Expiration Not Supported
- Updated Import-SqlServerInventoryFromGzClixml and Get-SqlServerInventory to associate a machine with an instance based on partial machine name and IP address match
- Get-SqlServerInventory
- Modified parametersets to fix a bug which led to "Parameter set cannot be resolved using the specified named parameters." errors when using Windows authentication and discovering instances using DNS or subnet ranges
- Updated error handling in Get-SqlServerDatabaseEngineInformation to provide the actual line number that errors occurred inside of functions
- Updated all functions which return a string value for an enumeration
- Wrapped enum values in switch statement with $() in some cases they were not being evaluated as expected; this corrects that problem
- Bug fix: Changed default value for switch statements to $_.ToString()
- Updated error handling in Get-WindowsMachineInformation to provide the actual line number that errors occurred inside of functions
- Modified parametersets to fix a bug which led to "Parameter set cannot be resolved using the specified named parameters." errors when using Windows authentication and discovering instances using DNS or subnet ranges
- Added -ErrorAction Stop to Get-WmiObject calls throughout module to provide better error handling
- Windows PowerShell version 2.0 or higher (version 3 or higher strongly recommended)
- SQL Server Management Objects (SMO)
- Microsoft Excel 2007 or higher
- Sysadmin level rights to SQL Server
- Administrator level rights to Windows (Optional)
- RDS-Manager PowerShell Module (Optional