Add Operating System to Asset Report
Hello, How can I add OS to the following report?
SELECT "resDept"."DEPTNAME" AS "Division", "resDept"."DEPTNAME" AS "Division", "ci"."CINAME" AS "CI Name", "citype"."TYPENAME" AS "CI Type", "cirest"."DISPLAYSTATE" AS "Asset State", "cires"."ASSETTAG" AS "Service Tag", "cicd"."COMPONENTNAME" AS "Product Name", "resUser"."FIRST_NAME" AS "User", "resFields"."UDF_CHAR1" AS "Building", "resFields"."UDF_CHAR2" AS "Room", "resFields"."UDF_DATE1" AS "Warranty Start Date", "cires"."WARRANTYEXPIRY" AS "Warranty Expiration Date", "resFields"."UDF_LONG7" AS "Total Yearly Support Amount Charged", "resFields"."UDF_LONG1" AS "Support Budget Number 1", "resFields"."UDF_LONG4" AS "Support Amount 1", "resFields"."UDF_LONG2" AS "Support Budget Number 2", "resFields"."UDF_LONG5" AS "Support Amount 2", "resFields"."UDF_LONG3" AS "Support Budget Number 3", "resFields"."UDF_LONG6" AS "Support Amount 3", "resFields"."UDF_CHAR5" AS "Notes" FROM "Resources" "cires" LEFT JOIN "BaseElement" "baseci" ON "cires"."CIID"="baseci"."CIID" LEFT JOIN "CI" "ci" ON "baseci"."CIID"="ci"."CIID" LEFT JOIN "CIType" "citype" ON "ci"."CITYPEID"="citype"."TYPEID" LEFT JOIN "ComponentDefinition" "cicd" ON "cires"."COMPONENTID"="cicd"."COMPONENTID" LEFT JOIN "ResourceState" "cirest" ON "cires"."RESOURCESTATEID"="cirest"."RESOURCESTATEID" LEFT JOIN "ResourceOwner" "resOwn" ON "cires"."RESOURCEID"="resOwn"."RESOURCEID" LEFT JOIN "AaaUser" "resUser" ON "resOwn"."USERID"="resUser"."USER_ID" LEFT JOIN "DepartmentDefinition" "resDept" ON "resOwn"."DEPTID"="resDept"."DEPTID" LEFT JOIN "Resource_Fields" "resFields" ON "cires"."RESOURCEID"="resFields"."RESOURCEID" WHERE ((((("cirest"."DISPLAYSTATE" COLLATE SQL_Latin1_General_CP1_CS_AS != N'Expired') AND ("cirest"."DISPLAYSTATE" COLLATE SQL_Latin1_General_CP1_CS_AS != N'In Store')) AND ("cirest"."DISPLAYSTATE" COLLATE SQL_Latin1_General_CP1_CS_AS != N'Disposed')) OR ("cirest"."DISPLAYSTATE" COLLATE SQL_Latin1_General_CP1_CS_AS IS NULL)) AND ((("citype"."TYPENAME" COLLATE SQL_Latin1_General_CP1_CI_AS LIKE N'%MACs%') OR ("citype"."TYPENAME" COLLATE SQL_Latin1_General_CP1_CI_AS LIKE N'%Tablets%')) OR ("citype"."TYPENAME" COLLATE SQL_Latin1_General_CP1_CI_AS LIKE N'%Workstation%'))) AND cires.CIID IS NOT NULL ORDER BY 1, 4
SELECT "resDept"."DEPTNAME" AS "Division", "resDept"."DEPTNAME" AS "Division", "ci"."CINAME" AS "CI Name", "citype"."TYPENAME" AS "CI Type", "cirest"."DISPLAYSTATE" AS "Asset State", "cires"."ASSETTAG" AS "Service Tag", "cicd"."COMPONENTNAME" AS "Product Name", "resUser"."FIRST_NAME" AS "User", "resFields"."UDF_CHAR1" AS "Building", "resFields"."UDF_CHAR2" AS "Room", "resFields"."UDF_DATE1" AS "Warranty Start Date", "cires"."WARRANTYEXPIRY" AS "Warranty Expiration Date", "resFields"."UDF_LONG7" AS "Total Yearly Support Amount Charged", "resFields"."UDF_LONG1" AS "Support Budget Number 1", "resFields"."UDF_LONG4" AS "Support Amount 1", "resFields"."UDF_LONG2" AS "Support Budget Number 2", "resFields"."UDF_LONG5" AS "Support Amount 2", "resFields"."UDF_LONG3" AS "Support Budget Number 3", "resFields"."UDF_LONG6" AS "Support Amount 3", "resFields"."UDF_CHAR5" AS "Notes" FROM "Resources" "cires" LEFT JOIN "BaseElement" "baseci" ON "cires"."CIID"="baseci"."CIID" LEFT JOIN "CI" "ci" ON "baseci"."CIID"="ci"."CIID" LEFT JOIN "CIType" "citype" ON "ci"."CITYPEID"="citype"."TYPEID" LEFT JOIN "ComponentDefinition" "cicd" ON "cires"."COMPONENTID"="cicd"."COMPONENTID" LEFT JOIN "ResourceState" "cirest" ON "cires"."RESOURCESTATEID"="cirest"."RESOURCESTATEID" LEFT JOIN "ResourceOwner" "resOwn" ON "cires"."RESOURCEID"="resOwn"."RESOURCEID" LEFT JOIN "AaaUser" "resUser" ON "resOwn"."USERID"="resUser"."USER_ID" LEFT JOIN "DepartmentDefinition" "resDept" ON "resOwn"."DEPTID"="resDept"."DEPTID" LEFT JOIN "Resource_Fields" "resFields" ON "cires"."RESOURCEID"="resFields"."RESOURCEID" WHERE ((((("cirest"."DISPLAYSTATE" COLLATE SQL_Latin1_General_CP1_CS_AS != N'Expired') AND ("cirest"."DISPLAYSTATE" COLLATE SQL_Latin1_General_CP1_CS_AS != N'In Store')) AND ("cirest"."DISPLAYSTATE" COLLATE SQL_Latin1_General_CP1_CS_AS != N'Disposed')) OR ("cirest"."DISPLAYSTATE" COLLATE SQL_Latin1_General_CP1_CS_AS IS NULL)) AND ((("citype"."TYPENAME" COLLATE SQL_Latin1_General_CP1_CI_AS LIKE N'%MACs%') OR ("citype"."TYPENAME" COLLATE SQL_Latin1_General_CP1_CI_AS LIKE N'%Tablets%')) OR ("citype"."TYPENAME" COLLATE SQL_Latin1_General_CP1_CI_AS LIKE N'%Workstation%'))) AND cires.CIID IS NOT NULL ORDER BY 1, 4