Asset Module - Database Schema Documentation for builds below 15000/7800
Asset Module — Database Schema Documentation
Section 1: Asset Core Details
| Field | Column | Source Table | JOIN Clause |
|---|
| Asset ID | r.RESOURCEID | Resources r | — |
| Asset Name | r.RESOURCENAME | Resources r | — |
| Asset Tag | r.ASSETTAG | Resources r | — |
| Serial Number | r.SERIALNO | Resources r | — |
| Barcode | b.BARCODE | Barcodes b | LEFT JOIN Barcodes b ON r.BARCODEID = b.BARCODEID |
| Description | r.DESCRIPTION | Resources r | — |
| IP Addresses | r.IPADDRESSES | Resources r | — |
| Primary IP | r.PRIMARYIPADDRESS | Resources r | — |
| MAC Addresses | r.MACADDRESSES | Resources r | — |
| Is Personal | r.ISPERSONAL | Resources r | — |
| Is Loanable | r.ISLOANABLE | Resources r | — |
| Location (Text) | r.LOCATION | Resources r | — |
| Scan Serial Number | r.SCANSERIALNUMBER | Resources r | — |
| Acquisition Date | longtodate(r.ACQUISITIONDATE) | Resources r | — |
| Warranty Expiry | longtodate(r.WARRANTYEXPIRY) | Resources r | — |
| Expiry Date | longtodate(r.EXPIRYDATE) | Resources r | — |
| Created Time | longtodate(r.CREATEDTIME) | Resources r | — |
| Modified Time | longtodate(r.MODIFIEDTIME) | Resources r | — |
Section 2: Asset State
| Field | Column | Source Table | JOIN Clause |
|---|
| State (Display) | rs.DISPLAYSTATE | ResourceState rs | LEFT JOIN ResourceState rs ON r.RESOURCESTATEID = rs.RESOURCESTATEID |
| State Description | rs.STATEDESC | ResourceState rs | (same) |
| State Detail | rs.DESCRIPTION | ResourceState rs | (same) |
| Is Disposed | rs.ISDISPOSED | ResourceState rs | (same) |
Section 3: Product / Component Type
| Field | Column | Source Table | JOIN Clause |
|---|
| Product Name | cd.COMPONENTNAME | ComponentDefinition cd | LEFT JOIN ComponentDefinition cd ON r.COMPONENTID = cd.COMPONENTID |
| Manufacturer | cd.MANUFACTURERNAME | ComponentDefinition cd | (same) |
| Part Number | cd.PARTNO | ComponentDefinition cd | (same) |
| Product Cost | cd.COST | ComponentDefinition cd | (same) |
| Asset Type | ct.COMPONENTTYPENAME | ComponentType ct | LEFT JOIN ComponentType ct ON cd.COMPONENTTYPEID = ct.COMPONENTTYPEID |
| Resource Type | rt.TYPE | ResourceType rt | LEFT JOIN ResourceType rt ON ct.RESOURCETYPEID = rt.RESOURCETYPEID |
| Resource Category | rc.CATEGORY | ResourceCategory rc | LEFT JOIN ResourceCategory rc ON ct.RESOURCECATEGORYID = rc.RESOURCECATEGORYID |
Section 4: Asset Owner
| Field | Column | Source Table | JOIN Clause |
|---|
| Owner Name | owneruser.FIRST_NAME | AaaUser owneruser | LEFT JOIN ResourceOwner ro ON r.RESOURCEID = ro.RESOURCEID
LEFT JOIN SDUser ownersdu ON ro.USERID = ownersdu.USERID
LEFT JOIN AaaUser owneruser ON ownersdu.USERID = owneruser.USER_ID |
| Owner Employee ID | ownersdu.EMPLOYEEID | SDUser ownersdu | (via ResourceOwner) |
| Owner Job Title | ownersdu.JOBTITLE | SDUser ownersdu | (via ResourceOwner) |
| Owner Department | ownerdept.DEPTNAME | DepartmentDefinition ownerdept | LEFT JOIN DepartmentDefinition ownerdept ON ro.DEPTID = ownerdept.DEPTID |
| Owner VIP | ownersdu.ISVIPUSER | SDUser ownersdu | (via ResourceOwner) |
| Owner Email | ownercontact.EMAILID | AaaContactInfo ownercontact | LEFT JOIN AaaUserContactInfo owneruci ON owneruser.USER_ID = owneruci.USER_ID
LEFT JOIN AaaContactInfo ownercontact ON owneruci.CONTACTINFO_ID = ownercontact.CONTACTINFO_ID |
Section 5: Ownership History
| Field | Column | Source Table | JOIN Clause |
|---|
| Assigned User | histuser.FIRST_NAME | AaaUser histuser | LEFT JOIN ResourceOwnerHistory roh ON r.RESOURCEID = roh.RESOURCEID
LEFT JOIN SDUser histsdu ON roh.USERID = histsdu.USERID
LEFT JOIN AaaUser histuser ON histsdu.USERID = histuser.USER_ID |
| Changed By | taskuser.FIRST_NAME | AaaUser taskuser | LEFT JOIN SDUser tasksdu ON roh.TASKUSERID = tasksdu.USERID
LEFT JOIN AaaUser taskuser ON tasksdu.USERID = taskuser.USER_ID |
| Ownership Start | longtodate(roh.STARTTIME) | ResourceOwnerHistory roh | (same) |
| Ownership End | longtodate(roh.ENDTIME) | ResourceOwnerHistory roh | (same) |
| Department | rohdept.DEPTNAME | DepartmentDefinition rohdept | LEFT JOIN DepartmentDefinition rohdept ON roh.DEPTID = rohdept.DEPTID |
| Comments | roh.COMMENTS | ResourceOwnerHistory roh | (same) |
Section 6: State History
| Field | Column | Source Table | JOIN Clause |
|---|
| New State | newstate.DISPLAYSTATE | ResourceState newstate | LEFT JOIN ResourceStateHistory rsh ON r.RESOURCEID = rsh.RESOURCEID
LEFT JOIN ResourceState newstate ON rsh.RESOURCESTATEID = newstate.RESOURCESTATEID |
| Previous State | prevstate.DISPLAYSTATE | ResourceState prevstate | LEFT JOIN ResourceState prevstate ON rsh.PREVRESOURCESTATEID = prevstate.RESOURCESTATEID |
| State Change Time | longtodate(rsh.STARTTIME) | ResourceStateHistory rsh | (same) |
| State End Time | longtodate(rsh.ENDTIME) | ResourceStateHistory rsh | (same) |
| Changed By | stateuser.FIRST_NAME | AaaUser stateuser | LEFT JOIN SDUser statesdu ON rsh.USERID = statesdu.USERID
LEFT JOIN AaaUser stateuser ON statesdu.USERID = stateuser.USER_ID |
| Comments | rsh.COMMENTS | ResourceStateHistory rsh | (same) |
Section 7: Site / Region / Physical Location
| Field | Column | Source Table | JOIN Clause |
|---|
| Site | sdo.NAME | SDOrganization sdo | LEFT JOIN SiteDefinition sitedef ON r.SITEID = sitedef.SITEID
LEFT JOIN SDOrganization sdo ON sitedef.SITEID = sdo.ORG_ID |
| Region | regiondef.REGIONNAME | RegionDefinition regiondef | LEFT JOIN RegionDefinition regiondef ON sitedef.REGIONID = regiondef.REGIONID |
| Building | bldg.BUILDINGNAME | BuildingDefinition bldg | LEFT JOIN ResourceLocation rloc ON r.RESOURCEID = rloc.RESOURCEID
LEFT JOIN BuildingDefinition bldg ON rloc.BUILDINGID = bldg.BUILDINGID |
| Floor | flr.FLOORNAME | FloorDefinition flr | LEFT JOIN FloorDefinition flr ON rloc.FLOORID = flr.FLOORID |
| Room | rm.ROOMNAME | RoomDefinition rm | LEFT JOIN RoomDefinition rm ON rloc.ROOMID = rm.ROOMID |
| Location (Text) | rloc.LOCATION | ResourceLocation rloc | (same) |
| Latitude | rloc.LATITUDE | ResourceLocation rloc | (same) |
| Longitude | rloc.LONGITUDE | ResourceLocation rloc | (same) |
Section 8: CI / CMDB
| Field | Column | Source Table | JOIN Clause |
|---|
| CI ID | ci.CIID | CI ci | LEFT JOIN CI ci ON r.CIID = ci.CIID |
| CI Name | ci.CINAME | CI ci | (same) |
| CI Description | ci.DESCRIPTION | CI ci | (same) |
| CI Type | citype.TYPENAME | CIType citype | LEFT JOIN CIType citype ON ci.CITYPEID = citype.TYPEID |
| CI Status | cistatus.STATUSNAME | CIStatus cistatus | LEFT JOIN CIStatus cistatus ON ci.STATUSID = cistatus.STATUSID |
| CI Created Date | longtodate(ci.CREATEDDATE) | CI ci | (same) |
| CI Last Modified | longtodate(ci.LASTMODIFIED) | CI ci | (same) |
| CI Version | ci.VERSION | CI ci | (same) |
Section 9: Vendor
| Field | Column | Source Table | JOIN Clause |
|---|
| Vendor Name | vd.NAME | VendorDefinition vd | LEFT JOIN VendorDefinition vd ON r.VENDORID = vd.VENDORID |
| Contact Person | vd.CONTACTPERSON | VendorDefinition vd | (same) |
| Email | vd.EMAILID | VendorDefinition vd | (same) |
| Phone | vd.LANDLINE | VendorDefinition vd | (same) |
| Fax | vd.FAX | VendorDefinition vd | (same) |
| Website | vd.WEB_URL | VendorDefinition vd | (same) |
| City | vd.CITY | VendorDefinition vd | (same) |
| State | vd.STATE | VendorDefinition vd | (same) |
| Country | vd.COUNTRY | VendorDefinition vd | (same) |
Section 10: Purchase Order Chain
| Field | Column | Source Table | JOIN Clause |
|---|
| PO Name | po.PONAME | PurchaseOrder po | LEFT JOIN PurchaseLot pl ON r.PURCHASELOTID = pl.PURCHASELOTID
LEFT JOIN PurchaseOrderItem poi ON pl.PURCHASEORDERITEMID = poi.PURCHASEORDERITEMID
LEFT JOIN PurchaseOrder po ON poi.PURCHASEORDERID = po.PURCHASEORDERID |
| PO Custom ID | po.POCUSTOMID | PurchaseOrder po | (same) |
| Date Ordered | longtodate(po.DATEORDERED) | PurchaseOrder po | (same) |
| Date Required | longtodate(po.DATEREQUIRED) | PurchaseOrder po | (same) |
| Shipping Price | po.SHIPPINGPRICE | PurchaseOrder po | (same) |
| Sales Tax | po.SALESTAX | PurchaseOrder po | (same) |
| Total Price | po.TOTALPRICE | PurchaseOrder po | (same) |
| PO Item Name | poi.ITEMNAME | PurchaseOrderItem poi | (same) |
| PO Item Price | poi.PRICE | PurchaseOrderItem poi | (same) |
| Quantity Ordered | poi.QUANTITYORDERED | PurchaseOrderItem poi | (same) |
| Lot Date Received | longtodate(pl.DATERECEIVED) | PurchaseLot pl | (same) |
| Lot Warranty Expiry | longtodate(pl.WARRANTYEXPIRY) | PurchaseLot pl | (same) |
| Lot Lease Expiry | longtodate(pl.LEASEEXPIRY) | PurchaseLot pl | (same) |
| PO Requester | poreq.FIRST_NAME | AaaUser poreq | LEFT JOIN SDUser poreqsdu ON po.REQUESTERID = poreqsdu.USERID
LEFT JOIN AaaUser poreq ON poreqsdu.USERID = poreq.USER_ID |
| PO Vendor | povd.NAME | VendorDefinition povd | LEFT JOIN VendorDefinition povd ON po.VENDORID = povd.VENDORID |
Section 11: Cost
| Field | Column | Source Table | JOIN Clause |
|---|
| Purchase Cost | rcost.PURCHASECOST | ResourceToCost rcost | LEFT JOIN ResourceToCost rcost ON r.RESOURCEID = rcost.RESOURCEID |
| Operational Cost | rcost.OPERATIONALCOST | ResourceToCost rcost | (same) |
| Current Cost | rcost.CURRENTCOST | ResourceToCost rcost | (same) |
| Total Cost | rcost.TOTALCOST | ResourceToCost rcost | (same) |
Section 12: System / Hardware Info
| Field | Column | Source Table | JOIN Clause |
|---|
| Workstation Name | si.WORKSTATIONNAME | SystemInfo si | LEFT JOIN SystemInfo si ON r.RESOURCEID = si.WORKSTATIONID |
| System Manufacturer | si.MANUFACTURER | SystemInfo si | (same) |
| System Model | si.MODEL | SystemInfo si | (same) |
| Service Tag | si.SERVICETAG | SystemInfo si | (same) |
| BIOS Name | si.BIOSNAME | SystemInfo si | (same) |
| BIOS Version | si.BIOSVERSION | SystemInfo si | (same) |
| Logged User | si.LOGGEDUSER | SystemInfo si | (same) |
| Processor Summary | si.PROCESSOR | SystemInfo si | (same) |
| Processor Count | si.PROCESSORCOUNT | SystemInfo si | (same) |
| Core Count | si.PROCESSORCORECOUNT | SystemInfo si | (same) |
| Disk Space | si.DISKSPACE | SystemInfo si | (same) |
| RAM Slots | si.RAMSLOTSCOUNT | SystemInfo si | (same) |
| Agent Installed | si.ISAGENTINSTALLED | SystemInfo si | (same) |
| Agent Version | si.AGENTVERSION | SystemInfo si | (same) |
| Last Boot Time | si.LASTBOOTTIME | SystemInfo si | (same) |
| Is Server | si.ISSERVER | SystemInfo si | (same) |
Processor Details
| Field | Column | Source Table | JOIN Clause |
|---|
| CPU Name | pi.CPUNAME | ProcessorInfo pi | LEFT JOIN ProcessorInfo pi ON si.WORKSTATIONID = pi.WORKSTATIONID |
| CPU Speed | pi.SPEED | ProcessorInfo pi | (same) |
| CPU Vendor | pi.VENDOR | ProcessorInfo pi | (same) |
| CPU Model | pi.CPUMODEL | ProcessorInfo pi | (same) |
| CPU Serial | pi.CPUSERIALNUMBER | ProcessorInfo pi | (same) |
| Number of Cores | pi.NUMBEROFCORES | ProcessorInfo pi | (same) |
Memory Details
| Field | Column | Source Table | JOIN Clause |
|---|
| Total Memory | mi.TOTALMEMORY | MemoryInfo mi | LEFT JOIN MemoryInfo mi ON si.WORKSTATIONID = mi.WORKSTATIONID |
| Free Memory | mi.FREEMEMORY | MemoryInfo mi | (same) |
| Virtual Memory | mi.VIRTUALMEMORY | MemoryInfo mi | (same) |
Memory Module Details
| Field | Column | Source Table | JOIN Clause |
|---|
| Module Name | mm.NAME | MemoryModuleInfo mm | LEFT JOIN MemoryModuleInfo mm ON si.WORKSTATIONID = mm.WORKSTATIONID |
| Capacity | mm.CAPACITY | MemoryModuleInfo mm | (same) |
| Memory Type | mm.MEMORYTYPE | MemoryModuleInfo mm | (same) |
| Frequency | mm.FREQUENCY | MemoryModuleInfo mm | (same) |
| Socket Label | mm.SOCKETLABEL | MemoryModuleInfo mm | (same) |
Hard Disk Details
| Field | Column | Source Table | JOIN Clause |
|---|
| Model Number | hd.MODELNUMBER | HardDiskInfo hd | LEFT JOIN HardDiskInfo hd ON si.WORKSTATIONID = hd.WORKSTATIONID |
| Serial Number | hd.SERIALNUMBER | HardDiskInfo hd | (same) |
| Capacity | hd.CAPACITY | HardDiskInfo hd | (same) |
| Free Space | hd.FREESPACE | HardDiskInfo hd | (same) |
| Drive Type | hd.DRIVETYPE | HardDiskInfo hd | (same) |
| Manufacturer | hd.MANUFACTURER | HardDiskInfo hd | (same) |
Drive Details
| Field | Column | Source Table | JOIN Clause |
|---|
| Drive Name | dr.DRIVENAME | DriveInfo dr | LEFT JOIN DriveInfo dr ON si.WORKSTATIONID = dr.WORKSTATIONID |
| Drive Type | dr.DRIVETYPE | DriveInfo dr | (same) |
| Capacity | dr.CAPACITY | DriveInfo dr | (same) |
| Free Space | dr.FREESPACE | DriveInfo dr | (same) |
| File System | dr.FILESYSTEM | DriveInfo dr | (same) |
Monitor Details
| Field | Column | Source Table | JOIN Clause |
|---|
| Monitor Type | mon.MONITORTYPE | MonitorInfo mon | LEFT JOIN MonitorInfo mon ON si.WORKSTATIONID = mon.WORKSTATIONID |
| Max Resolution | mon.MAXRESOLUTION | MonitorInfo mon | (same) |
| Manufacturer | mon.MANUFACTURER | MonitorInfo mon | (same) |
| Serial Number | mon.SERIALNUMBER | MonitorInfo mon | (same) |
OS Details
| Field | Column | Source Table | JOIN Clause |
|---|
| OS Name | osi.OSNAME | OSInfo osi | LEFT JOIN OSInfo osi ON si.WORKSTATIONID = osi.WORKSTATIONID |
| Version | osi.VERSION | OSInfo osi | (same) |
| Build Number | osi.BUILDNUMBER | OSInfo osi | (same) |
| Service Pack | osi.SERVICEPACK | OSInfo osi | (same) |
| Product ID | osi.PRODUCTID | OSInfo osi | (same) |
| System Type | osi.SYSTEMTYPE | OSInfo osi | (same) |
| License Type | osi.LICENSETYPE | OSInfo osi | (same) |
| License Status | osi.LICENSESTATUS | OSInfo osi | (same) |
Network Details
| Field | Column | Source Table | JOIN Clause |
|---|
| NIC Name | ni.NICNAME | NetworkInfo ni | LEFT JOIN NetworkInfo ni ON r.RESOURCEID = ni.WORKSTATIONID |
| NIC Description | ni.NICDESCRIPTION | NetworkInfo ni | (same) |
| IP Address | ni.IPADDRESS | NetworkInfo ni | (same) |
| MAC Address | ni.MACADDRESS | NetworkInfo ni | (same) |
| Subnet Mask | ni.IPNETMASK | NetworkInfo ni | (same) |
| Gateway | ni.GATEWAY | NetworkInfo ni | (same) |
| DHCP | ni.ISDHCP | NetworkInfo ni | (same) |
| DHCP Server | ni.DHCPSERVER | NetworkInfo ni | (same) |
Section 13: Software Installed
| Field | Column | Source Table | JOIN Clause |
|---|
| Software Name | swl.SOFTWARENAME | SoftwareList swl | LEFT JOIN SoftwareInfo swi ON si.WORKSTATIONID = swi.WORKSTATIONID
LEFT JOIN SoftwareList swl ON swi.SOFTWAREID = swl.SOFTWAREID |
| Product Name | swl.PRODUCTNAME | SoftwareList swl | (same) |
| Product Version | swl.PRODUCTVERSION | SoftwareList swl | (same) |
| File Version | swl.FILEVERSION | SoftwareList swl | (same) |
| Company Name | swl.COMPANYNAME | SoftwareList swl | (same) |
| Manufacturer | swm.NAME | SoftwareManufacturer swm | LEFT JOIN SoftwareManufacturer swm ON swl.SWMANUFACTURERID = swm.SWMANUFACTURERID |
| Install Path | swi.LOCATION | SoftwareInfo swi | (same) |
| File Size | swi.FILESIZE | SoftwareInfo swi | (same) |
Section 14: Maintenance Contract
| Field | Column | Source Table | JOIN Clause |
|---|
| Contract Name | mc.CONTRACTNAME | MaintenanceContract mc | LEFT JOIN ContractDetails cdet ON r.RESOURCEID = cdet.RESOURCEID
LEFT JOIN MaintenanceContract mc ON cdet.CONTRACTID = mc.CONTRACTID |
| Custom Contract ID | mc.CUSTOMCONTRACTID | MaintenanceContract mc | (same) |
| From Date | longtodate(mc.FROMDATE) | MaintenanceContract mc | (same) |
| To Date | longtodate(mc.TODATE) | MaintenanceContract mc | (same) |
| Total Price | mc.TOTALPRICE | MaintenanceContract mc | (same) |
| Support | mc.SUPPORT | MaintenanceContract mc | (same) |
| Contract Vendor | mcvd.NAME | VendorDefinition mcvd | LEFT JOIN VendorDefinition mcvd ON mc.MAINTENANCEVENDOR = mcvd.VENDORID |
Section 15: Loan
| Field | Column | Source Table | JOIN Clause |
|---|
| Loan ID | lo.LOANID | Loan lo | LEFT JOIN LoanResources lr ON r.RESOURCEID = lr.RESOURCEID
LEFT JOIN Loan lo ON lr.LOANID = lo.LOANID |
| Loan Custom ID | lo.LOANCUSTOMID | Loan lo | (same) |
| Loaned To | loanuser.FIRST_NAME | AaaUser loanuser | LEFT JOIN SDUser loansdu ON lo.USERID = loansdu.USERID
LEFT JOIN AaaUser loanuser ON loansdu.USERID = loanuser.USER_ID |
| Loan Start | longtodate(lo.STARTTIME) | Loan lo | (same) |
| Loan End | longtodate(lo.ENDTIME) | Loan lo | (same) |
| Extended To | longtodate(lo.EXTENDEDTO) | Loan lo | (same) |
| Returned On | longtodate(lo.RETURNEDON) | Loan lo | (same) |
| Loan Status | lo.STATUS | Loan lo | (same) |
| Is Returned | lr.ISRETURNED | LoanResources lr | (same) |
Section 16: Scan / Audit History
| Field | Column | Source Table | JOIN Clause |
|---|
| Audit Time | longtodate(ah.AUDITTIME) | AuditHistory ah | LEFT JOIN AuditHistory ah ON r.RESOURCEID = ah.WORKSTATIONID |
| Audit Status | ah.AUDITSTATUS | AuditHistory ah | (same) |
| Comments | ah.COMMENTS | AuditHistory ah | (same) |
| HW Change Table | hwah.TABLENAME | HWAuditHistory hwah | LEFT JOIN HWAuditHistory hwah ON ah.AUDITID = hwah.AUDITID |
| HW Change Column | hwah.COLUMNNAME | HWAuditHistory hwah | (same) |
| HW New Value | hwah.COLUMNVALUE | HWAuditHistory hwah | (same) |
| HW Old Value | hwah.COLUMNOLDVALUE | HWAuditHistory hwah | (same) |
| Operation | ao.OPERATIONSTRING | AuditOperation ao | LEFT JOIN AuditOperation ao ON hwah.OPERATION = ao.OPERATION |
Section 17: CI History
| Field | Column | Source Table | JOIN Clause |
|---|
| Edit Mode | cih.EDITMODE | CIHistory cih | LEFT JOIN CIHistory cih ON ci.CIID = cih.CIID |
| Operation Time | longtodate(cih.OPERATIONTIME) | CIHistory cih | (same) |
| Changed By | cihuser.FIRST_NAME | AaaUser cihuser | LEFT JOIN SDUser cihsdu ON cih.USERID = cihsdu.USERID
LEFT JOIN AaaUser cihuser ON cihsdu.USERID = cihuser.USER_ID |
| Attribute Changed | cihd.ATTRIBUTE | CIHistoryDetails cihd | LEFT JOIN CIHistoryDetails cihd ON cih.HISTORYID = cihd.HISTORYID |
| Old Value | cihd.OLDVALUE | CIHistoryDetails cihd | (same) |
| New Value | cihd.NEWVALUE | CIHistoryDetails cihd | (same) |
Section 18: Depreciation
| Field | Column | Source Table | JOIN Clause |
|---|
| Depreciation Type | dtype.DEPRECIATIONTYPE | DepreciationType dtype | LEFT JOIN ResourceDepreciation rdep ON r.RESOURCEID = rdep.RESOURCEID
LEFT JOIN DepreciationDetails dd ON rdep.DEPRECIATIONID = dd.DEPRECIATIONID
LEFT JOIN DepreciationType dtype ON dd.DEPRECIATIONTYPEID = dtype.DEPRECIATIONTYPEID |
| Salvage Value | dd.SALVAGEVALUE | DepreciationDetails dd | (same) |
| Useful Life | dd.USEFULLIFE | DepreciationDetails dd | (same) |
| Depreciation % | dd.DEPRECIATIONPERCENT | DepreciationDetails dd | (same) |
Section 19: Asset Additional Fields (UDF)
| Field | Column | Source Table | JOIN Clause |
|---|
| UDF Char 1–24 | rf.UDF_CHAR1 … rf.UDF_CHAR24 | Resource_Fields rf | LEFT JOIN Resource_Fields rf ON r.RESOURCEID = rf.RESOURCEID |
| UDF Long 1–10 | rf.UDF_LONG1 … rf.UDF_LONG10 | Resource_Fields rf | (same) |
| UDF Date 1–10 | longtodate(rf.UDF_DATE1) … | Resource_Fields rf | (same) |
New to ADSelfService Plus?
Related Articles
6. Database Schema
Request Module Column Name Column Value Joining Table Request ID wo.workorderid workorder wo Request Subject wo.title workorder wo Request created time longtodate(wo.createdtime) workorder wo Request category cd.CATEGORYNAME LEFT JOIN ...
Support Center Schema - 8 series
To populate the WorkOrder/Request information, the tables that need tobe populated are : WorkOrder WorkOrderStates WorkOrder_Threaded WorkOrderToDescription WorkOrder_Fields (If there are any WorkOrder Addl Fields) To map Account and SubAccount to a ...
Remote read only access to database for Postgres customers
Use case: Frequently customers want to connect some reporting / dashboard application like PowerBI or Tableau with our Postgres database server. By default, the bundled Postgres is configured to only listen to the local machine. We can configure to ...
How to Connect to SCP Database ? (from 11000 builds)
In-Built POSTGRES (PGSQL) : Open a CMD prompt as an administrator and navigate to ManageEngine\supportcenterplus\pgsql\bin and run the below command 1. If the database is PGSQL (Default database) psql -h localhost -U scpadmin -p 65432 -d ...
Online API documentation
Dear Users You can refer to the latest API document from our online demo page available here. (Login as administrator to view the same) Once login -> Goto Admin -> API -. Documentation to refer the same. or once login done -> click the below link to ...