Find Jobs
Hire Freelancers

Advanced FSO folder size and insert to database

$30-50 USD

已完成
已发布大约 16 年前

$30-50 USD

货到付款
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
项目 ID: 3784245

关于此项目

2提案
远程项目
活跃16 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
颁发给:
用户头像
See private message.
$38.25 USD 在3天之内
5.0 (1条评论)
1.2
1.2
2威客以平均价$36 USD来参与此工作竞价
用户头像
See private message.
$34 USD 在3天之内
5.0 (1条评论)
0.0
0.0

关于客户

SPAIN的国旗
Marbella, Spain
5.0
161
会员自11月 27, 2005起

客户认证

谢谢!我们已通过电子邮件向您发送了索取免费积分的链接。
发送电子邮件时出现问题。请再试一次。
已注册用户 发布工作总数
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出,请再次登录。