List of Assets that consume Node license
SELECT
Resources.RESOURCEID,
Resources.resourcename,
ComponentType.COMPONENTTYPENAME AS "Product Type"
FROM
Resources
LEFT JOIN ComponentDefinition
ON Resources.COMPONENTID = ComponentDefinition.COMPONENTID
LEFT JOIN ComponentType
ON ComponentDefinition.COMPONENTTYPEID = ComponentType.COMPONENTTYPEID
LEFT JOIN ResourceType
ON ComponentType.RESOURCETYPEID = ResourceType.RESOURCETYPEID
LEFT JOIN ResourceCategory
ON ComponentType.RESOURCECATEGORYID = ResourceCategory.RESOURCECATEGORYID
LEFT JOIN ResourceState
ON Resources.RESOURCESTATEID = ResourceState.RESOURCESTATEID
WHERE
ResourceCategory.CATEGORY LIKE 'IT'
AND ResourceType.TYPE LIKE 'Asset'
AND ResourceState.RESOURCESTATEID NOT IN (4, 5);
New to ADSelfService Plus?
Related Articles
Query to show Non IT assets or the assets that does not consume license (MSSQL & PGSQL)
Tested in Build PGSQL (14300) or MSSQL (14306) SELECT MAX(resource.RESOURCENAME) AS "Asset Name", MAX(resource.ASSETTAG) AS "Asset Tag", MAX(product.COMPONENTNAME) AS "Product", MAX(productType.COMPONENTTYPENAME) AS "Product Type", ...Query to get list of assets consuming license per account. (MSSQL & PGSQL)
Tested in builds from PGSQL (14300) or MSSQL (14306) Query: SELECT ad.ORG_NAME AS "Account", Resources.Resourcename "Asset name", productType.COMPONENTTYPENAME AS "Product Type", product.COMPONENTNAME AS "Product", state.displaystate AS "Asset State" ...Query to show count of IT assets or count of assets that consumed license (MSSQL & PGSQL)
Tested in Build PGSQL (14300) or MSSQL (14306) SELECT count(Resources.RESOURCEID) "Count Of Used Assets" FROM Resources LEFT JOIN ComponentDefinition ON Resources.COMPONENTID=ComponentDefinition.COMPONENTID LEFT JOIN ComponentType ON ...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 ...Unable to modify asset state or unable to edit assets
Issue: While trying to change asset state from list view, we get "Sorry an error has occurred". If we try to Edit that asset, we get a blank page. Error traces from logs: |[com.adventnet.servicedesk.asset.action.AssetDefAction]|[SEVERE]|[102]: ...