Assets reports by manufacturer.
There was a user who requested the "Manufacturer" field to be available under Assets reports. Currently it is only available under "Assets by Product type" present on the Reports page.
In this, the Manufacturer under "Customization - Asset Management - Product" mapped to Asset will be displayed.
The user can also make use of the below Query:
SELECT productType.COMPONENTTYPENAME AS "Product Type", resource.RESOURCENAME AS "Asset Name", product.COMPONENTNAME AS "Product", productType.COMPONENTTYPENAME AS "Product Type", aao.NAME AS "Vendor Name", state.DISPLAYSTATE AS "Asset State", rCategory.CATEGORY AS "Asset Category", rtype.TYPE AS "Asset Type", product.MANUFACTURERNAME AS "Manufacturer" FROM Resources resource LEFT JOIN ComponentDefinition product ON resource.COMPONENTID = product.COMPONENTID LEFT JOIN ComponentType productType ON product.COMPONENTTYPEID = productType.COMPONENTTYPEID LEFT JOIN ResourceType rtype ON productType.RESOURCETYPEID = rtype.RESOURCETYPEID LEFT JOIN ResourceCategory rCategory ON productType.RESOURCECATEGORYID = rCategory.RESOURCECATEGORYID LEFT JOIN VendorDefinition resourceVendor ON resource.VENDORID = resourceVendor.VENDORID LEFT JOIN SDOrganization aao ON resourceVendor.VENDORID = aao.ORG_ID LEFT JOIN ResourceState state ON resource.RESOURCESTATEID = state.RESOURCESTATEID LEFT JOIN ResourceLocation resLocation ON resource.RESOURCEID = resLocation.RESOURCEID WHERE (resLocation.SITEID IN (2)) ORDER BY 1;
New to ADSelfService Plus?
Related Articles
Query Reports on Purchase Order Items (MSSQL)
Tested in build MSSQL (14306) MSSQL: 1. Login to SDP MSP as administrator 2. Execute this from SDP MSP application -> Reports -> New Query report Execute below query SELECT "po"."POCUSTOMID" AS "PO Number", "po"."PONAME" AS "PO Name", ...Task related reports (MSSQL)
Tested in MSSQL build (14306) Sample Output and headers present in this report Goto reports -> New query report and executes the following SELECT taskdet.TASKID AS "Task ID", taskdet.MODULE AS "Module", taskprior.PRIORITYNAME AS "Priority", ...Query to show workstation details.(MSSQL & PGSQL)
Tested in Build PGSQL (14300) or MSSQL (14306) Below query will show Only workstations and its details. SELECT Max(workstation.workstationname) "Workstation", Max(workstation.servicetag) "Service Tag", Max(workstation.model) "Model", ...When will the Assets get duplicated ?
Please find the possible scenarios when the machines are renamed with _old Scenario 1: When the workstations are swapped in the network. Consider two workstations, MACHINE-A with service tag ST-1 and MACHINE-B with ST-2. Both the workstations are ...Known issue in Reports throwing error in UI
Issue - Reports thrown error in UI Trace in Logs. [12:23:37:156]|[02-13-2023]|[SYSERR]|[INFO]|[27512]: Thread Thread[Thread-129,5,main] exited unexpectedly.java.lang.NoClassDefFoundError: Could not initialize class ...