Asset group

Asset group





SELECT max(resgrp.GROUPNAME) AS "Group Name",
       MAX(resource.RESOURCENAME) AS "Asset Name",
       MAX(state.DISPLAYSTATE) AS "Asset State",
       MAX(rCategory.CATEGORY) AS "Asset Category",
       MAX(product.COMPONENTNAME) AS "Product",
       MAX(productType.COMPONENTTYPENAME) AS "Product Type",
       MAX(aaaUser.FIRST_NAME) AS "User" FROM Resources RESOURCE
LEFT JOIN ComponentDefinition product ON resource.COMPONENTID=product.COMPONENTID
LEFT JOIN ComponentType productType ON product.COMPONENTTYPEID=productType.COMPONENTTYPEID
LEFT JOIN ResourceCategory rCategory ON productType.RESOURCECATEGORYID=rCategory.RESOURCECATEGORYID
LEFT JOIN ResourceState state ON resource.RESOURCESTATEID=state.RESOURCESTATEID
LEFT JOIN ResourceOwner rOwner ON resource.RESOURCEID=rOwner.RESOURCEID
LEFT JOIN ResourceAssociation rToAsset ON rOwner.RESOURCEOWNERID=rToAsset.RESOURCEOWNERID
LEFT JOIN SDUser sdUser ON rOwner.USERID=sdUser.USERID
LEFT JOIN AaaUser aaaUser ON sdUser.USERID=aaaUser.USER_ID
LEFT JOIN StaticGroup stgrp ON stgrp.RESOURCEID = resource.RESOURCEID
LEFT JOIN ResourceGroup resgrp ON resgrp.GROUPID = stgrp.GROUPID
GROUP BY resource.RESOURCEID

      • Related Articles

      • Technician group

        This report is used to get the associated groups of the technicians. SELECT AaaUser.FIRST_NAME "FullName", (SDOrganization.NAME) "Site", (qd.queuename) "Group" FROM AaaUser LEFT JOIN UserDepartment ON AaaUser.USER_ID=UserDepartment.USERID LEFT JOIN ...
      • Request violated by Group

        This report used to find the group who violated the request. If the request/incident already has a violation and is reassigned to another group the new group assumes the violation instead of the group that the violation occurred. To make any changes ...
      • Shared Request - Group

        SELECT wo.WORKORDERID AS "Request ID", wo.TITLE AS "Subject", aau.FIRST_NAME AS "Requester", qd.QUEUENAME AS "Group", ti.FIRST_NAME AS "Technician", std.STATUSNAME AS "Request Status", qa.queuename "Shared to group" FROM WorkOrder wo LEFT JOIN SDUser ...
      • Group change from history

        This report is used to find who changed the group To make any changes to a query, refer to the KB article below. https://pitstop.manageengine.com/support/manageengine/ShowHomePage.do#Solutions/dv/24000633501275 SELECT wo.WORKORDERID "Request ID", ...
      • Asset System tab

        SELECT workstation.workstationname "Workstation",         ua.username                 "User Name",         ua.domainname               "Domain Name",         ua.description              "Description",         ua.status                   "Status",  ...