VB and SMS Stuff

Here are VB things that I have assembled/written. Bugger all error checking, but they do work in a limited kind of fashion. Feel free to download and take apart, do what you like with it really.  All tested on Windows NT and seem to work fine on W2K as well.

None of it is anything mind-blowing, but it was useful to me :) If you want to email me about anything on here, you can by using "develop" at my domain name.

VB Stuff

FindFiles

This was used to perform a scan for document files on a workstation, then report it all back to a share on a server. Program was written because the workstations were win9x without any kind of file/print sharing so we needed something to drop into the login script. Would be nice to change it to write the entire file locally, then copy it up.. Wasn't a problem with our environment size though so wasn't done! The program will basically look for data files such as .doc, .xls, .zip, .txt etc and put it all into a file. Useful for doing a migration.

writedata

This wrote the data in the share (created for findfiles above) into an Access database so that reports can be created. The table was pretty simple and you should be able to work out the structure from the code.

sendmail

This program would read the data from the database, and send an email to each user telling them which files they have. slight problem removing the duplicate users (because the data is not normalised), but works pretty well. This, and the above two all work together really...

dirlisting

Ever need to print out a list of all files of a certain type (doc, xls, exe, etc) in a directory and all subdirectories? This program will let you enter an extension and then prints the output (to a printer). Also records the list in a file in the temp directory. The new version will also display the last accessed date of the files. This is of course dependent on what the OS reports it to be and seems to work best over network connections! Useful for working out what how many word documents (for instance) you have in a shared drive.

Password Reminder

Have laptop users who spend most of time dialing in, and you spend most of your time unlocking their accounts because of expired passwords? Well, install this on the laptop. It will grab the date of the next required password change (expiry date) for the current user and store it in the registry (HKCU). Next time the computer is restarted, it will check the expiry (warn if necessary), and try and grab an updated date. If the machine is not on the network, it will sit in the background and check periodically to see if it comes on. If the machine does go onto the network, it will check for a new expiry date and act accordingly.

GALIMPORT12.ZIP

An application written in VB that can be used for taking an export.csv file from the Microsoft Exchange Admin program, and automatically cleaning it up (sorting out the SMTP addresses, removing columns) to prepare it for import as custom recipients.. Will also import it into the container of your choice if you are brave. Just make sure you run it on a test box first! Made for Exchange 5.5.

SMS Stuff  

(Systems Management Server)

generic.ipf

LOGON.IPF

An IPF that was written to be placed in the logon script to give you a record of all workstations that logon (well, using a logon script anyway). Watch out for file contention though. If you are implementing this into anything other than a small site, you should change it so that it writes to multiple files. Perhaps one per department. Otherwise the file seems to get overwritten!

quickrt.zip

A small VB app that will let you use remote tools and bypass the "permission required" setting. If you wanted to, you could also include remote.exe and support files so that you wouldn't need the admin console.

CLIINST.IPF

This can be used to create a client installation request for a list of workstations in a text file. You will need rci (remote client installation) turned on on the SMS site.

IESETUP.IPF

A fairly bog standard IPF for installing Internet Explorer via SMS.

Pocket PC Stuff  

random.zip

Asks you for an upper and lower number range, and puts the numbers in a random order. Useful for christmas raffle draws etc :) Written in eVB for the PPC2002 OS. the list will contain all numbers within the range but without duplicates. The code could easily be compiled for VB6. Would also work as a dice simulator or virtual dice I suppose! If you were desperate!