Script to determine how much ram - KiXtart.org - official site

You are not logged in. [Log In] KiXtart.org website » Forums » KiXtart » Basic Scripting » Script to determine how much ram

Page 1 of 1

1

Topic Options

#175093 - 2007-03-30 01:12 AM Script to determine how much ram
jeremyschubert jeremyschubert Getting the hang of it Registered: 2005-09-17 Posts: 89	I have a lab with 32 machines running 2K. Can I use kix to write a script that will export the following data to a spread sheet or text file: -netbios name or serial number of computer -how many slots there are to hold RAM -how much memory is in each slot. Or would it be better to use VBScript (how dare I mention that posibility here ) to complete this task? Thanks, Jeremy _________________________ --- Bishop Grandin Technology Department 'Either we're on time, or we're late'
Top

#175102 - 2007-03-30 03:48 PM Re: Script to determine how much ram [Re: jeremyschubert]
Glenn Barnas Glenn Barnas KiX Supporter Registered: 2003-01-28 Posts: 4401 Loc: New Jersey	"Yes!" You could probably use one of the WMI interfaces, such as WMIQuery(), to gather the data. KixOMatic would be helpful to determine the WMI objects of interest (and verify they are supported on your hardware). You can use the CSV() function I published to write CSV formatted files - load each record of data into an array, then simply use something like this: Code: $ = RedirectOutput('inventory.csv') CSV($DataRecordArray) @CRLF $ = RedirectOutput('') in a loop to write each data record. .CSV files can be directly opened by Excel. I turn on/off redirection here so I can output status messages to the screen outside this part of the loop.. this isn't necessary. I've also published an XLlib UDF - it consists of several individual functions that directly manipulate Excel workbooks. With that, you could update your worksheets directly. There are also UDFs that interface with Access or SQL. Glenn _________________________ Actually I am a Rocket Scientist! $\:D$
Top

#175118 - 2007-03-31 01:14 AM Re: Script to determine how much ram [Re: Glenn Barnas]
jeremyschubert jeremyschubert Getting the hang of it Registered: 2005-09-17 Posts: 89	Thanks Glenn, I will Google kixomatic. Is that another form of Kix like kixforms? Or a UDF of sorts? Jeremy _________________________ --- Bishop Grandin Technology Department 'Either we're on time, or we're late'
Top

#175119 - 2007-03-31 01:22 AM Re: Script to determine how much ram [Re: jeremyschubert]
Gargoyle Gargoyle MM club member Registered: 2004-03-09 Posts: 1597 Loc: Valley of the Sun (Arizona, US...	Or you can just get it from here http://www.kixtart.org/forums/ubbthreads...true#Post128017 _________________________ Today is the tomorrow you worried about yesterday.
Top

Page 1 of 1

1

Previous Topic

Previous Topic View All Topics

View All Topics

Index Next Topic

Next Topic

Moderator: Jochen, Allen, Radimus, Glenn Barnas, ShaneEP, Ruud van Velsen, Arend_, Mart

Hop to:

Shout Box

Who's Online

0 registered and 1574 anonymous users online.

Newest Members

BeeEm, min_seow, Audio, Hoschi, Comet
17882 Registered Users

Generated in 0.065 seconds in which 0.036 seconds were spent on a total of 13 queries. Zlib compression enabled.

click tracking