Overview

This command will list asset reservations.

Related tables

Table	Description	Primary key (PK)	Connection tables
ASRESERVE	Assets reservation	CDRESERVE	ADALLUSERS ADDEPARTMENT
ASASSETRESERVE	Association of assets with the reservations	CDRESERVE CDASSET CDREVISION	ASASSET ASRESERVE
ASASSET	Assets	CDASSET CDREVISION	ADCHECKLIST ADCOMPANY ADTEAM ASCONTROLS ASDEPRECIATION ASGENCONFIG ASSTATE DCDOCUMENT
OBOBJECT	Item/Asset/Supply data based on revision	CDOBJECT CDREVISION	ADTEAM GNASSOC GNREVISION OBOBJECTGROUP OBSUBREASON
GNREVISION	Revision	CDREVISION	ADALLUSERS GNACTIONASSOC GNASSOC GNREASON GNREVCONFIG GNREVISIONSTATUS
OBOBJECTGROUP	Item/Asset/Supply	CDOBJECTGROUP	GNFAVORITE
OBOBJECTTYPE	Item/Asset/Supply type	CDOBJECTTYPE	ADMEASUNITY ADTEAM GNMASK GNREVCONFIG GNTYPEROLE
ADDEPARTMENT	Department	CDDEPARTMENT	ADALLUSERS ADDEPARTMENT ADTEAM COWORKSPACE GNASSOC GNFAVORITE GNMAPPING
ADALLUSERS	User	CDUSER	ADALLUSERS ADUSEREXTERNALDATA GNFAVORITE
PRTASK	Project/Task/Nonproject task/Monitored event	CDTASK	ADALLUSERS ADDEPARTMENT ADTEAM GNACTIVITYTIMECFG GNAPPROV GNASSOC GNCALENDAR GNCHECKLISTANSWER GNFAVORITE GNREVISIONSTATUS PRCONFRECURRING PRPRIORITY PRTASKTYPE

Oracle

SELECT
   PRTK1.FGTASKTYPE,
   GRP.FGSTATUS,
   ASA.FGASSTATUS,
   ASTR.FGSTATUS FGSTATUSRESERVE,
   OBTY.IDOBJECTTYPE,
   OBJ.IDOBJECT,
   OBJ.NMOBJECT,
   GNR.IDREVISION,
   ASR.IDRESERVE,
   ASR.DTCHECKOUT,
   ASTR.DTDUEDATE,
   ASTR.DTEND,
   ASTR.FGTYPERESERVE,
   ADDPTEMISSOR.IDDEPARTMENT || ' - ' || ADDPTEMISSOR.NMDEPARTMENT AS NMDEPARTMENTEMISSOR_FULLNAME,
   USREMISSOR.IDUSER,
   USREMISSOR.NMUSER AS NMUSEREMISSOR,
   ADDPTDESTINATARIO.IDDEPARTMENT || ' - ' || ADDPTDESTINATARIO.NMDEPARTMENT AS NMDEPARTMENTDEST_FULLNAME,
   USRDESTINATARIO.IDUSER AS USRDEST,
   USRDESTINATARIO.NMUSER AS NMUSERDESTINATARIO

FROM
   ASRESERVE ASR
   INNER JOIN ASASSETRESERVE ASTR ON ( ASR.CDRESERVE = ASTR.CDRESERVE )
   INNER JOIN ASASSET ASA ON ( ASTR.CDASSET = ASA.CDASSET )
   INNER JOIN OBOBJECT OBJ ON ( OBJ.CDOBJECT = ASTR.CDASSET AND OBJ.FGCURRENT = 1 )
   INNER JOIN GNREVISION GNR ON ( OBJ.CDREVISION = GNR.CDREVISION )
   INNER JOIN OBOBJECTGROUP GRP ON ( ASTR.CDASSET = GRP.CDOBJECTGROUP )
   INNER JOIN OBOBJECTTYPE OBTY ON ( GRP.CDOBJECTTYPE = OBTY.CDOBJECTTYPE )
   INNER JOIN ADDEPARTMENT ADDPTEMISSOR ON ( ASR.CDSENDERDEPT = ADDPTEMISSOR.CDDEPARTMENT )
   INNER JOIN ADUSER USREMISSOR ON ( ASR.CDSENDERUSER = USREMISSOR.CDUSER )
   INNER JOIN ADDEPARTMENT ADDPTDESTINATARIO ON ( ASR.CDDESTDEPT = ADDPTDESTINATARIO.CDDEPARTMENT )
   INNER JOIN ADUSER USRDESTINATARIO ON ( ASR.CDDESTUSER = USRDESTINATARIO.CDUSER )
   LEFT OUTER JOIN PRTASK PRTK1 ON (PRTK1.CDTASK = ASR.CDTASK)
WHERE
   OBJ.FGTEMPLATE <> 1 /*OBS 1*/
   AND (ASA.FGASSTATUS IS NULL OR ASA.FGASSTATUS <> 4) /*OBS 2

Postgres

SQL Server

SELECT
   PRTK1.FGTASKTYPE,
   GRP.FGSTATUS,
   ASA.FGASSTATUS,
   ASTR.FGSTATUS FGSTATUSRESERVE,
   OBTY.IDOBJECTTYPE,
   OBJ.IDOBJECT,
   OBJ.NMOBJECT,
   GNR.IDREVISION,
   ASR.IDRESERVE,
   ASR.DTCHECKOUT,
   ASTR.DTDUEDATE,
   ASTR.DTEND,
   ASTR.FGTYPERESERVE,
   ADDPTEMISSOR.IDDEPARTMENT + ' - ' + ADDPTEMISSOR.NMDEPARTMENT AS NMDEPARTMENTEMISSOR_FULLNAME,
   USREMISSOR.IDUSER,
   USREMISSOR.NMUSER AS NMUSEREMISSOR,
   ADDPTDESTINATARIO.IDDEPARTMENT + ' - ' + ADDPTDESTINATARIO.NMDEPARTMENT AS NMDEPARTMENTDEST_FULLNAME,
   USRDESTINATARIO.IDUSER AS USRDEST,
   USRDESTINATARIO.NMUSER AS NMUSERDESTINATARIO

FROM
   ASRESERVE ASR
   INNER JOIN ASASSETRESERVE ASTR ON ( ASR.CDRESERVE = ASTR.CDRESERVE )
   INNER JOIN ASASSET ASA ON ( ASTR.CDASSET = ASA.CDASSET )
   INNER JOIN OBOBJECT OBJ ON ( OBJ.CDOBJECT = ASTR.CDASSET AND OBJ.FGCURRENT = 1 )
   INNER JOIN GNREVISION GNR ON ( OBJ.CDREVISION = GNR.CDREVISION )
   INNER JOIN OBOBJECTGROUP GRP ON ( ASTR.CDASSET = GRP.CDOBJECTGROUP )
   INNER JOIN OBOBJECTTYPE OBTY ON ( GRP.CDOBJECTTYPE = OBTY.CDOBJECTTYPE )
   INNER JOIN ADDEPARTMENT ADDPTEMISSOR ON ( ASR.CDSENDERDEPT = ADDPTEMISSOR.CDDEPARTMENT )
   INNER JOIN ADUSER USREMISSOR ON ( ASR.CDSENDERUSER = USREMISSOR.CDUSER )
   INNER JOIN ADDEPARTMENT ADDPTDESTINATARIO ON ( ASR.CDDESTDEPT = ADDPTDESTINATARIO.CDDEPARTMENT )
   INNER JOIN ADUSER USRDESTINATARIO ON ( ASR.CDDESTUSER = USRDESTINATARIO.CDUSER )
   LEFT OUTER JOIN PRTASK PRTK1 ON (PRTK1.CDTASK = ASR.CDTASK)
WHERE
   OBJ.FGTEMPLATE <> 1 /*OBS 1*/
   AND (ASA.FGASSTATUS IS NULL OR ASA.FGASSTATUS <> 4) /*OBS 2*/

Notes

▪1: The FGTEMPLATE field of the OBOBJECT table indicates whether the asset is a template, 1 – Yes; 2 – No;

▪2: The FGSTATUS field of the ASASSET indicates the asset status, the value 4 is disabled.

Fields used on the view screen

ativo-03

ativo-04