CREATE  VIEW [dbo].[al_bi_disc_batch_view] AS
select
    CA_DISCOVERY_BATCH.CA_BATCH_ID_UID,
    CA_DISCOVERY_BATCH.PROCESS_NAME,
    CA_DISCOVERY_BATCH.START_DATETIME,
    CA_DISCOVERY_BATCH.END_DATETIME,
    dbo.SECS2DATE(CA_DISCOVERY_BATCH.END_DATETIME) as ENDDATE_LIMIT,
    dbo.SECS2DATE(CA_DISCOVERY_BATCH.END_DATETIME + 86400) as ENDDATE_PLUS24H,
    CA_DISCOVERY_BATCH.BATCH_ID,
    CA_DISCOVERY_BATCH.INPUT_FILE_NAME,
    CA_DISCOVERY_BATCH.TENANT,
    CA_DISCOVERY_BATCH.DISCOVERY_TOOL,
    CA_DISCOVERY_BATCH.TOTAL_COUNT,
    CA_DISCOVERY_BATCH.SUCCESS_COUNT,
    CA_DISCOVERY_BATCH.FAILURE_COUNT,
    CA_DISCOVERY_BATCH.PROCESSING_ERROR_COUNT,
    CA_DISCOVERY_BATCH.MATCHED_BY_LABEL,
    CA_DISCOVERY_BATCH.MATCHED_BY_SERIAL_NUMBER,
    CA_DISCOVERY_BATCH.MATCHED_BY_ASSET_TAG,
    CA_DISCOVERY_BATCH.MATCHED_BY_HOST_NAME,
    CA_DISCOVERY_BATCH.MATCHED_BY_DNS_NAME,
    CA_DISCOVERY_BATCH.MATCHED_BY_MAC_ADDRESS
from
    CA_DISCOVERY_BATCH
GO