10.9.1 Operating daily import of HIBUN logs
You can examine daily HIBUN logs reported from client PCs by importing them into the JP1/IT Desktop Management 2 operation log. The following procedure shows an example of operating these logs.
To operate the logs:
-
Create a shared folder on the JP1/IT Desktop Management 2 management server, so that the HIBUN log relay server can access the folder.
-
On the HIBUN log relay server, use the Windows Task Scheduler to execute HIBUN commands on a regular basis to output HIBUN logs in CSV format.
The logs should be output to the folder for the HIBUN log relay server, with the path containing the command execution date in its name. Specify the different output destinations between HIBUN logs on the previous day and late-reported HIBUN logs (HIBUN logs older than or equal to two days ago). In this procedure, the output destination of the late-reported HIBUN logs is "the-command-execution-date_old".
-
Copy the CSV file that was output in step 2 to the JP1/IT Desktop Management 2 management server.
The file should be copied to the folder for the JP1/IT Desktop Management 2 management server, with the path containing the command execution date and the-command-execution-date_old in its name.
-
Considering the time when the operations in steps 2 and 3 finish, execute the external log import command with the folders "the command execution date" and "the-command-execution-date_old" copied in step 3 as input.
The HIBUN logs are now imported into JP1/IT Desktop Management 2.
To acquire HIBUN logs on the previous day prior to the late-reported HIBUN logs, acquire logs in the order of "the command execution date" and "the-command-execution-date_old". Periodically delete the folder "the command execution date" and "the-command-execution-date_old".
HIBUN commands
The following example shows HIBUN commands you execute in step 2 of the To operate the logs section.
sflogcmd /m:in:administrator-name:password sflogcmd /c:dc:"input-folder":"output-folder":UTF-8:c:b sflogcmd /m:ot
The input-folder and output-folder should be specified as follows:
- input-folder
-
HIBUN-log-relay-server-data-folder\User_Log\type-of-log\YYYY_MM\DD
The type-of-log should be specified as one of the following:
Access log: Access, Event log: Event, HIBUN extended operation log: OML
- output-folder
-
any-folder\type-of-log_command-execution-date
For the type-of-log, the type of log designated in the input-folder should be specified.
Example of the batch file to execute HIBUN commands
The following example shows a batch file that outputs HIBUN access logs for three days stored in the data-folder-in-the-HIBUN-log-relay-server\User_Log\Access folder to the C:\work\HibunLog\Access\command-execution-date(in-YYYYMMDD-format) folder in CSV format when the date display format in the OS is set to yyyy/MM/dd. To output logs on the preveous day, describe "set IMPORTDAYS=2" on the second line and "set i=1" on the third line. To output logs for four days from two days ago, describe "set IMPORTDAYS=6" on the second line and "set i=2" on the third line.
@echo off set IMPORTDAYS=3 set i=0 sflogcmd /m:in:administrator-name:password :days_loop set PERIOD=%i% call :getpastdate call :getcurrentdate sflogcmd /c:dc:"HIBUN-log-relay-server-data-folder\User_Log\Access\%PASTDATE%":"C:\work\HibunLog\Access\%yy%%mm%%dd%":UTF-8:c:b set /a i+=1 if %i% lss %IMPORTDAYS% goto days_loop sflogcmd /m:ot exit /b rem Subroutine to return a date in the past (N days ago) rem Set the number of days for the PERIOD variable and call the subroutine rem Set the result (YYYY_MM\DD) for the PASTDATE variable rem Set the current date for the yy, mm, and dd variables :getpastdate rem == Get the current date == call :getcurrentdate set PASTDATE=%yy%_%mm%\%dd% if %PERIOD% equ 0 exit /b rem Calculate the date before the specified date set n=0 :getpastdate_loop set /a n=n+1 set /a dd=1%dd%-101 set dd=00%dd% set dd=%dd:~-2% set /a ymod=%yy% %% 4 rem == Operation for a new month or year == if %dd%==00 ( if %mm%==01 (set mm=12& set dd=31& set /a yy=%yy%-1) if %mm%==02 (set mm=01& set dd=31) if %mm%==03 (set mm=02& set dd=28& if %ymod%==0 (set dd=29)) if %mm%==04 (set mm=03& set dd=31) if %mm%==05 (set mm=04& set dd=30) if %mm%==06 (set mm=05& set dd=31) if %mm%==07 (set mm=06& set dd=30) if %mm%==08 (set mm=07& set dd=31) if %mm%==09 (set mm=08& set dd=31) if %mm%==10 (set mm=09& set dd=30) if %mm%==11 (set mm=10& set dd=31) if %mm%==12 (set mm=11& set dd=30) ) if not %n% == %PERIOD% goto getpastdate_loop set PASTDATE=%yy%_%mm%\%dd% exit /b rem Subroutine to get the current date rem Set the result for the yy, mm, and dd variables :getcurrentdate rem == Get the current date == set dt=%date% rem == For the yyyy/MM/dd format == set yy=%dt:~0,4% set mm=%dt:~5,2% set dd=%dt:~8,2% exit /b
External log import command
The following example shows the external log import command you execute in step 4 of the To operate the logs section. The execution result of the command is redirected to the execution result output file for output.
ioutils importexlog -import input-folder -log type-of-HIBUN-log >> execution-result-output-file 2>>&1
The input-folder and the type-of-HIBUN-log should be specified in the following format:
- input-folder
-
any-folder\type-of-log_command-execution-date
For the type-of-log, the type of log designated in the output-folder for the HIBUN command to be executed should be specified.
- type-of-HIBUN-log
-
One of the following can be specified:
HA: HIBUN access log, HE: HIBUN event log, HO: HIBUN extended operation log
Example of the batch file to execute the external log import command
The following example shows a batch file that imports HIBUN access logs stored in the C:\work\HibunLog\Access\command-execution-date(in-YYYYMMDD-format) folder and outputs the execution result to the C:\log\HA_command-execution-date(in-YYYYMMDD-format).log when the date display format in the OS is set to yyyy/MM/dd.
@echo off setlocal call :getcurrentdate ioutils importexlog -import C:\work\HibunLog\Access\%yy%%mm%%dd% -log HA >> C:\log\HA_%yy%%mm%%dd%.log 2>>&1 exit /b rem Subroutine to get the current date rem Set the result for the yy, mm, and dd variables :getcurrentdate rem == Get the current date == set dt=%date% rem == For the yyyy/MM/dd format == set yy=%dt:~0,4% set mm=%dt:~5,2% set dd=%dt:~8,2% exit /b
When HIBUN logs are imported from multiple HIBUN log relay servers
If you import HIBUN logs from multiple HIBUN log relay servers, create a folder for each log relay server that stores the CSV file, on the JP1/IT Desktop Management 2 management server.
Time to import HIBUN logs
When you execute the step 2 and 3 at 00:30 and execute the step 4 at 03:00 of the above "To operate the logs:", in the list view of operation logs, you can see the operation logs notified on the previous day.
Importing late-reported logs
A management target PC is sometimes brought to the outside of the company, and its logs cannot be reported to the HIBUN log relay server.
For example, if you want to import HIBUN logs that are reported one month later into JP1/IT Desktop Management 2, you need to output the HIBUN logs for one month as a CSV file and then use the external log import command to import the file.
Depending on the environment of the management server and the number of days for which HIBUN logs are to be acquired, it might take more than one day for HIBUN logs to be acquired. In this case, consider an operation to reduce the number of days for which HIBUN logs are to be acquired.
Operation in a multi-server configuration
When JP1/IT Desktop Management 2 is configured in the multi-server configuration, operate the system as follows:
-
Copy the CSV file containing HIBUN logs to the management server that stores the operation logs.
-
On the management server in step 1, execute the external log import command to import the HIBUN logs into JP1/IT Desktop Management 2.