Search
-
Re: Query All Incidents That A User Has Touched
I would need to research and build the SQL query as I do not have exactly what you want. Although I did just find an interesting bit of C# code of mine I forgot about that has some SQL..... The main purpose was "Get a list of certain tickets with the most recent user who modified it along with the date they modified it"… -
Re: Add keywords to Request Offerings to improve search in service catalog
Since I liked the clean look of the mobile version, I have hidden the Catalog Small text with this CSS code: /* Remove Request Offering Small text */ .sc-item-list .media-heading small { display: none; } Then filled that field with key words. The search works in Portal version 6.0.3 and I think it will work in 7 as well.… -
SQL Server - Free Cache
Long story short, SCSM was really really slow. While a restart of the SQL Server or failover will fix the issue if it's a memory leak type of deal (like cache not being freed), it was time consuming and I don't want to have to mess around with that. Therefore, I came up with an SQL script to meet the business requirements… -
Re: SCSM DW [DWDataMart] - Get all incidents with last known related users and enum display names
Here is a view we created for IR and SR You cab just remove the selects for the campus, building and office. USE [DWDataMart] GO /****** Object: View [dbo].[WorkitemSummaryvw] Script Date: 2019/11/07 4:26:19 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE view [dbo].[WorkitemSummaryvw] as Select c.ID,… -
Walk Through – Portal Deployment Example Part 1
As if the Cireson Portal V3.x - V5.x Installation Instructions KB isn’t already long enough, here is a basic example walking through of the installation of the Cireson Portal for someone new to SCSM and Cireson. Important Note: This article is not meant to replace the install instructions; rather provide a Contoso example… -
Re: Powershell activity log
param([guid]$id,[guid]$PSId)$InstallationConfigKey = 'HKLM:\SOFTWARE\Microsoft\System Center\2010\Service Manager\Setup'$AdminModule = (Get-ItemProperty -Path $InstallationConfigKey -Name InstallDirectory).InstallDirectory + "Powershell\System.Center.Service.Manager.psd1"Import-Module -Name $AdminModule -PassThru#security… -
Re: Simple PowerShell Optimizations for Maximum Value
# Cireson Webinar 6-22-2016# PowerShell examples # Author: Nick Velich ### PART 1 ### ## What Version of PowerShell am I using?$PSVersionTable.PSVersion ## And is that the 64-bit version of PowerShell?[Environment]::Is64BitProcess ## Aliasesdir # Familiar to those coming from the Windows Command LineGet-ChildItem # Same as… -
Re: Error after Selecting Location
For exampel here I select "Anforderung Drucker" what is a Service Request. The green and blue icons are SRs, the orange and red ones IRs. The error occurs for IRs and SRs. The Error looks like this: We have a customization in our servicerequest.js file in custom directory: { columnFieldList: [ { DataType: "Enum",…