Read Excel contents, search servers and Pass into another excel file.

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • fiveheads
    New Member
    • Apr 2007
    • 1

    Read Excel contents, search servers and Pass into another excel file.

    Hi guy,

    I'm Javascript beginner... Recently thinking to have a code, which can read a list of servers from EXCEL (XLS) file and search these servers from network and then pass the results into another excel fle. Any expert can help me....

    \\%%i.domain.co m\HKEY_LOCAL_MA CHINE\SOFTWARE\ Fireware Systems\Galaxy\ Platform Information\%%i .domain.com\ser vers" /v "sCSCLIENTN AME

    Currently i have a version using dos command to grep info as per bottom..
    But that's not flexible when want to check more servers with that.

    --------
    @echo off
    :Start
    CLS
    ECHO.
    echo.
    echo.
    echo Server:
    for /f "tokens=1 delims= " %%i in ('readstr') do (reg query "\\%%i.domain.c om\HKEY_LOCAL_M ACHINE\SOFTWARE \fireware Systems\Galaxy\ Platform Information\%%i .domain.com\css erver" /v "sCSCLIENTNAME" ) > temp.txt
    sh runme.sh
    call cs
    echo Comm Serve = %CSServer%
    echo Do you want me to launch the fireware?
    choice
    if errorlevel 2 goto norunning
    if errorlevel 1 goto runit

    goto bye

    :norunning
    goto bye

    :runit
    echo Launching commserve...
    cmd /c start c:\apps\cssear~ 1\cs\%CSServer%
    pause.
    goto bye

    :bye
    goto start


    --------
Working...