I wrote a .vbs script, but it is not working as expected. I am looking a for a powershell script which can will give me desired output.
I am looking for (ex: name has PRD, datastore has APP & name had DB, datastore has PRD, it should mail information. Same way, it should go through complete .CSV file and give me the output. If all the fields are mapped correclty, it should say: ALL GOOD.
.vbs script what I wrote:
'To get the Column Values of the Fields
if (instr(ucase(objWorkBook.Worksheets(1).Cells(i, 1)),"DB") and instr(ucase(objWorkBook.Worksheets(1).Cells(i, 2)),"APP")) Then
Here are some of the powershell cmdlets I believe would be very helpful for this effort:
Thanks. It worked out.
You must be logged in to reply to this topic.