Is it possible to use Spotlight to configure an alert on , for example, Open Files in windows?
You can track counters not included in Spotlight using the Custom Counters feature. Custom counters are configured on the Diagnostic Server (Default Settings) and can then be applied to specific connections.
For Windows queries you need to use VMI queries.
It is recommended that the query return only one column and one row. For all custom counter queries, Spotlight reads only the first column of the first row of data. Any additional data is ignored. To return multiple values, use more than one query.
To create a counter to know the Open Files in windows you need the follwoing query:
SELECT FilesOpen FROM Win32_PerfRawData_PerfNet_Server