SQL Server

Discussion List

Discussion	Started By	Replies	Views	Most Recent
Change Management Assignee or Category Accepted Answer	Metro_ITS April 16	4	20	Metro_ITS April 17
Change Management Category Accepted Answer	Metro_ITS April 2	2	33	Metro_ITS April 11
Where to find Connector Status using SQL? Answered	Conner_Wood September 2018	2	41	James_Atance January 11
How To - Report All work items Answered	Marek_Lefek October 2018	3	47	Justin_Workman January 2
SCSM DW Query - Backlog Accepted Answer	Gerhard_Goossens November 2018	4	45	Tom_Hendricks November 2018
HOW TO - Summary Report - Cireson Hardware Assets	Conner_Wood September 2018	0	56	Conner_Wood September 2018
objects Service Management database Answered	Roman_Nepomniashchii September 2018	1	34	Tony_Collett September 2018
Self Service Portal Install and SQL error invalid object dbo.SettingsItem Answered	Penny_Smith August 2018	2	21	Penny_Smith August 2018
SQL Server - Free Cache	Conner_Wood December 2017	0	24	Conner_Wood December 2017
How to restore missing Cireson Analytics SQL agent jobs after database migration to new server	Yuriy_Mikhaylenko November 2017	1	46	Justin_Workman November 2017
SQL ServiceManager Class Properties and Relationships - CIRESON SENPAI NOTICE ME!	Conner_Wood September 2017	0	49	Conner_Wood September 2017
HOW TO - SCSM DataWarehouse - Report FULL NAME of IR CLASSIFICATION	Conner_Wood July 2017	3	134	Conner_Wood September 2017
SCSM Data Warehouse - Fact Groom Retention - Prevent Relationships Getting Marked As Deleted	Conner_Wood September 2017	0	13	Conner_Wood September 2017
SCSM SQL Servers - Verify AlwaysOn for ServiceManager	Conner_Wood August 2017	0	33	Conner_Wood August 2017
ServiceManagement Accepted Answer	Nathan_Erdman July 2017	1	36	Conner_Wood July 2017
EntityChangeLogid Change Type = 3 "Stage" Accepted Answer	Brian_Wiest June 2017	1	5	Konstantin_Slavin-Bo June 2017
SCSM DW Query - Billable Time	Adam_Dzyacky June 2016	1	538	AJ_Wittenbrink June 2017
Problem Relates to Config Item Accepted Answer	Brian_Wiest December 2016	3	23	Geoff_Ross December 2016
Is there any way of looking at calls that are moved in to the data Warehouse Accepted Answer	Mark_Geary November 2016	2	33	Conner_Wood November 2016
How to use SQL on ServiceManager DB to check User Permissions from User Roles Accepted Answer	Conner_Wood October 2016	5	344	Conner_Wood October 2016
Can you populate query results in a request from an external database using SQL Accepted Answer	Jarrett_Faulk September 2016	1	25	Adam_Dzyacky September 2016
SCSM Live Reporting - Display Child IR List of Specified Parent IR	Conner_Wood August 2016	0	517	Conner_Wood August 2016
How to access archived service requests	Casey_Averill August 2016	3	126	Casey_Averill August 2016
Query Pulling First Assigned To and not the current Assigned to. Suggestions?	Brian_Wiest June 2016	10	702	Chris_Chekaluk June 2016
DW and problemws with assigned to user	Bostjan_Cernjak June 2016	2	34	Bostjan_Cernjak June 2016