I'm trying to list all machines in scope that contain the file master.mdf (this identifies it as a full SQL server, because just filtering by Microsoft SQL Server also shows SQL installs that are not servers... it's weird). The full file path is "C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\master.mdf", although the MSSQL10_50.MSSQLSERVER part would be different across machines, so would need to be a wildcard. 

Anyway, I'm having a very difficult time figuring out a Has File rule to do this. I've tried everything from proper regex searches to is equal to file path, etc. Any help?
0 Comments   [ - ] Hide Comments


Please log in to comment

There are no answers at this time
Answer this question or Comment on this question for clarity