Query to show workstation additional fields
SELECT workstation.WORKSTATIONNAME AS "Machine Name", workstation.MANUFACTURER AS "Manufacturer", workstation.SERVICETAG AS "Service Tag", workstation.MODEL AS "Model", aao.NAME AS "Vendor Name", wof.udf_char1 "Cubical Number", wof.udf_char2 "Purchase order", wof.udf_char3 "Invoice Number", wof.udf_char4 "Invoice Date", resToCost.TOTALCOST AS "Total Cost", LONGTODATE(resource.WARRANTYEXPIRY) AS "Warranty Expiry" FROM SystemInfo workstation LEFT JOIN Resources resource ON workstation.WORKSTATIONID=resource.RESOURCEID LEFT JOIN VendorDefinition resourceVendor ON resource.VENDORID=resourceVendor.VENDORID LEFT JOIN SDOrganization aao ON resourceVendor.VENDORID=aao.ORG_ID LEFT JOIN ResourceToCost resToCost ON resource.RESOURCEID=resToCost.RESOURCEID LEFT JOIN ResourceLocation resLocation ON workstation.WORKSTATIONID=resLocation.RESOURCEID LEFT JOIN workstation_fields wof ON workstation.workstationid=wof.workstationid WHERE (ISSERVER='0')
New to ADSelfService Plus?
Query to show account additional fields _ Details required
We Need to know whether that is a common account additional fields or add attribute under individual account. So please send us the following screenshots. 1. Admin-> Account additional fields list view page. 2. Accounts->Edit account and show ...
Query to show user additional fields along with requests
MSSQL: SELECT wo.WORKORDERID AS "Ticket Number", pd.PRIORITYNAME AS "Priority", cd.CATEGORYNAME AS "Category", qd.QUEUENAME AS "Group", ti.FIRST_NAME AS "Technician", technician.attribute_302 "Technician Business Unit", aau.FIRST_NAME AS "Requester", ...
Query to show Software license details with additional fields, allocated workstations and its users with email address
PGSQL & MSSQL: SELECT resources.resourcename "License Name", Max(softwarelist.softwarename) "Managed Software", slt.licensetype "License Type", Max(softwarelicenses.licensekey) "License Key", softwarelicenses.installationscount "No of CALs", ...
Query to display additional field associations with templates
Use case The reports shows in which templates the created additional fields are associated Query select sd.name "Service Catalog Name", rt.templatename "Template name", fc.field_name "Fields" from requesttemplate_list rt left ...
How to import user additional fields using LDAP
In order to import additional fields or map any other fields in AD to the system fields, a row needs to be updated with the appropriate values You can follow the below steps 1. Take a trimmed backup of the database. 2. Connect to the Database 4. Run ...