Find Jobs
Hire Freelancers

Advanced FSO folder size and insert to database

$30-50 USD

Completed
Posted about 16 years ago

$30-50 USD

Paid on delivery
I need a script which will tell me how much space each of my email users are utilising in Mega Bytes and to store the folder size to a sql database table. I will fire the script every night using scheduled tasks but I dont expect this script to induce much overhead at all. The script should be very well commented as I may need to make adjustments to it. To explain the file structure of the server, each user folder is stored in G:/[login to view URL] (pete is an example). I currently have 200 domains which are structured similar to this... G:/[login to view URL] G:/domain2_net G:/[login to view URL] In each of these folders, there is a sub folder called /users/. G:/[login to view URL] G:/domain2_net/users/ G:/[login to view URL] In each of the /users/ folder, there are subfolders with the users name G:/[login to view URL] G:/[login to view URL] G:/[login to view URL] Basically, I need the script to get the folder size of each of the individual users folders in order to check their usage. The VBS Script should do the following.. 1. Check the folder size of each user folder located in G:/[login to view URL] 2. write the folder path and folder size to a sql table as per below The VBS script would sit in the root of G: and would write the results to a remote SQL database. I would need to be able to edit the IP address and Drive Letter part of the script as I have mail servers on different ip addresses and different drives. SQL Database Schema ======================== Table name: IMAIL_USAGE Columns: ServerIP varchar(255) 'this is the server where the mail is located FolderPath varchar(1000) 'where the users folder is located (G:/[login to view URL]) FolderSize numeric(10) 'the size in MB of the users folder LastCheckDate datetime 'time stamp of the record ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables): a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment. b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request. 3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement). ## Platform VB Script
Project ID: 3784245

About the project

2 proposals
Remote project
Active 16 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
See private message.
$38.25 USD in 3 days
5.0 (1 review)
1.2
1.2
2 freelancers are bidding on average $36 USD for this job
User Avatar
See private message.
$34 USD in 3 days
5.0 (1 review)
0.0
0.0

About the client

Flag of SPAIN
Marbella, Spain
5.0
161
Member since Nov 27, 2005

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.