8 Replies Latest reply on Nov 13, 2014 9:41 AM by 981699

    Changing an existing report to include all locations

    981699

      Hello,

       

      I'm trying to change report Map Monitor For Location (under Audit Reports) to include all reports, rather than choosing one location each time I run the report.

       

      How can i do this?

       

      This is the report's script:

       

      SELECT

      tLogKeys.ItemDesc,

      tLogKeys.ItemLongDesc,

      tLogActivity.ItemKey,

      tLogActivity.IOSource,

      tLogActivity.Status,

      tLogActivity.StartTime AS TDate,

      tLogActivity.StartTime,

      tLogActivity.EndTime,

      tLogActivity.UserName,

      tLogActivity.EventInfo,

      tLogActivity.ErrorInfo,

      tLogActivity.PartitionKey,

      tPOVPartition.PartName

       

       

      FROM tLogActivity

      INNER JOIN tLogKeys

      ON tLogActivity.ItemKey = tLogKeys.ItemKey

      INNER JOIN tPOVPartition

      ON tLogActivity.PartitionKey = tPOVPartition.PartitionKey

       

       

      WHERE

      (tLogActivity.PartitionKey = ~Loc~)

      AND (tLogActivity.ItemKey = 225)

       

       

      ORDER BY

      tPOVPartition.PartName,

      tLogActivity.IOSource,

      tLogActivity.Status,

      tLogActivity.StartTime DESC

       

      Thanks

      Lilach