Search
-
Re: SCSM DW [DWDataMart] - Get all incidents with last known related users and enum display names
Here is a view we created for IR and SR You cab just remove the selects for the campus, building and office. USE [DWDataMart] GO /****** Object: View [dbo].[WorkitemSummaryvw] Script Date: 2019/11/07 4:26:19 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE view [dbo].[WorkitemSummaryvw] as Select c.ID,… -
Re: Resolution rate percent
Here you go Just Use this for SSRS to create the desired chart, pull out what you do not need. (like the dates) The Key to this table is the ,datediff(dd, WIM.CreatedDate, idm.ResolvedDate) + case when datepart(dw, WIM.CreatedDate) = 7 then 1 else 0 end - (datediff(wk, WIM.CreatedDate, idm.ResolvedDate) * 2) case when… -
Re: Anyone experiencing "missing" runbooks in SCSM?
Invoking ad-hoc automation from tickets is pretty straight forward. I would note that I use Kelverion integration packs and this makes things a lot easier. You do not need Kelverion integration packs to make this work, but you will need to add some creative alternatives. Here is the basic flow. * Figure out when was the… -
Re: Database Blocking Issue - dbo.p_Entity ChangeLog Snapshot;1
I made a program called Advanced History Groomer to attempt to combat the sheer amount of history that builds up within SCSM to purge history records no one cares about! Obviously this is more of a preventative tool than a fix after the database is too full to run grooming jobs within the timespan it has. SCSM was never… -
Re: Apply IR template to existing Incident record
Geoff, we followed your steps and this code works for us: custom.js: /* ------------------------------------------------------------------------------------------- */ /* ----------- Incident - Apply Template ----------------------------------------------------- */ /* - Task is available only for New incident (before it is… -
Re: Target AD Groups for Specific Custom Tasks
I'm still unable to get this to work :( I apologize for not being very good at JavaScript, but I'm learning. This is the code I'm trying to use. Can you critique please? Thanks! //Start Task app.custom.formTasks.add('Incident', "Resolve Incident", function (formObj, viewModel) { $( ".taskmenu li:contains('Resolve… -
Re: Grids not populating on mobile - Are blocked CDN's the culprit?
The tools are very limited in the mobile browsers. I can get a console in one of them, but the only thing I get is a (very long) list of CDN's it is trying to hit. The timestamps coincide with when I load the Cireson portal. On the desktop, I do not see any references to those CDN's when I look at the dev tools, even when… -
Support FAQ - I dont know where to start or which KBs to read first?
The amount of knowledge articles can be a little overwhelming at first so let me list the must reads to get your knowledge up to speed quickly. I spend a lot of my day answering questions or helping solve issues by simply summarizing these KB’s and have these memorized now to be our customers human Cireson KB search… -
Re: SCSM Add-on - Advanced History Groomer [w/ Source Code]