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", ...How to auto-create change request(s) for unplanned changes on Assets
This post describes the use of a python script to auto-create change requests for unplanned modifications on Assets using Custom Schedules. This script is applicable only for builds prior to 11138. UseCase: Multiple assets are inventoried in ...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 ...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", ...