Hi All,
I tried to create a .bat file(attached) to show list of QlikView QMC reports running between 5am to 5:30am, because the CPU consumption is high during that time.
The script I've written :
@Echo off
echo Reports running between 5:00 AM and 5:30 AM:
echo --------------------------------------------
REM Replace the following path with the actual path to your QlikView QMC logs
set "LOG_PATH=C:\ProgramData\QlikTech\ManagementService\QVPR\Test\QVManagementService.log"
REM Extract relevant log entries for the specified time range
findstr /c:"[05:00:" /c:"[05:01:" /c:"[05:02:" /c:"[05:03:" /c:"[05:04:" /c:"[05:05:" /c:"[05:06:" /c:"[05:07:" /c:"[05:08:" /c:"[05:09:" ^
/c:"[05:10:" /c:"[05:11:" /c:"[05:12:" /c:"[05:13:" /c:"[05:14:" /c:"[05:15:" /c:"[05:16:" /c:"[05:17:" /c:"[05:18:" /c:"[05:19:" ^
/c:"[05:20:" /c:"[05:21:" /c:"[05:22:" /c:"[05:23:" /c:"[05:24:" /c:"[05:25:" /c:"[05:26:" /c:"[05:27:" /c:"[05:28:" /c:"[05:29:" ^
/c:"[05:30:" "%LOG_PATH%"
echo --------------------------------------------
pause
Could you please help me to get the correct script to show the lists as well as the % of CPU consumptions in excel? and i will get the same in email.
Thanks.
Regards,
Ranjana
