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.
Found 1148 threads
-
0 VotesChange Ticket - Review activity and the approver who has approved it
Hi Friends, I am struggling to find a SQL query to extract the review activities / CAB approval for a change ticket. And also from the list of approvers who approved the particular ...
-
0 Votes
[Announcement] "System Center" Forum will be migrating to a new home on Microsoft Q&A!
This "System Center" Forum will be migrating to a new home on Microsoft Q&A! We've listened to your ... -
0 Votes
Retrieve old service manager jobs.
Hello World! I have been put in charge of managing SCSM. We currently use Service manager console for all our help desk jobs and project ...Unanswered | 1 Replies | 970 Views | Created by Galveo - Tuesday, June 2, 2020 2:58 PM | Last reply by Nick Velich - Tuesday, July 21, 2020 8:58 PM -
0 Votes
How to connect data analytics / business intelligence tools to Service Manager?
I have a specific department that would like to connect their data analytics / business intelligence tools to our Service Manager environment. I would like to limit their ability to view only ...Answered | 1 Replies | 1828 Views | Created by Shodaman - Monday, April 6, 2020 9:14 PM | Last reply by Andreas Baumgarten - Tuesday, April 7, 2020 5:15 PM -
0 Votes
End user Reports permissions
Hello, i have an permission issue that the end users cant view the reports from the web portal URL or even from the SCSM console, the only way that ...Proposed | 2 Replies | 936 Views | Created by mhendawy - Thursday, March 5, 2020 11:35 AM | Last reply by Stoyan Chalakov - Friday, March 6, 2020 10:34 AM -
0 Votes
MPSyncJob stucked after upgrade to SCSM 2016
Hi community, I'm having this issue with MPSyncJob after upgrading to SCSM 2016 (from 2012 R2): Job is stucked but shows as ...Unanswered | 2 Replies | 1207 Views | Created by JoaquinGomez - Tuesday, January 21, 2020 4:07 PM | Last reply by Xin Guo - Thursday, February 13, 2020 8:43 AM -
0 Votes
Data Warehouse installation failed
Hi I faced this error when I try to install SCSM Data Warehouse "An error occurred while executing a custom ...Proposed | 1 Replies | 1201 Views | Created by Heba57 - Tuesday, February 4, 2020 4:15 PM | Last reply by Xin Guo - Wednesday, February 5, 2020 5:52 AM -
0 Votes
Deploy SCSM 2012 R2 Data Warehouse Server on Windows Server 2016
Hello community! I'm trying to install a SCSM 2012 R2 Data Warehouse server on Windows Serve 2016 but i'm getting an error upon setup ...Proposed | 2 Replies | 991 Views | Created by JoaquinGomez - Monday, January 6, 2020 9:41 PM | Last reply by James Atance - Solutions Architect - Tuesday, January 7, 2020 10:24 AM -
1 Votes
Setup Cannot Complete Custom Action failed CreateSrsFolder_SC
Hello, I'm installing a Microsoft System Center Service Manager, Console and Reporting Server. This is two servers scenario where SM Console, SM Database ...Answered | 6 Replies | 5408 Views | Created by Amer Yehia - Sunday, June 23, 2019 12:49 PM | Last reply by LANHD - Saturday, January 4, 2020 2:33 PM -
0 Votes
Incident KPI trends no data found
Hi, My Incident KPI trend report show "No data Found". pls guide. Thx iffiAnswered | 3 Replies | 1346 Views | Created by imughal - Tuesday, December 24, 2019 11:33 AM | Last reply by Andreas Baumgarten - Thursday, December 26, 2019 6:09 PM -
0 Votes
Schedule Daily doesn't change Next Run
Hello, I've set the schedule (Service Manager) to Daily at 18:30 but the Next run doesn't ...Unanswered | 4 Replies | 1363 Views | Created by Yann_Gomes - Monday, December 9, 2019 1:21 PM | Last reply by Yann_Gomes - Monday, December 9, 2019 1:52 PM -
0 Votes
Problems with the datawarehouse update from 1801 to 1807
I am trying to build out the lab environment for additional testing. The production management server and the datawarehouse are both at 1807. The lab management server is at 1807. I am trying to add ...Answered | 2 Replies | 1960 Views | Created by MEHernandez - Monday, November 25, 2019 8:44 PM | Last reply by MEHernandez - Wednesday, December 4, 2019 12:18 PM -
0 Votes
Timezone List in Reports missed an Item
Hi, There is a client console in our environment that can't see it's timezone in the timezone list of reports parameters. Do you know how does this parameter get ... -
1 Votes
Report problem in SCSM data warehouse server
Hi All, I have installed SCSM 2016 management server and register with SCSM data ware house server.Now after successful registration there is no reports are visible in SQL and also ...Unanswered | 11 Replies | 3184 Views | Created by NajeebUllah - Monday, July 1, 2019 10:12 AM | Last reply by C Sharp Conner - Tuesday, August 6, 2019 9:35 PM -
0 Votes
Not see Cube Jobs
Hello guys, I have some cubes that works fine. These are updating every 15 mins, refreshing the data. i want to make some changes to the time scheduled update time but for the love of me i ...Unanswered | 1 Replies | 1609 Views | Created by Lionelf07 - Friday, July 12, 2019 3:38 PM | Last reply by Brett Moffett - Monday, July 15, 2019 10:46 PM -
1 Votes
cubes
hello. I installed scsm 2019 and move existing tickets from my scsm2012r2. After i installed dw I found that change and Activity management Cube are failing. I was using this ...Proposed | 1 Replies | 1546 Views | Created by kototamopeva - Tuesday, July 9, 2019 3:47 PM | Last reply by Stoyan Chalakov - Friday, July 12, 2019 9:19 AM -
1 Votes
Customize List of Incidents Report
Hi, I have customize List of Incident reports by adding Incident Description and the age of the incident ( Resolved Date - Created Date ) . Now i need to add also ...Answered | 2 Replies | 2034 Views | Created by Mohamed Maamoun - Sunday, June 16, 2019 1:10 PM | Last reply by Swati06 - Monday, July 8, 2019 2:57 PM -
0 Votes
Data Warehouse don't complete tasks - MPSyncJob-Management Pack
Hi, I have installed SCSM 2016 over Windows 2016 servers. I'm using SQL 2016. SCSM was installed at June 20th. The problems ...Answered | 5 Replies | 2990 Views | Created by SCCMadmin09 - Tuesday, July 4, 2017 10:18 PM | Last reply by SCCMadmin09 - Friday, July 5, 2019 8:20 PM -
6 Votes
SCSM 2012 Reports not showing
In my SCSM environment, the SQL Reporting Services is on a remote server, so after the special installation, I managed to get it running and i can launch reports via console or via web ...Answered | 18 Replies | 18464 Views | Created by Patrick Zhang - Friday, June 1, 2012 8:24 PM | Last reply by NajeebUllah - Monday, July 1, 2019 10:05 AM -
0 Votes
Service Manager Service Catalog Cube Library MP Fails to deploy
I have create some custom fields in the service request class, then using the SCUtils PowerShell script, I created the outriggers so that I could get real values rather than the enumerations. I am see ... - Items 1 to 20 of 1148 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.
