Then I noticed you’re only looking to see if the server is in both Excel and your list, and printing it out if so. That’s logic that can be compressed into two lines.

$regex = '(?i)^(' + (($manlist | ForEach-Object { [Regex]::Escape($_) }) -join "|") + ')$'
($ExcelWorkSheet.Range("A:A").Value() | Select-Object) -match $regex

How To Ask Questions The Smart Way

message edited by Razor2.3

startouch1:

I assume you are the administrator and
since you have to do this on 100 servers,
every day, you would rather automate ?

Let’s build a solution for you step-by-step.

1. The solaris shell command to remove all
syslog.* files is

find "/" -name "syslog.*" -print -exec rm {} \;

2. To remove syslog files, you will need
to be superuser. You can NOT login as su
remotely, but you can supply
the supreuser password using a HERE DOCUMENT.
So, the solaris script is

su root << "EOF"
su_password
EOF
find "/" -name "syslog.*" -print -exec rm {} \;

3. If you put the above script in your DOS file
input.txt, and call the plink command as follows,
it will automate this for one server.

4. You now want to automate for
100 solaris servers (I assume that means
a lot of solaris servers).

Create a file C:/ServerList.txt as follows.

192.168.1.155\txyz\t123456\tsu_password

\t is tab.
First field is IP address of the solaris server,
second remote login,
third remote password,
fourth superuser password.
Each server entry – one per line.

5. Let’s now write a biterscripting
( http://www.biterscripting.com )
script to automate this for all Solaris servers
using the input from file C:/ServerList.txt.

# Script SolarisLogs.txt
var str list, serverentry, address, rlogin, rpswd, supswd, plinkcmd
set $wsep = "\t"
# Read server list.
cat "C:/ServerList.txt" > $list
# Get the first server entry.
lex "1" $list > $serverentry
# Process server entries one by one.
while ($serverentry <> "")
do
    # Extract the fields.
    wex -p "1" $serverentry > $address
    wex -p "2" $serverentry > $rlogin
    wex -p "3" $serverentry > $rpswd
    wex -p "4" $serverentry > $supswd

    # Compose the input.txt file.
    echo "su root << "EOF"" > input.txt
    echo $supswd >> input.txt
    echo "EOF" >> input.txt
    echo "find "/" -name "syslog.*" -print -exec rm {} \;" >> input.txt

    # Compose the plink command.
    set $plinkcmd="c:/Plink.exe -ssh -l "+$rlogin+" "+$address+" -pw ""+$rpswd+"" -m input.txt >> result.txt"

    # Execute the plink.cmd.
    system -s $plinkcmd

    # Get the next server entry.
    lex "1" $list > $serverentry
done

6. Save this script in file
C:/Scripts/SolarisLogs.txt on your local
DOS system, from where you will kick off
this activity. You can now run this script
manually from biterscripting with this command.

script "C:/Scripts/SolarisLogs.txt"

7. Of course, you do not want to
run this manually every day. So,
schedule this script to run at a time daily
when the servers are least in use,
using cron or task scheduler,
with the following command.

"C:/biterScripting/biterScripting.exe" script "C:/Scripts/SolarisLogs.txt"

That completes the solition. It was a good
challenge. I have not tested it. You may need
to do some trial-and-error during testing.
But I hope that this, at least, provides a
good starting point.

And yes, if you improve upon this solution,
you should re-post it for the benefit of
other over-worked Solaris administrators.

Hi,
If cell A1 contains your Y or N letter,
then in another cell enter this formula:
=IF(A1=”Y”,”Your cell says Yes”,”Your cell says No”)

This formula depends on the assumption that cell A1 only ever contains Y or N.

You can extend the formula like this:
=IF(A1=”Y”,”Your cell says Yes”,IF(A1=”N”, “Your cell says No”,”This looks like a maybe”))
and the formula will respond to three states – Y, N or anything else.

If you want to be sure that cell A1 contains only Y or N look at Data Validation with the List option, and you can stop anything other than Y and N being entered.
(although data validation is not case sensitive) – so the formula to use should allow both upper and lower case, like this:
=IF(OR(A1=”Y”,A1=”y”),”Your cell says Yes”,”Your cell says No”)

If you go the data validation route and need more help – just ask.

Regards