Subscribing is a smart move!
You can subscribe to this forum after you log in or create your free account.
Geo SCADA Knowledge Base
Access vast amounts of technical know-how and pro tips from our community of Geo SCADA experts.
Originally published on Geo SCADA Knowledge Base by sbeadle1 | June 10, 2021 01:01 AM
SELECT TOP( 50 ) RECORDCOUNT AS "_RECORDCOUNT", FORMATVALUE( RECORDCOUNT / 40320.0 * 100.0 USING '0.00' ) || '%' AS PERCENTRATEDMAXSIZE, 'Hd' || 'I' || FORMATVALUE( ( OBJECTID / 256 ) USING '00000' ) || '\' || FORMATVALUE( OBJECTID USING '000000' ) || '\WK' || FORMATVALUE( GRANULE USING '0000000' ) || '.HRD' AS RELATIVEHISTORICPATH, OBJECTID AS OBJECTID, STARTTIME AS PERIODSTARTING, FORMATVALUE( ( ( RECORDCOUNT * 32 ) / 1024.0 ) USING '0' ) || ' KB' AS FILESIZE, CDBPOINT.FULLNAME, CDBPOINT.IDFROM CDBHISTORICFILE LEFT JOIN CDBPOINT ON CDBHISTORICFILE.OBJECTID = CDBPOINT.IDORDER BY "_RECORDCOUNT" DESC
SELECT TOP( 50 ) RECORDCOUNT AS "_RECORDCOUNT", FORMATVALUE( RECORDCOUNT / 6825.0 * 100.0 USING '0.00' ) || '%' AS PERCENTRATEDMAXSIZE, 'Jn' || 'I' || FORMATVALUE( STREAM USING '00000' ) || '\H' || FORMATVALUE( GRANULE USING '0000000' ) || '.HRD' AS RELATIVEHISTORICPATH, CAST( ( STREAM * 256 ) AS STRING ) || ' - ' || CAST( ( ( STREAM + 1 ) * 256 - 1 ) AS STRING ) AS OBJECTIDRANGE, STARTTIME AS PERIODSTARTING, FORMATVALUE( ( ( RECORDCOUNT * 768 ) / 1024.0 ) USING '0' ) || ' KB' AS FILESIZEFROM CDBEVENTFILEORDER BY "_RECORDCOUNT" DESC
SELECT MIN( STREAM ) AS "STREAM No.", COUNT( RECORDCOUNT ) AS "TotalFiles", SUM( RECORDCOUNT ) AS "TotalRecords", SUM( CASE WHEN RECORDCOUNT > 7500 THEN 1 ELSE 0 END ) AS "7500 plus", SUM( CASE WHEN RECORDCOUNT > 15000 THEN 1 ELSE 0 END ) AS "15000 plus", SUM( CASE WHEN RECORDCOUNT > 30000 THEN 1 ELSE 0 END ) AS "30000 plus", SUM( CASE WHEN RECORDCOUNT > 60000 THEN 1 ELSE 0 END ) AS "60000 plus"FROM CDBEVENTFILEGROUP BY STREAMORDER BY "STREAM No." ASC
SELECT MIN( FORMATVALUE( STARTTIME USING 'YYYY-MM-dd' ) ) AS "Date", COUNT( RECORDCOUNT ) AS "TotalFiles", SUM( RECORDCOUNT ) AS "TotalRecords", SUM( CASE WHEN RECORDCOUNT > 7500 THEN 1 ELSE 0 END ) AS ">7500", SUM( CASE WHEN RECORDCOUNT > 15000 THEN 1 ELSE 0 END ) AS ">15000", SUM( CASE WHEN RECORDCOUNT > 30000 THEN 1 ELSE 0 END ) AS ">30000", SUM( CASE WHEN RECORDCOUNT > 60000 THEN 1 ELSE 0 END ) AS ">60000"FROM CDBEVENTFILEGROUP BY FORMATVALUE( STARTTIME USING 'YYYY-MM-dd' )ORDER BY "Date" ASC
:bof@echo off & setlocal enableextensionsREMREM Recursively finds all files larger than a specified number of bytes within a specified path.REMREM Usage:REM findlarge.bat "" REMREM Example 1:REM findlarge.bat "c:\Database\Historic" 2097152REM Example 2:REM findlarge.bat "c:\Database\Historic" 2097152 > output.txtREMREM:init for /f "tokens=*" %%f in ('dir "%~1" /b /s /o-d') do ( if %%~zf GEQ %~2 echo %%~zf - %%~ff ) endlocal & goto :end:end
C:\utilities\findlarge>findlarge.bat "c:\Users\All Users\Control Microsystems\ClearSCADA\Database\History" 20971525047040 - c:\Users\All Users\ControlMicrosystems\ClearSCADA\Database\History\Historic\HdI000017325184- c:\Users\All Users\ControlMicrosystems\ClearSCADA\Database\History\Historic\HdI00000
Directory of C:\ProgramData\Schneider Electric\ClearSCADA\Database\History\Historic\HdI00000\00004003/05/2015 01:44 PM.03/05/2015 01:44 PM ..10/08/2014 10:27 AM 160 WK021589.HRD03/05/2015 01:43 PM 32 WK021610.HRD 2 File(s) 192 bytesDirectory of C:\ProgramData\Schneider Electric\ClearSCADA\Database\History\Historic\HdI00000\00004910/08/2014 10:18 AM .10/08/2014 10:18 AM ..10/08/2014 10:17 AM 96 WK021589.HRD 1 File(s) 96 bytes
C:\> forfiles /P "ProgramData\Schneider Electric\ClearSCADA\Database\Journal" /S /D +01/03/2015 /C "cmd /c echo @path,@fsize" > JournalFilesSince0103215.csv
Create your free account or log in to subscribe to the forum - and gain access to more than 10,000+ support articles along with insights from experts and peers.