Search
-
Re: GetUsersGroups API Issue..
Ryan, I think we should do a full resync of your users and groups. Can you do this in dev and see if it gets you the correct results. First, stop the Cache Builder service and then run the following commands against the ServiceManagement DB: TRUNCATE TABLE CI$User TRUNCATE TABLE CI$DomainGroup TRUNCATE TABLE LastModified… -
Re: Add Priority Columns To Views
@Raymond_Didonato It's not possible to add a column to the OOB views. But you could do a SQL Table Widget for a 'My CRs' view and include the Priority column. I just used this query and got the color coding for Status and Priority: SELECT WorkItemId AS 'Id' ,Title ,c.DisplayString AS 'Category' ,s.DisplayString AS 'Status'… -
Re: Cireson Knowledge articles not showing for end users since upgrade to version 7.3.2012.1
@Leon_Vaughn Couple of things you will want to run through: 1. This can be typically caused by a faulty AD connector in SCSM that did not bring over users rights correctly. You will want to resync your AD connector in SCSM. Then recycle your cachebuilder service. If that does not work 2. You can preform a hard reset on the… -
Re: SQL query of Templates & connected SR/IRs
@Liz_Ross - updated query to include MP name where the RO lives: select ro.DisplayName, sta.DisplayName as 'Status', so.DisplayName as 'ServiceOffering', td.DisplayName as 'Template', bme.LastModified as 'LastModified', mp.MPFriendlyName from MTV_System$RequestOffering ro join Relationship roso on roso.TargetEntityId =… -
Re: Can a view with the token [me] be promoted to the portal?
Here is an example that will pull all open incidents assigned to the logged on user Select * From(SELECT wi.WorkItemId as [Id], wi.Title, dsstatus.DisplayString as [Status], dssupport.DisplayString as [SupportGroup], wi.PriorityId as [Priority], Case When wi.AssignedUser IS Null Then 'UnAssigned' Else wi.AssignedUser End… -
Analytics Archiver beating SQL Novice - advice please
Appreciate its early days with the archiver. Just looking at what is possible whilst the global search doesn't search analytics. I'm not entirely sure if this is possible yet. In some ways I prefer OData because it adds a search box for me but I wondered if there was a way to replicate this... ...Using SQL. This is the… -
Service Request Permissions
I created a new SR and a new SO and added the SR to the SO. I did not add either of them to any groups, but users that already have access to other SR's can see the new SR. I cannot see where they are getting permissions to this new SR. I have looked everywhere I know, the users are not part of any other roles except the… -
Re: Proper format to add analyst comment through the V3 API
Hi @Shane_Weber There's two things you need in order to add a new item via a commit. You need to have the relationship in question in the NameRelationship array. The members of this array will be defined by the type projection used in order to grab the projection. Secondly, you need to mark the new object as dirty with… -
Re: SCSM Console Update to 2016 - Active Work Items View Not Working Correctly (Cireson Portal)
-
Re: Cachebuilder Status & Timeline Display
I don't think is as ideal as we want it (lacking some prettier animation and possibly some tighter integration). but using Cireson's Dashboarding tools we can acheive some GUI like integration of this. That shows the Last Modified times from the LastModified table from the ServiceManagement database. However I noticed that…