Disk Quotas

We have disk quotas set on our server, each user gets 300mbs.
We have some teachers that hit their limit and need to delete some files. Is there a way to print out a list of what user's files that they own with location and size of the file.

They can save in several different locations on 1 drive, (user folder, public share, ect.) and they have no idea where **** is.

Thank You

 

Since Windows NT does not come with Disk Quota software, you must be using a 3rd party utility. I would start off by looking at the help file of that software. If you can't find it, tell us what you are using for disk quotas and we will see if we can find it.

 

I'm sorry I posted in the wrong OS. it should be in Win 2000.

Dave

 

Someone may come up with a more elegant way of doing what you want but this will work.

From the cmd window,
- do a dir on the folders you want to check and use a /Q switch which will display the file owner.
- pipe the results to a file.
- open the file using Excel or another SS that can import text files.
- sort with primary on the "file owner" col. and secondary on the path col.

This should give you a nice list of all files for a specific user and sorted by the folder they live in.

 

That doesn't quite do it. Since the Dir location isn't in a field, it doesn't sort right.

Almost : )

 

Hey, a coding challenge.

The information supplied by the above command can be modified and placed into a file of your own selection. That file could then be imported successfully into Microsoft Excel (or even Lotus 1-2-3 if you can go that far back). If no-one else out there has something that works, then I'll post something when I get it written (probably later this morning).

For a more professional report / graphical display I use a product called TreeSize Pro (URL REMOVED) - I have no connection to this organisation other than the fact that I wish I had the time to write something of this nature myself, as my current Visual basic effort fails a little short in the GUI department). This software can be downloaded as shareware, but should really be registered in the long term (by purchasing the software) but as a short term measure it will get you out to the situation you find yourself in.

Joe.

 

Well, I drafted this up for use.

The line containing (`dir c:\data\*.* /a /q /s`) needs modified for your own folder reference. Nothing spectacular just something like:

(`dir p:\*.* /a /q /s`)
(`dir p:\teachers\*.* /a /q /s`)
(`dir \\aerosmith\c$\*.* /a /q /s`)
(`dir \\aerosmith\openshare\*.* /a /q /s`)
(`dir \\aerosmith\openshare\*.doc /a /q /s`)

All of the above require you to have access to the folders specified. Nothing can be done about files that you do not have permission to access.

If you do modify the folder information above then please remember to copy the file OUTPUT.TXT which is created during the process, othewise you will over-write the previous data.

Extract the file below into a Windows NT Command Script stored within it's own directory (so all the files created / used are kept in one folder), and double click or call it from a command prompt.

Joe.

--- oooOOOooo ---

@echo off

echo.
echo File Owner, Version 01.01.00 A1
echo Copyright Joseph Kevin Robertson, 2002
echo.

del output.txt 2>1 > nul
del processed.txt 2>1 > nul

for /f "usebackq tokens=1,2,3,4,5,*" %%i in (`dir C:\Data\desktop\*.* /a /q /s`) do (
if "%%i "== "Volume" if "%%j "== "in" (
echo Reported created upon : %DATE% - %TIME%
echo Default Folder : %CD% [%%n]
call :OUTPUT HEADER
echo Processed > PROCESSED.TXT
)
if "%%i "== "Volume" if "%%j "== "Serial" (
echo Processed > PROCESSED.TXT
)
if "%%i "== "Directory" if "%%j "== "of" (
echo Processing Directory : %%k
echo Processed > PROCESSED.TXT
set FILEOWNERPROCESSINGFOLDER=%%k
)
if "%%k "== "<DIR>" (
echo Processed > PROCESSED.TXT
)
if "%%j "== "File(s)" if "%%l "== "bytes" (
echo Files Total : %%i
echo Processed > PROCESSED.TXT
)
if "%%i "== "Total" if "%%j "== "Files" (
echo Processed > PROCESSED.TXT
)
if "%%j "== "Dir(s)" if "%%l "== "bytes" (
echo Dir Total : %%i
echo Processed > PROCESSED.TXT
)
if not exist PROCESSED.TXT (
set FILEOWNERDATE=%%i
set FILEOWNERTIME=%%j
set FILEOWNERSIZE=%%k
set FILEOWNERUSER=%%l
set FILEOWNERFILE=%%m %%n
call :OUTPUT
)
del processed.txt 2>1 > nul
)

goto exit

:OUTPUT
if "%1 "== "HEADER" (
echo Application : File Owner, Version 01.01.00 A1 > output.txt
echo Copyright : Joseph Kevin Robertson, 2002 >> output.txt
echo Report created upon : %DATE% >> output.txt
echo : %TIME% >> output.txt
echo. >> output.txt
) else (
echo %FILEOWNERDATE%*%FILEOWNERTIME%*%FILEOWNERSIZE%*%FILEOWNERUSER%*%FILEOWNERPROCESSINGFOLDER%\%FILEOWNERFILE% >> output.txt
)
goto exit

:exit
rem set FILEOWNERDATE=
rem set FILEOWNERTIME=
rem set FILEOWNERSIZE=
rem set FILEOWNERUSER=
rem set FILEOWNERPROCESSINGFOLDER=
rem set FILEOWNERFILE=

 

PS. I've just re-read the Posting Rules, and can consider myself warned for the above posting for the graphical utility . Not bad for only starting this morning.