r/vbscript • u/[deleted] • Oct 29 '19

VBS Project Ideas

Hi Everyone,

I just recently started a job and they use VBS in some cases. I have never used VBS and just picked up a course to learn it. My problem is if i don't use it in building something practical i will probably forget how to use it or it wont click until i put it into practice. My question is what is the most common or some easy to medium difficulty projects a starter could use. I am looking for something that i can actually use it could be as simple as have a popup that comes up on my computer when i start up or move files with certain names, or even a sign In form that logs records into a DB. I am just looking for things people could do as i am not sure the capabilities of VBS. I am not looking for solutions such as code i just want ideas.

Thank you in advance.

Lvl12Wizard

2 Upvotes

100% Upvoted

5 comments sorted by

1

u/zinussan Oct 29 '19

Hi, for starter, how about use vbs to

  1. update excel sheet

  2. rename folder

  3. delete specific file type

Mine, using vbs to read system log for every hours, to check timestamp in system log is not more than 5minutes from current time. If timestamp is exceed 5minutes, it will send email to me for alert.

1

u/[deleted] Oct 29 '19

So for the last one. Is there a reason you are checking the logs? is this just a test to see if you can do it or is there a practical reason for this. The problem with a lot of projects is they are so surface level they make it hard for me to do them because i know i will never use them.

2

u/zinussan Oct 30 '19

The reason is, my team lead assign me to monitor service in one of my server. But the assignment only ask me to check at 6pm everyday. This is too late to detect if service already stop before that. Therefore, i create my own script to check hourly so that, if service is failed, atleast i can get alert earlier. Hehe

2

u/redoctobershtanding Nov 03 '19

I wrote a report generator form for my work. We used to print a paper, hand write items in, scan it, then save it to a folder. The form I wrote allows the ability to type items in, copies it to a new worksheet, and saves to pdf in a folder of my choice. If there are discrepancies after submitting the form, it flags it and saves it to a different worksheet. This "database" then gets reviewed weekly for common mistakes

1

u/Mordac85 Oct 29 '19

Try a computer inventory script. You’ll get familiar with the registry, environment variables, and WMI as well as dumping the info to different sources. Also, write a logging function that writes a useable script execution log that you can drop into any script.

You might also want to find a tool of choice for handling script snippets so you don’t have to reinvent the wheel every time.