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?
                See all integrations
                New to ADManager Plus?

                  New to ADSelfService Plus?

                  Start your free trial
                  Start your free trial

                    • Related Articles

                    • Script to update Request with another Group when the request is approved

                      Use case:   Assume a requester is requesting for an gadget asset and it requires approval from their managers.  This ticket needs to be moved to "Asset" group only when the ticket gets approved. Pre-requisite - Python should be installed in the ...

                    • Query to show all asset details ( MSSQL )

                      Tested in build MSSQL (14306) SELECT MAX("resource"."RESOURCENAME") AS "Asset Name", MAX("resource"."ASSETTAG") AS "Asset Tag",MAX(resource.SERIALNO) AS "Org Serial Number", MAX("product"."COMPONENTNAME") AS "Product", ...

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

                      Related Products