Server Newsgroups: Scripting for Windows Server

skipping blank field in excel

hi.seth_(g)mail - 4 Mar 2006 11:19 PM - 2 messages

Sometimes I get a field thats blank in excel. Instead of putting something in the field, how do I tell the script to skip blank fields and go to the next field? Here is what I have so far: ' UpdateUserProfile2.vbs ...

formating the output of a script

Lee Collison - 4 Mar 2006 8:57 PM - 3 messages

I have a script that will gather information that I need when performing system audits and it pushes it to a word document that I really like. What I would like to be able to do is format that out put so that certain lines are ...

syntax coloring for MSH

klumsy - 4 Mar 2006 5:05 AM - 12 messages

is there any standard, or convetion for syntax coloring for MSH? do people have any ideas of what they thing would be good. as for myself, this is what i am thinking (some of the following "certian colours may end up being the same) ...

[MSH] - Control over name suffix for MSH scripts?

Alex K. Angelopoulos - 4 Mar 2006 1:47 AM - 3 messages

From what I can see in the current MSH release (1.0.7487.0), a script hosted by msh.exe - even a custom build - can only use a .msh extension. There may be security reasons behind this, but the fact that this extension ...

[msh]get-content of large files.

Dung K Hoang - 3 Mar 2006 9:46 PM - 18 messages

Hi, I notice that when you use the cmdlet get-content on large files, it takes some times before seeing output on the console. I also observe that during the excution of the command, the virtual memoery used by the process msh.exe can augment up to 300% and this virtual memory ...

[MSH] small error in "help copy-item"

forestial - 3 Mar 2006 5:30 PM - 2 messages

Type "help copy-item". The decription of the parameter "-Path" says in part: PARAMETERS -Path System.String[] The path to the item(s) that are to be cleared. The word "cleared" should read "copied" ...

execute command and close the cmd window

Jrex7 - 3 Mar 2006 3:25 PM - 3 messages

Does anyone know how to run a command from a batch file and continue executing the next command without waiting for the first command to finish. Here's what I am tryint to do. I have a batch file that tries to connect to ...

Password Change Notification Mail By VBScript.......

Achintya Bhar - 3 Mar 2006 3:13 PM - 2 messages

Hello, I am having Windows 2003 Active Directory where Exchange 2003 is installed. Very recently i have implemented password policy organization wide where users required to be changed their password within 30 days otherwise their password will be expired and they will not be able to access their mailbox. ...

Script error

Kelly - 3 Mar 2006 12:18 PM - 3 messages

Hi all, I created this script ,to make network mapping if a customer belongs to a group in Active directory. But it does not work to me and they give this error to me. Set oNet = Wscript.CreateObject("Wscript.Network") ...

question about Excel object... (how to save but overwrite)

SixHouse - 3 Mar 2006 11:15 AM - 6 messages

i run a script that writes output to an excel spreadsheet. im using the saveAs method to save the spreadsheet when im done but if the file already exists i get a prompt asking me if i want to overwrite. since i always will ...

Remote Mappings

SubnetJO - 3 Mar 2006 9:48 AM - 2 messages

Hi All. I need to retrieve the network mappings on remote computers. In vbscript I can use WMI classes as Win32_MappedLogicalDisk or better Win32-LogicalDisk but... there is a great problem. These methods don't work! What I want is to know if a user, on his worstation has a mapping associated ...

Remotely configuring user accounts

Bob - 3 Mar 2006 2:20 AM - 5 messages

Hi I have an environment where I have a number of computers (Win2000 Pro) connected to a domain (so I can do remote administration on them). Each of these computers has a user defined in the "local" security accounts ...

custom hosts an suspend.

klumsy - 2 Mar 2006 7:25 PM - 3 messages

i've finally created a runspace that uses my own MSHhost, and all is going well, except i'm not sure how to deal with Suspend. what sort of stuff should i put inside of public override void EnterNestedPrompt() and exit? ...

[MSH] Problem with clear-host cmdlet

Vinicius Canto - 2 Mar 2006 7:06 PM - 9 messages

Hello guys, I've been testing the beta 3.1 of Monad and the auto-completion feature doesn't work with clear-host command. I tried type 'clea' and press TAB key, but nothing was completed in console. Is there a bug? ...

Add Users to Security Groups

motko - 2 Mar 2006 5:50 PM - 7 messages

I've been using a script to create multiple security groups from an Excel spreadsheet. I'd like to add the ability to add users to these groups as they are created utilizing the same script, pulling the user names from the ...

[MSH] clear-host

Vinicius Canto - 2 Mar 2006 5:28 PM - 6 messages

How to make a keyboard shortcut to cls (clear-host) like the most unix shells, that cleans the screen automatically when a user type Ctrl+L? Sorry about my poor English... Thanks, ...

I got Access Denied (SWbemObjectEx) when I use Put_ Method.

a.guarischi - 2 Mar 2006 3:49 PM - 2 messages

Hello, I can't get out of this problem. My goal is to automate installation of printers to Windows XP Client. Do do this i made up a .vbs script and I know, to access and use WMI in write mode, the user, or the process should ...

Running vbs from Cygwin

Paul Hughes - 2 Mar 2006 3:27 PM - 7 messages

Hello, I'm opening a ssh connection from a Linux box to our Windows Server 2003 which then initiates a Cygwin terminal. I then try and run a vbs script that opens Word to convert documents from Word to PostScript. ...

When Idle?

MarcusB - 2 Mar 2006 1:38 PM - 2 messages

I need a script which will check if loged in user is active or idle (no touching mouse or keybord for some minutes). MarcusB ...

[MSH] audit parameter on get-acl

Luis Abreu - 2 Mar 2006 12:13 PM - 12 messages

hello guys. hum...after looking at the help for the get-acl cmdlet, i got under the impression that i could use the -audit parameter to get a list with the auditions made over a specified item. by looking at the docs, it seems like it accepts a ...

OR command

James - 2 Mar 2006 8:21 AM - 2 messages

i m using ifmember. Is there a way to do a "OR" command ? eg ifmember of globalgrp A OR ifmember of globalgrp B 'map net use paths. ...

getting $mshhome and other provider details from C# (when hosting monad)

klumsy - 2 Mar 2006 8:16 AM - 7 messages

i am wondering if there are any classes and methods by which i can get $mshhome value from C#, without having to make a pipeline and passing $mshhome in? but furthermore. where i am heading, is to be able to query a provider ...

[MSH] MSH and WinPE

Jeremy Pack - 2 Mar 2006 5:32 AM - 3 messages

Is anyone able to tell me the plans for Monad and WINPE? (You not going to force me to go back and write vbs are you?) Given that Monad appears to be layered on the .Net Framework which does not ...

Find MDB Files on a server

OldDog - 1 Mar 2006 9:25 PM - 2 messages

Hi, I use this sub to locate all the MDB files on a given server. It works , but, I would like to exclude a few sub-directories from the search. Any ideas how to do that? '__________________________<begin Sub>__________________________ ...

Would like help on Perl script to print to windows printer, or printers, please

Brainwave Surfer - 1 Mar 2006 8:12 PM - 4 messages

Dear all, I have an Active State Perl program that can print to LPT1: as a straight ASCII text printer.. However, it will not print on a co-worker's computer. I can put up the code if anyone is willing to help out, or give pointers ...

Export-Csv does not accept Add open mode

oka326 - 1 Mar 2006 5:21 PM - 5 messages

Hello, Executing the following commands cause an erorr: MSH> $log = combine-path (pwd) 'history.log' MSH> h -Count 1 | select Id,StartExecutionTime,CommandLine | ex port-csv -Path $log -OpenMode Add -Encoding utf8 export-csv : Cannot validate argument "Add" because it does not belong ...

Edit NTFS security with VB script

Hans Sleurink - 1 Mar 2006 3:17 PM - 4 messages

I have a script (it's a long one so I will not post it here), that searches a certain directory and then edits all subdirectories. It adds a domain group with Full Control to each subdirectory. If I check the NTFS tab after it has ...

Script does not capture qwinsta output correctly

Spin - 1 Mar 2006 2:36 PM - 5 messages

Scripting experts, The below script developed by Michael Harris (thanks Michael) some years back worked great for getting a snapshot of the current active and disconnected users on a Terminal Server. What's happening though is inside the logfile (which does get created successfully), even though active and ...

Using HTA to add user to multiple groups

Karl Stringer - 1 Mar 2006 12:49 PM - 4 messages

I haven't had that much experience of scripting but I recently put together an HTA to create user accounts in a Windows 2003 Active Directory Domain. It can create accounts, set passwords, select an OU from a drop-down list etc, just fine but I've run into a problem when ...

function pointer to a commandlet.

klumsy - 1 Mar 2006 8:33 AM - 3 messages

i want to know the syntax for making a function pointer to a commandlet ie. $a = clear-host will just clear the host, and not put a functional "pointer" to it.. the reason i ask is i am making a function like this ...

TAB completion scenarios in monad

klumsy - 1 Mar 2006 8:31 AM - 2 messages

can people help me with listing the complete list of tab completion that happens in monad. I am planning to add tab completion (and intellisence to MSH analyzer) and what to start but mimicing monads imbuilt behaviour. from what i see here are the following scenarios i have seen ...

CSV line (tokens) to Variables...

tbader01 - 1 Mar 2006 4:39 AM - 3 messages

Hello, I have hit a wall and can't figure out how to do this! How can I take a text line such as: a,b,c,d,e,f,g,h,i,j,k,l,m,n,o,p,q,r,s,t,u,v,w,x,y,z ...

Script that determines Terminal Server Active & Disconnected users

Spin - 1 Mar 2006 2:44 AM - 3 messages

Scripting experts, The below script developed by Michael Harris (thanks Michael) some years back works great for getting a snapshot of the current active and disconnected users on a Terminal Server. Funny thing thoughm if I change line 2 in anyway (altering the log file location, the script bombs out for ...

[MSH] Finding Modules in a Process That Have Been Rebased

Keith Hill [MVP] - 1 Mar 2006 12:48 AM - 7 messages

This topic is important to developers because it affects the load time of an application. The more modules that require rebasing by the OS loader, the longer it takes to load an application. In this blog article: [link] ...

Search security logs for specific event

Regina - 28 Feb 2006 9:09 PM - 4 messages

Does anyone of or have a script that will search the security event logs for a specific event ID? Event ID 628. More specifically I'm looking for information on how I can pick up event ID 628, the target account name and ...

Monad question

J Ford - 28 Feb 2006 8:06 PM - 9 messages

Can you utilize monad to rename a computer on a domain similar to that of netdom? Without using netdom that is... Thanks Jeremy ...

Set System Timezone and Time on Windows logon

Anukul - 28 Feb 2006 7:48 PM - 3 messages

Hi All: I am looking for a solution to set the Windows system Timezone and Time when the user logons on the network. All systems are a part of the domain network. I want to change the TimeZone and Time based on the timezone and time set on a Server on my network. ...

winnt usage reference

Abraham Andres Luna - 28 Feb 2006 6:50 PM - 3 messages

hello everyone, i found a script that shows me how to pull group and user info using winnt: Set objUsr = GetObject("WinNT://Computer/UserName,user") or Set objGrp = GetObject("WinNT"//Computer/GrpName,group") is there a reference available for the winnt objects returned i can read up ...

Compiler for WSH

Marios Andreas Tofarides - 28 Feb 2006 3:29 PM - 2 messages

Hello all, I haven't noticed anything like that, but I would like to ask whether there is a way to create an executable file from a .vbs script Thanks in advance, Marios ...

WMI on a user with no administrative access

Marios - 28 Feb 2006 10:28 AM - 2 messages

Hello all! I'm trying to run the following script, which assigns a static IP address: ---------------------------------------------------------------------------------- strComputer = "." Set objWMIService = GetObject("winmgmts:" _ & "{impersonationLevel=impersonate}!\\" & strComputer & "\root\cimv2") Set colNetAdapters = objWMIService.ExecQuery _ ("Select * from Win32_NetworkAdapterConfiguration where IPEnabled=TRUE") ...

IsFolder

rupart - 28 Feb 2006 6:02 AM - 3 messages

Guys, Is there "Isfolder" function in vbs? I want to find out whether the files that i am enumerating is a folder or file. Can anyone point me to an example? TIA ...

Scalability of the add-member cmdlet.

Dung K Hoang - 28 Feb 2006 12:55 AM - 2 messages

I observe some strange behavior with the add-member cmdlet and would like to get your ideas on this issue. Basically, I have a script that creates MSH objects and add new propeties to the objects using the add-member cmdlet. ...

help with scripting AD attribute change

SixHouse - 27 Feb 2006 7:02 PM - 3 messages

Hi everyone. on an AD user object, on the security tab (security > advanced in 2003) i need to check the "Allow inheritable permissions from parent to propagate to this object" box on ALL users in my domain... any ideas? i cant even locate ...

[FYI] MSH Beta 3.1

Jean - 27 Feb 2006 4:45 PM - 11 messages

Windows "Monad" Shell Beta 3.1 (for .NET Framework 2.0 RTM) x86 [link] Windows "Monad" Shell Beta 3.1 (for .NET Framework 2.0 RTM) AMD64 ...

[MSH] Send email

Yimin Wei - 27 Feb 2006 3:42 PM - 9 messages

I used this script to send email and it worked quite well under beta 1. However, I tested it under beta 2 and beta 3 and it didn't work any more. Does anyone use MSH to send email? Yimin ...

Creating a hyperlink in Excel ss using vbscript

jbruns - 27 Feb 2006 3:10 PM - 5 messages

Does anyone have an example of how to simply create a hyperlink in a cell in an Excel ss? I know it uses ActiveSheet.Hyperlinks.Add method but I am having trouble understanding the syntax. Thanks in advance ...

Enumerate local group members

Vittorio Pavesi - 27 Feb 2006 8:01 AM - 3 messages

Do anybody know hot to list the members of a local group ? I would like to monitor the list of users present into the Administrators Group. Thanks Vittorio Pavesi ------------------------ [link] ...

[MSH] WMI Put_ how?

Jeremy Pack - 27 Feb 2006 6:06 AM - 5 messages

Get-WMIOBJECT is great but set-wmiobject appears to be missing. So could one of you Monad Gurus please hint at how WMI's put can be used from Monad. For example I want to create a printer in VBscript: ...

HTA Msgbox question

TomKing - 27 Feb 2006 1:50 AM - 5 messages

I have put delete user function in my hta. It's working. But in order to prevent accidently deleting a user. I want to put some warning message like a message box says "Do you want to delete this user?". Then you can click "Yes" ...