<?xml version="1.0" encoding="utf-8"?>
<Templates xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="http://gpsgate.com/xml/">
  <Template>
    <Object>
      <TemplateGuid>08983cde-93a0-4b75-b0e3-cfcd1c61c827</TemplateGuid>
      <TemplateVersion>5</TemplateVersion>
      <ObjectType>GpsGate.Reporting.v3.ReportDefinitionWriter</ObjectType>
      <ObjectData>
        <ReportDefinition>
          <Name>UserExport</Name>
          <ScopeID>895a6082-4b5a-491e-a8fd-a83fddfe5ecd</ScopeID>
          <Description></Description>
          <AppTemplate>00000000-0000-0000-0000-000000000000</AppTemplate>
          <Query>21c98434-e332-437c-835f-8665d3bbc4e9</Query>
          <TableDefinition defaultStyles="false">
            <pageDefinition>
              <pageFormat>Auto</pageFormat>
              <columnWidths>
                <double>0</double>
                <double>0</double>
                <double>0</double>
              </columnWidths>
            </pageDefinition>
            <Columns />
            <Regions>
              <Region repeatHeader="false" pageBreak="false" expression="" level="0" sortExpression="" sortDirection="">
                <Header kind="h">
                  <RegionRow id="h_0_0" VisibilityExpression="true">
                    <Column expression="username" visibilityExpression="" action="" id="h_0_0_0" cspan="1" escape="true">
                      <Layout style="font-weight:bold" />
                      <AltLayout style="" />
                    </Column>
                    <Column expression="name" visibilityExpression="" action="" id="h_0_0_1" cspan="1" escape="true">
                      <Layout style="font-weight:bold" />
                      <AltLayout style="" />
                    </Column>
                    <Column expression="device1.imei" visibilityExpression="" action="" id="h_0_0_2" cspan="1" escape="true">
                      <Layout style="font-weight:bold" />
                      <AltLayout style="" />
                    </Column>
                  </RegionRow>
                </Header>
                <Item kind="i">
                  <RegionRow id="i_0_0" VisibilityExpression="true">
                    <Column expression="[Username]" visibilityExpression="" action="" id="i_0_0_0" cspan="1" escape="true">
                      <Layout style="" />
                      <AltLayout style="" />
                    </Column>
                    <Column expression="[Name]" visibilityExpression="" action="" id="i_0_0_1" cspan="1" escape="true">
                      <Layout style="" />
                      <AltLayout style="" />
                    </Column>
                    <Column expression="[IMEI]" visibilityExpression="" action="" id="i_0_0_2" cspan="1" escape="true">
                      <Layout style="" />
                      <AltLayout style="" />
                    </Column>
                  </RegionRow>
                </Item>
                <Footer kind="f">
                  <RegionRow id="f_0_0" VisibilityExpression="false">
                    <Column expression="" visibilityExpression="" action="" id="f_0_0_0" cspan="1" escape="true">
                      <Layout style="" />
                      <AltLayout style="" />
                    </Column>
                    <Column expression="" visibilityExpression="" action="" id="f_0_0_1" cspan="1" escape="true">
                      <Layout style="" />
                      <AltLayout style="" />
                    </Column>
                    <Column expression="" visibilityExpression="" action="" id="f_0_0_2" cspan="1" escape="true">
                      <Layout style="" />
                      <AltLayout style="" />
                    </Column>
                  </RegionRow>
                </Footer>
              </Region>
            </Regions>
          </TableDefinition>
        </ReportDefinition>
      </ObjectData>
    </Object>
    <Object>
      <TemplateGuid>21c98434-e332-437c-835f-8665d3bbc4e9</TemplateGuid>
      <TemplateVersion>4</TemplateVersion>
      <ObjectType>GpsGate.Reporting.v3.QueryWriter</ObjectType>
      <ObjectData>
        <Query>
          <Name>ExportUsers</Name>
          <ScopeID>895a6082-4b5a-491e-a8fd-a83fddfe5ecd</ScopeID>
          <QueryText>SELECT Users.Name, Users.Username, Device.IMEI FROM  Users
	JOIN Device ON Device.OwnerID = Users.UserID
WHERE Users.UserID IN (SELECT TagUsers.UserID FROM TagUsers WHERE TagID = [Tag])</QueryText>
          <IsInternal>False</IsInternal>
          <Type>GpsGate.Reporting.v3.UserQuery</Type>
          <Parameters>
            <Parameter>
              <type_name>GpsGate.Reporting.v3.QueryReportSqlParameter</type_name>
              <assembly_name>GpsGate.Reporting.v3</assembly_name>
              <param_name>ApplicationID</param_name>
              <multi>False</multi>
              <value_field>ApplicationID</value_field>
              <label_field>Name</label_field>
              <user_def_value>Applications</user_def_value>
              <data_type>System.Int32</data_type>
              <default_value></default_value>
            </Parameter>
            <Parameter>
              <type_name>GpsGate.Reporting.v3.QueryReportSqlParameter</type_name>
              <assembly_name>GpsGate.Reporting.v3</assembly_name>
              <param_name>Tag</param_name>
              <multi>False</multi>
              <value_field>TagID</value_field>
              <label_field>Name</label_field>
              <user_def_value>Tags</user_def_value>
              <data_type>System.Int32</data_type>
              <default_value></default_value>
            </Parameter>
          </Parameters>
        </Query>
      </ObjectData>
    </Object>
  </Template>
</Templates>