Find Jobs
Hire Freelancers

Advanced FSO folder size and insert to database

$30-50 USD

Slutfört
Publicerad ungefär 16 år sedan

$30-50 USD

Betalning vid leverans
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

Om projektet

2 anbud
Distansprojekt
Senaste aktivitet 16 år sedan

Ute efter att tjäna lite pengar?

Fördelar med att lägga anbud hos Freelancer

Ange budget och tidsram
Få betalt för ditt arbete
Beskriv ditt förslag
Det är gratis att registrera sig och att lägga anbud på uppdrag
Tilldelad till:
Använd avatar
See private message.
$38,25 USD Om 3 dagar
5,0 (1 omdöme)
1,2
1,2
2 frilansar lägger i genomsnitt anbud på $36 USD för detta uppdrag
Använd avatar
See private message.
$34 USD Om 3 dagar
5,0 (1 omdöme)
0,0
0,0

Om kunden

Flagga för SPAIN
Marbella, Spain
5,0
161
Medlem sedan nov. 27, 2005

Kundverifikation

Tack! Vi har skickat en länk för aktivering av gratis kredit.
Något gick fel med ditt e-postmeddelande. Vänligen försök igen.
Registrerade Användare Totalt antal jobb publicerade
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Laddar förhandsgranskning
Tillstånd beviljat för geolokalisering.
Din inloggningssession har löpt ut och du har blivit utloggad. Logga in igen.