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
        New to M365 Manager Plus?
        New to M365 Manager Plus?
          New to RecoveryManager Plus?
          New to RecoveryManager Plus?
            New to Exchange Reporter Plus?
            New to Exchange Reporter Plus?
              New to SharePoint Manager Plus?
              New to SharePoint Manager Plus?
                  See all integrations
                  New to ADManager Plus?

                    New to ADSelfService Plus?

                    Start your free trial

                      • 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",  ...

                        Related Products