Service Manager - Data Warehouse, Reporting and Dashboards announcement
-
Link
In my recent blog post I've attached a schema as well as some guidance as to how to navigate through the DW, what the type of tables are and more.
-
0 VotesSCSM-SQL - Locking for wich SCSM-DB table I can find the business service table
Hi, I am trying to find all names of our Business Service in SCSM. In witch SCSM-DB and table can I find it? Just want to have a list all with q SQL Query. /SaiTechProposed | 1 Replies | 70 Views | Created by SaiTech - Tuesday, April 2, 2019 7:41 PM | Last reply by JamesUK76 - Thursday, April 4, 2019 8:07 AM
-
0 Votes
Sql query to connect IDs of service requests and incidents converted to service requests
1) SELECT temp.*, i.Title AS IR_Title, i.Description AS IR_Descr, i.Classification AS IR_Classification, i.ResolutionCategory AS IR_ResolutionCategory, ... -
1 Votes
Looking to Query ALL OPEN SR (service request) before they are copied to the Data Warehouse
As a Senior Developer in Fullstack web dev, I'm being tasked with understanding SCSM and all its glory. We pay for Cireson - however my question is really around how ...Unanswered | 2 Replies | 108 Views | Created by tazmanrising - Wednesday, March 27, 2019 10:50 PM | Last reply by tazmanrising - Thursday, March 28, 2019 5:44 PM -
0 Votes
Install DW database
Hi, Can i install DW database on the same SQL server that is hosting Serivce Manger Database ?Answered | 2 Replies | 398 Views | Created by Mohamed Maamoun - Sunday, March 10, 2019 10:56 AM | Last reply by Andreas Baumgarten - Monday, March 11, 2019 10:49 AM -
0 Votes
How Create Bulk of Service request useing Excel File.
Dear, kindly provide me with solution for , How Can create 50 SRs just in one Service request , and this service request count as 50 for the assigned ...Answered | 2 Replies | 149 Views | Created by Yahia Bakr - Sunday, March 10, 2019 2:18 PM | Last reply by Andreas Baumgarten - Sunday, March 10, 2019 9:57 PM -
0 Votes
Create Change Request report containing PA and SA from DataWarehouse
Hi everyone! I need to create a report from DW containing PA and SA like this: , I have searched the tables but I can not get it. The Activities are configured as the image ...Proposed | 14 Replies | 377 Views | Created by Mauricio-Urrutia - Thursday, January 10, 2019 10:24 PM | Last reply by Dwalsham - Monday, February 18, 2019 10:27 AM -
0 Votes
Error on report Service Request KPI Trend
When I run the build-in report Service Request KPI Trend it show me data. If I run the same report, but filters on the Support Group, to only see some support groups, I'll get an error: The ... -
0 Votes
Cube Extension MP
Hi I've noticed that there are a number of measures which exist in the workitems cube that do not exist in the catalog cube (average completion time being one of them). Rather than ...Unanswered | 0 Replies | 174 Views | Created by marshalexander99 - Thursday, January 24, 2019 11:08 AM -
0 Votes
SCSM 2016 Reports - No items found
Good day friends, I have installed scsm, consoles have been installed on at least 5 computers, everything has worked well, we have already worked the incidents ...Unanswered | 5 Replies | 270 Views | Created by César Martínez C - Friday, January 4, 2019 9:51 PM | Last reply by César Martínez C - Tuesday, January 8, 2019 1:22 PM -
0 Votes
Unable to register to data ware house
System.TypeLoadException: Could not load type 'Microsoft.EnterpriseManagement.UI.Core.Connection.IManagementGroupSession' from assembly 'Microsoft.EnterpriseManagement.UI.Core, ...Unanswered | 4 Replies | 338 Views | Created by mhendawy - Thursday, December 27, 2018 10:39 AM | Last reply by mhendawy - Friday, December 28, 2018 3:53 PM -
0 Votes
Date Filter Blank in SCSM 2010SP1
Hello, When we are generating reports in SCSM, unable to select the Date filter option, blank its coming. Please find the attached ...Unanswered | 2 Replies | 284 Views | Created by Anil Kulkarni - Wednesday, December 12, 2018 9:56 AM | Last reply by Anil Kulkarni - Friday, December 14, 2018 8:02 AM -
0 Votes
SCSM console is getting hang is Very slow
Hello, After opening the SCSM Console, when we click on All open Incidents option (Total Count 51) its taking to much time. SCSM version: 2010 ...Proposed | 4 Replies | 305 Views | Created by Anil Kulkarni - Thursday, December 6, 2018 1:19 PM | Last reply by Anil Kulkarni - Friday, December 7, 2018 11:21 AM -
0 Votes
SCSM Console Crashes When Selecting Favorite Report
I have some users whose consoles crash when they go to reporting in Service Manager and then select a report. Has anyone else experienced this? Also, does anyone know where the information is stored ...Unanswered | 6 Replies | 366 Views | Created by zuldera7 - Monday, November 5, 2018 11:47 PM | Last reply by zuldera7 - Monday, November 19, 2018 6:41 PM -
0 Votes
Linking Incident Dim and User Dim
Hi I am new to service manager data, I am trying to extract Incidents Opened by Users. I couldn't find a way of joining these two tables to exact the basic relevant ...Unanswered | 3 Replies | 435 Views | Created by channaNZ - Monday, September 10, 2018 4:17 AM | Last reply by C Sharp Conner - Thursday, November 8, 2018 7:13 PM -
0 Votes
Incidents History & SLA Reporting
I will get these into the TechNet Wiki and gallery once I do get more points so apologies for this :) I understand there is a lot of headache trying to obtain historical ... -
0 Votes
Incident contains activity - wrong target activity
Hi, We have stumbled upon a weird problem. It has been replicated in 3 environments. We are creating reports and we would like to know about activities linked to ...Unanswered | 1 Replies | 381 Views | Created by Aleksandrs Pridorožnijs - Tuesday, October 2, 2018 12:25 PM | Last reply by Aleksandrs Pridorožnijs - Tuesday, November 6, 2018 9:25 AM -
0 Votes
Where to check antivirus version of workstations, and their last full scan?
Hi, Guys. Do you know where to check antivirus version of workstations, and their last full scan? I also want to know latest antivirus version being used by ...Answered | 5 Replies | 451 Views | Created by TheBats - Sunday, October 7, 2018 10:10 AM | Last reply by Andreas Baumgarten - Tuesday, October 30, 2018 6:47 PM -
2 Votes
Change Management Report
I am not to familiar with SQL. Given that, I can get around and create some basic reports if I know what tables to queries. I have a need to create a simple Management report for our director. She ...Answered | 9 Replies | 467 Views | Created by MEHernandez - Friday, October 12, 2018 1:16 PM | Last reply by MEHernandez - Wednesday, October 17, 2018 4:36 PM -
0 Votes
Is SCSM 2012 R2 compatible with SQL 2012 SP4 Build 11.07469
Good afternoon, My SQL administrator wants to update our SQL to the latest SP and build with security patches. But he wanted to verify with me if it is ok. I have done some ...Proposed | 2 Replies | 363 Views | Created by kbruster - Tuesday, October 2, 2018 7:07 PM | Last reply by Xin Guo - Wednesday, October 3, 2018 6:17 AM -
0 Votes
SLO Breach Percentage Filtering
Hello Everyone, I am currently trying to create an excel Dashboard from the data cube. However I am finding that the SLOs data changes significantly when filtering on Created ...Unanswered | 0 Replies | 314 Views | Created by GrahamMarshall2018 - Wednesday, September 26, 2018 6:45 PM - Items 1 to 20 of 1127 Next ›
Service Manager - Data Warehouse, Reporting and Dashboards announcement
-
Link
In my recent blog post I've attached a schema as well as some guidance as to how to navigate through the DW, what the type of tables are and more.
