Symptoms
K2 Logging
Diagnoses
What are the most efficient sql queries to retrieve K2 logging information from the K2 database ?
Resolution
The text file logs will be in the file path pasted below.
C:Program Files (x86)K2 blackpearlHost ServerBin
Depending on your settings in the config file those logs can contain errors only all the way to all of the server activity.
In order to extract your logs via the K2 database you will need to enable the "ArchiveExtension" node by flipping the "Active" flag to "True" and setting the LogLevel to equate to "Error".
Again if you wanted to track all activity you could adjust the log level.
That in turn will log your errors in the HostServer.LogArchive table.
The query pasted below will extract your errors.
USE K2
SELECT *
FROM HostServer.LogArchive
In order to view the error profiles via a SQL query the following query was provided.
SELECT *
FROM Server.ErrorLog
The following URLs were also provided for reference.
help.k2.com/files/1628
http://old.k2underground.com/blogs/blackbelt/archive/2008/04/16/logging-framework-made-easy.aspx
