KACE Product Support

Is there a way to automatically download the logfile 'kmsgr_output'?

I run a Windows script towards the end of the work day, to tell me how many times the computers have connected to the K1000.
I have to login on to http://k1000/system, then go to troubleshooting tools, and download the whole compressed logs, then pull out the 1 logfile I need. I want to automate that.

Or, even better, is it possible to determine how many times the computers have connected using an SQL query?
Here is the Windows JS file I made, maybe there is a way to construct a similar SQL query.

// FindAndCountHostnames.js
// Needs kmsgr_output from kbox_logs.tgz at
// kbox\kboxwww\logs\kmsgr_output in same folder as script.
// Results printed to results.txt in same folder as script.

var objFso = new ActiveXObject("Scripting.FileSystemObject");
// FSO OpenTextFile constants
var ForReading = 1;
var ForWriting = 2;
var ForAppending = 8;

var idxComputers = new ActiveXObject("Scripting.Dictionary");
var TextCompare = 1;
idxComputers.CompareMode = TextCompare;

// Hostname regex stored in first match.
var reHosts = new RegExp("host\=(.*)\&nictype", "i");
reHosts.compile("host\=(.*)\&nictype", "i");

// kmsgr_output input file
var strInFile = "kmsgr_output";

if (!objFso.FileExists(strInFile)){
  WScript.Echo(strInFile + " not found.");
  WScript.Quit(1);
}

try{
  var objInFile = objFso.OpenTextFile(strInFile, ForReading);
}
catch(e){
  WScript.Echo("Problem opening " + strInFile);
  WScript.Quit(2);
}

var strCurrLine, arrMatches;

while (!objInFile.atEndOfStream){
  strCurrLine = objInFile.ReadLine();
  arrMatches = reHosts.exec(strCurrLine);

  if (arrMatches != null){
    // Store count of hostnames.
    if (idxComputers.Exists(RegExp.$1)){
    idxComputers.Item(RegExp.$1) = idxComputers.Item(RegExp.$1) + 1;
  }
    else{
    idxComputers.Add(RegExp.$1.toUpperCase(), 1);
    }
  }
}
objInFile.Close();

if (idxComputers.Count == 0){
  WScript.Echo("No computers found.");
  WScript.Quit(3);
}

var arrKeys = (idxComputers.Keys().toArray()).sort();

var strOutFile = "results.txt";

try{
  // Write results to file.
  var objOutFile = objFso.OpenTextFile(strOutFile, ForWriting, true);
  objOutFile.WriteLine("Computername" + "\t" + "NumberOfConnects");
  
  for (var i = 0; i < arrKeys.length; i++){
    objOutFile.WriteLine(arrKeys[i] + "\t" + idxComputers.Item(arrKeys[i]));
  }
}
catch(f){
  WScript.Echo("Problem creating " + strOutFile);
  WScript.Quit(4);
}
objOutFile.Close();

WScript.Echo("Finished");