Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
PC performance checkup script?
Anyone have a nice script that will report some common config issues / problems that might affect pc performance? I am thinking vbs version of PCPitstop or some similar tool. -
Creating data in a columnar fashion inside a scollable table
Don't reinvent the wheel: http://www.microsoft.com/technet/scriptcenter/topics/activex/spreadsheet.mspx :) -
search for shortcut in a particular folder based on comment property
Actually you can insert a comment/description via script. I want to search for a particular shortcut based on its comment/description property. Heres how to set the commen/description property,took forever to work this out but heres how: Dim objShell, strPath Dim objShortcut Set objShell... -
search for shortcut in a particular folder based on comment property
Hi all, I think this is a tough one. I need to search for shortcuts in a particular folder, based on the comment in the properties of the shortcut (right click shortcut, select properties). Is that possible? I found a WMI script on MS scripting site that allows me to enumerate every shortcut on... -
select top X where X is based on a percentage of records
Hi all. I am trying to build a list that consists of 10% of every machine model I have in a database. I have no idea how to do this, I got started with this: -- select distinct(model0), count(model0) as counted, round((count(model0)*.10),0) as test_counts from v_GS_COMPUTER_SYSTEM where model0...- WiccaChic
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Programming
-
copy all subfolders and contents to another directory
Anyone have a script to copy an entire directory structure and all of its contents? I need to copy every folder under directory /dir1 to /dir2 and I am at a loss. OS = AIX 5.2- WiccaChic
- Thread
- Replies: 4
- Forum: UNIX Scripting
-
help! need to read the eventlog in a script, but it refuses to work...
Hi all. Keep getting the following error on WinXP boxes as well as my Win2000 servers whenever I try to use vbs to read the event log: " ActiveX component can't create object: 'GetObject'" Heres the code I am using: <html> <head> <title>OpLets v1.0</title> </head> <body> <script... -
desperate - script to remove IPX from network card config?
Anyone have a script that will remove IPX from a pcs network card config? Please help!!! -
lots of page faults - whats that mean?
Recently started monitoring my SQL server with perfmon and I am seeing page faults running at 100% almost all the time. Can someone explaing to me what that indicates performance wise?- WiccaChic
- Thread
- Replies: 3
- Forum: Microsoft SQL Server: Setup and Administration
-
math in awk (or something?!?!)
Hi all. I am using the following to get the starting line number of some info in a log: date +"%a %b %e"|xargs -i grep -n {} /u/informix/online.log|tail -n 1|cut -f 1 -d :|xargs -i more -p {} /u/informix/online.log I want to take the resulting number and subtract it from the total number of...- WiccaChic
- Thread
- Replies: 1
- Forum: UNIX Scripting
-
AIX korn shell debugging
Is there a way to debug ksh scripts? I am thinking I saw someone do this long ago, and you could see each command before it executed, but I dont know how to do it.- WiccaChic
- Thread
- Replies: 3
- Forum: UNIX Scripting
-
Script to help change passwd in AIX
I have been told several times it woudl require a C program to do this. Maybe someone will come up with something new here, I would like to be able to do this (not just for ROOT) as well. -
SSA D40 hardware fit in a standard server rack?
Do you know if the SSA D40 disk drawer will fit into a standard server rack - say like a Compaq rack? Maybe it will fit, but is there some other detail about that drawer that shuold make me NOT want to install it as such? -
vbs ping output to HTML for nice display
Seen lots of examples of ping scripts to test if a server is up. I was wondering if anyone had gone one step further and used the output from such a script to update an HTML page so you could have a GUI view of whether a list of servers is up...maybe color-coded! -
script needed to check for logical volume mirroring
Hi all. Can someone donate a script? We do logical volume mirroring and I would like to have a fast way to verify all of our logical volumes are mirrored. This is necessary because we have a database that uses raw devices and we frequently have DBAs creating raw space/LVs for the database and... -
wait hint with cursor?
Is it possible to use a wait hint in a select done via cursor? Please no "dont use cursors" posts, I didnt write the code and I am just trying to help a developer.- WiccaChic
- Thread
- Replies: 1
- Forum: Informix solutions
-
prevent all users except one or two accounts from logging in
Thanks for the answers! I really like your idea Ken, thanks! -
where are stored procedures stored?
How can I see the code for a stored procedure?- WiccaChic
- Thread
- Replies: 2
- Forum: Informix solutions
-
how to ID all dbspaces that make up a database for restore purposes
Hello all. I sure hope someone here can help me because informix support did not seem very interested in my question. I have two systems running informix, one system A has much more storage space on it than the other (system B!). I have two databases in the same instance on system A and I want...- WiccaChic
- Thread
- Replies: 1
- Forum: Informix solutions
-
prevent all users except one or two accounts from logging in
Hi all. I know I can create a "nologin" file in /etc that will prevent everyone but root from logging on. Is there a way I could prevent everyone but root and one other account from logging on? I have a need to allow the primary account for my informix database to login as well as root when I...
