Windows 10: Write a batch script to read list of db names to connect

Hi, I hope someone can help me. I am new to batch scripting. I want to read a file that has database names and connect to each of them to get status. I'd like to do this from cmd command. I really appreciate if I can get some help here.

Thanks in advance.

:)

 

Batch File - Find Multiple Files From Multiple Locations


Hi,

I'm not new to Batch Files but i have a requirement that i can't seem to get my head around, I'm sure it must be simple'ish..

I have 2 .txt files (Locations.txt | Files.txt)

• Locations is a list of directories
• Files is a list of file names

I would like to write a Batch Script that would loop through each location in the Locations.txt for files names that match any in Files.txt

I think i may need to write a for loop to cycle through the locations but then i'm not sure how i would pass the file names through for it to check for.

Basically if it does find any of those file names in any of the location i would want it to echo a message.

Regards,
Jamie

 

Writing batch files

I haven't done any coding for a very long time and I am looking for a tutorial and command list for making a batch file in win10. All I can seem to find are videos or sites that tell you that you use notepad to save a file as a .bat with virtually no info
on the actual programming/scripting. I know it'll all come back to me once I do one or two basic files, but I need a detailed refresher. Any suggestions?

(Specifically, I need a program to replace lines in one text file with lines from a different text file.)

 

Batch File to list files from two seperat networks

Hello,

I work in a factory where multiple PCs are on seperate VLANs. I need to view contents of a directory from one VLAN called "Admin" and compare it with individual directories from multiple PCs on another VLAN called "Shop" ("Shop" is not part of the Domain)

I have created a VB script that will compare two txt files and report the diffences. So I am trying to create two text files from each VLAN using a batch file. The batch file will be ran from a PC with two network cards so it can see both VLANs.

I can easily create the list from the "Admin" network using:
dir /b \\Server\Share\ > Active.txt

The "Shop" list is different. It needs a username and password. All Shop PCs have the same user name and password but I'm not sure how to structure the script to create a list from multiple PCs using a user name and password.
If I open the folders from Windows and enter the credentials then a script like this will work:
dir /b \\PC_Name1\Share > Programs.txt
dir /b \\PC_Name2\Share >> Programs.txt

Using the command above without first opening the folder and entering the credentials gives this error: Logon failure: unknown user name or bad password

Thanks in advance for any help.