Solved

Scripting customized information into a report

Posted on 2012-03-21
3
239 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 54

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 54

Expert Comment

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

~bp
0

Featured Post

Resolve Critical IT Incidents Fast

If your data, services or processes become compromised, your organization can suffer damage in just minutes and how fast you communicate during a major IT incident is everything. Learn how to immediately identify incidents & best practices to resolve them quickly and effectively.

Question has a verified solution.

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

Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
In threads here at EE, each comment has a unique Identifier (ID). It is easy to get the full path for an ID via the right-click context menu. However, we often want to post a short link within a thread rather than the full link. This article shows a…
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

740 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