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

                      • Query to show number of requests raised per Asset (MSSQL)

                        Tested in Build MSSQL (14306) SELECT ci.ciname 'Asset Name', cd.COMPONENTNAME 'Product', cty.COMPONENTTYPENAME 'Product Type',COUNT(wo.ciid) 'Total Requests raised for this asset' FROM workorder wo left join CI ON ci.ciid=wo.ciid LEFT JOIN RESOURCES ...

                      • Asset Ownership History Report

                        Please use the below query to get the report on Asset Ownership History. SELECT r.resourcename AS "Workstation Name", ct.componenttypename AS "Product type", rs.displaystate AS "Asset State", aa.first_name AS "Assigned User", LONGTODATE(sh.starttime) ...

                        Related Products