Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

My Information

  • Agent Count
  1. Sorted. It ended up being the field picked from the Field Chooser needing to be the subtable of Computers so that it could tally up per computer ID. Here's the SQL query to create the view for the results if anybody finds it useful elsewhere. (It's 'between 2 and 4' because displaying '=3' showed incomplete results despite being only value 3 that you can visually see in the table data! Odd but true and still no reasonable explanation as to why. SELECT `eventlogs`.`ComputerID` AS `ComputerID`, MAX(`eventlogs`.`TimeGen`) AS `MAX(TimeGen)` FROM `eventlogs` WHERE ((`eventlogs`.`Source` = 'shadowprotectspx') AND (`eventlogs`.`EventID` BETWEEN '2' AND '4')) GROUP BY `eventlogs`.`ComputerID` ORDER BY `eventlogs`.`TimeGen` DESC)$$
  2. I've got a report that trawls through the eventlogs table looks for the last successful SPX backup job and then displays this, however when I have multiple servers in a report, it shows the same value for each server even though they are different in the table. The datasource is based on eventlogs and this Where query: source='shadowprotectspx' AND eventid='3' Fields pulled through are ComputerID, EventID, Source, TimeGen. There's a relationship between this data source and computers based on ComputerID. The field on the report is based on a calculated field using max([TimeGen]) but that value appears as the same for all devices, i.e. it appears to be one value for the whole customer when actually it should be one per server. I'm sure I'm very close to getting this working but just haven't got the right syntax! I wouldn't have to do this is the SPX plugin worked with later versions of the software but that's another issue! Would be grateful for any suggestions. Thanks Adrian
  3. Hi I'm not sure there is one as we had to pay CW to create a new report for us as Report Centre takes a lot of time to understand / reverse engineer to get to grips with it. Adrian
  4. Hi Michael I've installed the plugin as a trial and set it up on a couple of locations but there's no information displayed in the detail or the chart. The plugin says that speedtests have been run and shows that others are scheduled too. I have admin permissions in LT. I'm using LT 100.332 and plugin version 1.3. The LT server has been rebooted too. Any help or suggestions gratefully received. Thanks Adrian
  • Create New...