Script to Count the SQL DB's backed up in Daily manner
1. Create a file D:\Servers.txt with List of Clients
2. Open the script file and change the line below as per your installed path.
Set objExec = objShell.Exec("SETX HOMEPATH D:\Program Files\Veritas\NetBackup\bin")
3.Save this file and execute it.
4.Output will be saved in Excel under D:\Details.xls
Find the attaced file for sample output.
Let me know if you face any issues.
As per your advice , i have placed the "Servers" file in D drive with some server names. Also my master server has been installed in D drive only.I am executing this script , but it fails with error. Please find the attachment.
Sorry i have missed comments. Check out this 2 lines. It uses a temp staging test file. which will be created under this folder Test. You can create a folder called Test else remove the Test from that script line.