1
Vote

Results grid limited to 5000 rows

description

The result grid only shows 5000 lines.
 
Can it be configurable or without limit.
Configuration would be prefered to avoid system hang.
 
I discoverd it using this query and then found the same in the VLP-forum:
SELECT
ComputerName,
TimeGenerated,
SUBSTR( Message, ADD(INDEX_OF(Message, ','), 2), SUB(SUB(INDEX_OF(Message, ' owned by '), INDEX_OF(Message, ',' )), 2) ) AS PrintedFile,
SUBSTR( Message, ADD(INDEX_OF(Message, ' owned by '), 10), SUB(SUB(INDEX_OF(Message, ' was printed on '), INDEX_OF(Message, ' owned by ' )), 10) ) AS FileOwner,
SUBSTR( Message, ADD(INDEX_OF(Message, ' was printed on '), 16), SUB(SUB(INDEX_OF(Message, ' via port '), INDEX_OF(Message, ' was printed on ' )), 16) ) AS PrinterName,
SUBSTR( Message, ADD(INDEX_OF(Message, ' via port '), 10), SUB(SUB(INDEX_OF(Message, '. Size in bytes: '), INDEX_OF(Message, ' via port ' )), 10) ) AS PrinterPort,
SUBSTR( Message, ADD(INDEX_OF(Message, '. Size in bytes: '), 17), SUB(SUB(INDEX_OF(Message, '; pages printed: '), INDEX_OF(Message, '. Size in bytes: ' )), 17) ) AS FileSize,
TRIM(SUBSTR( Message, ADD(INDEX_OF(Message, '; pages printed: '), 17), SUB(SUB(STRLEN(Message), INDEX_OF(Message, '; pages printed: ' )), 17) ) ) AS PagesPrinted
FROM \srv01\System, \srv02\system
WHERE EventID = 10
 
This issue was reported by storri in the VLP-forum.
(http://groups.google.com/group/visual-log-parser/browse_thread/thread/747c76bccd23001)
 
/Anders

comments