SQL Server

Discussion	Started By	Replies	Views	Most Recent
MA Comment and Clompleted by User Answered ✓	Sarah_Geihs July 2023	5	45	Sarah_Geihs July 2023
SCSM DW Query - Billable Time	Adam_Dzyacky June 2016	3	935	Adam_Dzyacky September 2022
2 Cireson SQL Jobs fail Answered ✓	Simon_Zeinhofer November 2021	4	74	Simon_Zeinhofer November 2021
ServiceManagement database issue Answered	alex_kokin October 2021	1	8	Brett_Moffett October 2021
SQL files Answered ✓	Gerhard_Goossens September 2021	1	25	Dijon_Blease October 2021
Query Help Answered	alex_kokin June 2021	4	28	alex_kokin June 2021
Self Service Portal Install and SQL error invalid object dbo.SettingsItem Answered	Penny_Smith August 2018	4	124	Shane_White November 2020
SQL Query to get a Manual Activity's (MA's) parent Change Request (CR) Answered	Brett_Etzel November 2020	2	112	Brett_Etzel November 2020
Support Group Membership Answered ✓	Metro_ITS April 2020	2	163	Metro_ITS April 2020
[How To] - Quickly View Existing Workflow History of an Incident	Conner_Wood November 2019	3	290	Conner_Wood January 2020
Time Worked report w/support group and created date Answered ✓	Liz_Ross December 2019	14	353	Liz_Ross January 2020
Where to find Connector Status using SQL? Answered	Conner_Wood September 2018	3	193	Conner_Wood November 2019
SCSM DW [DWDataMart] - Get all incidents with last known related users and enum display names	Bruno_Serafim November 2019	2	452	Bruno_Serafim November 2019
SQL query of Templates & connected SR/IRs Answered ✓	Liz_Ross October 2019	10	37	Justin_Workman October 2019
Services don't seem to start....portal website not showing up Answered	Isabella_Michel October 2019	6	62	Isabella_Michel October 2019
HOW TO - SCSM LIVE Database - Report FULL NAME of IR CLASSIFICATION	Conner_Wood September 2019	0	122	Conner_Wood September 2019
SQL for waiting Approval for changes that require 80% Approval	Carol_Morrell August 2019	3	32	Carol_Morrell August 2019
SQL databases move Answered	George_Kouskouridas July 2019	2	417	Gerhard_Goossens July 2019
Change Management Assignee or Category Answered ✓	Metro_ITS April 2019	4	18	Metro_ITS April 2019
Change Management Category Answered ✓	Metro_ITS April 2019	2	95	Metro_ITS April 2019
How To - Report All work items Answered	Marek_Lefek October 2018	3	88	Justin_Workman January 2019
SCSM DW Query - Backlog Answered ✓	Gerhard_Goossens November 2018	4	60	Tom_Hendricks November 2018
HOW TO - Summary Report - Cireson Hardware Assets	Conner_Wood September 2018	0	127	Conner_Wood September 2018
objects Service Management database Answered	Roman_Nepomniashchii September 2018	1	32	Tony_Collett September 2018
SQL Server - Free Cache	Conner_Wood December 2017	0	94	Conner_Wood December 2017
How to restore missing Cireson Analytics SQL agent jobs after database migration to new server	Yuriy_Mikhaylenko November 2017	1	164	Justin_Workman November 2017
SQL ServiceManager Class Properties and Relationships - CIRESON SENPAI NOTICE ME!	Conner_Wood September 2017	0	149	Conner_Wood September 2017
HOW TO - SCSM DataWarehouse - Report FULL NAME of IR CLASSIFICATION	Conner_Wood July 2017	3	339	Conner_Wood September 2017
SCSM Data Warehouse - Fact Groom Retention - Prevent Relationships Getting Marked As Deleted	Conner_Wood September 2017	0	15	Conner_Wood September 2017
SCSM SQL Servers - Verify AlwaysOn for ServiceManager	Conner_Wood August 2017	0	40	Conner_Wood August 2017