Search
-
SQL ServiceManager Class Properties and Relationships - CIRESON SENPAI NOTICE ME!
Cireson, the community wants you to make it better, make the search better and dynamically get the properties and relationships of the class you are targeting! Here is your headstart for Class Properties: WITH cte_Children AS ( SELECT a.[ManagedTypeId], a.[BaseManagedTypeId] FROM [dbo].[ManagedType] a WHERE a.TypeName =… -
Re: WorkItem Search of Action Log Comments
Yeah, and it's not that hard to get a list of all the properties of a class in the ServiceManager Database, especially using SQL because Microsoft put extensions under the same view. So you don't have to try to recurse through the classes as you just need to get the viewname that the class you want is reported from and… -
SCSM CopyCat
Greetings worthy ones, I believe some people are C# developers on these forums that could benefit from the following program that I've included Source Code with. In particular, when copying or converting you can choose the mapping of properties and relationships. This is extremely important regarding SCSM environments that…