Downloadable Custom Report Layouts

Patriot offers the below customised report layouts for download. See Customising Report Layouts for more information on creating, editing, and importing customised report layouts.

Australian Standard AS2201.2

Download: Australian Standards AS2201.2 Operator Response Extended Report.rdlc

Report Type: Operator Response Extended

This variation on the Operator Response Extended report generates the required compliance statistics for AS2201.2.

The default category definitions are based on action plan priority:

Category Action Plan Priorities
High Priority 1
Asset Threatening 2
Subsistence 3
Low Priority 4+

These category definitions can be changed to suit your system set up by altering the table filters in the report definition file.

User Extended Report

Download: User Extended Report.rdlc

Report Type: User Report

This is a user report which gives more details than the standard User Report.

Additional information included in the Extended report:

False Alarm Summary Report

Download: False Alarm Summary Report.rdlc

Report Type: FalseAnalysis

This is a False Alarm Analysis Report which contains only the summary information.

Unlike the standard False Alarm Analysis Report, it does not show a list of Policed Alarms.

Reason Analysis Report With Completion Times

Download: Reason Analysis Report With Completion times.rdlc

Report Type: ReasonAnalysis

This is a Reason Analysis Report which contains extended summary information, including percentages of alarms responded to or completed within certain time limits.

This report will only work if your Patriot licence includes the UK module.

Reason Analysis Summary Report

Download: Reason Analysis Summary Report.rdlc

Report Type: ReasonAnalysis

This is a Reason Analysis Report used in previous version of Patriot 6 which includes the summary table only - no activation listing is present.

Offline Report

Download: Offline Report.rdlc

Report Type: GenericReport

This reports lists signals received from offline (Non-Monitored) clients. Because this report is of GenericReport type it must be used in combination with an advanced search query:

SELECT s.RecDateTime, s.Notes, s.CallerIDNo, s.RawData
FROM PatriotEntities.Signal AS s
WHERE s.Type_No = 65508 AND s.Client_No = 'SYST000101'
AND s.RecDateTime >= <ds> AND s.RecDateTime <= <de>
AND s.Notes >= <cns> AND s.Notes <= <cne>

Online / Offline Report

Download: OnlineOffline Report.rdlc

Report Type: GenericReport

This reports lists Clients which have changed their monitoring status within the specified time frame sorted by Dealer (it will not show Clients that don't have a Dealer. It lists whether they are currently online or offline, when the last change was, and totals the changes underneath each Dealer.
Because this report is of GenericReport type it must be used in combination with an advanced search query:

SELECT 
 m.InstallerID as [DealerID],
 u.user_name as [Dealer],
 m.client_no as [Client No],
 m.name as [Client Name],
 CASE WHEN m.nonmonitored = 1 THEN 'NO'
  ELSE 'YES'
  END as [Online],
 CASE WHEN m.CommMonitorDateTime between <ds> and <de>
  THEN m.CommMonitorDateTime
  ELSE Max(select value op.OperDateTime from PatriotEntities.OperatorLog as op
   WHERE op.Item = m.Client_No
   AND op.Description like '%NonMonitored Chg To%'
   AND op.OperDateTime between <ds> and <de>)
  END as [Date],
  m.InstallDateTime as [Install Date]
FROM PatriotEntities.Memalarm as m, PatriotEntities.Muser as u
WHERE u.UserId = m.InstallerID
 AND (exists (
  SELECT 1 from PatriotEntities.OperatorLog as op
  WHERE op.Item = m.Client_No
  AND op.Description like '%NonMonitored Chg To%'
  AND op.OperDateTime between <ds> and <de>)
  OR m.CommMonitorDateTime between <ds> and <de>)
 AND m.Client_No like '%BASE%'
 AND m.CurrentWorkGroup <>1
ORDER BY m.NonMonitored

Full Online/Offline Report by User

Download: OnlineOffline Report.rdlc

Report Type: GenericReportByUser

Similar to the Online/Offline Report but removes the date/time constraints. All of a Dealer/Bureau's clients are listed along with their online/offline status.

SELECT 
 m.InstallerID as [DealerID],
 u.user_name as [Dealer],
 m.client_no as [Client No],
 m.name as [Client Name],
 CASE WHEN m.nonmonitored = 1 THEN 'NO'
  ELSE 'YES'
  END as [Online],
 CASE WHEN m.NonMonitored = 1
  THEN Max(select value op.OperDateTime from PatriotEntities.OperatorLog as op
   WHERE op.Item = m.Client_No
   AND op.Description like '%NonMonitored Chg To%')
  ELSE
   m.CommMonitorDateTime
 END as [Date],
  m.InstallDateTime as [Install Date]
FROM PatriotEntities.Memalarm as m 
JOIN PatriotEntities.Muser as u ON m.InstallerID = u.UserID
WHERE u.UserId = <uid>
 AND m.Client_No like '%BASE%'
 AND m.CurrentWorkGroup <>1
ORDER BY m.NonMonitored

Incident X Report with Dealer Branding

Download: Incident X With Dealer Image Report.rdlc

Report Type: IncidentReportX, IncidentReportXByUser

This is an Incident Report which contains a dealer logo along the top of the report, allowing each dealer/installer to have a distinct reporting style.

Incident Report without Client Number

Download: Incident Report without Client Number.rdlc

Report Type: IncidentReport

This is an Incident Report used in previous versions of Patriot 6 which does not show any Client Numbers on the report.

Incident Report without Zone/User Number

Download: Incident Report without Zone User Number.rdlc

Report Type: IncidentReport

This is an Incident Report used in previous versions of Patriot 6 which does not show the Zone/User number column on the report.

Incident X Report without Zone/User Number

Download: Incident X Report without Zone User Number.rdlc

Report Type: IncidentXReport

This is an Incident X Report used in previous versions of Patriot 6 which does not show the Zone/User number column on the report.

Incident X Report ADSW Variation

Download: Incident X Report ADSW Variation.rdlc

Download: Incident X Sub Report ADSW Variation.rdlc

Report Type: IncidentXReport and IncidentXByUserReport

This is an Incident X by User Report comparable to that produced by the ADSW software package.

Incident X List Report ADSW Variation (no page breaks)

Download: Incident X Report ADSW Variation NBR.rdlc

Download: Incident X Sub Report ADSW Variation.rdlc

Report Type: IncidentXReport and IncidentXByUserReport

This is an Incident X by User Report comparable to that produced by the ADSW software package. List format without page breaks between clients.

Operator Response Report (UL)

Download: OperatorResponseReportUL.rdlc

Report Type: OperatorResponseExtendedX

This is a Response Report which gives a summary of operator and patrol responses for a given date range. It separates data according to Client Grouping 5, which is assigned on the Report tab of clients.

Log Analysis Reports

These are shortened versions of the standard Log Analysis Report. Useful for a quick summary of the volume of signals received per client over a period of time.

Log Analysis Report (Signal Totals Only):

Report that shows a list containing the following data:

Client Number Client Name Total signal count

Report Type: LogAnalysisReport

Download: Log Analysis Report (Totals Only)


Download: Log Analysis Report Excluding Testmode Signals (Totals Only)


Log Analysis Report (With Action Plans):

Report that shows a list containing the following data:

Client Number Client Name Total signal count per action plan

Report Type: LogAnalysisReport

Download: Log Analysis Report (With Action Plans)

Download: Log Analysis Report Excluding Testmode Signals (With Action Plans)

Walk Test Report

After a walk test through a site, this report will show:

Example of a walk test report

Report Type: WalkTestReport

Download: Walk Test Report.rdlc

Download: Walk Test Sub Report.rdlc

UL Client Statistics Report

For Patriot to be UL classified the Client Statistics Report must be imported into Patriot.

There are 2 reports that need to be setup. Both of these are based on the Generic Report Format.

  1. Client Statistics Totals Report

    Create a new query using the following:

    USING Microsoft.Samples.Entity;
    
    FUNCTION ActiveCount() AS
    (
        SELECT value COUNT(mem.client_no)
        FROM PatriotEntities.Memalarm AS mem
        WHERE mem.UNS_MON <> 0
    )
    
    FUNCTION InactiveCount() AS
    (
        SELECT value COUNT(mem.client_no)
        FROM PatriotEntities.Memalarm AS mem
        WHERE mem.UNS_MON = 0
        AND mem.CurrentWorkgroup = 0
    )
    
    SELECT ActiveCount() AS ActiveClients,
           InactiveCount() AS InactiveClients
    FROM PatriotEntities.MasterSysSettings

    Then create a new report type, of type Generic Report. Use the Client StatisticsTotal.rdlc format.

  2. Client Statistics By Receiver Report

    Create a new query using the following:

    USING Microsoft.Samples.Entity;
    
    FUNCTION ActiveCount(portid string) AS
    (
        SELECT value COUNT(mem.client_no)
        FROM PatriotEntities.Memalarm AS mem
        WHERE mem.UNS_MON <> 0
        AND mem.portid = portid
    )
    
    FUNCTION InactiveCount(portid string) AS
    (
        SELECT value COUNT(mem.client_no)
        FROM PatriotEntities.Memalarm AS mem
        WHERE mem.UNS_MON = 0
        AND mem.CurrentWorkgroup = 0
        AND mem.portid = portid
    )
    
    SELECT mem.portid, ActiveCount(mem.portid) AS ActiveClients,
           InactiveCount(mem.portid) AS InactiveClients
    FROM PatriotEntities.Memalarm AS mem
    GROUP BY mem.portid

    Then create a new report type, of type Generic Report. Use the Client Statistics By Receiver.rdlc format.

Billing Invoice Report

Download: Billing Charge Report.rdlc

Report Type: BillingServices, BillingServicesByUser, BillingActivations, BillingActivationsByUser, BillingWorkOrders, BillingWorkOrdersByUser

This is an invoice summary report. It is meant to server an appendage to the formatted invoice produced by your integrated accounting software package. For example if you are billing a dealer for monitoring service charges, and that dealer has a large number of clients, you can send the dealer a one line invoice along with this report which shows the client breakdown of charges.

This report will only work if your Patriot licence includes a Billing integration module

Advanced Search Generic Report

This report can be used to improve the formatting of the advanced search report. See Reporting on searches for more details.

Download: Advanced Search Report.rdlc

Then create a new report of type Generic Report. Select this rdlc file for the report format. Next select this new report from System Settings -> System Wide settings -> Search Settings -> Advanced Search Report.

Related Pages