Leigh_Kilday Ninja IT Monkey ✭✭✭✭
Reactions
-
Re: SCSM DW and extended workitems
Go to the SCSM console > Data Warehouse tab > Data Warehouse Jobs view > click MPSyncJob. Check that the job is enabled, then sort your Syncronization Job Details table by Batch Id (descendi… (View Post)3 -
Re: Create on Behalf - Function / Customization
We have users who select their own names in this field because they don't know they can leave it blank. I agree that it could be a little clearer. (View Post)1 -
Re: SQL Query by date
Just to clarify, are you adding the FROM statement that I (oddly) left off? I also missed a ')' in my transcription... The following works for me: SELECT CAST(YEAR(FirstAssignedDate) as varchar(4)) +… (View Post)6 -
Re: Using other data sources in the SQL Table Widget and preserving click-through functionality
I've answered my own question. Rather than using just the reporting db by itself, the FROM still needs to reference a ServiceManagement table but I can join it to my additional data and the link is p… (View Post)8 -
Re: How would you describe your current experience with SCSM Data Warehouse reporting?
We are creating our own cubes from the DW. The DW has some advantages, such as its MPSync job and we don't have to intimately understand object model. The OOTB cubes are not user-friendly and seem to… (View Post)3