query report
Complete worklog report -MSSQL
Query: SELECT aau.FIRST_NAME AS "Requester", max(wo.WORKORDERID) AS "Request ID", rtdef.NAME AS "Request request type", wo.TITLE AS "Subject", wo.description , std.STATUSNAME AS "Request Status", ti.FIRST_NAME AS "Assigned Technician", ...
Query to extract the “Software-License Additional Fields” along with the existing additional fields (PGSQL)
(Applicable for builds 14300 & above) Below query has been modified to add a LEFT JOIN between the additional fields table and the table from which you extracted the softwares: QUERY: SELECT SUM(scd.ALLOCATED) AS "Allocated", ...
Query report for both live and archived requests (PGSQL)
Tested in Build 14306 Columns - Request ID Created Time Resolved Time Account Category Subcategory Group Query - SELECT wo.WORKORDERID AS "Request ID", wo.CREATEDTIME AS "Created Time", wo.RESOLVEDTIME AS "Resolved Time", ad.ORG_NAME AS "Account", ...
Query to retrieve users login and logout history and find their current status
REQUIREMENT: To generate a report that contains the login and logout history of users and to determine the current user status. TESTED IN: Builds 14503 (Postgres) QUERY 1: The following query provides the login and logout history of users. SELECT ...
Query to get Cab, Cab Members along with their email address (MSSQL)
Tested in build MSSQL (14306) MS-SQL select cab.name as "CAB Name", usr.first_name "CAB Member",AaaContactInfo.EMAILID AS'Email' from cabdefinition cab left join cabmembers members on cab.cabid = members.cabid left join aaauser usr on members.userid ...
Query to List down Account and corresponding sites and its requesters (MSSQL & PGSQL)
*Tested in builds from PGSQL (14300) or MSSQL (14306) *Applicable for 14500 builds For Accounts and Site: select adef.org_name "Account",sdo.name "Site Name" from accountdefinition adef left join accountsitemapping asm on adef.org_id=asm.accountid ...