Log in to follow, share, and participate in this socialgroup.
Hi all, The hour function does not work as intended (or it does, but the working use goes by me than). When I cast timestamp with DATE and TIME to HOUR I get an TIME factor - an hour, which does… Show more
Hello, I have created a report for all Active CIs but when I run the report it just keeps rendering even before the filters are displayed on the left and then eventually gives the below error… Show more
Hi, I currently have a report on all our top priority calls that are open. The reports runs on Priority Incident/Work Order hyperlink Submit Date Status SLM Status Support Group Assignee… Show more
HI, For some cases I have to set the column value to NULL in my report. I have tried that though using calculated fields but no luck with it. Can anyone help me to find a way to set the Null value… Show more
Hi All, Let me explain first, I got three kinds of Worklog note that I want have in three different column for each incident in the report, I mean column A = Note A, column B = Note B and column C… Show more
Has anyone successfully done this yet? I've tried to use subqueiries with some success. I used an advanced append subquery and used a left outer join based on the Support Organization. When I do… Show more
Smart-Reporting Time Zone Setting - the Time in Smart Reporting is one hour earlier than the time in Work Order
Hi, we have a smart reporting, to get work order completion time. However, in smart reporting the time is one hour than the time in WO in Smart-IT. For example, for WO12345, the completion… Show more
Smart Reporting - The function Hour () will convert the timestamp 12:00 am to 0:00, instead of 12:00
In Smart Reporting, in calculation field, if i used hand SQL to call the function Hour (), it will convert the timestamp 12:00 AM to Hour 0:00 However, this is wrong, it should be converted to 12:00… Show more
Load more items
Hi All, Is there any way to export the Smart reporting reports along with its schedule (broadcast) from one environment to other ? I have tried to export and import the reports but the… Show more
No images have been added to this gallery tile yet.