All Tags >
FS input format (
RSS)
Sorry, but there are no more tags available to filter with.
-
It might take a long time to recurse a whole volume, but here it is: SELECT RootPath , SUM(Size) AS TotalSize USING EXTRACT_PREFIX(EXTRACT_PATH(Path), 1, '\\') AS RootPath FROM C:\* WHERE Name NOT IN ('.'; '..') GROUP BY RootPath WITH ROLLUP Note that the EXTRACT_PREFIX number must match the number of...
-
Just wondering if there is a way to expand upon this and get the size of a top level of folders on a volume. Thanks, Floyd
-
Just a thought : you could also look at WMI (Windows Management Instrumentation) http://msdn.microsoft.com/library/en-us/wmisdk/wmi/wmi_tasks__disks_and_file_systems.asp ...determine how much free space is available on a drive Use the Win32_LogicalDisk class and the FreeSpace property. strComputer =...
-
Sorted it!!! Iwas referencing the wrong COM object (iCOM instead of COM) Works a treat now
-
I am having a problem in an app i am working on at the moment which looks at remote directories and dumps the name, last access date size etc of user home areas to a datagrid......I am using the logparser.dll in an ASP.net page and when i use a local machine path ( \\LocalHost\sharename ) in the SQL...
-
[QUOTE User="LogParser User : Parser Phenatic"]Quote: Is it possible to do a graph to show the free space of a disk. I tried using logparser "Select sum(size), sub(29528752128,sum(size))INTO disk.gif FOM d:\*.*" -i:FS -o:chart -chartType ie But get a ...[/QUOTE] First of all I am assuming it was a typo...
-
Is it possible to do a graph to show the free space of a disk. I tried using logparser "Select sum(size), sub(29528752128,sum(size))INTO disk.gif FOM d:\*.*" -i:FS -o:chart -chartType ie But get a error stating d:\system volume information: Access is denied.
-
Does anyone know a way to take the output from a tool like "showacls" and use Log Parser? Format for tools like CACLS and SHOWACLS look something like this: Path Group/User Rights Example: C:\ BUILTIN\Administrators Full Control [ALL] NT AUTHORITY\SYSTEM Full Control [ALL] CREATOR OWNER Special Access...
-
I got it. I just have to set the attribute equal to D--------.
-
Can I use LogParser to generate a report of only the folders in a directory tree?