The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.
COURSE of the MONTH
15 days, 7 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Batch file or VB file to gather specific server info
Posted on 2011-03-07
Hello out there,
I am needing a batch file or VB cmd to gather the below server info. Please help, my eyes are tired of looking at google. Also can this info below be gathered across the local network. I would like to run a script from one server and have it grab this info from other servers on the local network.
1. Current RAM Utilization
2. Last Reboot Date & Time
3. Free space of C:, D: and E:
And I need to know how to permanently set the "File Version" column in Windows Explorer?
I am needing a batch file or VB cmd to gather the below server info. Please help, my eyes are tired of looking at google. Also can this info below be gathered across the local network. I would like to run a script from one server and have it grab this info from other servers on the local network.
1. Current RAM Utilization
2. Last Reboot Date & Time
3. Free space of C:, D: and E:
And I need to know how to permanently set the "File Version" column in Windows Explorer?
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
-
2
4 Comments
You can gather a ton of info using the msinfo32.exe file. This file can be used to dump the information to a .txt file or .nfo file which can then be copied. So you do a simple batch file to run msinfo32.exe with the appropriate switch (example /report {Path} for a .txt report or /computer {ComputerName} for remote computer). It should be noted that this is only for use with XP, Vista, or 7.
I write this with the assumption that you are familar with batch scripting. So bascially run the exe with the appropriate switches and it will start, run the report and save it to the location you specify.
MS article about the program's switches:
http://support.microsoft.com/kb/q300887/
I write this with the assumption that you are familar with batch scripting. So bascially run the exe with the appropriate switches and it will start, run the report and save it to the location you specify.
MS article about the program's switches:
http://support.microsoft.com/kb/q300887/
Yeah.... I'm not that smart on batch files. Sorry I am however learning slowly. Could you write the script for me please. By the way how can I automate the info I need for server 2003?
PSTools (free from MS) give some very handy info
Run the command:
PSInfo -d -u Username -p Password \\RemotePcNameOrIP
and you will get:
C:\AdminTools>Psinfo.exe -d
PsInfo v1.75 - Local and remote system information viewer
Copyright (C) 2001-2007 Mark Russinovich
Sysinternals - www.sysinternals.com
System information for \\RCSHLAP02:
Uptime: 1 day 0 hours 10 minutes 41 seconds
Kernel version: Windows Vista (TM) Business, Multiprocessor Free
Product type: Professional
Product version: 6.0
Service pack: 2
Kernel build number: 6002
Registered organization: HP
Registered owner: setup
???, ???
Activation status: Error reading status
IE version: 8.0000
System root: C:\Windows
Processors: 2
Processor speed: 1.9 GHz
Processor type: Intel(R) Core(TM)2 Duo CPU T7250 @
Physical memory: 3064 MB
Video driver: Mobile Intel(R) 965 Express Chipset Family
Volume Type Format Label Size Free Free
C: Fixed NTFS 102.90 GB 1.97 GB 1.9%
D: Fixed NTFS HP_RECOVERY 7.34 GB 755.21 MB 10.1%
E: Fixed NTFS OS_TOOLS 1.55 GB 1.32 GB 84.8%
F: CD-ROM 0.0%
G: CD-ROM 0.0%
C:\AdminTools>
You can also have this save the output to a file
Run the command:
PSInfo -d -u Username -p Password \\RemotePcNameOrIP
and you will get:
C:\AdminTools>Psinfo.exe -d
PsInfo v1.75 - Local and remote system information viewer
Copyright (C) 2001-2007 Mark Russinovich
Sysinternals - www.sysinternals.com
System information for \\RCSHLAP02:
Uptime: 1 day 0 hours 10 minutes 41 seconds
Kernel version: Windows Vista (TM) Business, Multiprocessor Free
Product type: Professional
Product version: 6.0
Service pack: 2
Kernel build number: 6002
Registered organization: HP
Registered owner: setup
???, ???
Activation status: Error reading status
IE version: 8.0000
System root: C:\Windows
Processors: 2
Processor speed: 1.9 GHz
Processor type: Intel(R) Core(TM)2 Duo CPU T7250 @
Physical memory: 3064 MB
Video driver: Mobile Intel(R) 965 Express Chipset Family
Volume Type Format Label Size Free Free
C: Fixed NTFS 102.90 GB 1.97 GB 1.9%
D: Fixed NTFS HP_RECOVERY 7.34 GB 755.21 MB 10.1%
E: Fixed NTFS OS_TOOLS 1.55 GB 1.32 GB 84.8%
F: CD-ROM 0.0%
G: CD-ROM 0.0%
C:\AdminTools>
You can also have this save the output to a file
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
If you have done a reformat of your hard drive and proceeded to do a successful Windows XP installation, you may notice that a choice between two operating systems when you start up the machine.
Here is how to get rid of this:
Click Start
Clic…
When you start your Windows 10 PC and got an "Operating system not found" error or just saw "Auto repair for startup" or a blinking cursor with black screen. A loop for Auto repair will start but fix nothing. You will be panic as there are no back…
In this video, we discuss why the need for additional vertical screen space has become more important in recent years, namely, due to the transition in the marketplace of 4x3 computer screens to 16x9 and 16x10 screens (so-called widescreen format). …
- Microsoft Legacy OS
- Windows 10
- Windows 8
- Windows OS
- Windows 7
- Windows Vista, Windows XP, Windows 2000
With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…
- Windows 10
- Microsoft Legacy OS
- Windows Vista
- Windows 8
- Windows XP
- Windows OS, Windows 7, *Windows Updates, *windows update
Suggested Courses
Course of the Month15 days, 7 hours left to enroll
741 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.