Snippet Name: Scan_for_S2WPVMIMSQL1_in_non-binary_files

Tags:

Created Date: 2025-06-16 13:12:39
Last Modified Date: 2025-05-31 10:31:36

Dependencies:

DBA Notes:

Sample Output:

Title: Scan for "S2WPVMIMSQL1" in non-binary files
Author: user
i need to scan all non binary files on a given server, to see if they contain the string "S2WPVMIMSQL1", can you write a python script that outputs the directory, the filename, and hte line number for any file with that string

Author: ChatGPT
Certainly! Here's a Python script that should help you achieve that:

```python
import os

def search_files(root_dir, target_string):
    for root, dirs, files in os.walk(root_dir):
        for file_name in files:
            file_path = os.path.join(root, file_name)
            if os.path.isfile(file_path) and not file_path.endswith(".exe"):  # Skip binary files
                with open(file_path, 'r', encoding='utf-8', errors='ignore') as file:
                    line_number = 0
                    for line in file:
                        line_number += 1
                        if target_string in line:
                            print(f"Directory: {root}, Filename: {file_name}, Line Number: {line_number}")

# Provide the root directory and the target string
root_directory = "/path/to/your/server"
target_string = "S2WPVMIMSQL1"

search_files(root_directory, target_string)
```

Make sure to replace `"/path/to/your/server"` with the actual path of the server directory you want to scan. This script will recursively search all non-binary files (excluding `.exe` files) within the specified directory and its subdirectories for the target string. If the string is found, it will print the directory, filename, and line number where the string is located.

Author: user
how does the path change for Windows, like if it was C:\Deploymentfolder

Author: ChatGPT
For Windows paths, you need to use double backslashes (`\\`) or a raw string (`r"..."`) to ensure the backslashes are treated as literal characters and not escape characters. Here's how you would modify the script for a Windows path like `C:\Deploymentfolder`:

```python
import os

def search_files(root_dir, target_string):
    for root, dirs, files in os.walk(root_dir):
        for file_name in files:
            file_path = os.path.join(root, file_name)
            if os.path.isfile(file_path) and not file_path.endswith(".exe"):  # Skip binary files
                with open(file_path, 'r', encoding='utf-8', errors='ignore') as file:
                    line_number = 0
                    for line in file:
                        line_number += 1
                        if target_string in line:
                            print(f"Directory: {root}, Filename: {file_name}, Line Number: {line_number}")

# Provide the root directory and the target string
root_directory = r"C:\Deploymentfolder"
target_string = "S2WPVMIMSQL1"

search_files(root_directory, target_string)
```

With the `r` before the string `"C:\Deploymentfolder"`, it becomes a raw string, so you don't need to escape the backslashes manually. This script should work correctly on Windows systems.

Author: user
what otehr binary files, otehr than *.exe should we logically skip? *.dlls for example?

Author: ChatGPT
Yes, skipping `.dll` files would also be logical, as they are binary files commonly found in Windows systems. Additionally, skipping other binary file types such as `.so` (shared object files in Unix/Linux systems) and `.lib` (library files) might be appropriate depending on your specific environment. 

Here's the modified script that skips `.exe`, `.dll`, `.so`, and `.lib` files:

```python
import os

def is_binary_file(file_path):
    binary_extensions = ['.exe', '.dll', '.so', '.lib']
    return any(file_path.lower().endswith(ext) for ext in binary_extensions)

def search_files(root_dir, target_string):
    for root, dirs, files in os.walk(root_dir):
        for file_name in files:
            file_path = os.path.join(root, file_name)
            if os.path.isfile(file_path) and not is_binary_file(file_path):  
                with open(file_path, 'r', encoding='utf-8', errors='ignore') as file:
                    line_number = 0
                    for line in file:
                        line_number += 1
                        if target_string in line:
                            print(f"Directory: {root}, Filename: {file_name}, Line Number: {line_number}")

# Provide the root directory and the target string
root_directory = r"C:\Deploymentfolder"
target_string = "S2WPVMIMSQL1"

search_files(root_directory, target_string)
```

This script defines a function `is_binary_file()` to check if a given file has an extension that indicates it's binary, and skips processing such files. You can add or remove file extensions from the `binary_extensions` list as needed.