Collection 'Files' failed & Collection 'Database Disk Space Utilization' failed (4333933)

Collection 'Files' failed & Collection 'Database Disk Space Utilization' failed

Getting the following errors on one of the SQL 2012 instances  being monitored:

Severity    Alarm    Message    Raised    Cleared
Information    Monitored Server - SQL Server Collection Execution Failure    Collection 'Files' failed : Error 512, Level 16, State 1, Procedure -, Line 98, Message: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, , >= or when the subquery is used as an expression. [50000]    23/04/2015 12:00:00    
Information    Monitored Server - SQL Server Collection Execution Failure    Collection 'Database Disk Space Utilization' failed : Collection 'Files' failed : Error 512, Level 16, State 1, Procedure -, Line 98, Message: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, , >= or when the subquery is used as an expression. [50000]    24/04/2015    

WORKAROUND

1. Go to {DS dir}\Agent\conf\package\sqlserver_spotlight\2012
2. Backup the SQLFiles.sql
3. Copy the attached file there.

A Diagnostic Server restart is not required. 

STATUS

Issue fixed in version 11.5. The latest version of Spotlight on SQL Server Enterprise can be downloaded here

SOSSE-4240

Updated SQLFiles.sql