Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to associate hardware information into an Oracle Table?

Re: How to associate hardware information into an Oracle Table?

From: Chuck Lee <pklalee_at_hotmail.com>
Date: 26 Apr 2004 09:40:51 -0700
Message-ID: <45b3fd33.0404260840.507aa270@posting.google.com>


Thanks

How we write the results of the following script into an OS text file?

Lee

Following script returns the name and version number of an Oracle Sever installed on a computer:

Script Code

strComputer = "."
Set objWMIService = GetObject("winmgmts:" _ & "{impersonationLevel=impersonate}!\\" & strComputer & "\root\cimv2")
Set colOperatingSystems = objWMIService.ExecQuery _ ("Select * from Win32_OperatingSystem")
For Each objOperatingSystem in colOperatingSystems Wscript.Echo objOperatingSystem.Caption & " " & objOperatingSystem.Version
Next

"Howard J. Rogers" <hjr_at_dizwell.com> wrote in message news:<408cc996$0$26367$afc38c87_at_news.optusnet.com.au>...
> Chuck Lee wrote:
>
> > Hi,
> >
> > I wanted to run the script against the Oracle server.
> > So we can collect all the hardware & software information of the
> > Oracle Server when the script runs.
> >
> > Thanks
> >
> > Lee
>
> Well, like I said: the script you provided with your first post merely
> collects the operating system and version information for the machine it
> is run on. Not exactly "all hardware" details, is it?
>
> Is there something I'm missing here?
>
> Regards
> HJR
Received on Mon Apr 26 2004 - 11:40:51 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US