Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.
Select "1. Global" as "Site","1.6. Hours spent on maintenance this week" as "Category",(sum(ticket_work.time_spent)/3600) ||'h '|| ((sum(ticket_work.time_spent)%3600)/60) ||'m' as "Total" from tickets, ticket_work where (tickets.created_at>=date('now','-7 days')) and (category='Maintenance')
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|SQL: Pulling all records from one table using join data from 2 other tables||5||42|
|SQL Lag Function DateDiff||2||26|
|How can I group this data in the following manner?||2||34|
|Importing from CSV to SSMS||2||14|
Join the community of 500,000 technology professionals and ask your questions.