Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 244
  • Last Modified:

Scripting customized information into a report

Experts,

I am looking to create a script in which I can pull the following information from a server and save it to a text file on the machine.

Information needed:
1. Machine Name:
2. Number of CPU's
3. Version of Oracle running on each machine.

Now the Oracle Version can be gotten by running Sqlplus -v from a command prompt.

I am at a loss on the others.

In order to get full points please provide a fully functional script that can pull items 1 - 3 and save them in a text file on the workstation.
0
itguy565
Asked:
itguy565
  • 2
1 Solution
 
Bill PrewCommented:
Here's a simple BAT script that will do the job.
@echo off
set LogFile=c:\temp\info.txt
echo %COMPUTERNAME%>"%LogFile%"
systeminfo 2>NUL|find /i "Processor(s):">>"%LogFile%"
sqlplus -v>>"%LogFile%"

Open in new window

~bp
0
 
itguy565Author Commented:
Exactly what I was looking for..
0
 
Bill PrewCommented:
Great, glad that helped, thanks for the feedback.

~bp
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now