Hi All, I am not very good with SQL, in fact i am hopeless with it, i have been using a tool called FlySpeed sql to help me build some queries and well, when you copy and paste that in to the query builder in SD+ it just errors out, I think our version is running Mysql, but not sure.
Can anyone help me convert this to a usable query? we are running V 9317 of SD+
SELECT
CI.CINAME,
CI1.CINAME AS CINAME1,
Requester.ATTRIBUTE_1202,
Requester.ATTRIBUTE_2401,
SystemInfo.SERVICETAG,
Resources.SERIALNO,
Resource_Fields.UDF_CHAR11
FROM
CIRelationships
INNER JOIN CI ON CIRelationships.CIID = CI.CIID
INNER JOIN CI CI1 ON CIRelationships.CIID2 = CI1.CIID
INNER JOIN Requester ON Requester.CIID = CI1.CIID
INNER JOIN Resources ON Resources.CIID = CI.CIID
INNER JOIN SystemInfo ON SystemInfo.WORKSTATIONID = Resources.RESOURCEID
INNER JOIN Resource_Fields ON Resource_Fields.RESOURCEID = Resources.RESOURCEID