Report on Count of Assets by Site
DB Compatibility : PGSQL & MSSQL
Build Compatibility : Builds above 10000
SELECT aaov.NAME AS "Site", productType.COMPONENTTYPENAME AS "Product Type", count(resource.RESOURCENAME) AS "Asset Count" FROM Resources resource
left JOIN ComponentDefinition product ON resource.COMPONENTID=product.COMPONENTID
left JOIN ComponentType productType ON product.COMPONENTTYPEID=productType.COMPONENTTYPEID
left JOIN ResourceLocation resLocation ON resource.RESOURCEID=resLocation.RESOURCEID
left JOIN SiteDefinition siteDef ON resLocation.SITEID=siteDef.SITEID
left JOIN SDOrganization aaov ON siteDef.SITEID=aaov.ORG_ID group by aaov.NAME,productType.COMPONENTTYPENAME
left JOIN ComponentDefinition product ON resource.COMPONENTID=product.COMPONENTID
left JOIN ComponentType productType ON product.COMPONENTTYPEID=productType.COMPONENTTYPEID
left JOIN ResourceLocation resLocation ON resource.RESOURCEID=resLocation.RESOURCEID
left JOIN SiteDefinition siteDef ON resLocation.SITEID=siteDef.SITEID
left JOIN SDOrganization aaov ON siteDef.SITEID=aaov.ORG_ID group by aaov.NAME,productType.COMPONENTTYPENAME
New to ADSelfService Plus?
Related Articles
Summary of assets under each Site
DB Compatibility : PGSQL & MSSQL Build Compatibility : Builds above 10000 SELECT regiondefinition.regionname as "Region",aaov.NAME AS "Site", (select count(*) from resources left JOIN ComponentDefinition product ON ...Report on count of laptops and desktops in each site
DB Compatibility : PGSQL & MSSQL Build Compatibility : Builds above 10000 SELECT aaov.NAME AS "Site", case when componentdefinitionlaptop.islaptop is null then 'Desktop' else 'laptop' end as "Workstation type", count(resource.RESOURCENAME) AS "Asset ...Site details
This report is used to get the complete list of Site detail configured in the application. SELECT sd.name "SiteName", sd.Description "Description", regionDef.REGIONNAME "Region", timezonedefinition.displayname "Timezone", apa.DOOR_NO"Door Number", ...Software Compliance Report
Number of products out of compliance select swct.compliancetype "Compliance Type",count(swcd.softwareid) "Number of Products" from SWComplianceDetails swcd left join swcompliancetype swct on swcd.swcompliancetypeid=swct.swcompliancetypeid where ...Report on Organizational roles
DB Compatibility : PGSQL & MSSQL Build Compatibility : Builds above 10000 select r.orgrolename "orgrolename", r.description "Description", au.FIRST_NAME "Name", DepartmentDefinition.DEPTNAME "Department", SDOrganization.NAME "Site" from aaauser au ...