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   [ + ] Show comments


There are no answers at this time

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login