Conner_Wood Ninja IT Monkey ✭✭✭✭
Reactions
-
HOW TO - Summary Report - Cireson Hardware Assets
USE [ServiceManager]; WITH EnumText AS ( SELECT DISTINCT Enum.EnumTypeId, Enum.EnumTypeName, LT.LTValue AS 'EnumText' FROM [dbo].[EnumType] Enum (nolock) JOIN [dbo].[LocalizedText] LT (nolock) ON LT.… (View Post)4 -
Re: An SMlets based Exchange Connector
Wow, this is more advanced than I thought after reading through it all on GitHub. This is what has been needed years ago. (View Post)2 -
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 Proper… (View Post)2 -
Re: How to find the incidents with the most re-assignments ?
Muwhahahahahah, Muwhauhauhahauhauhauha!!!!!!! Now to sum it up: * what you'd use for LIVE == the history log in the LIVE ServiceManager DB * what you'd use for ARCHIVE == The Enumeration Duration and… (View Post)1 -
Re: Modify content in DWDataMart Possible?
You can indeed update the DWDataMart, personally I recommend to update both DWRepository and then DWDataMart. Cause DWDataMart pulls from DWRepository. "But this doesn't follow ITIL standards&qu… (View Post)6