I'm assuming you are asking about querying Incidents. If so, you can just make a copy of the Incident Details report and make your modifications to that.
Brandon Ryan ClearPointe -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Tran,Brian Sent: Friday, July 10, 2015 2:15 PM To: [email protected] Subject: [servman] SQL Statement Hello, We would like to create a custom report in Service Manager. Does anyone have a SQL statement to query the following columns from the DWDataMart? Please share it with us. Created Date, ID Affected User, Title, Description, Classification, Status, Created By User, Assigned To User, Resolved By, Resolved Date Thank you, Brian ________________________________ This communication, together with any attachments or embedded links, is for the sole use of the intended recipient(s) and may contain information that is confidential or legally protected. If you are not the intended recipient, you are hereby notified that any review, disclosure, copying, dissemination, distribution or use of this communication is strictly prohibited. If you have received this communication in error, please notify the sender immediately by return e-mail message and delete the original and all copies of the communication, along with any attachments or embedded links, from your system.
