Solved

Scripting customized information into a report

Posted on 2012-03-21
3
237 Views
Last Modified: 2012-03-22
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
Comment
Question by:itguy565
  • 2
3 Comments
 
LVL 52

Accepted Solution

by:
Bill Prew earned 500 total points
ID: 37750523
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
 
LVL 11

Author Closing Comment

by:itguy565
ID: 37751141
Exactly what I was looking for..
0
 
LVL 52

Expert Comment

by:Bill Prew
ID: 37751915
Great, glad that helped, thanks for the feedback.

~bp
0

Featured Post

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article is meant to give a basic understanding of how to use R Sweave as a way to merge LaTeX and R code seamlessly into one presentable document.
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
In this fifth video of the Xpdf series, we discuss and demonstrate the PDFdetach utility, which is able to list and, more importantly, extract attachments that are embedded in PDF files. It does this via a command line interface, making it suitable …

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now