Change History

Version 1.0.2.1

Updates to NetworkScan.psm1
  • 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
Updates to SQLServerDatabaseEngineInformation.psm1 module
  • 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
Updates to SqlServerInventory.psm1 module
  • 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
Updates to WindowsInventory.psm1 module
  • 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
Updates to WindowsMachineInformation.psm1 module
  • Modified Get-ApplicationInformationFromRegistry
    • Updated condition to validate contents of Install Date value from registry (should match YYYYMMDD)
ReadMe Updates
  • Updated SqlServerInventory and WindowsInventory Readme files to match documentation on CodePlex

 

Version 1.0.2.0

Updates to NetworkScan.psm1
  • 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
Updates to SQLServerDatabaseEngineInformation.psm1 module:
  • 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
Updates to SqlServerInventory.psm1 module:
  • 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
Updates to WindowsInventory.psm1 module
  • 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

 

Version 1.0.1.0

Updates to LogHelper.psm1 module
  • Modified Write-Log function to force writing warning messages if logging to a file is disabled
Updates to SqlServerInventory.psm1 module
  • 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
Updates to SQLServerDatabaseEngineInformation.psm1 module
  • 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()
Updates to WindowsMachineInformation.psm1 module
  • Updated error handling in Get-WindowsMachineInformation to provide the actual line number that errors occurred inside of functions
Updates to Get-SqlServerInventoryToClixml.ps1
  • 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
Updates to NetworkScan.psm1
  • Added -ErrorAction Stop to Get-WmiObject calls throughout module to provide better error handling

Last edited Oct 17, 2013 at 7:15 PM by kendalvandyke, version 6

Comments

No comments yet.